On Tue, 21 Feb 2012 21:53:49 +0100, Bartosz Dmytrak <bdmytrak@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.
--
Guillaumehttp://www.postgresql.frhttp://dalibo.com