How to rename a constraint/trigger??
От
Andrei Bintintan
Тема
How to rename a constraint/trigger??
Дата
Msg-id
023201c4941a$3ade6350$0b00a8c0@forge
Список
Дерево обсуждения
How to rename a constraint/trigger?? "Andrei Bintintan" <klodoma@ar-sd.net>
Re: [SQL] How to rename a constraint/trigger?? Josh Berkus <josh@agliodbs.com>
Hi to all,
I have a database, where in the tables I have around 100 constrains (link to other tables) that don't have a name "<unnamed>" or they have a name like "$1" "$2". Now, I have a module which bases on the same structure, but I get some query errors from a "<unnamed>" constraint. I really don't know exaclty which the constrain generates the error, in that table I have 12 such constrains.
Does anyone have a script or it exist a command so that I can rename all the "<unnamed>"constrains in this database?
I'm using postgre 7.3.2.
Thankx,
Andy.
В списке pgsql-admin по дате отправления