Postgres Pro
Downloads
Home   >   mailing lists

Re: Updating a table column with ref integrity - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Updating a table column with ref integrity
Date
Msg-id web-1827592@davinci.ethosmedia.com
Whole thread Raw
In response to Updating a table column with ref integrity  (teknokrat <teknokrat@yahoo.com>)
Responses how can I improve the speed of this query  ("Peter T. Brown" <peter@memeticsystems.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Proposal of hierarchical queries, a la Oracle
Next
From: Richard Huxton
Date:
Subject: Re: Does Postgres replace \\ with \ in an update query