Hello,

here it is as requested by Bruce.
I tested it restoring my database with > 100000 BLOBS, and dumping it out.
But unfortunatly I can not restore it back due to problems in pg_dump.

-- 
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------
Sat, 21 Oct 2000 18:19:37 +0700
Denis Perchine <dyp@perchine.com>
Patch to support transactions with BLOBs for current CVS
> >here it is as requested by Bruce.
> >I tested it restoring my database with > 100000 BLOBS, and dumping it out.
> >But unfortunatly I can not restore it back due to problems in pg_dump.
>
> Please clarify - based on your last private email you stated that there was
>
> not a problem with pg_dump, but a problem in the your BLOB patch:

Yeps. I have fixed all the crap. And it restores perfect from my archive 
which I made some time ago with your pg_dump for 7.0.2. It was _10 if I am 
not mistaken.

Also it dumps out fine, but restore back from new archive stops right away. 
And when I tried to do dump/restore on the empty database I was failed.

> >From: Denis Perchine <dyp@perchine.com>
> >Date: Fri, 20 Oct 2000 12:15:18 +0700
> >
> >Sorry... I had a look inside server log... Looks like my bug...
>
> Are you now saying there is a new problem with pg_dump?
>
>
> ----------------------------------------------------------------
> Philip Warner                    |     __---_____
> Albatross Consulting Pty. Ltd.   |----/       -  \
> (A.B.N. 75 008 659 498)          |          /(@)   ______---_
> Tel: (+61) 0500 83 82 81         |                 _________  \
> Fax: (+61) 0500 83 82 82         |                 ___________ |
> Http://www.rhyme.com.au          |                /           \|
>
>                                  |    --________--
>
> PGP key available upon request,  |  /
> and from pgp5.ai.mit.edu:11371   |/

-- 
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------

Sat, 21 Oct 2000 18:36:28 +0700
Denis Perchine <dyp@perchine.com>
Re: Patch to support transactions with BLOBs for current CVS
> >Yeps. I have fixed all the crap. And it restores perfect from my archive
> >which I made some time ago with your pg_dump for 7.0.2. It was _10 if I am
> >not mistaken.
> >
> >Also it dumps out fine, but restore back from new archive stops right
> > away. And when I tried to do dump/restore on the empty database I was
> > failed.
>
> This is the same recent bug as from the hacker list?

Yeps. I just made a comment that I was unable to make a complete circle in my 
tests. :-)))

-- 
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------

Sat, 21 Oct 2000 18:46:44 +0700
Denis Perchine <dyp@perchine.com>
Re: Patch to support transactions with BLOBs for current CVS
At 18:19 21/10/00 +0700, Denis Perchine wrote:
>Hello,
>
>here it is as requested by Bruce.
>I tested it restoring my database with > 100000 BLOBS, and dumping it out.
>But unfortunatly I can not restore it back due to problems in pg_dump.
>

Please clarify - based on your last private email you stated that there was
not a problem with pg_dump, but a problem in the your BLOB patch:

>From: Denis Perchine <dyp@perchine.com>
>Date: Fri, 20 Oct 2000 12:15:18 +0700
>
>Sorry... I had a look inside server log... Looks like my bug...
>

Are you now saying there is a new problem with pg_dump?


----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.B.N. 75 008 659 498)          |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 0500 83 82 82         |                 ___________ |
Http://www.rhyme.com.au          |                /           \|
                                 |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/

Sat, 21 Oct 2000 22:21:56 +1000
Philip Warner <pjw@rhyme.com.au>
Re: Patch to support transactions with BLOBs for
  current CVS
At 18:36 21/10/00 +0700, Denis Perchine wrote:
>> >here it is as requested by Bruce.
>> >I tested it restoring my database with > 100000 BLOBS, and dumping it out.
>> >But unfortunatly I can not restore it back due to problems in pg_dump.
>>
>> Please clarify - based on your last private email you stated that there was
>>
>> not a problem with pg_dump, but a problem in the your BLOB patch:
>
>Yeps. I have fixed all the crap. And it restores perfect from my archive 
>which I made some time ago with your pg_dump for 7.0.2. It was _10 if I am 
>not mistaken.
>
>Also it dumps out fine, but restore back from new archive stops right away. 
>And when I tried to do dump/restore on the empty database I was failed.
>

This is the same recent bug as from the hacker list?


----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.B.N. 75 008 659 498)          |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 0500 83 82 82         |                 ___________ |
Http://www.rhyme.com.au          |                /           \|
                                 |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/

Sat, 21 Oct 2000 22:35:05 +1000
Philip Warner <pjw@rhyme.com.au>
Re: Patch to support transactions with BLOBs for
  current CVS
Applied.  Thanks.  I know it is a pain to generate a new patch against
the release.

[ Charset koi8r unsupported, skipping... ]

[ Attachment, skipping... ]


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Sat, 21 Oct 2000 11:55:35 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Patch to support transactions with BLOBs for current CVS
Bruce Momjian writes:

> Applied.  Thanks.  I know it is a pain to generate a new patch against
> the release.

Regression tests opr_sanity and sanity_check are now failing.

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


Sun, 22 Oct 2000 00:05:01 +0200 (CEST)
Peter Eisentraut <peter_e@gmx.net>
Re: [PATCHES] Patch to support transactions with BLOBs for current
 CVS
OK, Denis, can you run the regression tests with your patch and see what
is going on?

> Bruce Momjian writes:
> 
> > Applied.  Thanks.  I know it is a pain to generate a new patch against
> > the release.
> 
> Regression tests opr_sanity and sanity_check are now failing.
> 
> -- 
> Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/
> 
> 


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Sat, 21 Oct 2000 20:10:03 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Re: [PATCHES] Patch to support transactions with BLOBs
	for current CVS
Hi,

> OK, Denis, can you run the regression tests with your patch and see what
> is going on?
>
> > Bruce Momjian writes:
> > > Applied.  Thanks.  I know it is a pain to generate a new patch against
> > > the release.
> >
> > Regression tests opr_sanity and sanity_check are now failing.

This was due to change in template1.
Here is regression.diff attached.

And also there's test.patch attached which will fix this.

-- 
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------
Sun, 22 Oct 2000 13:30:56 +0700
Denis Perchine <dyp@perchine.com>
Re: Re: [PATCHES] Patch to support transactions with BLOBs for
	current CVS