On Tue, 21 Feb 2012 21:53:49 +0100, Bartosz Dmytrak <bdmyt...@eranet.pl> wrote: > Hi,I found incorrect script generated for trigger with column list > specified. > SQL window shows:CREATE TRIGGER "trgTest" AFTER INSERT OR UPDATE OF > RowId, Value1 OR DELETE -- missing quotation marks for column names > ON "tblTest" FOR EACH ROW EXECUTE PROCEDURE "trgTest"(); > > But should be:CREATE TRIGGER "trgTest" AFTER INSERT OR UPDATE OF > "RowId", "Value1" OR DELETE ON "tblTest" FOR EACH ROW > EXECUTE PROCEDURE "trgTest"(); > Script for create trigger with wizard is generated properly.Tested > on pgAdmin 1.14.1 on Windows 7 32 bit and Mandriva 2011 64 bit >
Thanks again. It's now fixed. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
