Re: SQL99 CREATE TABLE ... (LIKE parent_table)
От | Rod Taylor |
---|---|
Тема | Re: SQL99 CREATE TABLE ... (LIKE parent_table) |
Дата | |
Msg-id | 1052829659.30791.15.camel@jester обсуждение исходный текст |
Ответ на | Re: SQL99 CREATE TABLE ... (LIKE parent_table) (Hannu Krosing <hannu@tm.ee>) |
Ответы |
Re: SQL99 CREATE TABLE ... (LIKE parent_table)
Re: SQL99 CREATE TABLE ... (LIKE parent_table) |
Список | pgsql-patches |
On Tue, 2003-05-13 at 05:08, Hannu Krosing wrote: > 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 is described as being replaced by the column definitions within the new table, with no mention of connection to the parent table.. 11.3, 6, d) "The <like clause> is effectively replaced by NCi, 1 (one) <= i <= cnt" -- Rod Taylor <rbt@rbt.ca> PGP Key: http://www.rbt.ca/rbtpub.asc
Вложения
В списке pgsql-patches по дате отправления: