How to rename a constraint/trigger??

am 06.09.2004 16:03:02 von klodoma

This is a multi-part message in MIME format.

------=_NextPart_000_022F_01C49433.5E74EAA0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi to all,

I have a database, where in the tables I have around 100 constrains (link t=
o other tables) that don't have a name "" or they have a name like=
"$1" "$2". Now, I have a module which bases on the same structure, but I g=
et some query errors from a "" constraint. I really don't know exa=
clty which the constrain generates the error, in that table I have 12 such=
constrains.=20

Does anyone have a script or it exist a command so that I can rename all th=
e ""constrains in this database?=20

I'm using postgre 7.3.2.

Thankx,
Andy.

------=_NextPart_000_022F_01C49433.5E74EAA0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi =
to=20
all,

I have a database, where in the tables I h=
ave=20
around 100 constrains (link to other tables) that don't have a name=20
"<unnamed>" or they have a name like "$1" "$2". Now, I have a module =
which=20
bases on the same structure, but I get some query errors from a=20
"<unnamed>" constraint. I really don't know exaclty which the=
=20
constrain generates the error, in that table I have 12 such constrains=
..=20

Does anyone have a script or it exist=
a=20
command so that I can rename all the "<unnamed>"constrains in this=20
database?

I'm using postgre 7.3.2.

Thankx,

Andy.

------=_NextPart_000_022F_01C49433.5E74EAA0--