Re: [HACKERS] odd pg_dump output? - Mailing list pgsql-hackers

>Thanks Tatsuo! But these are older problems, not new breakage from me,
>right? Have you had a chance to test the latest pg_dump with your
>patches? I'm still concerned that I didn't test pg_dump with a
>regression test dump/reload/dump sequence (by comparing the two dump
>files).

I ran pg_dump with the regression DB, then did psql to reload.
seems there are some problems in the output from pg_dump.

BTW, this is FreeBSD 2.2.6 and one of the regression gets dump core
(select_having).
--
Tatsuo Ishii
t-ishii@sra.co.jp

CREATE TYPE widget ( internallength = 24, externallength = -1, input = 144673(widget_in), output = 144674(widget_out),
send= 144674(widget_out), receive = 144673(widget_in), default = '-'); 
ERROR:  parser: parse error at or near "("
CREATE TYPE _widget ( internallength = -1, externallength = -1, input = 750(array_in), output = 751(array_out), send =
751(array_out),receive = 750(array_in), default = '-'); 
ERROR:  parser: parse error at or near "("
CREATE TYPE city_budget ( internallength = 16, externallength = -1, input = 1287(int44in), output = 653(int44out), send
=653(int44out), receive = 1287(int44in), default = '-', element = int4, delimiter = ','); 
ERROR:  parser: parse error at or near "("
CREATE TYPE _city_budget ( internallength = -1, externallength = -1, input = 750(array_in), output = 751(array_out),
send= 751(array_out), receive = 750(array_in), default = '-'); 
ERROR:  parser: parse error at or near "("
CREATE SEQUENCE default_seq start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
SELECT nextval ('default_seq');
CREATE
nextval
-------
      1
(1 row)

CREATE SEQUENCE check_seq start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE SEQUENCE insert_seq start 8 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
SELECT nextval ('insert_seq');
CREATE
CREATE
nextval
-------
      8
(1 row)

CREATE SEQUENCE rtest_seq start 4 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
SELECT nextval ('rtest_seq');
CREATE
nextval
-------
      4
(1 row)

