PREPARE, FK's and VIEWs - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject PREPARE, FK's and VIEWs
Date
Msg-id GNELIHDDFBOCMGBFGEFOGEOOCDAA.chriskl@familyhealth.com.au
Whole thread Raw
Responses Re: PREPARE, FK's and VIEWs  (Karel Zak <zakkr@zf.jcu.cz>)
Re: PREPARE, FK's and VIEWs  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: PREPARE, FK's and VIEWs  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-hackers
Hi,

Now that we have prepared statements, should the foreign key code be changed
to use them?  I think it's highly likely that they will be reused in a
connection.  Might be an idea.

Also, what if the person wants to prepare a view?  Should they have to
PREPARE <view select> or should we automatically prepare them the first time
they're used in a connection?  Or should we offer a PREPARE VIEW <viewname>
option?

I personally think the second option would be neat.

Chris



pgsql-hackers by date:

Previous
From: Gavin Sherry
Date:
Subject: Re: Proposed GUC Variable
Next
From: Karel Zak
Date:
Subject: Re: PREPARE, FK's and VIEWs