Re: [BUGS] [patch] test failure on sparc64 due to undefined division by zero behaviour

2011-03-11 Thread Tom Lane
Martin Pitt writes: > The C99 standard [2], section 6.5.5 paragraph 5 actually says: > "The result of the / operator is the quotient from the division of > the first operand by the second; the result of the % operator is the > remainder. In both operations, if the value of the second operan

Re: [BUGS] Collation problem right from AbstractJdbc2DatabaseMetaData.getTables

2011-03-11 Thread Tom Lane
"Pavel B. Milovantsev" writes: > Getting fresh 9.1devel I found that jdbc driver failed to obtain tables > form the metadata call. Yeah, this ties into the argument going on right now over whether the collation assignment algorithm is up to snuff ... I'll see about fixing it.

[BUGS] Collation problem right from AbstractJdbc2DatabaseMetaData.getTables

2011-03-11 Thread Pavel B. Milovantsev
Getting fresh 9.1devel I found that jdbc driver failed to obtain tables form the metadata call. > ResultSet rs = dbMetaData.getTables(null, "%", tableNamePattern == null ? "%" > : tableNamePattern, new String[]{"TABLE"}); ERROR: no collation was derived for the sort expression at character 1

Re: [BUGS] BUG #5927: PostgreSQL8.2

2011-03-11 Thread Robert Haas
On Fri, Mar 11, 2011 at 10:10 AM, Vishal wrote: > > The following bug has been logged online: > > Bug reference:      5927 > Logged by:          Vishal > Email address:      vish...@indevia.com > PostgreSQL version: 8.2 > Operating system:   Windows Server 2008 > Description:        PostgreSQL8.2

[BUGS] [patch] test failure on sparc64 due to undefined division by zero behaviour

2011-03-11 Thread Martin Pitt
Hello PostgreSQL hackers, I recently got the following bug report about a test suite failure on sparc64: - Forwarded message from Aurelien Jarno - Date: Wed, 02 Mar 2011 23:49:05 +0100 From: Aurelien Jarno To: Debian Bug Tracking System Subject: Bug#616180: postgresql-9.0: FTBFS on sp

Re: [BUGS] BUG #5814: documentation bug

2011-03-11 Thread Robert Haas
On Fri, Mar 11, 2011 at 10:05 AM, Bruce Momjian wrote: > Also, it seems this was addressed in January: > >        commit af84bee43e356866dc46c95ae5bf77996a8237ff >        Author: Robert Haas >        Date:   Sat Jan 8 06:12:05 2011 -0500 > >            Remove bogus claims regarding createuser def

[BUGS] BUG #5927: PostgreSQL8.2

2011-03-11 Thread Vishal
The following bug has been logged online: Bug reference: 5927 Logged by: Vishal Email address: vish...@indevia.com PostgreSQL version: 8.2 Operating system: Windows Server 2008 Description:PostgreSQL8.2 Details: I am getting an error in my PostGreSQL8.2 Error 1053:

Re: [BUGS] BUG #5924: bug or feature?

2011-03-11 Thread Tom Lane
"Ferenc Lutischan" writes: > Description:bug or feature? Feature. If we weren't willing to push qualifications down into views, they'd be far too slow to be useful. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make change

Re: [BUGS] ecpg preprocessor regression in 9.0

2011-03-11 Thread Heikki Linnakangas
On 01.11.2010 15:47, Heikki Linnakangas wrote: On 01.11.2010 15:31, Heikki Linnakangas wrote: This used to work in the PostgreSQL 8.4 ecpg preprocessor: EXEC SQL EXECUTE mystmt USING 1.23; but in 9.0 it throws an error: floattest.pgc:39: ERROR: variable "1" is not declared Attached is the fu

Re: [BUGS] BUG #5889: "Intersects" for polygons broken

