Re: SQL99 CREATE TABLE ... (LIKE parent_table) - Mailing list pgsql-patches

From Hannu Krosing
Subject Re: SQL99 CREATE TABLE ... (LIKE parent_table)
Date
Msg-id 1052816920.1922.6.camel@fuji.krosing.net
Whole thread Raw
In response to Re: SQL99 CREATE TABLE ... (LIKE parent_table)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: SQL99 CREATE TABLE ... (LIKE parent_table)  (Rod Taylor <rbt@rbt.ca>)
List pgsql-patches
Tom Lane kirjutas E, 12.05.2003 kell 17:59:
> Rod Taylor <rbt@rbt.ca> writes:
> > Quick patch to add the subject.  Restructures all inheritance to consist
> > of a few flags to indicate which structures we want to inherit
>
> I think overloading the inheritance mechanism to serve this purpose is a
> bad idea.

Are you sure that LIKE is not _supposed_ to be inheritable. I mean that
changes done to the LIKE table should carry over to the table defined
using LIKE:

create table template( i int);
create table instance(like template, t text);
alter table template add column j int;

and now instance should have columns i,j,t .

> It complicates and confuses a significant amount of code
> that's already pretty confusing (no, I don't believe you found it all).
> It'd be better to have a localized bit of code that processes LIKE by
> generating a ColumnDef schema list.

Would this not detach the definitions .

----------
Hannu


pgsql-patches by date:

Previous
From: "Andrew Dunstan"
Date:
Subject: CIDR addresses in pg_hba.conf
Next
From: Rod Taylor
Date:
Subject: Re: SQL99 CREATE TABLE ... (LIKE parent_table)