[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

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:

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 #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

[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

[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

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

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] 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] 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 #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 #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 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 #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 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 #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 #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 #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] 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 #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

[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 #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] [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 #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] 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] 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.

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