how can i change my table/column constraint

From: "Muhammad Rusydi" <rusydi(at)cbn(dot)net(dot)id>
To: "postgres general" <pgsql-general(at)postgresql(dot)org>
Subject: how can i change my table/column constraint
Date: 2001-05-05 06:49:31
Message-ID: 003e01c0d530$032e8220$1102a8c0@windows
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
if i have created this tables:
create table lab (
kd_lab varchar(4) check (kd_lab ~'[0][1-4][0-9][0-9]'),
name varchar(10),
primary key (kd_lab));

create table tb2 (
kd_lab varchar(4) references lab (kd_lab),
tb2 varchar(10),
primary key (kd_lab));

the questions is if i want to change the check constraint to
[0][1-5][0-9][0-9]
how can i do this?
if i create another table named lab2 with same fields and then i move
all tuples from lab to lab2, then drop table lab and rename lab2 to
lab, is the references constraint in table tb2 still valid?
would you show me how to do this?

TIA
Didi

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Anand Raman 2001-05-05 07:18:59 Re: how can i change my table/column constraint
Previous Message Doug McNaught 2001-05-05 04:50:40 Re: how can i get plpgsql in function?