pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedrename constraint
2+ messages / 2 participants
[nested] [flat]
* rename constraint
@ 2008-04-17 12:03 sathiya psql <sathiya.psql@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: sathiya psql @ 2008-04-17 12:03 UTC (permalink / raw)
To: pgsql-performance
Hi,
I need to change the name of the constraint.,
What will be the best way to do this.
Am using postgres 8.1.
Is it possible to do the rename constraint( like renaming a column), i don't
know how to do this ?
Or i need to drop the constraint, and i need to create constraint with new
name, how the impact of this in performance, because these constraint
changes am going to do in a table which has 10 million records....
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: rename constraint
@ 2008-04-17 12:14 Thomas Spreng <spreng@socket.ch>
parent: sathiya psql <sathiya.psql@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Thomas Spreng @ 2008-04-17 12:14 UTC (permalink / raw)
To: sathiya psql <sathiya.psql@gmail.com>; +Cc: pgsql-performance
On 17.04.2008, at 14:03, sathiya psql wrote:
> Hi,
>
> I need to change the name of the constraint.,
>
> Or i need to drop the constraint, and i need to create constraint
> with new
> name, how the impact of this in performance, because these constraint
> changes am going to do in a table which has 10 million records....
That's how I would do it, create the new constriaint, then drop the
old one.
I'n not aware of any syntax that would allow to rename a constraint.
Cheers,
tom
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-04-17 12:14 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-04-17 12:03 rename constraint sathiya psql <sathiya.psql@gmail.com>
2008-04-17 12:14 ` Thomas Spreng <spreng@socket.ch>
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