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

2011-10-12 Thread STIEG Heimo
OH, I thought, that the psql maintains also the odbc driver. thanks for the information. -Ursprüngliche Nachricht- Von: Stefan Kaltenbrunner [mailto:ste...@kaltenbrunner.cc] Gesendet: Mittwoch, 12. Oktober 2011 08:51 An: STIEG Heimo Cc: pgsql-bugs@postgresql.org; robertmh...@gmail.com Be

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

2011-10-12 Thread Craig Ringer
On 10/12/2011 03:21 PM, STIEG Heimo wrote: OH, I thought, that the psql maintains also the odbc driver. The PostgreSQL odbc driver, psqlODBC, is maintained as a project associated with (though not part of) PostgreSQL proper. unixODBC, which is the ODBC implementation for UNIX, has nothing to

[BUGS] *.sql contrib files contain unresolvable MODULE_PATHNAME

2011-10-12 Thread Martin Pitt
Hello all, In https://launchpad.net/bugs/835502 it was reported that the 9.1.1 contrib *.sql files contain the token "MODULE_PATHNAME", which is unknown: psql test < /usr/share/postgresql/9.1/extension/intarray--1.0.sql This fails with a ton of errors about the file "MODULE_PATHNAME" not exist

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

2011-10-12 Thread Bo Thorbjørn Jensen
> 12. oktober 2011 04:17 > Emne: Re: [BUGS] BUG #6246: character encoding for 64 bit > > 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

Re: [BUGS] *.sql contrib files contain unresolvable MODULE_PATHNAME

2011-10-12 Thread Stefan Kaltenbrunner
On 10/12/2011 09:53 AM, Martin Pitt wrote: > Hello all, > > In https://launchpad.net/bugs/835502 it was reported that the 9.1.1 > contrib *.sql files contain the token "MODULE_PATHNAME", which is > unknown: > > psql test < /usr/share/postgresql/9.1/extension/intarray--1.0.sql > > This fails wi

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

2011-10-12 Thread Susannah
Bo budget123.dk> writes: > > > The following bug has been logged online: > > Bug reference: 6246 > Logged by: Bo > Email address: bo budget123.dk > PostgreSQL version: 9.1 > Operating system: Windows server 2008 > Description:character encoding for 64 bit > Detail

[BUGS] BUG #6252: After drop the default database 'postgres', I can not create a database by 'createdb.exe'

2011-10-12 Thread Can not create DB by 'createdb.exe' when DB 'postgres' is droped
The following bug has been logged online: Bug reference: 6252 Logged by: Can not create DB by 'createdb.exe' when DB 'postgres' is droped Email address: yanghui...@gmail.com PostgreSQL version: 9.0.5 Operating system: Windows XP SP2 Description:After drop the default

[BUGS] BUG #6253: JDBC driver: getIndexInfo() returns quotes around quoted column names

2011-10-12 Thread Laurian Vostinar
The following bug has been logged online: Bug reference: 6253 Logged by: Laurian Vostinar Email address: lvosti...@servoy.com PostgreSQL version: 9.0 Operating system: Windows 7 Description:JDBC driver: getIndexInfo() returns quotes around quoted column names Details:

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

2011-10-12 Thread Kevin Grittner
Susannah wrote: > FATAL: conversion between WIN1252 and LATIN1 is not supported WIN1512 supports characters which are not supported by LATIN1. If you sent such characters to the database, what would you expect to happen? > I can connect through pgAdmin and create tables etc, just not with

Re: [BUGS] BUG #6252: After drop the default database 'postgres', I can not create a database by 'createdb.exe'

2011-10-12 Thread Kevin Grittner
wrote: > 1.drop database 'postgres' > 2.create a database by createdb.exe > the follow error message will dispaly: > Can not create DB by 'createdb.exe' when database 'postgres' is > droped To create a database, the createdb executable has to connect to the cluster. A connection is always to

Re: [BUGS] BUG #6252: After drop the default database 'postgres', I can not create a database by 'createdb.exe'

2011-10-12 Thread John R Pierce
On 10/12/11 9:28 AM, Kevin Grittner wrote: This is not a bug. The workaround is to not drop the database which is automatically created on installation. or to explicitly connect to another database to do the create -- john r pierceN 37, W 122 santa cruz ca

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

2011-10-12 Thread bushcraftrelf
Kevin Grittner wrote: > > > WIN1512 supports characters which are not supported by LATIN1. If > you sent such characters to the database, what would you expect to > happen? > > -Kevin > Hi Kevin, I forgot to mention a few things. One is that the problem only arises in postgres 9.1 - I can

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

2011-10-12 Thread Craig Ringer
On 10/13/2011 03:09 AM, bushcraftrelf wrote: Kevin Grittner wrote: WIN1512 supports characters which are not supported by LATIN1. If you sent such characters to the database, what would you expect to happen? -Kevin Hi Kevin, I forgot to mention a few things. One is that the problem only

Re: [BUGS] BUG #6252: After drop the default database 'postgres', I can not create a database by 'createdb.exe'

2011-10-12 Thread Craig Ringer
On 10/12/2011 02:48 PM, Can not create DB by 'createdb.exe' when DB 'postgres' is droped wrote: The following bug has been logged online: Bug reference: 6252 Logged by: Can not create DB by 'createdb.exe' when DB 'postgres' is droped Email address: yanghui...@gmail.com Postgr