Re: [HACKERS] Misleading CREATE TABLE error

2012-02-26 Thread Robert Haas
On Fri, Feb 24, 2012 at 4:03 AM, Peter Eisentraut pete...@gmx.net 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

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 tables into

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 to base a

Re: [HACKERS] Misleading CREATE TABLE error

2011-12-27 Thread Thom Brown
On 27 December 2011 20:16, Peter Eisentraut pete...@gmx.net 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

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 t...@linux.com 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

Re: [HACKERS] Misleading CREATE TABLE error

2011-11-09 Thread Robert Haas
On Tue, Nov 8, 2011 at 4:49 PM, Thom Brown t...@linux.com 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