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
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? |
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 |