Re: [BUGS] BUG #6051: wCTE query fail with wrong error text on a table with rules

2011-06-04 Thread Tom Lane
Merlin Moncure writes: > On Fri, Jun 3, 2011 at 10:42 AM, Jehan-Guillaume (ioguix) de Rorthais > wrote: >> test=# CREATE RULE test_ins AS ON INSERT TO test DO INSTEAD INSERT INTO >> test2 VALUES (NEW.i); >> CREATE RULE >> test=# WITH t1 AS ( >> DELETE FROM ONLY test RETURNING * >> ) >> INSERT INT

Re: [BUGS] BUG #6049: Can't load dumped view with VALUES and ORDER BY

2011-06-04 Thread Tom Lane
"Dylan Adams" writes: > If you create a view based on a VALUES statement with an ORDER BY clause, > the SQL produced by pg_dump can't be loaded back into the database. I've applied a patch for this. Thanks for the report! regards, tom lane -- Sent via pgsql-bugs mailin

[BUGS] BUG #6052: ADD COLUMN - ERROR: tables can have at most 1600 columns

2011-06-04 Thread dinesh
The following bug has been logged online: Bug reference: 6052 Logged by: dinesh Email address: din...@milkorwater.com PostgreSQL version: 8.4.7 Operating system: WIndows 7 pro 64 bit Description:ADD COLUMN - ERROR: tables can have at most 1600 columns Details: I hav