Re: [HACKERS] Re: Prepared statements fail after schema changes with surprising error

2013-01-22 Thread Dimitri Fontaine
Andres Freund writes: > On 2013-01-22 14:24:26 +0100, Dimitri Fontaine wrote: >> Tom Lane writes: >> >> DROP SCHEMA public; >> >> CREATE SCHEMA public; >> > >> > changes the OID of schema public, whereas the search_path that's cached >> > for the cached plan is cached in terms of OIDs. So while

[HACKERS] Re: Prepared statements fail after schema changes with surprising error

2013-01-22 Thread Andres Freund
On 2013-01-22 14:24:26 +0100, Dimitri Fontaine wrote: > > Tom Lane writes: > >> DROP SCHEMA public; > >> CREATE SCHEMA public; > > > > changes the OID of schema public, whereas the search_path that's cached > > for the cached plan is cached in terms of OIDs. So while there is a > > table named p