[BUGS] Date calculation produces wrong output with 7.02

2001-02-23 Thread pgsql-bugs
Mark Stosberg ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Date calculation produces wrong output with 7.02 Long Description I use Postgres nearly every day and am very appreciative of the project. I think this example wil

Re: [BUGS] Date calculation produces wrong output with 7.02

2001-02-23 Thread Tom Lane
Mark Stosberg ([EMAIL PROTECTED]) writes: > [PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc 2.96] > cascade=> select date(CURRENT_DATE + ('30 days'::reltime)); > date > -- > 9097-10-20 Ugh. What is happening here is that there is no '+' operator between types date and relt

[BUGS] delete fails due to referential integrity, but return code is 0.

2001-02-23 Thread Leonid Furman
Hello, I am using PostgreSql on Windows NT 4.0 service pack 5. PostgreSQL version is PostgreSQL 7.0.0 on i686-pc-cygwin, compiled by gcc egcs-2.91.57. The client is an ODBC program which connects to the backend using odbc driver version 6.50.00.00. When deleting a record from table A reference

[BUGS] regression test problems

2001-02-23 Thread Jeffrey F. Lawhorn
Postgres Developers: I have found what I believe to be a bug in the regression test procedures. Specifically, the createlang script requires that the PGLIB variable be set either via a command line argument (that is not documented in the man page) or passed in via the environment. When runni

[BUGS] JDBC bug in 7.1b4

2001-02-23 Thread Rainer Mager
Hi, While trying 7.1b4 I got this using JDBC2: ERROR: A request from 10.0.0.46 (10.0.0.46) resulted in java.lang.NumberFormatException: 20 18:46:53+09 java.lang.NumberFormatException: 20 18:46:53+09 at java.lang.Integer.parseInt(Integer.java, Compiled Code) at java.lang.Integ

[BUGS] non blcoking behaviour

2001-02-23 Thread Erik Hofman
POSTGRESQL BUG REPORT TEMPLATE Your name : Erik Hofman Your email address : [EMAIL PROTECTED] Sys

[BUGS]

2001-02-23 Thread Nome real
Gabriel Sampaio Papassoni [EMAIL PROTECTED] system configuration Architeture :unknow Operating System: Linux Conectiva 6.0 PostgreSQL Version 7.0 Description of the problem: I canot create more than one database. example : I create a database called dbname1 this is OK but when I try t

[BUGS] makefile broken...

2001-02-23 Thread Dan Pereira
Hello, I'm running slackware Linux 7.1 using gmake and I get the following errors when doing a configure: mkdir: cannot make directory `interfaces/odbc': No such file or directory ln: ./include/port: hard link not allowed for directory configure: error: can not link interfaces/odbc/port to ./in

[BUGS] ExecEvalAggref

2001-02-23 Thread Moritz Gmelin
Hi Postgresql developers ! I'm pretty happy with postgres, and am right now testing PSQL 7.1 for image storage and stuff. So here's my bug report. pretty simple. do a create table test (id int); insert into test values (1); insert into test values (2); insert into test values (3); select count(

Re: [BUGS] Sequence of characters not supported by psql/pg_dump

2001-02-23 Thread Samuel Minne
Le jeu, 11 jan 2001, Tatsuo Ishii a écrit : > > I use PostgreSQL 7.0.2 on linux. > > The base was set with initdb -E UNICODE. > > > > I have many Strings with accents (french language). > > Some of them aren't supported by queries or pg_dump: > > > > WORKING EXAMPLE: > > DB=# sel

[BUGS] Problem using Postgres 7.0.3 on SCO Unixware 7.1.1

2001-02-23 Thread Joel Quinet
Hi all, I try to use Postgres 7.0.3 on SCO Unixware 7.1.1. It compiles fine, but I have the following error message when a launch psql: psql: No pg_hba.conf entry for localhost, user postgres, database postgres. I have made no change to the pg-hba.conf. I have read in the documentation, it is ok

Re: [BUGS] pg_dump failing on LinuxPPC

2001-02-23 Thread Stu Coates
Tom Lane wrote: > > Looks like you're trying to run a 6.5-or-older pg_dump against a 7.1 backend. > Check your PATH. Boy am I red faced... I was forgetting that LinuxPPC2000 comes with PostgreSQL installed... oh well, it was late! ;-( Anyway, I've sorted my obsolete version problem, and have di

Re: [BUGS] non blcoking behaviour

2001-02-23 Thread Tom Lane
Erik Hofman <[EMAIL PROTECTED]> writes: > Probably adding CONNECTION_MADE to PQsendQuery The code is not broken, but it would be if we changed that. CONNECTION_MADE is an intermediate state in the nonblocking connection procedure; it does not entitle you to send a query. You really shouldn't be

Re: [BUGS] Problem using Postgres 7.0.3 on SCO Unixware 7.1.1

2001-02-23 Thread Peter Eisentraut
Joel Quinet writes: > I try to use Postgres 7.0.3 on SCO Unixware 7.1.1. You'll be better off using a 7.1 beta. We've fixed quite a few problem with UnixWare in there. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

[BUGS] Re:

2001-02-23 Thread Thomas Lockhart
> now if I delete de database dbname1 and try to create the database dbname2 > it works. Your hard disk is full?? - Thomas

Re: [BUGS] pg_dump failing on LinuxPPC

2001-02-23 Thread Tom Lane
Stu Coates <[EMAIL PROTECTED]> writes: > Anyway, I've sorted my obsolete version problem, and have discovered > another. Attached is a short shell script that causes pg_dump to core > dump whilst trying to dump a single, quite simple, table. Fix committed --- but it just missed the boat for 7.1b

[BUGS] Receiving "No such file or directory" error from the database

2001-02-23 Thread pgsql-bugs
John Puster ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Receiving "No such file or directory" error from the database Long Description While setting up the sourceforge package (which requires an installation of PostgreSQL

Re: [BUGS] Receiving "No such file or directory" error from the database

2001-02-23 Thread Tom Lane
John Puster ([EMAIL PROTECTED]) writes: > While setting up the sourceforge package (which requires an > installation of PostgreSQL 7.1), a script created a temporary table > called user_metric_tmp1_1. This table is impossible to browse, alter, > or drop. All said actions on this table result in