Simon Riggs <[EMAIL PROTECTED]> writes:
> On Tue, 2006-02-14 at 16:55 +0800, Christopher Kings-Lynne wrote:
>> Huh? But it'll cause a total failure of dump restore?
> Perhaps you can explain further?
As the code stands, a restore involving blobs plus --single-transaction
produces
BEGIN;
...
BEGIN;
...
COMMIT;
...
COMMIT;
which does *not* have the intended behavior because BEGIN does not nest.
This is a must-fix, else we may as well revert the patch entirely,
because it does not work.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org