Re: [HACKERS] Misleading CREATE TABLE error

2012-02-26 Thread Robert Haas
On Fri, Feb 24, 2012 at 4:03 AM, Peter Eisentraut wrote: > On tis, 2011-11-29 at 06:33 +0200, Peter Eisentraut wrote: >> > > I'm not trying to inherit a relation, I'm trying to base a table on >> > > it.  As it happens, "cows" is a foreign table, which *is* a table, >> > > just not a regular table

Re: [HACKERS] Misleading CREATE TABLE error

2012-02-24 Thread Peter Eisentraut
On tis, 2011-11-29 at 06:33 +0200, Peter Eisentraut wrote: > > > I'm not trying to inherit a relation, I'm trying to base a table on > > > it. As it happens, "cows" is a foreign table, which *is* a table, > > > just not a regular table. It might be useful to add support to clone > > > foreign tab

Re: [HACKERS] Misleading CREATE TABLE error

2011-12-27 Thread Thom Brown
On 27 December 2011 20:16, Peter Eisentraut wrote: > It's not only the error message that's misleading, but the whole code, > because the entire code for CREATE TABLE ... (LIKE ...) claims to do > "inheritance" based on an ancient understanding of the SQL standard.  I > know this has confused me m

Re: [HACKERS] Misleading CREATE TABLE error

2011-12-27 Thread Peter Eisentraut
On tis, 2011-11-08 at 21:49 +, Thom Brown wrote: > I found the following error message misleading: > > test=# create table cows2 (LIKE cows); > ERROR: inherited relation "cows" is not a table > STATEMENT: create table cows2 (LIKE cows); > > I'm not trying to inherit a relation, I'm trying t

Re: [HACKERS] Misleading CREATE TABLE error

2011-11-28 Thread Peter Eisentraut
On ons, 2011-11-09 at 12:00 -0500, Robert Haas wrote: > On Tue, Nov 8, 2011 at 4:49 PM, Thom Brown wrote: > > I found the following error message misleading: > > > > test=# create table cows2 (LIKE cows); > > ERROR: inherited relation "cows" is not a table > > STATEMENT: create table cows2 (LIKE

Re: [HACKERS] Misleading CREATE TABLE error

2011-11-09 Thread Robert Haas
On Tue, Nov 8, 2011 at 4:49 PM, Thom Brown wrote: > I found the following error message misleading: > > test=# create table cows2 (LIKE cows); > ERROR:  inherited relation "cows" is not a table > STATEMENT:  create table cows2 (LIKE cows); > > I'm not trying to inherit a relation, I'm trying to ba