[BUGS] BUG #4075: PostgreSQL Database Server 8.2 failed to start

2008-04-01 Thread uri
The following bug has been logged online: Bug reference: 4075 Logged by: uri Email address: [EMAIL PROTECTED] PostgreSQL version: 8-2 Operating system: win xp sp 2 Description:PostgreSQL Database Server 8.2 failed to start Details: Hi , I google it alot and not fou

[BUGS] BUG #4076: "IS NOT NULL (IS NULL)" return wrong answer even where all fields are NULL(or NOT NULL).

2008-04-01 Thread Tatsuhito Kasahara
The following bug has been logged online: Bug reference: 4076 Logged by: Tatsuhito Kasahara Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.11 Operating system: Red Hat Enterprise Linux 5.1 Description:"IS NOT NULL (IS NULL)" return wrong answer even where al

[BUGS] BUG #4077: Error 42704

2008-04-01 Thread Ronald Prins
The following bug has been logged online: Bug reference: 4077 Logged by: Ronald Prins Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Windows Vista Description:Error 42704 Details: I have precisly the same problem as discribed in this foru

[BUGS] BUG #4078: ERROR: operator does not exist: numeric = character varying

2008-04-01 Thread rupesh
The following bug has been logged online: Bug reference: 4078 Logged by: rupesh Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 Operating system: linux 4.0 Description:ERROR: operator does not exist: numeric = character varying Details: ERROR: operator do

Re: [BUGS] BUG #4078: ERROR: operator does not exist: numeric = character varying

2008-04-01 Thread Peter Eisentraut
Am Dienstag, 1. April 2008 schrieb rupesh: > ERROR:  operator does not exist: numeric = character varying at character > 675 > HINT:  No operator matches the given name and argument type(s). You might > need to add explicit type casts. > (0.735 sec) > > > This was previously working in 8.2.3 but no

[BUGS] BUG #4079: libpq.dll very slow (unusable)

2008-04-01 Thread Pavel Golub
The following bug has been logged online: Bug reference: 4079 Logged by: Pavel Golub Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: Windows XP SP2 Description:libpq.dll very slow (unusable) Details: Comparing 8.3.1 to 8.2.5 release INSE

[BUGS] BUG #4081: Running Postgres as Windows service vs regular applications

2008-04-01 Thread Pavel Alexei
The following bug has been logged online: Bug reference: 4081 Logged by: Pavel Alexei Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.7 Operating system: Windows XP SP2 Description:Running Postgres as Windows service vs regular applications Details: I faced

Re: [BUGS] BUG #4076: "IS NOT NULL (IS NULL)" return wrong answer even where all fields are NULL(or NOT NULL).

2008-04-01 Thread Tom Lane
"Tatsuhito Kasahara" <[EMAIL PROTECTED]> writes: > PostgreSQL version: 8.1.11 > Description:"IS NOT NULL (IS NULL)" return wrong answer even where > all fields are NULL(or NOT NULL). > I think following fix is related.. > http://archives.postgresql.org/pgsql-committers/2006-09/msg00439.php

[BUGS] BUG #4082: Fatal error, close server

2008-04-01 Thread MARCO A GONZALEZ
The following bug has been logged online: Bug reference: 4082 Logged by: MARCO A GONZALEZ Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: WIN XP Description:Fatal error, close server Details: I'm working with VFP9. When I execute "SELECT

[BUGS] BUG #4083: Return type of MAX and MIN of a VARCHAR column is TEXT

2008-04-01 Thread Pedro Gimeno
The following bug has been logged online: Bug reference: 4083 Logged by: Pedro Gimeno Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 Operating system: Irrelevant Description:Return type of MAX and MIN of a VARCHAR column is TEXT Details: Example: CREATE

Re: [BUGS] BUG #4082: Fatal error, close server

2008-04-01 Thread Heikki Linnakangas
MARCO A GONZALEZ wrote: The following bug has been logged online: Bug reference: 4082 Logged by: MARCO A GONZALEZ Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: WIN XP Description:Fatal error, close server Details: I'm working with VF

Re: [BUGS] BUG #4083: Return type of MAX and MIN of a VARCHAR column is TEXT

2008-04-01 Thread Tom Lane
"Pedro Gimeno" <[EMAIL PROTECTED]> writes: > Description:Return type of MAX and MIN of a VARCHAR column is TEXT This is not a bug. Most if not all operations with varchar will return text --- it doesn't have its own operators. > The last query's return types are both TEXT, which in Zeos

[BUGS] Postgre cant start

2008-04-01 Thread Olivier Bessière
Hello, If you can be of any help… please feel free. PostgreSQL V7.1 == [EMAIL PROTECTED] bin]$ postgres start DEBUG: database system was interrupted being in recovery at 2008-04-01 00:31:20 CST This propably means that some data b

Re: [BUGS] Postgre cant start

2008-04-01 Thread Tom Lane
=?iso-8859-1?Q?Olivier_Bessi=E8re?= <[EMAIL PROTECTED]> writes: > PostgreSQL V7.1 Egad. You really, really, really need to update forthwith. The list of bugs that have been fixed since 7.1 would curl your toes. http://developer.postgresql.org/pgdocs/postgres/release.html > FATAL 2: cannot read

Re: [BUGS] BUG #4076: "IS NOT NULL (IS NULL)" return wrong answer even where all fields are NULL(or NOT NULL).

2008-04-01 Thread Tatsuhito Kasahara
Hi. Tom Lane wrote: >> I think following fix is related.. >> http://archives.postgresql.org/pgsql-committers/2006-09/msg00439.php > > Yup, it is. Why are you reporting this? Document(for 8.1.11) said "A row value is considered not null if it has at least one field that is not null. ". http://w