Обсуждение: RE: [HACKERS] pg_dump not in very good shape

>> And a pg_dump that cores trying to dump someone's database is *not*
>> a "minor" problem.
No, I didn't mean minor when it happens, I meant minor to fix.  Sorry.  Of
course it's serious for the user.

>> So I'm leaning towards leaving the pg_dump code as-is and fixing the
>> limitation in pqexpbuffer.
Yes, this is the correct solution.  What's the best way? To check the
incoming string lengths for anything aproaching or greater than 1kB and
slice it up from there?

MikeA

"Ansley, Michael" <Michael.Ansley@intec.co.za> writes:
>> So I'm leaning towards leaving the pg_dump code as-is and fixing the
>> limitation in pqexpbuffer.

> Yes, this is the correct solution.  What's the best way? To check the
> incoming string lengths for anything aproaching or greater than 1kB and
> slice it up from there?

I don't think we can do that short of writing a complete snprintf
emulation --- so we might as well just use snprintf.
        regards, tom lane

Tom Lane wrote:
> 
> "Ansley, Michael" <Michael.Ansley@intec.co.za> writes:
> >> So I'm leaning towards leaving the pg_dump code as-is and fixing the
> >> limitation in pqexpbuffer.
> 
> > Yes, this is the correct solution.  What's the best way? To check the
> > incoming string lengths for anything aproaching or greater than 1kB and
> > slice it up from there?
> 
> I don't think we can do that short of writing a complete snprintf
> emulation --- so we might as well just use snprintf.
> 
>                         regards, tom lane

Can I go ahead and use today's snapshot to write up the diffs for
pg_dump for dumping COMMENT ON statements?

Mike Mascari

Mike Mascari <mascarm@mascari.com> writes:
> Can I go ahead and use today's snapshot to write up the diffs for
> pg_dump for dumping COMMENT ON statements?

Sure --- just don't test it with any long comments ;-)
        regards, tom lane