From: Andrei Bintintan <klodoma@ar-sd.net>
To: pgsql-sql@postgresql.org
To: pgsql-admin@postgresql.org
Subject: How to rename a constraint/trigger??
Date: Mon, 6 Sep 2004 17:03:02 +0300
Message-ID: <023201c4941a$3ade6350$0b00a8c0@forge> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: klodoma@ar-sd.net, pgsql-admin@postgresql.org
Subject: Re: How to rename a constraint/trigger??
In-Reply-To: <023201c4941a$3ade6350$0b00a8c0@forge>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox