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(at)commandprompt(dot)com>wrote:

> Excerpts from Vladimir Kokovic's message of sáb oct 16 15:45:02 -0300 2010:
> > 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.
>
> --
> Álvaro Herrera <alvherre(at)commandprompt(dot)com>
> The PostgreSQL Company - Command Prompt, Inc.
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>