Re: [BUGS] empty array can crash backend using int_array_enum from contrib.

2005-04-22 Thread Andrew - Supernews
On 2005-04-23, Tom Lane <[EMAIL PROTECTED]> wrote: > Ron Mayer <[EMAIL PROTECTED]> writes: >> Using the int_array_enum function from contrib/intagg I can crash the >> 8.0.2 backend when I pass it an empty array. > > Man, we've had a few problems with that thing, haven't we? > > I patched it along t

Re: [BUGS] V2 protocol -> 8.1 server

2005-04-22 Thread Tom Lane
Kris Jurka <[EMAIL PROTECTED]> writes: > The 8.1 server doesn't work when issuing queries using the v2 protocol, Yeah, looks like I broke something :-( ... will fix tomorrow. regards, tom lane ---(end of broadcast)--- TIP 8

Re: [BUGS] V2 protocol -> 8.1 server

2005-04-22 Thread Kris Jurka
With the promised files this time. On Sat, 23 Apr 2005, Kris Jurka wrote: > > The 8.1 server doesn't work when issuing queries using the v2 protocol, > notably the isnull bitmask in the DataRow message is incorrect. I suspect > the problem is with this commit: > > http://archives.postgresq

Re: [BUGS] BUG #1618: EXTRACTing EPOCH from TIME WITH TIME ZONE is broken

2005-04-22 Thread Tom Lane
"Dennis Vshivkov" <[EMAIL PROTECTED]> writes: > Time zone component should be added, not subtracted. Why? regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postg

[BUGS] V2 protocol -> 8.1 server

2005-04-22 Thread Kris Jurka
The 8.1 server doesn't work when issuing queries using the v2 protocol, notably the isnull bitmask in the DataRow message is incorrect. I suspect the problem is with this commit: http://archives.postgresql.org/pgsql-committers/2005-03/msg00224.php I've attached the tcpdump output from establi

Re: [BUGS] empty array can crash backend using int_array_enum from contrib.

2005-04-22 Thread Tom Lane
Ron Mayer <[EMAIL PROTECTED]> writes: > Using the int_array_enum function from contrib/intagg I can crash the 8.0.2 > backend when I pass it an empty array. Man, we've had a few problems with that thing, haven't we? I patched it along these lines: *** contrib/intagg/int_aggregate.c.orig Thu Apr

Re: [BUGS] BUG #1609: Bug in interval datatype for 64 Bit timestamps

2005-04-22 Thread Oliver Siegmar
On Thursday 21 April 2005 15:57, Tom Lane wrote: > I don't think it's a new bug, seeing that I didn't change the code > for the ISO case. > > I see the imprecise result only in the non-integer-datetime case; is > it acting differently for you? You're right - it has nothing to do with your patch. I

[BUGS] BUG #1616: Inadequate behavior GIST (btree_gist) multicolumn: first not unique

2005-04-22 Thread Sokolov Yura
The following bug has been logged online: Bug reference: 1616 Logged by: Sokolov Yura Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Windows2003, (and not tested, but sure Slackware10.0) Description:Inadequate behavior GIST (btree_gist)

[BUGS] Transactions and "create or replace function"

2005-04-22 Thread Ron Mayer
I have a long query something like select slow_function(col) from large_table; and half way through the query, in a separate connection, I CREATE OR REPLACE slow_function I was surprised to see that some of the rows in my select were processed by the old definition and some by the new. I w

Re: [BUGS] BUG #1610: rewrite rule and sequence

2005-04-22 Thread Olleg Samoylov
Richard Huxton wrote: That's not a bug, it's a feature (as they say). I suppose you could argue that a sequence only used by one table could inherit that table's permissions by default, but I can see problems when people reorder GRANT statements. HTH It's not feature, it's bug. From postgresql docu

[BUGS] BUG #1613: Installation flaw

2005-04-22 Thread
The following bug has been logged online: Bug reference: 1613 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.2 Operating system: Windows XP Description:Installation flaw Details: Hello, I am a new user of PostgreSQL. However, when I went to ins

[BUGS] BUG #1614: Bug in contrib/btree_gist for text

