============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Peter Hunter
Your email address : [EMAIL PROTECTED]
System Configuration
---------------------
Architecture (example: Intel Pentium) :Intel Pentium
Operating System (example: Linux 2.0.26 ELF) :Linux 2.2.12 ELF
PostgreSQL version (example: PostgreSQL-6.5.1): PostgreSQL-7.0beta1
Compiler used (example: gcc 2.8.0) :egcs-2.91.66
Please enter a FULL description of your problem:
------------------------------------------------
If you create two tables, one of which inherits from the other, then add a
field into the parent using alter table, it doesn't appear in the
child. (Which already seems to me a bug.) If you then add a field of the
same name into the child, insert some data into the child, and then dump,
the dump has columns in the wrong order, which means the dump will not
load, or worse, will load but put data into the wrong columns.
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
create database test;
create table a (first int4);
create table b (second text) inherits (a);
alter table a add column third int4;
alter table b add column third int4;
insert into b values (1, 'a', 2);
Now dump the database:
$ pg_dump test >test.pgsql
$ cat test.pgsql
CREATE TABLE "a" (
"first" int4,
"third" int4
);
CREATE TABLE "b" (
"second" text
)
inherits ("a");
COPY "a" FROM stdin;
\.
COPY "b" FROM stdin;
1 a 2
\.
Now notice the table b will be recreated with columns in the order first,
third, second, but the dump has columns in the order first, second, third.
So if we now do:
drop table b;
drop table a;
\i test
You are now connected as new user peter.
CREATE
CREATE
psql:public_html/catalogus/test:11: ERROR: copy: line 1, pg_atoi: error in
"a": can't parse "a"
psql:public_html/catalogus/test:11: PQendcopy: resetting connection
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
