basically copy the table to some other table..
Drop the old table..
recreate it with the constraints changed
Repopulate the table..
Hope this helps
Anand
On Sat, May 05, 2001 at 01:49:31PM +0700, Muhammad Rusydi wrote:
>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
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org