Search Postgresql Archives

Re: Re: Does it equal to execute "CREATE ACCESS METHOD"?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



thanks for your advice, yes I'm confused with my studying ways. Can you give me some like less-ambitious projects to study it?
 

jacktby@xxxxxxxxx
 
From: Tom Lane
Date: 2022-10-29 23:34
To: jacktby@xxxxxxxxx
CC: pgsql-general
Subject: Re: Does it equal to execute "CREATE ACCESS METHOD"?
"jacktby@xxxxxxxxx" <jacktby@xxxxxxxxx> writes:
> When I add
> "{ oid => '6015', oid_symbol => 'SPB_AM_OID',
>   descr => 'SPB index access method',
>   amname => 'spb', amhandler => 'spbhandler', amtype => 'i' },"
> in pg_am.dat
> and  add
> "{ oid => '388', descr => 'spb index access method handler',
>   proname => 'spbhandler', provolatile => 'v',
>   prorettype => 'index_am_handler', proargtypes => 'internal',
>   prosrc => 'spbhandler' }," in pg_proc.dat,
> so when I use the make install && cd contrib;make install;
> whether it equals to execute create access method?

Did you run initdb afterwards?  What you describe here should
result in an updated postgres.bki file, but that isn't the
same as catalog entries in a live database.

> And Sorry for the another mail "access method xxx does not exist", you suggest me add new
> Am Index in contrib, But I need to modify gist to spb, so that's not my require. And I need to know
> add those in pg_proc.dat and pg_am.dat, if it won't create access method for spb, what else I need to
> do?

To be very blunt, it doesn't sound to me that your skills with
Postgres are anywhere near up to the task of writing a new
index access method.  You should start with some less-ambitious
project to gain some familiarity with the code base.

regards, tom lane

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux