Re: [HACKERS] passing parameters to CREATE INDEX

2006-07-11 Thread ITAGAKI Takahiro
Teodor Sigaev [EMAIL PROTECTED] wrote: pluggable parameters for index. I think, we may can add to pg_opclass's definition method/parameter name and create some API (may be, index specific) to propagate parameter's to module's interface functions to index. How abount adding a new option

Re: [HACKERS] passing parameters to CREATE INDEX

2006-07-05 Thread Teodor Sigaev
http://archives.postgresql.org/pgsql-hackers/2005-09/msg00851.php Just to follow up on the discussion of that thread: what's been implemented is a way to store arbitrary name=value strings in an index's pg_class entry, and to make these available in a pre-parsed form through the index relcache

Re: [HACKERS] passing parameters to CREATE INDEX

2006-07-05 Thread Tom Lane
Teodor Sigaev [EMAIL PROTECTED] writes: can add to pg_opclass's definition method/parameter name and create some API (may be, index specific) to propagate parameter's to module's interface functions to index. Huh? You can get them from the index's Relation structure. I don't think there's

[HACKERS] passing parameters to CREATE INDEX

2006-07-04 Thread Simon Riggs
Just wanted to make clear to Hackers that the gates are now open to include other parameters for CREATE INDEX, as originally requested here: http://archives.postgresql.org/pgsql-hackers/2005-09/msg00851.php The new WITH (param=value...) syntax could easily be extended to include a variety of

Re: [HACKERS] passing parameters to CREATE INDEX

2006-07-04 Thread Tom Lane
Simon Riggs [EMAIL PROTECTED] writes: Just wanted to make clear to Hackers that the gates are now open to include other parameters for CREATE INDEX, as originally requested here: http://archives.postgresql.org/pgsql-hackers/2005-09/msg00851.php Just to follow up on the discussion of that

Re: [HACKERS] passing parameters to CREATE INDEX

2005-09-22 Thread Bruce Momjian
Added to TODO: * Allow CREATE INDEX to take an additional parameter for use with special index types --- Martijn van Oosterhout wrote: -- Start of PGP signed section. On Wed, Sep 21, 2005 at 08:47:04AM

Re: [HACKERS] passing parameters to CREATE INDEX

2005-09-21 Thread Martijn van Oosterhout
On Wed, Sep 21, 2005 at 08:47:04AM +0300, Hannu Krosing wrote: On K, 2005-09-21 at 09:01 +0400, Oleg Bartunov wrote: it'd be nice if parameters could be passed at the creation time only and somehow stored, so other functions could retrieve them. It's not convenient but also safe. If not

[HACKERS] passing parameters to CREATE INDEX

2005-09-20 Thread Oleg Bartunov
Hi there, it's desirable to be able to pass parameters to CREATE INDEX for GiST indices. Does SQL standard has something about that so we could implement it for 8.2 ? Example from real life project - performance of tsearch2 could be greatly improved if decrease signature size in gistidx.h,

Re: [HACKERS] passing parameters to CREATE INDEX

2005-09-20 Thread Andrew Dunstan
Oleg Bartunov wrote: Hi there, it's desirable to be able to pass parameters to CREATE INDEX for GiST indices. Does SQL standard has something about that so we could implement it for 8.2 ? According to the docs: CREATE INDEX is a PostgreSQL language extension. There are no provisions for

Re: [HACKERS] passing parameters to CREATE INDEX

2005-09-20 Thread Martijn van Oosterhout
On Tue, Sep 20, 2005 at 11:26:26PM +0400, Oleg Bartunov wrote: it's desirable to be able to pass parameters to CREATE INDEX for GiST indices. Does SQL standard has something about that so we could implement it for 8.2 ? As has been pointed out, INDEXes arn't in the SQL spec at all, so you can

Re: [HACKERS] passing parameters to CREATE INDEX

2005-09-20 Thread Tom Lane
Martijn van Oosterhout kleptog@svana.org writes: What syntax were you envisioning? Does this value just need to be passed to GiST at the creation of the the index, or does it actually need to remembered by the backend and passed each call? I should think that the index ought to remember any

Re: [HACKERS] passing parameters to CREATE INDEX

2005-09-20 Thread Oleg Bartunov
On Tue, 20 Sep 2005, Martijn van Oosterhout wrote: On Tue, Sep 20, 2005 at 11:26:26PM +0400, Oleg Bartunov wrote: it's desirable to be able to pass parameters to CREATE INDEX for GiST indices. Does SQL standard has something about that so we could implement it for 8.2 ? As has been pointed

Re: [HACKERS] passing parameters to CREATE INDEX

2005-09-20 Thread Hannu Krosing
On K, 2005-09-21 at 09:01 +0400, Oleg Bartunov wrote: On Tue, 20 Sep 2005, Martijn van Oosterhout wrote: What syntax were you envisioning? Does this value just need to be passed to GiST at the creation of the the index, or does it actually need to remembered by the backend and passed each