pg_dump doesn't work well with large object ...

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)

Browse pgsql-hackers by date

  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