Thread: BUG #5201: insert select gives bogus error message
The following bug has been logged online: Bug reference: 5201 Logged by: Email address: anteusz@freemail.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.
"" <anteusz@freemail.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