[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 Postgr

[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() Details:

[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 functions

[BUGS] Dúvida

2010-09-02 Thread Anderson Costa
*Bom Dia,* * * *Gostaria de saber como faço a integração do BD PostgreSQL com o Netbeans.* * * *Fiz uma classe e setei a JDBC, mas ela não implementa o BD. Como fazer a integração ou qual a forma de criar a classe ?* * * * * *Agradeço desde já a atenção.* * * * * * * *Anderson B. Costa* * * * * * *

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 co

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

2010-09-02 Thread Tom Lane
"KOIZUMI Satoru" 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 PGTYPESdecimal_free(). F

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

2010-09-02 Thread Tom Lane
"KOIZUMI Satoru" 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. regards, tom lane --

[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" 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 configure-generated

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 pro

Re: [BUGS] issue about information_schema REFERENTIAL_CONSTRAINTS

2010-09-02 Thread Tom Lane
Fabien COELHO 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 . To be on the > safe side, I would build a string (sql_identifier?) with something like: >

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 it

[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 installed

[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 p

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 l

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 / Administ