2005-04-22 Thread Sokolov Yura
The following bug has been logged online: Bug reference: 1614 Logged by: Sokolov Yura Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Windows2003, Slackware 10.0 Description:Bug in contrib/btree_gist for text Details: /* contrib/btree_gi

Re: [BUGS] BUG #1611: reading a date-field by "ResultSet.getTimestamp()" method analized dayligth flag

2005-04-22 Thread Ingolf Knopf
Am Donnerstag, 21. April 2005 23:49 schrieben Sie: > Ingolf Knopf wrote: > > The following bug has been logged online: > > > > Bug reference: 1611 > > Logged by: Ingolf Knopf > > Email address: [EMAIL PROTECTED] > > PostgreSQL version: 8.0.1 > > Operating system: JDBC > > Descr

[BUGS] empty array can crash backend using int_array_enum from contrib.

2005-04-22 Thread Ron Mayer
Using the int_array_enum function from contrib/intagg I can crash the 8.0.2 backend when I pass it an empty array. fli=# select int_array_enum('{}'::int[]); server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the

[BUGS] pg_dump: schema with OID 17262722 does not exist

2005-04-22 Thread Sebastien Montagne
- english -- Hi, pg_dump prints this strange error when attempting to dump our database : pg_dump: schema with OID 17262722 does not exist It worked well 6 minutes before. Is this a bug ? Where're using PostgreSQL 7.4.2.

[BUGS] Patch for Bug#1611

2005-04-22 Thread Ingolf Knopf
once more, because message was too long: see attached files. patches are based on postgresql-jdbc-8.0-311.src.tar.gz. sorry for using this way, I have still no experience with cvs. ResultSetTest.java.gz Description: GNU Zip compressed data AbstractJdbc2ResultSet.java.gz Description: GNU Zip co

[BUGS] BUG #1618: EXTRACTing EPOCH from TIME WITH TIME ZONE is broken

2005-04-22 Thread Dennis Vshivkov
The following bug has been logged online: Bug reference: 1618 Logged by: Dennis Vshivkov Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.6, 8.0.1 Operating system: Debian GNU/Linux, kernel 2.4 Description:EXTRACTing EPOCH from TIME WITH TIME ZONE is broken De

[BUGS] BUG #1619: ECPG allows definition of binary cursors but can't handle the result

2005-04-22 Thread
The following bug has been logged online: Bug reference: 1619 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Suse Linux 9.1 (x86) Description:ECPG allows definition of binary cursors but can't handle the result Details: I'm

[BUGS] BUG #1621: ODBC binding Unicode null-terminated string parameter doesn't work

2005-04-22 Thread Jeremy Stanley
The following bug has been logged online: Bug reference: 1621 Logged by: Jeremy Stanley Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.2 Operating system: Windows XP SP2 Description:ODBC binding Unicode null-terminated string parameter doesn't work Details:

[BUGS] BUG #1617: TIME WITH TIME ZONE comparison is partially broken

2005-04-22 Thread Dennis Vshivkov
The following bug has been logged online: Bug reference: 1617 Logged by: Dennis Vshivkov Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.6, 8.0.1 Operating system: Debian GNU/Linux, kernel 2.4 Description:TIME WITH TIME ZONE comparison is partially broken Det

[BUGS] BUG #1620: triggers breaks with alter table (at least with plpythonu)

2005-04-22 Thread Nahuel Greco
The following bug has been logged online: Bug reference: 1620 Logged by: Nahuel Greco Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.7 Operating system: Debian unstable i386 Description:triggers breaks with alter table (at least with plpythonu) Details: If

Re: [BUGS] BUG #1611: reading a date-field by "ResultSet.getTimestamp()"

2005-04-22 Thread Kris Jurka
On Fri, 22 Apr 2005, Oliver Jowett wrote: > Ingolf Knopf wrote: > > Bug reference: 1611 > > PostgreSQL version: 8.0.1 > > Operating system: JDBC > > Description:reading a date-field by "ResultSet.getTimestamp()" > > method analized dayligth flag > > Details: > > > > Retrieving d

Rules and Permissions docs change (was Re: [BUGS] BUG #1610: rewrite rule and sequence)

2005-04-22 Thread Richard Huxton
Olleg Samoylov wrote: Richard Huxton wrote: That's not a bug, it's a feature (as they say). I suppose you could argue that a sequence only used by one table could inherit that table's permissions by default, but I can see problems when people reorder GRANT statements. It's not feature, it's bug. F