Re: ALTER TABLE

From: "A(dot)Bhuvaneswaran" <bhuvan(at)symonds(dot)net>
To: Martins Zarins <mark(at)vestnesis(dot)lv>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: ALTER TABLE
Date: 2003-06-05 07:24:45
Message-ID: Pine.LNX.4.44.0306051251370.2462-100000@Bhuvan.bksys.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

  • ALTER TABLE at 2003-06-04 15:05:10 from Martins Zarins

Browse pgsql-admin by date

  From Date Subject
Next Message Victor Yegorov 2003-06-05 07:28:05 Re: ALTER TABLE
Previous Message Eko Pranoto 2003-06-05 01:04:18 (OOT) test only