Rename Trigger script error
| От | Bartosz Dmytrak |
|---|---|
| Тема | Rename Trigger script error |
| Дата | |
| Msg-id | CAD8_Ucbwo9XDr0GBMb3pBUGRW0FtFAweu=DCMqVOk7P_nfe49w@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Rename Trigger script error
|
| Список | pgadmin-support |
Hi,
Regards,
Bartek
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.
pgAdmin 1.14.2 Win 7 32 bit
Regards,
Bartek
В списке pgadmin-support по дате отправления: