Updating a table column with ref integrity

From: teknokrat <teknokrat(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Updating a table column with ref integrity
Date: 2002-11-15 11:45:39
Message-ID: ar2mb5$2f15$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-11-15 15:20:53 Re: Error message: standard SQL or PostgreQSL?
Previous Message Evgen Potemkin 2002-11-15 09:41:11 Proposal of hierarchical queries, a la Oracle