constraints & tableoid [pgsql8.1] - Mailing list pgsql-bugs

From 维 姜
Subject constraints & tableoid [pgsql8.1]
Date
Msg-id 1144739506.7005.2.camel@dell.sduept.com
Whole thread Raw
Responses Re: constraints & tableoid [pgsql8.1]  (Richard Huxton <dev@archonet.com>)
Re: constraints & tableoid [pgsql8.1]  (Michael Fuhr <mike@fuhr.org>)
List 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=#




pgsql-bugs by date:

Previous
From: "Anton"
Date:
Subject: BUG #2385: libpq, lo_write bug
Next
From: Richard Huxton
Date:
Subject: Re: constraints & tableoid [pgsql8.1]