Re: Trigger Script Error

On Tue, 21 Feb 2012 21:53:49 +0100, Bartosz Dmytrak <bdmytrak(at)eranet(dot)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