Re: [BUGS] ALTERed DEFAULTS not visible to PL/pgSQL cached plans

2006-03-12 Thread Alvaro Herrera
Josh Berkus wrote: > Steps to Reproduce: > (sample code attached) > 1) Create a table. > 2) Create a function which inserts a row into that table. > 3) Run the function once. > 4) ALTER the table with a new column and SET DEFAULT for that column. > 5) Run the function again. > 6) Re-load the funct

[BUGS] ALTERed DEFAULTS not visible to PL/pgSQL cached plans

2006-03-11 Thread Josh Berkus
Folks, Version: 8.1.3 Platform: SuSE Linux, GCC Severity: mild data corruption Reproducability: 100% Steps to Reproduce: (sample code attached) 1) Create a table. 2) Create a function which inserts a row into that table. 3) Run the function once. 4) ALTER the table with a new column and SET DEFAU