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

Reply via email to