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 <alvhe...@commandprompt.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 <alvhe...@commandprompt.com> > The PostgreSQL Company - Command Prompt, Inc. > PostgreSQL Replication, Consulting, Custom Development, 24x7 support >
