| 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: | Whole Thread | Raw Message | 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 |