Trigger Script Error

From: Bartosz Dmytrak <bdmytrak(at)eranet(dot)pl>
To: pgadmin-support(at)postgresql(dot)org
Subject: Trigger Script Error
Date: 2012-02-21 20:53:49
Message-ID: CAD8_UcY4xWJgGYM+wXkee-tjW-dZqCPn8dsz4KHhotcFZ3XqNg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2012-02-21 22:25:22 Re: \Copy and "Copy With Headers" -- every day these bug me.
Previous Message Guillaume Lelarge 2012-02-21 20:39:52 Re: Extension script error