Re: Empty bytea format - 9.1devel pg_dump and psql

Hi,

Yes, pgdiff shows the difference for a table that has fields with empty
bytea comparing 9.1devel and 8.4 pg_dump files!

Best regards,
Vladimir Kokovic, DP senior, Belgrade, Serbia

On Mon, Oct 18, 2010 at 5:45 PM, Alvaro Herrera
<alvherre@commandprompt.com>wrote:

> Excerpts from Vladimir Kokovic's message of s=E1b oct 16 15:45:02 -0300 2=
010:
> > Hi,
> >
> > I'm not sure whether it is OK, a blank format for bytea, which is
> presented
> > in 9.1devel (pg_dump and psql)
>
> Yeah, an empty bytea is now output differently by default (just like any
> other bytea).  The \x means "this bytea is output as a sequence of hex
> pairs"; followed by no other chars, it represents an empty bytea.
>
> Is this a problem?  I find it slightly funny on stuff like \d default
> values and such, but not enough to merit a special case.
>
> --
> =C1lvaro Herrera <alvherre@commandprompt.com>
> The PostgreSQL Company - Command Prompt, Inc.
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>