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
Regards,
Bartek