2011-03-11 Thread Bruce Momjian
Robert Haas wrote: > On Tue, Mar 8, 2011 at 3:20 PM, Konrad Garus wrote: > > http://www.postgresql.org/docs/current/static/functions-geometry.html > > > > I wish it explained what arguments each of the operators accepts, and > > whether any automatic conversions take place (like polygon to box in

Re: [BUGS] BUG #5837: PQstatus() fails to report lost connection

2011-03-11 Thread Merlin Moncure
On Tue, Jan 25, 2011 at 12:01 PM, Murray S. Kucherawy wrote: >> -Original Message- >> From: Robert Haas [mailto:robertmh...@gmail.com] >> Sent: Tuesday, January 25, 2011 7:33 AM >> To: Kevin Grittner >> Cc: Murray S. Kucherawy; Tom Lane; pgsql-bugs@postgresql.org >> Subject: Re: [BUGS] BU

Re: [BUGS] BUG #5925: Files corrupted

2011-03-11 Thread Alvaro Herrera
Excerpts from Castro's message of vie mar 11 09:06:00 -0300 2011: > > The following bug has been logged online: > > Bug reference: 5925 > Logged by: Castro > Email address: flas...@iol.pt > PostgreSQL version: 9.0 > Operating system: Windows Server 2003 > Description:

Re: [BUGS] BUG #5814: documentation bug

2011-03-11 Thread Bruce Momjian
Alvaro Herrera wrote: > Excerpts from Bruce Momjian's message of vie mar 11 11:44:52 -0300 2011: > > Robert Haas wrote: > > > On Thu, Mar 10, 2011 at 10:45 PM, Bruce Momjian wrote: > > > > Antje Petersen wrote: > > > >> > > > >> The following bug has been logged online: > > > >> > > > > >> Accord

Re: [BUGS] BUG #5814: documentation bug

2011-03-11 Thread tushar
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Bruce Momjian wrote: > Well, what do you suggest? I see no other way to specify the default > for pressing . I know I just press at those prompts. > [root@tushar bin]# ./createuser -p 5438 Enter name of role to add: test Shall the new role be a s

Re: [BUGS] BUG #5814: documentation bug

2011-03-11 Thread Alvaro Herrera
Excerpts from Bruce Momjian's message of vie mar 11 11:44:52 -0300 2011: > Robert Haas wrote: > > On Thu, Mar 10, 2011 at 10:45 PM, Bruce Momjian wrote: > > > Antje Petersen wrote: > > >> > > >> The following bug has been logged online: > > >> > > >> According to the documentation > > >> createus

Re: [BUGS] BUG #5837: PQstatus() fails to report lost connection

2011-03-11 Thread Bruce Momjian
Robert Haas wrote: > On Fri, Mar 11, 2011 at 5:56 AM, Bruce Momjian wrote: > > Robert Haas wrote: > >> On Tue, Jan 25, 2011 at 10:54 AM, Kevin Grittner > >> wrote: > >> > Robert Haas wrote: > >> >> I think this patch would only be adding to the confusion. ?When > >> >> PQgetResult() is called, w

Re: [BUGS] BUG #5814: documentation bug

2011-03-11 Thread Bruce Momjian
Robert Haas wrote: > On Thu, Mar 10, 2011 at 10:45 PM, Bruce Momjian wrote: > > Antje Petersen wrote: > >> > >> The following bug has been logged online: > >> > >> Bug reference: ? ? ?5814 > >> Logged by: ? ? ? ? ?Antje Petersen > >> Email address: ? ? ?antje.peter...@desy.de > >> PostgreSQL versi

Re: [BUGS] BUG #5814: documentation bug

2011-03-11 Thread Robert Haas
On Thu, Mar 10, 2011 at 10:45 PM, Bruce Momjian wrote: > Antje Petersen wrote: >> >> The following bug has been logged online: >> >> Bug reference:      5814 >> Logged by:          Antje Petersen >> Email address:      antje.peter...@desy.de >> PostgreSQL version: 8.1.21 >> Operating system:   Sci

