From: | David Sauer <davids(at)orfinet(dot)cz> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | pg_dump doesn't work well with large object ... |
Date: | 1999-05-28 11:21:05 |
Message-ID: | m27lptzbha.fsf@orfinet.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I have problem with pg_dump with CVS snapshot 19990526:
david=> \c test
connecting to new database: test
test=> \d
Database = test
+------------------+----------------------------------+----------+
| Owner | Relation | Type |
+------------------+----------------------------------+----------+
| david | tst | table |
| david | xinx35274 | index |
+------------------+----------------------------------+----------+
test=> select * from tst;
entry
-----
35274
(1 row)
test=> \d tst
Table = tst
+----------------------------------+----------------------------------+-------+
| Field | Type | Length|
+----------------------------------+----------------------------------+-------+
| entry | oid | 4 |
+----------------------------------+----------------------------------+-------+
EOF
But pg_dump prints:
$ pg_dump test
CREATE TABLE "tst" (
"entry" oid);
COPY "tst" FROM stdin;
35274
\.
failed sanity check, table xinv35274 was not found
===============================================================
But xinv35274 exist:
david=> \c test
connecting to new database: test
test=> select * from pg_class where relname like 'xin%';
relname |reltype|relowner|relam|relpages|reltuples|relhasindex|relisshared|relkind|relnatts|relchecks|reltriggers|relukeys|relfkeys|relrefs|relhaspkey|relhasrules|relacl
---------+-------+--------+-----+--------+---------+-----------+-----------+-------+--------+---------+-----------+--------+--------+-------+----------+-----------+------
xinv35274| 0| 501| 0| 0| 0|t |f |l | 2| 0| 0| 0| 0| 0|f |f |
xinx35274| 0| 501| 403| 2| 2048|f |f |i | 1| 0| 0| 0| 0| 0|f |f |
(2 rows)
I think, that this is problem (mainly if I need backup).
--
* David Sauer, student of Czech Technical University
* electronic mail: davids(at)orfinet(dot)cz (mime compatible)
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 1999-05-28 12:58:47 | Re: [HACKERS] Re: Release date and docs |
Previous Message | Vadim Mikheev | 1999-05-28 10:31:05 | Re: [HACKERS] Open 6.5 items |