Postgres Pro
Downloads
Home   >   mailing lists

Re: pgsql: Add psql option: -1 or --single-transaction - Mailing list pgsql-committers

From Christopher Kings-Lynne
Subject Re: pgsql: Add psql option: -1 or --single-transaction
Date
Msg-id 43F15923.4060101@familyhealth.com.au
Whole thread Raw
In response to Re: pgsql: Add psql option: -1 or --single-transaction Simon Riggs  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pgsql: Add psql option: -1 or --single-transaction
List pgsql-committers
Tree view 
> Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
>> How does this interact with the begin/commit placed around LOB dumps?
>
> Good question ... right offhand it looks like there are some broken
> things there (try grepping bin/pg_dump/ for BEGIN).

I suggest you just suppress the begin/commit for each LOB if
--single-transaction is specified, as it'd be in a single transaction
anyway...

Chris

pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgsql: Add psql option: -1 or --single-transaction Simon Riggs
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: pgsql: Add psql option: -1 or --single-transaction