Postgres Pro
Downloads
Home   >   mailing lists

Re: 8.1.3, libpq, PQprepare, plpgsql function, and partitioned tables - Mailing list pgsql-general

From Tom Lane
Subject Re: 8.1.3, libpq, PQprepare, plpgsql function, and partitioned tables
Date
Msg-id 26192.1144023656@sss.pgh.pa.us
Whole thread Raw
In response to 8.1.3, libpq, PQprepare, plpgsql function, and partitioned tables  ("shakahshakah@gmail.com" <shakahshakah@gmail.com>)
Responses Re: 8.1.3, libpq, PQprepare, plpgsql function, and partitioned tables  (Stephen Frost <sfrost@snowman.net>)
List pgsql-general
Tree view 
"shakahshakah@gmail.com" <shakahshakah@gmail.com> writes:
> Am I correct in assuming that when Postgres prepared the SQL to execute
> the "insert function" that the existing rules on the base table were
> also resolved at that time?  If so, is there any way to avoid that
> behavior?

Yes; no.  We are working on infrastructure to automatically redo
prepared plans when relevant catalog entries change, but it's not there
today :-(

            regards, tom lane

pgsql-general by date:

Previous
From: Chris
Date:
Subject: Re: Cant find temp tables
Next
From: Tom Lane
Date:
Subject: Re: Database security granularity