Re: 8.1.3, libpq, PQprepare, plpgsql function, and partitioned tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "shakahshakah(at)gmail(dot)com" <shakahshakah(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 8.1.3, libpq, PQprepare, plpgsql function, and partitioned tables
Date: 2006-04-03 00:20:56
Message-ID: 26192.1144023656@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"shakahshakah(at)gmail(dot)com" <shakahshakah(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message sconeek 2006-04-03 00:21:03 Re: Cant find temp tables
Previous Message Chris 2006-04-03 00:15:15 Re: Cant find temp tables