CREATE TABLE char_tbl (f1 char(4));
CREATE TABLE varchar_tbl (f1 varchar(4));
CREATE TABLE text_tbl (f1 text);
CREATE TABLE int2_tbl (f1 int2);
CREATE TABLE int4_tbl (f1 int4);
CREATE TABLE int8_tbl (q1 int8, q2 int8);
CREATE TABLE float4_tbl (f1 float4);
CREATE TABLE float8_tbl (f1 float8);
CREATE TABLE point_tbl (f1 point);
CREATE TABLE lseg_tbl (s lseg);
CREATE TABLE box_tbl (f1 box);
CREATE TABLE path_tbl (f1 path);
CREATE TABLE polygon_tbl (f1 polygon);
CREATE TABLE circle_tbl (f1 circle);
CREATE TABLE timespan_tbl (f1 timespan);
CREATE TABLE datetime_tbl (d1 datetime);
CREATE TABLE reltime_tbl (f1 reltime);
CREATE TABLE abstime_tbl (f1 abstime);
CREATE TABLE tinterval_tbl (f1 tinterval);
CREATE TABLE hobbies_r (name text, person text);
CREATE TABLE equipment_r (name text, hobby text);
CREATE TABLE onek (unique1 int4, unique2 int4, two int4, four int4, ten int4, twenty int4, hundred int4, thousand int4,
twothousandint4, fivethous int4, tenthous int4, odd int4, even int4, stringu1 name, stringu2 name, string4 name); 
CREATE TABLE tenk1 (unique1 int4, unique2 int4, two int4, four int4, ten int4, twenty int4, hundred int4, thousand
int4,twothousand int4, fivethous int4, tenthous int4, odd int4, even int4, stringu1 name, stringu2 name, string4 name); 
CREATE TABLE tenk2 (unique1 int4, unique2 int4, two int4, four int4, ten int4, twenty int4, hundred int4, thousand
int4,twothousand int4, fivethous int4, tenthous int4, odd int4, even int4, stringu1 name, stringu2 name, string4 name); 
CREATE TABLE person (name text, age int4, location point);
CREATE TABLE emp (salary int4, manager name) inherits ( person);
CREATE TABLE student (gpa float8) inherits ( person);
CREATE TABLE stud_emp (percent int4) inherits ( emp, student);
CREATE TABLE city (name name, location box, budget city_budget);
ERROR:  type name lookup of city_budget failed
CREATE TABLE dept (dname name, mgrname text);
CREATE TABLE slow_emp4000 (home_base box);
CREATE TABLE fast_emp4000 (home_base box);
CREATE TABLE road (name text, thepath path);
CREATE TABLE ihighway () inherits ( road);
CREATE TABLE shighway (surface text) inherits ( road);
CREATE TABLE real_city (pop int4, cname text, outline path);
CREATE TABLE a_star (class char(1), aa int4, a text);
CREATE TABLE b_star (bb text) inherits ( a_star);
CREATE TABLE c_star (cc name) inherits ( a_star);
CREATE TABLE d_star (dd float8) inherits ( b_star, c_star);
CREATE TABLE e_star (ee int2, e int4) inherits ( c_star);
CREATE TABLE f_star (ff polygon, f int4) inherits ( e_star);
CREATE TABLE aggtest (a int2, b float4);
CREATE TABLE arrtest (a _int2, b _int4, c _name, d _text, e _float8);
CREATE TABLE hash_i4_heap (seqno int4, random int4);
CREATE TABLE hash_name_heap (seqno int4, random name);
CREATE TABLE hash_txt_heap (seqno int4, random text);
CREATE TABLE hash_f8_heap (seqno int4, random float8);
CREATE TABLE bt_i4_heap (seqno int4, random int4);
CREATE TABLE bt_name_heap (seqno name, random int4);
CREATE TABLE bt_txt_heap (seqno text, random int4);
CREATE TABLE bt_f8_heap (seqno float8, random int4);
CREATE TABLE default_tbl (i int4 DEFAULT 100, x text DEFAULT 'vadim', f float8 DEFAULT 123.456);
CREATE TABLE defaultexpr_tbl (i1 int4 DEFAULT 100 + ( 200 - 199 ) * 2, i2 int4 DEFAULT nextval ( 'default_seq' ));
CREATE TABLE check_tbl (x int4,  CONSTRAINT check_con CHECK (x > 3));
CREATE TABLE check2_tbl (x int4, y text, z int4,  CONSTRAINT sequence_con CHECK (x > 3 AND y <> 'check failed' AND z <
8));
CREATE TABLE insert_tbl (x int4 DEFAULT nextval ( 'insert_seq' ), y text DEFAULT '-NULL-', z int4 DEFAULT - 1 * currval
('insert_seq' ),  CONSTRAINT insert_con CHECK (x >= 3 AND y <> 'check failed' AND x < 8),  CHECK (x + z = 0)); 
CREATE TABLE copy_tbl (x int4, y text, z int4,  CONSTRAINT copy_con CHECK (x > 3 AND y <> 'check failed' AND x < 7));
CREATE TABLE onek2 (unique1 int4, unique2 int4, two int4, four int4, ten int4, twenty int4, hundred int4, thousand
int4,twothousand int4, fivethous int4, tenthous int4, odd int4, even int4, stringu1 name, stringu2 name, string4 name); 
CREATE TABLE bprime (unique1 int4, unique2 int4, two int4, four int4, ten int4, twenty int4, hundred int4, thousand
int4,twothousand int4, fivethous int4, tenthous int4, odd int4, even int4, stringu1 name, stringu2 name, string4 name); 
CREATE TABLE ramp (name text, thepath path);
CREATE TABLE iportaltest (i int4, d float4, p polygon);
CREATE TABLE test_having (a int4, b int4, c char(8), d char(1));
CREATE TABLE subselect_tbl (f1 int4, f2 int4, f3 float8);
CREATE TABLE xacttest (a int2, b float4);
CREATE TABLE random_tbl (random int4);
CREATE TABLE rtest_t1 (a int4, b int4);
CREATE TABLE rtest_t2 (a int4, b int4);
CREATE TABLE rtest_t3 (a int4, b int4);
CREATE TABLE rtest_system (sysname text, sysdesc text);
CREATE TABLE rtest_interface (sysname text, ifname text);
CREATE TABLE rtest_person (pname text, pdesc text);
CREATE TABLE rtest_admin (pname text, sysname text);
CREATE TABLE rtest_emp (ename char(20), salary money);
CREATE TABLE rtest_emplog (ename char(20), who name, action char(10), newsal money, oldsal money);
CREATE TABLE rtest_empmass (ename char(20), salary money);
CREATE TABLE rtest_t4 (a int4, b text);
CREATE TABLE rtest_t5 (a int4, b text);
CREATE TABLE rtest_t6 (a int4, b text);
CREATE TABLE rtest_t7 (a int4, b text);
CREATE TABLE rtest_t8 (a int4, b text);
CREATE TABLE rtest_t9 (a int4, b text);
CREATE TABLE rtest_order1 (a int4);
CREATE TABLE rtest_order2 (a int4, b int4, c text);
CREATE TABLE rtest_nothn1 (a int4, b text);
CREATE TABLE rtest_nothn2 (a int4, b text);
CREATE TABLE rtest_nothn3 (a int4, b text);
CREATE TABLE rtest_nothn4 (a int4, b text);
CREATE FUNCTION widget_in (opaque ) RETURNS widget AS
'/mnt2/home/mgr/t-ishii/src/PostgreSQL/anonCVS/pgsql/src/test/regress/input/../regress.so'LANGUAGE 'C'; 
NOTICE:  ProcedureCreate: type 'widget' is not yet defined
CREATE FUNCTION widget_out (opaque ) RETURNS opaque AS
'/mnt2/home/mgr/t-ishii/src/PostgreSQL/anonCVS/pgsql/src/test/regress/input/../regress.so'LANGUAGE 'C'; 
CREATE FUNCTION check_primary_key ( ) RETURNS opaque AS
'/mnt2/home/mgr/t-ishii/src/PostgreSQL/anonCVS/pgsql/src/test/regress/input/../../../../contrib/spi/refint.so'LANGUAGE
'C';
CREATE FUNCTION check_foreign_key ( ) RETURNS opaque AS
'/mnt2/home/mgr/t-ishii/src/PostgreSQL/anonCVS/pgsql/src/test/regress/input/../../../../contrib/spi/refint.so'LANGUAGE
'C';
CREATE FUNCTION autoinc ( ) RETURNS opaque AS
'/mnt2/home/mgr/t-ishii/src/PostgreSQL/anonCVS/pgsql/src/test/regress/input/../../../../contrib/spi/autoinc.so'LANGUAGE
'C';
CREATE FUNCTION funny_dup17 ( ) RETURNS opaque AS
'/mnt2/home/mgr/t-ishii/src/PostgreSQL/anonCVS/pgsql/src/test/regress/input/../regress.so'LANGUAGE 'C'; 
CREATE FUNCTION ttdummy ( ) RETURNS opaque AS
'/mnt2/home/mgr/t-ishii/src/PostgreSQL/anonCVS/pgsql/src/test/regress/input/../regress.so'LANGUAGE 'C'; 
CREATE FUNCTION set_ttdummy (int4 ) RETURNS int4 AS
'/mnt2/home/mgr/t-ishii/src/PostgreSQL/anonCVS/pgsql/src/test/regress/input/../regress.so'LANGUAGE 'C'; 
CREATE FUNCTION hobbies (person ) RETURNS  SETOF hobbies_r AS 'select * from hobbies_r where person = $1.name' LANGUAGE
'SQL';
CREATE FUNCTION hobby_construct (text,text ) RETURNS hobbies_r AS 'select $1 as name, $2 as hobby' LANGUAGE 'SQL';
CREATE FUNCTION equipment (hobbies_r ) RETURNS  SETOF equipment_r AS 'select * from equipment_r where hobby = $1.name'
LANGUAGE'SQL'; 
CREATE FUNCTION user_relns ( ) RETURNS  SETOF name AS 'select relname
       from pg_class
       where relname !~ ''pg_.*'' and
             relkind <> ''i'' ' LANGUAGE 'SQL';
