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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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