[BUGS] 8.2beta1 restarts given query

2006-10-10 Thread Per Jensen
Bughunters, I am testing the 8.2beta1 server with a pg_dump/restore from a debian production sarge-PG74 instance. When the dump is restored to a test PG-8.1.3 my application works nicely (have not upgraded the production server though). When the same dump is restored to a PG-8.2beta1 some queri

Re: [BUGS] BUG #2684: Memory leak in libpq

2006-10-10 Thread Milen A. Radev
On 10/10/06, Tom Lane <[EMAIL PROTECTED]> wrote: "Milen A. Radev" <[EMAIL PROTECTED]> writes: > On 10/10/06, Tom Lane <[EMAIL PROTECTED]> wrote: >> I couldn't duplicate any such leak using your test program here. > The client and the server were on different machines - that's why I > believe "md

Re: [BUGS] BUG #2661: select time with time zone not converting

2006-10-10 Thread Jim C. Nasby
On Thu, Oct 05, 2006 at 09:04:50PM -0500, Jim Nasby wrote: > On Sep 28, 2006, at 3:54 PM, Harry Hehl wrote: > >Bug reference: 2661 > >Logged by: Harry Hehl > >Email address: [EMAIL PROTECTED] > >PostgreSQL version: 8.1.3 > >Operating system: Linux > >Description:select

Re: [BUGS] BUG #2685: Wrong charset of server messages on client

2006-10-10 Thread Tom Lane
Sergiy Vyshnevetskiy <[EMAIL PROTECTED]> writes: > Here is a new and improved patch, that closes security hole as well. We really can't consider a patch like this, because not only does it ignore the problem of multiple spellings of encoding names, but it actually breaks existing functionality on

Re: [BUGS] BUG #2685: Wrong charset of server messages on client

2006-10-10 Thread Sergiy Vyshnevetskiy
On Tue, 10 Oct 2006, Sergiy Vyshnevetskiy wrote: On Tue, 10 Oct 2006, Tom Lane wrote: Sergiy Vyshnevetskiy <[EMAIL PROTECTED]> writes: > > It's not magic, it's from ICU patch. Want me to send you a copy? :) You're missing my point, which is that non-ICU locale support doesn't necessarily

Re: [BUGS] BUG #2685: Wrong charset of server messages on client

2006-10-10 Thread Sergiy Vyshnevetskiy
On Tue, 10 Oct 2006, Tom Lane wrote: Sergiy Vyshnevetskiy <[EMAIL PROTECTED]> writes: It's not magic, it's from ICU patch. Want me to send you a copy? :) You're missing my point, which is that non-ICU locale support doesn't necessarily recognize the same encoding names. We would have done th

Re: [BUGS] BUG #2685: Wrong charset of server messages on client

2006-10-10 Thread Sergiy Vyshnevetskiy
On Tue, 10 Oct 2006, Tom Lane wrote: "Sergiy Vyshnevetskiy" <[EMAIL PROTECTED]> writes: Convert server messages to database charset. This has been discussed before: http://archives.postgresql.org/pgsql-patches/2005-08/msg00245.php The magic pg_enc2iananame_tbl[] you reference in your patch d

Re: [BUGS] BUG #2685: Wrong charset of server messages on client [PATCH]

2006-10-10 Thread Tom Lane
Sergiy Vyshnevetskiy <[EMAIL PROTECTED]> writes: >> It's not magic, it's from ICU patch. Want me to send you a copy? :) You're missing my point, which is that non-ICU locale support doesn't necessarily recognize the same encoding names. We would have done this years ago if we had a solution to th

Re: [BUGS] BUG #2685: Wrong charset of server messages on client

2006-10-10 Thread Sergiy Vyshnevetskiy
On Tue, 10 Oct 2006, Sergiy Vyshnevetskiy wrote: On Tue, 10 Oct 2006, Sergiy Vyshnevetskiy wrote: On Tue, 10 Oct 2006, Tom Lane wrote: > "Sergiy Vyshnevetskiy" <[EMAIL PROTECTED]> writes: > > Convert server messages to database charset. > > This has been discussed before: > http://

Re: [BUGS] BUG #2685: Wrong charset of server messages on client

2006-10-10 Thread Sergiy Vyshnevetskiy
On Tue, 10 Oct 2006, Sergiy Vyshnevetskiy wrote: On Tue, 10 Oct 2006, Tom Lane wrote: "Sergiy Vyshnevetskiy" <[EMAIL PROTECTED]> writes: > Convert server messages to database charset. This has been discussed before: http://archives.postgresql.org/pgsql-patches/2005-08/msg00245.php The m

Re: [BUGS] BUG #2684: Memory leak in libpq

2006-10-10 Thread Tom Lane
"Milen A. Radev" <[EMAIL PROTECTED]> writes: > On 10/10/06, Tom Lane <[EMAIL PROTECTED]> wrote: >> I couldn't duplicate any such leak using your test program here. > The client and the server were on different machines - that's why I > believe "md5" was used. I'm sending only the client machine's

Re: [BUGS] BUG #2685: Wrong charset of server messages on client [PATCH]

2006-10-10 Thread Tom Lane
"Sergiy Vyshnevetskiy" <[EMAIL PROTECTED]> writes: > Convert server messages to database charset. This has been discussed before: http://archives.postgresql.org/pgsql-patches/2005-08/msg00245.php The magic pg_enc2iananame_tbl[] you reference in your patch does not exist, and if it did exist it wo

Re: [BUGS] BUG #2684: Memory leak in libpq

2006-10-10 Thread Milen A. Radev
On 10/10/06, Tom Lane <[EMAIL PROTECTED]> wrote: "Milen A. Radev" <[EMAIL PROTECTED]> writes: > The same test programme has grown (after ~1 million iterations) from 2KB to > around 40MB used physical memory (as reported by "top"). I couldn't duplicate any such leak using your test program here.

Re: [BUGS] BUG #2684: Memory leak in libpq

2006-10-10 Thread Tom Lane
"Milen A. Radev" <[EMAIL PROTECTED]> writes: > The same test programme has grown (after ~1 million iterations) from 2KB to > around 40MB used physical memory (as reported by "top"). I couldn't duplicate any such leak using your test program here. What authentication method is being selected by you

[BUGS] BUG #2685: Wrong charset of server messages on client [PATCH]

2006-10-10 Thread Sergiy Vyshnevetskiy
The following bug has been logged online: Bug reference: 2685 Logged by: Sergiy Vyshnevetskiy Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: FreeBSD-6 stable Description:Wrong charset of server messages on client [PATCH] Details: DESCRIPT

[BUGS] BUG #2684: Memory leak in libpq

2006-10-10 Thread Milen A. Radev
The following bug has been logged online: Bug reference: 2684 Logged by: Milen A. Radev Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Debian 3.1 Description:Memory leak in libpq Details: Source: #include #include int main(int argc