[BUGS] BUG #3869: A scenario where pg_dump doesn't dump sequence

2008-01-12 Thread guillaume (ioguix) de Rorthais
The following bug has been logged online: Bug reference: 3869 Logged by: guillaume (ioguix) de Rorthais Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Linux, MacOSX 10.4.10 Description:A scenario where pg_dump doesn't dump sequence Details:

Re: [BUGS] BUG #3869: A scenario where pg_dump doesn't dump sequence

2008-01-12 Thread Tom Lane
"guillaume (ioguix) de Rorthais" <[EMAIL PROTECTED]> writes: > I think I found a bug in pg_dump from PostgreSQL 8.1. > When creating a table with a SERIAL column, thn alter this column as > smallint, pg_dump doesn't create the sequence anymore. This is fixed (along with lots of other corner cases

Re: [BUGS] BUG #3860: xpath crashes backend when is querying xmlagg result

2008-01-12 Thread Tom Lane
"Sokolov Yura" <[EMAIL PROTECTED]> writes: > xpath() crashes backend when is querying particular xmlagg results. Please see whether this patch fixes it: http://archives.postgresql.org/pgsql-committers/2008-01/msg00190.php The specific examples you give seem to be fixed, but that's not very much

Re: [BUGS] BUG #3858: psql hangs if called as postgres is coming online

2008-01-12 Thread Tom Lane
"Faisal N. Jawdat" <[EMAIL PROTECTED]> writes: > If I use psql on a local database while the daemon is coming online, psql > hangs and most be killed. Subsequent psql processes will connect without > incident. FWIW, I just spent some time trying to duplicate this on OSX 10.4.11, without success.