On Monday 29 May 2006 09:43 am, Michael Fuhr <[EMAIL PROTECTED]> thus
communicated:
--> On Mon, May 29, 2006 at 08:40:43AM -0400, Terry Lee Tucker wrote:
--> > INSERT INTO ctable (code, name) VALUES ('code_one', 'Code One');
--> > rnd=# SELECT * FROM ptable;
--> >code
--> > --
--> > c
On Mon, May 29, 2006 at 08:40:43AM -0400, Terry Lee Tucker wrote:
> INSERT INTO ctable (code, name) VALUES ('code_one', 'Code One');
> rnd=# SELECT * FROM ptable;
>code
> --
> code_one
> (1 row)
>
> rnd=# SELECT * FROM ctable;
> code | name
> ---+--
>
Hello List:
Please observe the following example that reproduces my problem:
CREATE TABLE ptable (code VARCHAR) WITHOUT OIDS;
CREATE TABLE
CREATE TABLE ctable (code VARCHAR, name VARCHAR)
INHERITS (ptable) WITHOUT OIDS;
NOTICE: merging column "code" with inherited definition
CREATE TABL
