pg_dump bug

From: Jie Liang <jliang(at)beijing(dot)rapid(dot)stbernard(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Cc: <pgsql-admin(at)postgresql(dot)org>, <rcrowe(at)stbernard(dot)com>
Subject: pg_dump bug
Date: 2002-04-01 20:11:12
Message-ID: 20020401115249.P56218-100000@beijing.rapid.stbernard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-bugs

I have a pg_dump file which contains only schemas,
I think there is a bug, which causes function reload
fail, look at following pieces of dump file:
......
......
--
-- TOC Entry ID 212 (OID 34744710)
--
-- Name: gibson Type: TABLE Owner: jliang
--

CREATE TABLE "gibson" (
"cid" integer,
"code" character varying(10),
"name" character varying(32)
);

--
-- TOC Entry ID 368 (OID 34746075)
--
-- Name: "urlsbycid" (smallint) Type: FUNCTION Owner: jliang
--

CREATE FUNCTION "urlsbycid" (smallint) RETURNS SETOF text AS '
select url from urlinfo where id = ratings_by_serial.id and
ratings_by_serial.cid = $1 order by random() limit 100;
' LANGUAGE 'sql';

--
-- TOC Entry ID 213 (OID 34752225)
--
-- Name: gibson2 Type: TABLE Owner: jliang
--

CREATE TABLE "gibson2" (
"cid" integer,
"code" character varying(10),
"name" character varying(32),
"url" text
);
......
......
--
-- TOC Entry ID 235 (OID 67353384)
--
-- Name: urlinfo Type: TABLE Owner: bob
--

CREATE TABLE "urlinfo" (
"url" text NOT NULL,
"id" integer NOT NULL,
"ratedby" character varying(32),
"ratedon" timestamp with time zone DEFAULT
"timestamp"('now'::text),
"comments" text,
"list" smallint,
"pidwsr" integer,
"refid" integer,
Constraint "urlinfo_pkey" Primary Key ("id")
);
......
......

BUG:
CREATE FUNCTION "urlsbycid" cannot be created before
table "urlinfo" created!!!

I am using PostgreSQL-7.1.3 with pg_dump -s -f filename dbname.
I am upgrading my DB from Pg7.1.3 to Pg7.2.
This is one of problems I got.
I don't know does this bug has been fixed in Pg7.2??

Jie LIANG

Software Engineer
St. Bernard Software

16882 W. Bernardo Dr.
San Diego, CA 92127
Office:(858)524-2134

jie(at)stbernard(dot)com

Browse pgsql-admin by date

  From Date Subject
Next Message Chad R. Larson 2002-04-01 20:23:02 Re: Is Posgresql and Interchange multithreaded?
Previous Message Gill, Jeffrey L 2002-04-01 17:56:27 Is Posgresql and Interchange multithreaded?

Browse pgsql-bugs by date

  From Date Subject
Next Message Joe Piscitella 2002-04-01 21:42:08 Solaris 8 install of postgres 7.2
Previous Message Konrad Gdowski 2002-03-31 22:22:48 date function 'age' problem