Re: [BUGS] rc4 and rc3, some deleted, but still needed text in the

2005-01-13 Thread Magnus Hagander
> Magnus Hagander wrote: > >This information is still in the documentation, it has moved to a > >different location. It's in the docmentation for the psql tool now. > >(It's under Client Application) > > Yes it is, but the message in the source code has not been > changed, which is very misleadi

[BUGS] character varying as boolean !!! help

2005-01-13 Thread Francesco Andreozzi
I think thi is a bug, I've a lot of db up with same structure and I don't have any prioblem.. I'm using psql 7.4.2 the problem is that i've a table sportellounico=# \d cfp Tabella "public.cfp" Colonna | Tipo| Modi

Re: [BUGS] rc4, PostgreSQL-installer on WinXP: ignores selected install-directory

2005-01-13 Thread Magnus Hagander
> >The installer will override any environment variables, as it > executes > >with its own environment in Windows Installer. To change a > directory, > >use the installer features for it. See the FAQ question 3.6. > > I did that, and here is FAQ 3.6: > I changed the directory but PostgreSQL wa

[BUGS] Possible problem with pg_get_viewdef on Postgres V8.0.0 rc4

2005-01-13 Thread laurie . burrow
I have a view definition that creates a view on both Postgres 7 and Postgres 8. The view definition works OK in that it does not return an error and the resulting view seems to operate correctly on both versions of Postgres. However Pgadmin 1.2.0 works fine with the Postgres 7 database containin

Re: [BUGS] character varying as boolean !!! help

2005-01-13 Thread Alvaro Herrera
On Thu, Jan 13, 2005 at 12:18:12PM +0100, Francesco Andreozzi wrote: Hi, > Tabella "public.cfp" > Colonna | Tipo| Modificatori > --+---+-

Re: [BUGS] character varying as boolean !!! help

2005-01-13 Thread Richard Huxton
Francesco Andreozzi wrote: if I try to insert something it works but the update no sportellounico=# UPDATE cfp SET testo='test' AND cod_procedimento='82' where cod_cfp='2'; ERROR: invalid input syntax for type boolean: "test" The error message is misleading you here. You want a comma not A

Re: [BUGS] rc4 and rc3, some deleted, but still needed text in the

2005-01-13 Thread Tom Lane
"Magnus Hagander" <[EMAIL PROTECTED]> writes: > Tom, want to do the honours, or do you want a patch? It's the message in > psql that you mentioned wasn't translatable. Location of docs changed. Yeah, it's on my must-fix list, but there's no point in fixing it until we decide where it should point

Re: [BUGS] Possible problem with pg_get_viewdef on Postgres V8.0.0 rc4

2005-01-13 Thread Tom Lane
[EMAIL PROTECTED] writes: > The cause of the pgadmin failure appears to be a call to > pg_get_viewdef(c.oid, true) used by pgadmin to populate its view display. > This function applied to my view works correctly on Postgres 7 but > generates the error Bogus Varno: 3 > in Postgres 8. Could we see a

Re: [BUGS] rc4 and rc3, some deleted, but still needed text in the

2005-01-13 Thread Magnus Hagander
> > Tom, want to do the honours, or do you want a patch? It's > the message > > in psql that you mentioned wasn't translatable. Location of > docs changed. > > Yeah, it's on my must-fix list, but there's no point in > fixing it until we decide where it should point to ;-). I'm > still waitin

Re: [BUGS] Possible problem with pg_get_viewdef on Postgres V8.0.0 rc4

2005-01-13 Thread laurie . burrow
Tom Lane wrote: > Could we see a full example? The view definition is of little use when > you didn't provide the definitions of the tables it references. Mea Culpa! The view references prd, and rspper tables whose defintions are shown below. I've included the gennme table as it i

Re: [BUGS] Possible problem with pg_get_viewdef on Postgres V8.0.0 rc4

