Re: [BUGS] NT Binary V7.0 - postgres fails start cause PG_VERSION

[EMAIL PROTECTED] wrote: > > Elian Carsenat ([EMAIL PROTECTED]) reports a bug with a severity >of 2 > The lower the number the more severe it is. > > Short Description > NT Binary V7.0 - postgres fails start cause PG_VERSION > > Long Description > NT Binary V7.0 - postgres fails to start becau

Re: [BUGS] Problem with BETWEEN and a view.

Andrew Snow <[EMAIL PROTECTED]> writes: > Here's a simpler script which reproduces the bug: OK, I can reproduce the bug in 7.0.2 and 7.0.3, but not in current development sources. More tomorrow ... I'm about out of steam for tonight ... regards, tom lane

Re: [BUGS] Problem with BETWEEN and a view.

> Looks like a bug to me, but I'd like not to have to reverse-engineer the > test case before I can look at it. Could you provide some sample data, > as well as the missing "Types" table declaration? Ideally a psql script > file to load everything up from scratch and trigger the error ;-) Well

Re: [BUGS] Problem with BETWEEN and a view.

Andrew Snow <[EMAIL PROTECTED]> writes: > # select * from mailredirs where start < CURRENT_TIMESTAMP and stop > >CURRENT_TIMESTAMP; > ERROR: Bad timestamp external representation 'Just because.' > Why is it even looking at the 'reason' field?? Looks like a bug to me, but I'd like not to have t

Re: [BUGS] Problem with BETWEEN and a view.

Further to this, I wish you to note the following works correctly: # select start, stop from mailredirs where start < CURRENT_TIMESTAMP; start | stop + 2000-10-31 17:26:52+11 | 2000-11-25 16:29:01+11 (1 row) # select st

[BUGS] Problem with BETWEEN and a view.

I just installed v7.0.3 release on a FreeBSD 4.x system. (Problem still happened in 7.0.2 too). This is the problem I noticed: # select * from mailredirs; username |destination | start | stop | reason --++

[BUGS] Fail to restore index tables from pg_dumpall

jessica ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description Fail to restore index tables from pg_dumpall Long Description Dear Pgsql-bugs Group, I am not sure if this is a bug or not but I really hope if any of you can help me.

[BUGS] Fail to restore index table from pg_dumpall

Dear Pgsql-bugs Group, I am not sure if this is a bug or not but I really hope if any of you can help me. My problem is I fail to restore all index tables from pg_dumpall command. First of all, I logged in as postgres superuser. Then I backed up my PostgreSQL database which is in version 6.4.2

[BUGS] Problem with RULE system with condition between 3 tables.

Hi All, I create rule with condition between 2 different tables, it's working OK. sysname - pkey in routers_snmp and routers_name tables. sysname,index - pkey in interfaces_name table. CREATE RULE "send_signal_if_update_interfaces_name" AS ON UPDATE TO interfaces_name WHERE old.monitor_ov_enabl

Re: [BUGS] Fail to restore index tables by pg_dumpall

"Jessica Ord" <[EMAIL PROTECTED]> writes: > After that, I restored this file onto a newer version of PostgreSQL 7.0.2 by > the below command. > # psql -e template1 < db.all > However, I login to the database and I noticed that all the tables are > restored properly except all my index tables are

[BUGS] Fail to restore index tables by pg_dumpall

Dear Psql-bugs Group, I am not sure if this is a bug or not but I really hope if any of you can help me. My problem is I logged as postgres superuser. I then backed up my PostgreSQL database with version 6.4.2 by using pg_dumpall. # pg_dumpall -o > db.all Then, I initialize the template1 by ru

[BUGS] JDBC

Hello postgresql team, I'am trying to connect to the posgresql database through JDBC and it doesn't function. 1. I have made the postgresql.jar through the command "make jdbc2" -as it is described in /src/interfaces/jdbc/ source- and it is copied to my CLASSPATH 2. I have an access to the datab

[BUGS] PostgreSQL fails to build [ Solaris 8 ]

I am getting a error while trying to compile PostgreSQL on my Solaris Sparc 20. Solaris 8 Attach is the error I'm getting when I ran gmake. # uname -a SunOS SPARC20 5.8 Generic sun4m sparc SUNW,SPARCstation-20 --- # gmake --version GNU Make ver

Re: [BUGS] Problems with rules

Hello > Long Description > The given code is destilled from a reallife DB. All attempts to define a rule which >automatically updates the column aenderungsdatum from table mitglieder on updates >failed. The result was every > time > psql:ruleerror:17: ERROR: query rewritten 10 times, may con

[BUGS] NT Binary V7.0 - postgres fails start cause PG_VERSION

Elian Carsenat ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description NT Binary V7.0 - postgres fails start cause PG_VERSION Long Description NT Binary V7.0 - postgres fails to start because PG_VERSION not recognized properly (windo

[BUGS] Problems with rules

Carsten Zerbst ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Problems with rules Long Description The given code is destilled from a reallife DB. All attempts to define a rule which automatically updates the column aenderung