pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedUpdating a table column with ref integrity
2+ messages / 2 participants
[nested] [flat]
* Updating a table column with ref integrity
@ 2002-11-15 11:45 teknokrat <teknokrat@yahoo.com>
0 siblings, 1 reply; 2+ messages in thread
From: teknokrat @ 2002-11-15 11:45 UTC (permalink / raw)
To: pgsql-sql
I need to to change the type of a table column. The problem is that this
table has a ref integrity constarint set up with another table. Does
anyone know how I can do this easily without breaking any constraints.
thanks
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Updating a table column with ref integrity
@ 2002-11-15 18:07 Josh Berkus <josh@agliodbs.com>
parent: teknokrat <teknokrat@yahoo.com>
0 siblings, 0 replies; 2+ messages in thread
From: Josh Berkus @ 2002-11-15 18:07 UTC (permalink / raw)
To: teknokrat <teknokrat@yahoo.com>; pgsql-sql
Teknokrat,
> I need to to change the type of a table column. The problem is that
> this
> table has a ref integrity constarint set up with another table. Does
>
> anyone know how I can do this easily without breaking any
> constraints.
Easily? No.
In sum: dump your database to file. Backup. Edit the file.
Re-create and re-load the database.
-Josh Berkus
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-11-15 18:07 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-11-15 11:45 Updating a table column with ref integrity teknokrat <teknokrat@yahoo.com>
2002-11-15 18:07 ` Josh Berkus <josh@agliodbs.com>
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