Re: [BUGS] BUG #5837: PQstatus() fails to report lost connection

2011-03-11 Thread Robert Haas
On Fri, Mar 11, 2011 at 5:56 AM, Bruce Momjian wrote: > Robert Haas wrote: >> On Tue, Jan 25, 2011 at 10:54 AM, Kevin Grittner >> wrote: >> > Robert Haas wrote: >> >> I think this patch would only be adding to the confusion. ?When >> >> PQgetResult() is called, we read enough data from the conne

Re: [BUGS] Problem with ALTER TABLE - occasional "tuple concurrently updated"

2011-03-11 Thread Bruce Momjian
Robert Haas wrote: > On Thu, Mar 10, 2011 at 10:37 PM, Bruce Momjian wrote: > > Robert Haas wrote: > >> On Thu, Mar 10, 2011 at 4:08 PM, Bruce Momjian wrote: > >> > Was this fixed? > >> > >> Not yet. ?I can probably fix it, if nobody else wants to do it. > > > > Well, it has languished for five m

Re: [BUGS] Problem with ALTER TABLE - occasional "tuple concurrently updated"

2011-03-11 Thread Robert Haas
On Thu, Mar 10, 2011 at 10:37 PM, Bruce Momjian wrote: > Robert Haas wrote: >> On Thu, Mar 10, 2011 at 4:08 PM, Bruce Momjian wrote: >> > Was this fixed? >> >> Not yet.  I can probably fix it, if nobody else wants to do it. > > Well, it has languished for five months, so the "nobody else wants" p

[BUGS] BUG #5926: information schema dtd_identifier for element_types, columns, parameters views inconsistent

2011-03-11 Thread Ingmar Brouns
The following bug has been logged online: Bug reference: 5926 Logged by: Ingmar Brouns Email address: swi...@gmail.com PostgreSQL version: 9.0.3 Operating system: Ubuntu 9.0.4 Description:information schema dtd_identifier for element_types, columns, parameters views i

[BUGS] BUG #5925: Files corrupted

2011-03-11 Thread Castro
The following bug has been logged online: Bug reference: 5925 Logged by: Castro Email address: flas...@iol.pt PostgreSQL version: 9.0 Operating system: Windows Server 2003 Description:Files corrupted Details: I change Postgresql v8.4 to v9. Before that i bakup all d

Re: [BUGS] BUG #5837: PQstatus() fails to report lost connection

2011-03-11 Thread Bruce Momjian
Robert Haas wrote: > On Tue, Jan 25, 2011 at 10:54 AM, Kevin Grittner > wrote: > > Robert Haas wrote: > >> I think this patch would only be adding to the confusion. ?When > >> PQgetResult() is called, we read enough data from the connection > >> to create and return one result object. ?It's true

Re: [BUGS] BUG #5857: pg_restore --clean dropping type too soon

2011-03-11 Thread Bruce Momjian
Tom Lane wrote: > "Stuart Bishop" writes: > > "pg_restore --clean" appears to have an ordering problem, where a custom > > type is being dropped before some functions that use that custom type as a > > parameter, which fails. > > It's always worked that way, and is difficult to avoid because of t

Re: [BUGS] BUG #5924: bug or feature?

2011-03-11 Thread John R Pierce
On 03/11/11 12:18 AM, Ferenc Lutischan wrote: The following bug has been logged online: Bug reference: 5924 Logged by: Ferenc Lutischan Email address: yours...@freemail.hu PostgreSQL version: 8.3.14 - 9.0.3 Operating system: Linux Description:bug or feature? Details:

[BUGS] BUG #5924: bug or feature?

2011-03-11 Thread Ferenc Lutischan
The following bug has been logged online: Bug reference: 5924 Logged by: Ferenc Lutischan Email address: yours...@freemail.hu PostgreSQL version: 8.3.14 - 9.0.3 Operating system: Linux Description:bug or feature? Details: Dear Developers, Inconsecutive view handlin