CREATE FUNCTION pt_in_widget (point,widget ) RETURNS int4 AS
'/mnt2/home/mgr/t-ishii/src/PostgreSQL/anonCVS/pgsql/src/test/regress/input/../regress.so'LANGUAGE 'C'; 
NOTICE:  ProcedureCreate: arg type 'widget' is only a shell
CREATE FUNCTION overpaid (emp ) RETURNS bool AS
'/mnt2/home/mgr/t-ishii/src/PostgreSQL/anonCVS/pgsql/src/test/regress/input/../regress.so'LANGUAGE 'C'; 
CREATE FUNCTION boxarea (box ) RETURNS int4 AS
'/mnt2/home/mgr/t-ishii/src/PostgreSQL/anonCVS/pgsql/src/test/regress/input/../regress.so'LANGUAGE 'C'; 
CREATE FUNCTION interpt_pp (path,path ) RETURNS point AS
'/mnt2/home/mgr/t-ishii/src/PostgreSQL/anonCVS/pgsql/src/test/regress/input/../regress.so'LANGUAGE 'C'; 
CREATE FUNCTION reverse_name (name ) RETURNS name AS
'/mnt2/home/mgr/t-ishii/src/PostgreSQL/anonCVS/pgsql/src/test/regress/input/../regress.so'LANGUAGE 'C'; 
CREATE AGGREGATE newcnt ( BASETYPE = int4,   SFUNC2 = 766(int4inc), STYPE2 = int4, INITCOND2 = '0'  );
ERROR:  parser: parse error at or near "("
CREATE AGGREGATE newavg ( BASETYPE = int4,  SFUNC1 = 177(int4pl), STYPE1 = int4, INITCOND1 = '0', SFUNC2 =
766(int4inc),STYPE2 = int4, INITCOND2 = '0', FINALFUNC = 154(int4div) ); 
ERROR:  parser: parse error at or near "("
CREATE AGGREGATE newsum ( BASETYPE = int4,  SFUNC1 = 177(int4pl), STYPE1 = int4, INITCOND1 = '0'   );
ERROR:  parser: parse error at or near "("
CREATE OPERATOR #%# (PROCEDURE = 142(int4fac) , LEFTARG = int4        );
ERROR:  parser: parse error at or near "("
 CREATE OPERATOR ## (PROCEDURE = 973(path_inter) , LEFTARG = path  , RIGHTARG = path  , COMMUTATOR = ##      );
ERROR:  parser: parse error at or near "("
 CREATE OPERATOR <% (PROCEDURE = 145188(pt_in_widget) , LEFTARG = point  , RIGHTARG = widget  , COMMUTATOR = >=%
);
ERROR:  parser: parse error at or near "("
 CREATE OPERATOR >=% (PROCEDURE = 145188(pt_in_widget) , LEFTARG = point  , RIGHTARG = widget  , COMMUTATOR = <%
);
ERROR:  parser: parse error at or near "("
 CREATE OPERATOR @#@ (PROCEDURE = 142(int4fac)  , RIGHTARG = int4       );
ERROR:  parser: parse error at or near "("
 CREATE OPERATOR #@# (PROCEDURE = 142(int4fac) , LEFTARG = int4        );
ERROR:  parser: parse error at or near "("
 COPY char_tbl FROM stdin;