[GENERAL] Problems with pg_dump ?

2008-06-06 Thread Alexandr Popov
rror while creating view ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list Any help will be appreciated -- Alexandr Popov -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] EXCEPT doesn't compare TIMESTAMP type?

2010-04-23 Thread Alexandr Popov
7; In Your case insert should be following INSERT INTO changelogtest (id, txid, txtime) values (5, 123, now()) except select id, txid, txtime from changelogtest where id=5; -- Alexandr Popov