Skip site navigation (1) Skip section navigation (2)

Re: BUG #5201: insert select gives bogus error message

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "" <anteusz(at)freemail(dot)hu>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5201: insert select gives bogus error message
Date: 2009-11-21 06:02:43
Message-ID: 4821.1258783363@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"" <anteusz(at)freemail(dot)hu> writes:
> I have two tables.
> table a, and table b.
> table a inherits table b in create table.
> table b had at least 10 fields.
> I had a command insert into a select * from b;
> I got an error message saying
> that number of expressions/arguments is not ok.
> This does not happen if I use "like" instead of inherit.

This is most likely pilot error, but without seeing exactly what
you did, no one can tell for sure.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: denny saviantDate: 2009-11-21 14:13:52
Subject: BUG #5207: unable to start postgresql server services
Previous:From: Alvaro HerreraDate: 2009-11-20 23:56:59
Subject: BUG #5206: wal_sync_method in stock postgresql.conf may be wrong

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group