Postgres Pro
Downloads
Home   >   mailing lists

Thread: Trigger Script Error

Trigger Script Error

From
Bartosz Dmytrak
Date:
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

Re: Trigger Script Error

From
Guillaume Lelarge
Date:
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