From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Bartosz Dmytrak <bdmytrak(at)eranet(dot)pl> |
Cc: | PgAdmin Support <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Rename Trigger script error |
Date: | 2012-03-10 08:11:06 |
Message-ID: | 1331367066.2339.0.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On Fri, 2012-03-09 at 11:49 +0100, Bartosz Dmytrak wrote:
> Hi,
> I think there is another bug in trigger script.
>
> Use case is: rename trigger using GUI, Trigger has to be based on camel
> case function name
>
> Generated Code is:
> ALTER TRIGGER "TriggerOldName" ON "MySchema"."MyTable" RENAME TO
> "TriggerNewName";
>
> /*BD: this part is not necessary but is created by pgAdmin*/
> CREATE TRIGGER "TriggerNewName" AFTER INSERT OR UPDATE OF "Col1", "Col2",
> "Col3" OR DELETE
> ON "MySchema"."MyTable" FOR EACH ROW
> EXECUTE PROCEDURE doSomething(); --missing schema name and quotation
>
> but should be only:
> ALTER TRIGGER "TriggerOldName" ON "MySchema"."MyTable" RENAME TO
> "TriggerNewName";
>
> I think RENAME line is enough, rest of script generates errors like:
> Function dosomenthing() does not exists or Trigger "TriggerNewName" already
> exists (after You correct function name manually) - what is expected
> behaviour.
>
Fixed now. Thanks for your report.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2012-03-10 11:52:22 | Re: Error on delete row |
Previous Message | Guillaume Lelarge | 2012-03-09 23:04:36 | Re: BUG |