On 2000-02-18, [EMAIL PROTECTED] mentioned:
> pg_dump doesn't support large objects, I haven't found any advise how
> to do it in doc neither in FAQ. How an I to backup a db with large
> objects without losing my data?
You need to write a C program using libpq's lo_import and lo_export
functions
Hi,
In order to upgrade from 6.4.2 to 6.5.2, I tried to dump my db by typing
[postgres@redhat60 pgsql]$ pg_dumpall -z > db.out
Instead of getting a dump file, I got the following message.
pg_dump: The -z option(dump ACLs)
Hi,
I'm a beginners whether for linux or for postgres.
I'd like know the difference between the Server Programming Interface
and libpq? When I will have to use libpq or SPI?
Can I have any linux C examples that list the tables and its contents.
Tha
I'm not sure if this will help but I just dealt with a similar problem.
When I tried to do a pg_dump it would fail. It turned out the culpret
was one single bad value in one row of one table. Any query that
returned that value would fail also, so I had to go through an
interitive process of sele
Hi, Matthew
I have tried to dump tables one by one to identify the table contains
bad value. However I got the following error messages from each dump.
..
SET TRANSACTION command failed. Explanation from backend: 'ERROR:
parser: parse error at or near "transaction"'.
..
May I