2005-01-13 Thread Tom Lane
[EMAIL PROTECTED] writes: > Tom Lane wrote: >> Could we see a full example? The view definition is of little use when >> you didn't provide the definitions of the tables it references. >Mea Culpa! >The view references prd, and rspper tables whose defintions are shown >below. OK, I f

[BUGS] BUG #1387: Sort order don't work correctly

2005-01-13 Thread Andrew Kompaneev
The following bug has been logged online: Bug reference: 1387 Logged by: Andrew Kompaneev Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 RC2 Operating system: Windows 2000 SP4 Description:Sort order don't work correctly Details: On Windows platform in data

Re: [BUGS] BUG #1375: Problem with Dollar qouting functions

2005-01-13 Thread Tony Caduto
Peter, It also does it from Borland Delphi and I tightly control the EOL markers. I use a Advanced Syntax Highlighting memo component/widget from TMS software. Delphi has a function called adjustlinebreaks, where I can convert the text going to the server to have either LF or CRLF and Postgres 8.

Re: [pgsql-www] [BUGS] tsearch2 headline function fails to parse

2005-01-13 Thread Justin Clift
Tom Lane wrote: > "Tom Hebbron" <[EMAIL PROTECTED]> writes: >>There also seems to be a problem with the bug submission form on the >>website - the wwwmaster.postgresql.org server that handles the POST >> data doesn't respond - it appears to be down? > > Not my turf, but maybe someone on pgsql-www

[BUGS] BUG #1388: documentation/announcement suggestion

2005-01-13 Thread Holger Klawitt
The following bug has been logged online: Bug reference: 1388 Logged by: Holger Klawitt Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0 Operating system: all Description:documentation/announcement suggestion Details: There is no (at least no apparent) lin

[BUGS] BUG #1377: Testing the bug submission form

2005-01-13 Thread Justin Clift
The following bug has been logged online: Bug reference: 1377 Logged by: Justin Clift Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Various Description:Testing the bug submission form Details: Tom forwarded an email saying the bug submis

Re: [pgsql-www] [BUGS] tsearch2 headline function fails to parse

2005-01-13 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Justin Clift > Sent: 10 January 2005 00:02 > To: Tom Lane > Cc: Tom Hebbron; pgsql-bugs@postgresql.org; [EMAIL PROTECTED] > Subject: Re: [pgsql-www] [BUGS] tsearch2 headline function > fails to pars

[BUGS] BUG #1392: could not select filter an entry from copied data table

2005-01-13 Thread Kanu Patel
The following bug has been logged online: Bug reference: 1392 Logged by: Kanu Patel Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.6 Operating system: Linux Description:could not select filter an entry from copied data table Details: I have postgresql 7.4.

[BUGS] BUG #1390: Lock Timeout

2005-01-13 Thread Tristen Ennemuist
The following bug has been logged online: Bug reference: 1390 Logged by: Tristen Ennemuist Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: linux Description:Lock Timeout Details: This is more of an enhancement request, not a bug. It would

[BUGS] BUG #1391: Perl trusted language triggers can't properly access $_SHARED

2005-01-13 Thread Sokolov Yura
The following bug has been logged online: Bug reference: 1391 Logged by: Sokolov Yura Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0 rc2 Operating system: Windows2003 Description:Perl trusted language triggers can't properly access $_SHARED Details: I cr

[BUGS] BUG #1384: Bugs in PostgreSQl 8.0

2005-01-13 Thread RANGARAJAN
The following bug has been logged online: Bug reference: 1384 Logged by: RANGARAJAN Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: windows Description:Bugs in PostgreSQl 8.0 Details: Hello sir, We have developed an web applic

[BUGS] BUG #1394: LIKE doesn't seem to use an index

2005-01-13 Thread Steve Nicolai
The following bug has been logged online: Bug reference: 1394 Logged by: Steve Nicolai Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.6 Operating system: Fedora Core 2 Description:LIKE doesn't seem to use an index Details: I've inherited some software that

