From: | "Hiroshi Saito" <saito(at)inetrt(dot)skcapi(dot)co(dot)jp> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Cc: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
Subject: | The comment sentence of Primary-Key is lost. |
Date: | 2003-09-19 14:13:26 |
Message-ID: | 04a901c37eb8$31b65120$1f324d80@w2k |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi all.
My comment sentence of Primary-Key is lost.!
See this sample below.
---------------------------------------------------------------
CREATE TABLE "MyTransaction"
(
"XID" int4 NOT NULL,
"LastSeqId" int4 NOT NULL,
"HostId" int4 NOT NULL,
CONSTRAINT "MyTransaction_pkey" PRIMARY KEY ("XID", "HostId")
) WITH OIDS;
COMMENT ON CONSTRAINT "MyTransaction_pkey" ON "MyTransaction" IS 'What happens to this?';
----------------------------------------------------------------
saito=# SELECT cls.oid, cls.relname as idxname, indrelid, indkey, indisclustered, indisunique,
indisprimary, n.nspname, indnatts, tab.relname as tabname, indclass, description,
pg_get_expr(indpred, indrelid, true) as indconstraint, contype, condeferrable, condeferred, amname
FROM pg_index idx
JOIN pg_class cls ON cls.oid=indexrelid
JOIN pg_class tab ON tab.oid=indrelid
JOIN pg_namespace n ON n.oid=tab.relnamespace
JOIN pg_am am ON am.oid=cls.relam
LEFT OUTER JOIN pg_description des ON (des.objoid=cls.oid AND des.objsubid = 0)
LEFT OUTER JOIN pg_constraint con ON con.conrelid=indrelid AND conname=cls.relname
WHERE cls.relname = 'MyTransaction_pkey';
oid | idxname | indrelid | indkey | indisclustered | indisunique | indisprimary | nspname | indnatts | tabname
| indclass | description | indconstraint | contype | condeferrable | condeferred | amname
--------+--------------------+----------+--------+----------------+-------------+--------------+---------+----------+-----------
----+-----------+-------------+---------------+---------+---------------+-------------+--------
518874 | MyTransaction_pkey | 518872 | 1 3 | f | t | t | saito | 2 |
MyTransaction | 1978 1978 | | | p | f | f | btree
(1 row)
*Why?*
saito=# SELECT * FROM pg_description WHERE objoid >= 518874::OID;
objoid | classoid | objsubid | description
--------+----------+----------+-----------------------
518875 | 16386 | 0 | What happens to this?
(1 row)
Hmm... 518875?
Do I have misunderstanding?
However,
pg_dumpall that all is supposed to be extracted after this result loses this.
As for this cause, something isn't known.
Any comment?
Regards,
Hiroshi Saito
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Luc Lachance | 2003-09-19 14:43:52 | Re: select where id=random()*something returns two results |
Previous Message | Ian Grant | 2003-09-19 11:01:57 | Re: select where id=random()*something returns two results |