Re: [BUGS] PostgreSQL 7.0.2 Date Miscalculation

2001-04-02 Thread Philip Warner
At 00:59 3/04/01 -0400, Tom Lane wrote: > >However, the horology diffs are not, and I can't reproduce them here. >Did anyone else see that? > I've just started seeing both... Philip Warner| __---_ Albat

Re: [BUGS] PostgreSQL 7.0.2 Date Miscalculation

2001-04-02 Thread Tom Lane
Robert Hentosh <[EMAIL PROTECTED]> writes: > After the daylight savings time change I have had similar failures > with 7.1RC2 and the latest CVS of 7.1. It failed on both timestamp > and horology regression tests. This happened on both my RH7.0 and > OpenBSD 2.8 (RH7.0 on an Athlon and BSD on a P

Re: [BUGS] PostgreSQL 7.0.2 Date Miscalculation

2001-04-02 Thread Robert Hentosh
On Mon, Apr 02, 2001 at 07:52:42PM -0400, [EMAIL PROTECTED] wrote: > Jay Guerette ([EMAIL PROTECTED]) reports a bug with a severity of 2 > The lower the number the more severe it is. > > Short Description > PostgreSQL 7.0.2 Date Miscalculation > > Long Description > PostgreSQL 7.0.2 > > The REL

Re: [BUGS] Table constraint ordering disrupted by pg_dump

2001-04-02 Thread Tom Lane
Philip Warner <[EMAIL PROTECTED]> writes: > While it't not a bug, it would be nice if pg_dump reproduced definitions as > faithfully as possible. To that end, would it be worth selecting the > constraints in OID order (using oid from pg_relcheck)? If it's just another clause in a query, you might

Re: [BUGS] Table constraint ordering disrupted by pg_dump

2001-04-02 Thread Philip Warner
At 16:40 2/04/01 -0400, Tom Lane wrote: > >I don't believe this is a bug. There is no guarantee that constraints >are checked in any particular order. > While it't not a bug, it would be nice if pg_dump reproduced definitions as faithfully as possible. To that end, would it be worth selecting th

[BUGS] PostgreSQL 7.0.2 Date Miscalculation

2001-04-02 Thread pgsql-bugs
Jay Guerette ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description PostgreSQL 7.0.2 Date Miscalculation Long Description PostgreSQL 7.0.2 The RELTIME function is miscalculating dates. (all my graphs were wrong today!) Sample Code T

[BUGS] compile error for DBD-Pg-0.95 + Cannot insert a duplicate key

2001-04-02 Thread V. M.
for latest cvs snapshot compile error for DBD-Pg-0.95: cannot find 2 include files libpq-fe.h and postgres_ext.h in the normal postgres include dir, must specify the subdir "postgres". - for latest cvs snapshot : UPDATE bann_info SET cre=cre-20, dis=dis+1 WHERE id=1 [Sun

Re: [BUGS] Loosing files after backend crash

2001-04-02 Thread Tom Lane
[EMAIL PROTECTED] writes: > During execution of some sql code backend crashed (the reason for it's > crashing is not the actual topic of this report). > And tried to delete the sequence, which i created in the previous session. > That's what pgsql told me: > ---8<--- > Netflow_Test=# drop SEQUENCE

[BUGS] Loosing files after backend crash

2001-04-02 Thread pgsql-bugs
Konstantin Solodovnikov ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Loosing files after backend crash Long Description After a backend crash the file for my sequence cannot be found. I use PostgreSQL 7.1RC1 compiled by GCC

Re: [BUGS] Table constraint ordering disrupted by pg_dump

2001-04-02 Thread Tom Lane
[EMAIL PROTECTED] writes: > When running a backup/restore version of the regression tests on 7.0.3 > and 7.1RCD1 the following was noted: when the create table command > contained two constraints, the error messages would reflect that the > constraints were being checked in a consistent order and

[BUGS] Table constraint ordering disrupted by pg_dump

2001-04-02 Thread pgsql-bugs
Tricia Holben ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Table constraint ordering disrupted by pg_dump Long Description When running a backup/restore version of the regression tests on 7.0.3 and 7.1RCD1 the following was

[BUGS] can u help me

2001-04-02 Thread JACOB SIBI
Hi, I have a probelm with my JDBC coding. Iam using a Java swing interface to input data. It reads in studentID from the textField and should output the average.The code compliles well. But i get the average as 0, with exceptions as detailed below. The error I get is java.sql..SQLException:[Micr

[BUGS] PostgreSQL tcp connection

2001-04-02 Thread Lonnie Cumberland
Hello, I have installed PostgreSQL 7.0.3 on my Mandrake 7.2 Linux system and have been trying to get it to listen for TCP connectins. I added the "-i" command to the /etc/init.d/postgresql script, but still it does not seem to accept any connections. I can make local connections, but need to

[BUGS] Clients do not compile with X11 includes under C++

2001-04-02 Thread Hauke Joachim Zuehl
Hello Team :) With help of a programmers newsgroup I could solve the problem of not compiling (Linux) C++ clients using X11 and pgsql/libpq++/pgconnection.h (included via pgdatabase.h). Well, I tried the following: g++ -c kunde.cc -o kunde.o -I/usr/local/include -D__WXMOTIF__ -D_REENTRANT -O2 -I