Skip site navigation (1) Skip section navigation (2)

constraints & tableoid [pgsql8.1]

From: 维 姜 <jw(dot)pgsql(at)sduept(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: constraints & tableoid [pgsql8.1]
Date: 2006-04-11 07:11:46
Message-ID: 1144739506.7005.2.camel@dell.sduept.com (view raw or flat)
Thread:
Lists: pgsql-bugs
jw=# CREATE TABLE base ( CHECK (tableoid = 'base'::regclass) );
CREATE TABLE
jw=# \d base
    Table "public.base"
 Column | Type | Modifiers
--------+------+-----------
Check constraints:
    "base_tableoid_check" CHECK (tableoid = 'base'::regclass::oid)

jw=# INSERT INTO base DEFAULT VALUES ;
ERROR:  new row for relation "base" violates check constraint
"base_tableoid_check"
jw=#



Responses

pgsql-bugs by date

Next:From: Richard HuxtonDate: 2006-04-11 08:26:58
Subject: Re: constraints & tableoid [pgsql8.1]
Previous:From: Patrick HeadleyDate: 2006-04-11 03:53:37
Subject: BUG #2386: pg_restore doesn't restore large objects

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group