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

From Stephen Frost
Subject Re: 8.1.3, libpq, PQprepare, plpgsql function, and partitioned tables
Date
Msg-id 20060403011346.GD4474@ns.snowman.net
Whole thread Raw
In response to Re: 8.1.3, libpq, PQprepare, plpgsql function, and partitioned tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> "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 :-(

Wouldn't it be possible to use 'execute' instead and have the plan
re-generated each time that way?  It'd be less efficient but I think
it'd work as a work-around...

Just some thoughts,

    Thanks,

        Stephen

Attachment

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Database security granularity
Next
From: "HIRA SIROJUDIN ABBAS"
Date:
Subject: help me...