| From: | Együd Csaba <csegyud(at)vnet(dot)hu> | 
|---|---|
| To: | "Pgsql-General(at)Postgresql(dot)Org (E-mail)" <pgsql-general(at)postgresql(dot)org> | 
| Subject: | pg_dump, bytea, dump order questions | 
| Date: | 2004-06-07 08:38:27 | 
| Message-ID: | 001601c44c6a$ce40e3e0$230a0a0a@compaq | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
Hi All,
I'd like to dump out my database using plain text format. Everything is ok,
but the bytea filds.
Restoring the dump file (using <<psql -f LO_TRY_INSERT_BYTEA.sql tmp7>>) it
sends an error message like
  psql:LO_TRY_INSERT_BYTEA.sql:14: ERROR:  Bad input string for type bytea
Trying dumping with copy commands it sends this error:
  psql:LO_TRY_COPY_BYTEA.sql:13: lost synchronization with server, resetting
connection
I used <<pg_dump -d ...>> and <<pg_dump ...>> formats for creating dump
files.
How should I use pg_dump to make it able to back my binary data correctly?
An other question. How can I make psql to change the dupm order of db
objects? My problem is, that one of my table fields has a default clasuse
using a plpgsql function. As being functions dumped after table definitions
creating these tables fail. What can I do in order to avoid these problems -
without modifying every dump file by hand?
Any help is appreciated.
Thank you,
  -- Együd Csaba
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com)
Version: 6.0.699 / Virus Database: 456 - Release Date: 2004. 06. 04.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gaetano Mendola | 2004-06-07 09:09:09 | Re: [HACKERS] CREATE DATABASE on the heap with PostgreSQL? | 
| Previous Message | Rajesh Kumar Mallah | 2004-06-07 07:58:22 | Tsearch case sensitive with dotted search terms. |