Обсуждение: pg_dumap not include foreign key...

me datastru ,try pg_dumpall > aa.out what not include foreign key......

CREATE TABLE "purcsub" (
   "trn_no" char(14) NOT NULL,
   "seq" int4 DEFAULT nextval('seq'::text),
   "pmrc_no" varchar(14),
   "item_no" char(20) NOT NULL,
   "item_na1" varchar(120),
   "color_na" varchar(20),
   "ware_no" char(4),
   "unit" varchar(4),
   "trn_qty" int2,
   "qty" float8 default 0,
   "sqty" float8 default 0,
   "price" float8 default 0,
   "sprice" float8 default 0,
   "discount" float8 default 0,
   "amount" float8 default 0,
   "memo" varchar(20),
   "trn_type" varchar(2),
   "trn_date" date,
   "fact_no" char(20),
   "giveaway" varchar(1),
foreign key (trn_no) references purc (trn_no)
ON DELETE CASCADE ON UPDATE CASCADE

);

���R�W�����^ �� �O �� �H �� �~�ȥD���G�� �� �t�A�ȱM�u�G0932-535772
mailto:msee@kimo.com.tw

You should have another lines later in the dump that start
with CREATE CONSTRAINT TRIGGER
These are the internal representation of the foreign key
constraint and is how pg_dump[all] currently should be
dumping those constraints out.  They probably are near
the bottom of the dump.

On Mon, 25 Dec 2000, xyzii wrote:

> me datastru ,try pg_dumpall > aa.out what not include foreign key......
>
> CREATE TABLE "purcsub" (
>    "trn_no" char(14) NOT NULL,
>    "seq" int4 DEFAULT nextval('seq'::text),
>    "pmrc_no" varchar(14),
>    "item_no" char(20) NOT NULL,
>    "item_na1" varchar(120),
>    "color_na" varchar(20),
>    "ware_no" char(4),
>    "unit" varchar(4),
>    "trn_qty" int2,
>    "qty" float8 default 0,
>    "sqty" float8 default 0,
>    "price" float8 default 0,
>    "sprice" float8 default 0,
>    "discount" float8 default 0,
>    "amount" float8 default 0,
>    "memo" varchar(20),
>    "trn_type" varchar(2),
>    "trn_date" date,
>    "fact_no" char(20),
>    "giveaway" varchar(1),
> foreign key (trn_no) references purc (trn_no)
> ON DELETE CASCADE ON UPDATE CASCADE
>
> );