Re: [BUGS] BUG #6247: Freeswitch will crash after 2-3 days within odbc connection

2011-10-11 Thread Stefan Kaltenbrunner
On 10/12/2011 08:40 AM, STIEG Heimo wrote: > Hello, > > > > do you need any further Information to solve that issue? Or do you have > any hints how to solve it by myself? well this list is for PostgreSQL bugs, we don't maintain unixODBC nor do we maintain the postgresql odbc driver - to quote

Re: [BUGS] BUG #6247: Freeswitch will crash after 2-3 days within odbc connection

2011-10-11 Thread STIEG Heimo
Hello, do you need any further Information to solve that issue? Or do you have any hints how to solve it by myself? Regards Heimo Stieg Von: STIEG Heimo Gesendet: Montag, 10. Oktober 2011 23:11 An: robertmh...@gmail.com Cc: pgsql-bugs@postgresql.org Betreff: AW:Re: [BUGS] BUG #6247: Freeswitch

Re: [BUGS] BUG #6251: cannot create roles that can actually login

2011-10-11 Thread Craig Ringer
On 10/11/2011 04:01 PM, nirodha wrote: The following bug has been logged online: Bug reference: 6251 Logged by: nirodha Email address: erikwinnm...@yahoo.com PostgreSQL version: 8.4 Operating system: ubuntu Description:cannot create roles that can actually login Det

Re: [BUGS] BUG #6246: character encoding for 64 bit

2011-10-11 Thread Craig Ringer
On 10/10/2011 04:20 PM, Bo wrote: The following bug has been logged online: Bug reference: 6246 Logged by: Bo Email address: b...@budget123.dk PostgreSQL version: 9.1 Operating system: Windows server 2008 Description:character encoding for 64 bit Details: I have jus

Re: [BUGS] BUG #6244: Ordering Problem

2011-10-11 Thread Leandro Guimarães Faria Corce DUTRA
Le 2011-O-11 18h57, Merlin Moncure a écrit : hm, LATIN1 is not a unicode supporting encoding, that might be problem. your database should probably be defined UTF8. Precisely, Latin1 is obsolete. Latin9 is better, as it at least includes the Euro character €, but still not as good as UTF-8.

Re: [BUGS] BUG #6244: Ordering Problem

2011-10-11 Thread Merlin Moncure
On Mon, Oct 10, 2011 at 7:35 AM, Murilo - Perfilweb Informática wrote: > Hello, > My encoding is LATIN1, my collation is pt_BR > Thank You. > 2011/10/7 Merlin Moncure hm, LATIN1 is not a unicode supporting encoding, that might be problem. your database should probably be defined UTF8. not an e

Re: [BUGS] memory leak in postgresql

2011-10-11 Thread Pavel Stehule
2011/10/11 Tom Lane : > Pavel Stehule writes: >> I found a following issue (tested on PostgreSQL 9.2) > >> CREATE OR REPLACE FUNCTION public.setfield(a anyelement, text, text) >> RETURNS anyelement >> LANGUAGE plpgsql >> AS $function$ >> begin >>   create temp table aux as select $1.*; >>   execut

Re: [BUGS] memory leak in postgresql

2011-10-11 Thread Tom Lane
Pavel Stehule writes: > I found a following issue (tested on PostgreSQL 9.2) > CREATE OR REPLACE FUNCTION public.setfield(a anyelement, text, text) > RETURNS anyelement > LANGUAGE plpgsql > AS $function$ > begin > create temp table aux as select $1.*; > execute 'update aux set ' || quote_iden

[BUGS] memory leak in postgresql

2011-10-11 Thread Pavel Stehule
Hello I found a following issue (tested on PostgreSQL 9.2) CREATE OR REPLACE FUNCTION public.setfield(a anyelement, text, text) RETURNS anyelement LANGUAGE plpgsql AS $function$ begin create temp table aux as select $1.*; execute 'update aux set ' || quote_ident($2) || ' = ' || quote_literal(

Re: [BUGS] pg_upgrade v9.1 issues

2011-10-11 Thread Bruce Momjian
lalong wrote: > I have 2 instances of postgres installed on same machine under Vista and have > run into the following issues when trying to migrate my data from one > instance into the other > > 1) If the upgrade process fails, the postmaster.tid file may remain even > though the postmaster s

[BUGS] pg_upgrade v9.1 issues

2011-10-11 Thread lalong
I have 2 instances of postgres installed on same machine under Vista and have run into the following issues when trying to migrate my data from one instance into the other 1) If the upgrade process fails, the postmaster.tid file may remain even though the postmaster service is no longer runnin

Re: [BUGS] BUG #6251: cannot create roles that can actually login

2011-10-11 Thread Robert Haas
On Tue, Oct 11, 2011 at 4:01 AM, nirodha wrote: > > The following bug has been logged online: > > Bug reference:      6251 > Logged by:          nirodha > Email address:      erikwinnm...@yahoo.com > PostgreSQL version: 8.4 > Operating system:   ubuntu > Description:        cannot create roles tha

[BUGS] BUG #6251: cannot create roles that can actually login

2011-10-11 Thread nirodha
The following bug has been logged online: Bug reference: 6251 Logged by: nirodha Email address: erikwinnm...@yahoo.com PostgreSQL version: 8.4 Operating system: ubuntu Description:cannot create roles that can actually login Details: I literally cut and paste the com

Re: [BUGS] BUG #6204: Using plperl functions generate crash

2011-10-11 Thread Guimarães Faria Corcete DUTRA , Leandro
2011/10/10 John R Pierce : > > whats important is what perl is in the POSTGRES SERVICE's path, not your > desktop users.   windows doesn't make this easy to determine. In principle I do not have any other perl installation anymore in that machine, nor in another one exhibiting the same symptoms.

Re: [BUGS] BUG #6249: Segmentation fault in VirtualXactLock()

2011-10-11 Thread Robert Haas
On Tue, Oct 11, 2011 at 3:14 AM, Fujii Masao wrote: > On Tue, Oct 11, 2011 at 10:44 AM, Fujii Masao wrote: >> When I built Streaming Replication and Hot Standby environment, set >> max_standby_streaming_delay to 1s and ran the following shell script which >> creates the conflict between read-only

Re: [BUGS] BUG #6249: Segmentation fault in VirtualXactLock()

2011-10-11 Thread Fujii Masao
On Tue, Oct 11, 2011 at 10:44 AM, Fujii Masao wrote: > When I built Streaming Replication and Hot Standby environment, set > max_standby_streaming_delay to 1s and ran the following shell script which > creates the conflict between read-only query and recovery, SEGV occurred on > the standby. In m