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

BUG #5201: insert select gives bogus error message

From: "" <anteusz(at)freemail(dot)hu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5201: insert select gives bogus error message
Date: 2009-11-20 09:31:02
Message-ID: 200911200931.nAK9V2iJ095076@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      5201
Logged by:          
Email address:      anteusz(at)freemail(dot)hu
PostgreSQL version: 8.3
Operating system:   Kanotix, Debian based
Description:        insert select gives bogus error message
Details: 

Hi,

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.

Responses

pgsql-bugs by date

Next:From: Marcel WielandDate: 2009-11-20 14:58:01
Subject: BUG #5202: Rule affecting more than one row is only fired once with LIMIT 1
Previous:From: Magnus HaganderDate: 2009-11-20 01:28:49
Subject: Re: BUG #5065: pg_ctl start fails as administrator, with "could not locate matching postgres executable"

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