Re: [HACKERS] GSoC 2017: Foreign Key Arrays - Mailing list pgsql-hackers

From Mark Rofail
Subject Re: [HACKERS] GSoC 2017: Foreign Key Arrays
Date
Msg-id CAJvoCuu5HjnpEgZUWrD=15aYpn1hkH8pyb8zMYPYyr9F3+Kw9A@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] GSoC 2017: Foreign Key Arrays  (Mark Rofail <markm.rofail@gmail.com>)
Responses Re: [HACKERS] GSoC 2017: Foreign Key Arrays
List pgsql-hackers
 What I am working on
  • since we want to create an index on the referencing column, I am working on firing a 'CREATE INDEX' query programatically right after the 'CREATE TABLE' query
    • The problem I ran into is how to specify my Strategy (GinContainsElemStrategy) within the CREATE INDEX query. For example: CREATE INDEX ON fktable USING gin (fkcolumn array_ops)
      Where does the strategy number fit?
    • The patch is attached here, is the approach I took to creating an index programmatically, correct? 
Best Regard,
Mark Rofail

Attachment

pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: [HACKERS] pg_receivewal and messages printed in non-verbose mode
Next
From: Thomas Munro
Date:
Subject: Re: [HACKERS] COPY vs. transition tables