Re: [BUGS] BUG #2333: dropdb ignores the database name argument

2006-03-18 Thread Alvaro Herrera
kevin barnes wrote: > In the 8.1 release on Unbuntu 5.10 there is an error with the dropdb command > in /usr/bin. The error manifests itself by not respecting the DBNAME > argument. It assumes that you want to connect to a database named 'postgres' > and ignores whatever argument you give it. The

Re: [BUGS] BUG #2333: dropdb ignores the database name argument

2006-03-18 Thread Bruce Momjian
kevin barnes wrote: > > The following bug has been logged online: > > Bug reference: 2333 > Logged by: kevin barnes > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1 > Operating system: ubuntu 5.10 > Description:dropdb ignores the database name argument > D

Re: [BUGS] BUG #2334: WHERE IN (SUBSELECT) fails when column is null

2006-03-18 Thread Stephan Szabo
On Fri, 17 Mar 2006, Patrick Narkinsky wrote: > This may be expected behavior, but it certainly doesn't seem right to me, > and it works as expected in sqlite. > > The database is as follows: > > BEGIN TRANSACTION; > create table a ( > id integer, > text varchar(20) > ); > INSERT INTO a VALUES(0,'

[BUGS] BUG #2333: dropdb ignores the database name argument

2006-03-18 Thread kevin barnes
The following bug has been logged online: Bug reference: 2333 Logged by: kevin barnes Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: ubuntu 5.10 Description:dropdb ignores the database name argument Details: In the 8.1 release on Unbuntu

[BUGS] BUG #2335: Order of data in data-only dumps

2006-03-18 Thread Jozef Behran
The following bug has been logged online: Bug reference: 2335 Logged by: Jozef Behran Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0 Operating system: Linux (Mandriva Linux 10.0) Description:Order of data in data-only dumps Details: When doing a data-onl

Re: [BUGS] BUG #2332: commands ignored until end of transaction block

2006-03-18 Thread William ZHANG
There must be some error caused by the SQL statements sent by the application or driver. You can log the SQL statements by setting log_statement to true in postgres.conf. Regards, William ZHANG ---(end of broadcast)--- TIP 3: Have you checked our

[BUGS] BUG #2334: WHERE IN (SUBSELECT) fails when column is null

2006-03-18 Thread Patrick Narkinsky
The following bug has been logged online: Bug reference: 2334 Logged by: Patrick Narkinsky Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: Mac OS X Description:WHERE IN (SUBSELECT) fails when column is null Details: This may be expected

Re: [BUGS] [PATCHES] Bonjour registration on Intel Macs is broken

2006-03-18 Thread Neil Conway
On Sat, 2006-03-18 at 15:35 -0600, Ashley Clark wrote: > The call to DNSServiceRegistrationCreate in postmaster.c does > incorrect byte-swapping on the port number which causes the Bonjour > registration call to fail on Intel Macs. Thanks for the patch -- applied to HEAD and back branches, back to

[BUGS] Bonjour registration on Intel Macs is broken

2006-03-18 Thread Ashley Clark
The call to DNSServiceRegistrationCreate in postmaster.c does incorrect byte-swapping on the port number which causes the Bonjour registration call to fail on Intel Macs.This patch uses htons() instead of htonl() and fixes this bug. Bonjour for Intel Mac.patch Description: Binary data Ashley Clar