[BUGS] BUG #5636: extra ( or missing )

2010-09-02 Thread KOIZUMI Satoru
The following bug has been logged online: Bug reference: 5636 Logged by: KOIZUMI Satoru Email address: koizumi...@minos.ocn.ne.jp PostgreSQL version: 9.0RC1 Operating system: MacOS X Description:extra ( or missing ) Details: At 33.8.5. The decimal type of

[BUGS] BUG #5637: JDBC driver method setClob always uses getAsciiStream()

2010-09-02 Thread Jochen Terstiege
The following bug has been logged online: Bug reference: 5637 Logged by: Jochen Terstiege Email address: jochen.tersti...@quinscape.de PostgreSQL version: 8.4 Operating system: Windows XP SP3 Description:JDBC driver method setClob always uses getAsciiStream()

[BUGS] BUG #5638: disagreement of argument name

2010-09-02 Thread KOIZUMI Satoru
The following bug has been logged online: Bug reference: 5638 Logged by: KOIZUMI Satoru Email address: koizumi...@minos.ocn.ne.jp PostgreSQL version: 9.0RC1 Operating system: MacOS X Description:disagreement of argument name Details: At 33.10.4. Additional

Re: [BUGS] issue about information_schema REFERENTIAL_CONSTRAINTS

2010-09-02 Thread Peter Eisentraut
On tor, 2010-09-02 at 07:54 +0200, Fabien COELHO wrote: We cannot change it. Yes we can! It, it is 100% postgresql: \d information_schema.referential_constraints View information_schema.referential_constraints ... FROM pg_namespace ncon JOIN pg_constraint con ON

Re: [BUGS] BUG #5636: extra ( or missing )

2010-09-02 Thread Tom Lane
KOIZUMI Satoru koizumi...@minos.ocn.ne.jp writes: At 33.8.5. The decimal type of PostgreSQL 9.0RC1 Documentation, ( is before by means. But there is no ). | the decimal type can be created either on the stack | or on the heap (by means of the functions | PGTYPESdecimal_new() and

Re: [BUGS] BUG #5638: disagreement of argument name

2010-09-02 Thread Tom Lane
KOIZUMI Satoru koizumi...@minos.ocn.ne.jp writes: At 33.10.4. Additional functions of PostgreSQL 9.0rc1 Documentation, the third argument of the function dtcvfmtasc is dtvalue. But in its following description, the argument name is referred as ts. Fixed, thanks.

[BUGS] BUG #5639: Compile fails on heap

2010-09-02 Thread Markus Ullmann
The following bug has been logged online: Bug reference: 5639 Logged by: Markus Ullmann Email address: m...@markus-ullmann.de PostgreSQL version: 9.0beta4 Operating system: Mac OS X 10.6.4 Description:Compile fails on heap Details: The compilation fails when trying

Re: [BUGS] BUG #5639: Compile fails on heap

2010-09-02 Thread Tom Lane
Markus Ullmann m...@markus-ullmann.de writes: The compilation fails when trying to build fat binarys (aka 32bit and 64bit in one file). There are ways to do that, but it's substantially more complicated than the patch you propose (which doesn't even begin to work, since it's trying to patch a

Re: [BUGS] issue about information_schema REFERENTIAL_CONSTRAINTS

2010-09-02 Thread Fabien COELHO
Hallo, \d information_schema.referential_constraints View information_schema.referential_constraints ... FROM pg_namespace ncon JOIN pg_constraint con ON ncon.oid = con.connamespace JOIN pg_class c ON con.conrelid = c.oid Well, for the sake of argument, how would you

Re: [BUGS] issue about information_schema REFERENTIAL_CONSTRAINTS

2010-09-02 Thread Tom Lane
Fabien COELHO coe...@cri.ensmp.fr writes: (1) use the OID as the constraint name everywhere, it would work, it would not look so good for display, but it is simple and fast. (2) otherwise something built on top of table,constraint. To be on the safe side, I would build a string

Re: [BUGS] BUG #5629: ALTER SEQUENCE foo START execute a RESTART

2010-09-02 Thread Alexsander Rosa
What about the risk of using ALTER SEQUENCE ... START N in a mixed environment? In the 8.4.x servers it will work as designed but in the 8.3.x (and below) servers, instead of issuing an error it will CORRUPT the sequence value without notice. I understand the point of keeping a (mis)feature when

[BUGS] BUG #5640: ODBC driver installed but not found

2010-09-02 Thread Hannu Pohjanpalo
The following bug has been logged online: Bug reference: 5640 Logged by: Hannu Pohjanpalo Email address: hannu.pohjanp...@winware.fi PostgreSQL version: 8.4.4 Operating system: Windows 7 Pro 64 bit Description:ODBC driver installed but not found Details: I

[BUGS] BUG #5641: Can not create any python language

2010-09-02 Thread Ron Park
The following bug has been logged online: Bug reference: 5641 Logged by: Ron Park Email address: rpar...@gmail.com PostgreSQL version: 9.0 Operating system: Windows 7 professional 64 bit Description:Can not create any python language Details: when trying to create

Re: [BUGS] Dúvida

2010-09-02 Thread Euler Taveira de Oliveira
Anderson Costa escreveu: *Gostaria de saber como faço a integração do BD PostgreSQL com o Netbeans.* * Esse não é o local apropriado para sua pergunta. É uma lista de relato de defeitos e não um local para tirar dúvidas de usuários; além disso, trata-se de uma lista na língua inglesa. Tente a

Re: [BUGS] BUG #5640: ODBC driver installed but not found

2010-09-02 Thread Craig Ringer
On 3/09/2010 2:36 AM, Hannu Pohjanpalo wrote: I installed PostgreSQL 8.4.4 in my Windows 7 Professional (64 bit), and ran (as Administrator)Application Stack Builder to download and install the ODBC driver. This installation looked perfectly successful, but when starting Control Panel /