Re: [BUGS] V2 protocol - 8.1 server

2005-04-23 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] empty array can crash backend using int_array_enum from contrib.

2005-04-23 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 these lines:

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

2005-04-23 Thread Tom Lane
Dennis Vshivkov [EMAIL PROTECTED] writes: On Sat, Apr 23, 2005 at 01:58:13AM -0400, Tom Lane wrote: Time zone component should be added, not subtracted. Why? [ good arguments snipped ] OK, I'm convinced --- particularly by the point that no place else in the backend thinks timetz-time -

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

2005-04-23 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 14

Re: [BUGS] V2 protocol - 8.1 server

2005-04-23 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:

Re: [BUGS] V2 protocol - 8.1 server

2005-04-23 Thread Tom Lane
Kris Jurka [EMAIL PROTECTED] writes: 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 Yup,

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

2005-04-23 Thread Tom Lane
Andrew - Supernews [EMAIL PROTECTED] writes: We were discussing this one on irc while it was presumably waiting in the moderation queue, and I suggested to the poster an alternative patch that allowed empty arrays to actually be treated as empty (your version will error out on

Re: [BUGS] BUG #1608: integer negative limit in plpgsql function arguments

2005-04-23 Thread Tom Lane
I wrote: You're right, we do cheat a little on negative numeric constants --- I had forgotten about the doNegate() hack in gram.y. We could conceivably fix it to cheat some more. Specifically it looks like make_const() in parse_node.c could check for the possibility that a T_Float fits in

Re: [BUGS] BUG #1583: Locale problem

2005-04-23 Thread Tom Lane
Andrew Grillet [EMAIL PROTECTED] writes: Fix is found ... the default .csrc file set the locale to en_GB.ISO_5589-1 but the correct setting is en_GB.ISO5589-1 So the locale was set to an invalid setting. This has undesirable side effects. Indeed ;-) It might be worth adding to the

Re: [BUGS] BUG #1613: Installation flaw

2005-04-23 Thread Magnus Hagander
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 install it on my Windows XP machine, it was

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

2005-04-23 Thread Tom Lane
Dennis Vshivkov [EMAIL PROTECTED] writes: [8.0.1|src/backend/utils/adt/date.c] timetz_cmp_internal(): /* Primary sort is by true (GMT-equivalent) time */ t1 = time1-time + time1-zone; t2 = time2-time + time2-zone; This code is only valid when HAVE_INT64_TIMESTAMP is NOT the

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

2005-04-23 Thread Tom Lane
Dennis Vshivkov [EMAIL PROTECTED] writes: Time zone component should be added, not subtracted. Done. regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

Re: [BUGS] Transactions and create or replace function

2005-04-23 Thread Tom Lane
Ron Mayer [EMAIL PROTECTED] writes: I would have expected that since the CREATE OR REPLACE was in a separate connection, and hense a separate transaction, that all the results of the select() will have been processed by the same function. System catalog accesses are generally done with