[BUGS] BUG #1395: Connection

2005-01-13 Thread Alexander Rodríguez
The following bug has been logged online: Bug reference: 1395 Logged by: Alexander Rodríguez Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 RC5 Operating system: Windows Description:Connection Details: When I add a server in Windows XP with service pack 1

[BUGS] pqsql, xythos, jdbc

2005-01-13 Thread Vincenzo Volpe
Hi, here at SAS, on MS Win platform we are currently supporting Postgres 7.3.4.2 and Xythos 4.0.48. for some of our installation, but we found the following problem using Postgres 8 and in particolar using the JDBC driver:   We used postgres 8 Beta1(which uses pg74.214.jdbc3.jar driver)

Re: [pgsql-www] [BUGS] tsearch2 headline function fails to parse integer arguments

2005-01-13 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane > Sent: 09 January 2005 21:04 > To: Tom Hebbron > Cc: pgsql-bugs@postgresql.org; [EMAIL PROTECTED] > Subject: Re: [pgsql-www] [BUGS] tsearch2 headline function > fails to parse integer argu

Re: [pgsql-www] [BUGS] tsearch2 headline function fails to parse

2005-01-13 Thread Alexey Borzov
Hi, Dave Page wrote: There also seems to be a problem with the bug submission form on the website - the wwwmaster.postgresql.org server that handles the POST data doesn't respond - it appears to be down? Not my turf, but maybe someone on pgsql-www will know what's up. Hmm, odd: [EMAIL PROTEC

[BUGS] BUG #1379: pg_dumpall problem

2005-01-13 Thread John Gallai
The following bug has been logged online: Bug reference: 1379 Logged by: John Gallai Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.2 Operating system: SuSE Linux 8.2 Description:pg_dumpall problem Details: Dear Developer Team! I think the pg_dumpall and

[BUGS] BUG #1398: Delete takes a long time & explain disagrees with \timing

2005-01-13 Thread Karl Martindale
The following bug has been logged online: Bug reference: 1398 Logged by: Karl Martindale Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.6 Operating system: Slackware 9.0 - Linux version 2.4.26 ([EMAIL PROTECTED]) (gcc version 3.3.4) Description:Delete takes

[BUGS] BUG #1397: busy-loop hang on web server

2005-01-13 Thread Chris Jones
The following bug has been logged online: Bug reference: 1397 Logged by: Chris Jones Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.6 Operating system: NetBSD 2.0 i386 Description:busy-loop hang on web server Details: I recently upgraded my OS from a previ

[BUGS] BUG #1378: make check fails in float4 and float8

2005-01-13 Thread Rolf Jentsch
The following bug has been logged online: Bug reference: 1378 Logged by: Rolf Jentsch Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: SUSE Linux 7.0 Description:make check fails in float4 and float8 Details: Hallo, while trying to install

[BUGS] BUG #1396: Connection

2005-01-13 Thread Alexander Rodríguez
The following bug has been logged online: Bug reference: 1396 Logged by: Alexander Rodríguez Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 RC5 Operating system: Windows Description:Connection Details: When I add a server in Windows XP with service pack 1

[BUGS] BUG #1382: No bug, just testing

2005-01-13 Thread Dave Page
The following bug has been logged online: Bug reference: 1382 Logged by: Dave Page Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0 RC4 Operating system: Linux developer.pgadmin.org 2.4.24-vs1.22 #12 SMP Wed May 12 09:33:12 BST 2004 i686 unknown unknown GNU/Linux De

[BUGS] BUG #1393: Adding 'LIMIT 1' to the query halts forever if no data present

2005-01-13 Thread Fahad
The following bug has been logged online: Bug reference: 1393 Logged by: Fahad Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0rc2 Operating system: Linux Description:Adding 'LIMIT 1' to the query halts forever if no data present Details: Hi, In an empty

[BUGS] BUG #1383: Junk character display on retrieval

2005-01-13 Thread R.Ramkumar
The following bug has been logged online: Bug reference: 1383 Logged by: R.Ramkumar Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows Description:Junk character display on retrieval Details: We have developed an web application in AS

[BUGS] BUG #1380: dont reading messages in russian languages

2005-01-13 Thread Ivan Chumak
The following bug has been logged online: Bug reference: 1380 Logged by: Ivan Chumak Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: windows 2000 Description:dont reading messages in russian languages Details: i talking about messages afte

[BUGS] BUG #1385: There are no ways to select unicode codepage during installation

2005-01-13 Thread Logvinov D.
The following bug has been logged online: Bug reference: 1385 Logged by: Logvinov D. Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0 RC3 Operating system: MS Windows 2000 Description:There are no ways to select unicode codepage during installation Details:

[BUGS] BUG #1386: 2 x 3.1 Gz Intel Cpu, 4Gb RAM, 2Gb Swap, Linux lssprod.localdomain 2.4.21-20.ELsmp #1 SMP Wed Aug 18

2005-01-13 Thread Gustav Lindenberg
The following bug has been logged online: Bug reference: 1386 Logged by: Gustav Lindenberg Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0rc2 Operating system: Red Hat Enterprise Linux ES release 3 (Taroon Update 3) Description:2 x 3.1 Gz Intel Cpu, 4Gb RAM

[BUGS] Bug Report

2005-01-13 Thread Elvis E. Henriquez A.
PostgreSQL RC4 Command prompt functions on Windows (Windows 2000 Professional - Spanish with SP4) still displays a message in the format: could not find a "functionname" to execute when executing a psql, pg_dump, createdb, createuser and some other functions. They work and do the required job, but

Re: [BUGS] pqsql, xythos, jdbc

2005-01-13 Thread Kris Jurka
On Wed, 12 Jan 2005, Vincenzo Volpe wrote: > here at SAS, on MS Win platform we are currently supporting Postgres > 7.3.4.2 and Xythos 4.0.48. for some of our installation, but we found > the following problem using Postgres 8 and in particolar using the JDBC > driver: > > We used postgres 8 Be

Re: [BUGS] BUG #1387: Sort order don't work correctly

2005-01-13 Thread Peter Eisentraut
Andrew Kompaneev wrote: > On Windows platform in database with encoding='UNICODE' sort order on > column with non-english chars (for example, Cyrillic) doesn't work Unicode doesn't work on Windows right now. Sorry. -- Peter Eisentraut http://developer.postgresql.org/~petere/ --

Re: [BUGS] BUG #1394: LIKE doesn't seem to use an index

2005-01-13 Thread Peter Eisentraut
Steve Nicolai wrote: > The software uses the like operator to select these related objects. > That gets slower as the number of objects increase, even though there > is an index on id. See this page for how to create correct indexes for pattern matching operators: http://www.postgresql.org/docs

Re: [BUGS] BUG #1384: Bugs in PostgreSQl 8.0

2005-01-13 Thread Peter Eisentraut
RANGARAJAN wrote: >We have developed an web application in ASP.Net with back > end as POSTGreSQL Version 7.4 for Linux, which works fine without any > issues. Recently we had tested the same application with POSTGreSQL > Version 8.0 for Windows, there we found lots of issues like if we

Re: [BUGS] BUG #1378: make check fails in float4 and float8

2005-01-13 Thread Peter Eisentraut
Rolf Jentsch wrote: > A small test program showed that the implementation of strtod in this > version of glibc is quite "special": 'inf' is understood but > 'infinity' is not. > after a call to > strtod("infinity",&end) > *end points to "inity", and not to the end of the input as expected. Yes, we

Re: [BUGS] BUG #1385: There are no ways to select unicode codepage during installation

2005-01-13 Thread Peter Eisentraut
Logvinov D. wrote: > There are no ways to select unicode codepage during installation. Unicode doesn't work correctly on Windows. That's why the choice is not given during installation. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)-