Re: ALTER TABLE - Mailing list pgsql-admin

From A.Bhuvaneswaran
Subject Re: ALTER TABLE
Date
Msg-id Pine.LNX.4.44.0306051251370.2462-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to ALTER TABLE  (Martins Zarins <mark@vestnesis.lv>)
List pgsql-admin
> work=# ALTER TABLE rdu ADD CONSTRAINT rdu_finish_time CHECK ((start_time <=
> finish_time) OR finish_time IS NULL);
> ERROR:  AlterTableAddConstraint: rejected due to CHECK constraint
> rdu_finish_time

I can say that the field, finish_time have the values which conflict with
the check constraint you define. ie.. Records exist with start_time
> finish_time, so update the records and try.

regards,
bhuvaneswaran


pgsql-admin by date:

Previous
From: "Anagha Joshi"
Date:
Subject: Urgent Help Needed !!!!!!!
Next
From: "Victor Yegorov"
Date:
Subject: Re: ALTER TABLE