[BUGS] Bug #450: triggered data change violation on relation

2001-09-13 Thread pgsql-bugs
Sebastien Bechet ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description triggered data change violation on relation Long Description We have exactly the same problem : http://fts.postgresql.org/db/mw/msg.html?mid=1032531 Stephan Szab

[BUGS] libpd - PQfinish() - crashes client application in some cases

2001-09-13 Thread Jean-Michel.chabanne
Hi, I shall try to write english well enough :) I'm writing a GUI client to access my PostrgeSQL DB, with FLTK libraries. Sometimes, the client crashes. I have written un source code, as little as possible, without FLTK libraries, to test the behavior of PQfinish(), and I noticed : If no connexio

[BUGS] plpgsql & temp table -bug

2001-09-13 Thread Szima Gabor
Hello! - > createdb test CREATE DATABASE > createlang plpgsql test > psql test Welcome to psql, the PostgreSQL interactive terminal. create function testcnt () returns int4 as ' declare rp int4; begin select count(*) into rp from test

[BUGS] SQLCODE==-209

2001-09-13 Thread John Summerfield
I'm using 7.2devel from CVS, and as I've already reported, the documentation doesn't build. Consequently I'm forced to rely on documentation for 7.1.2/3 which does not mention -209, at least in the ecpg documentation I'm looking at, Nore does it appear in the DB2 documentation I'm using as sec

[BUGS] dynamic date

2001-09-13 Thread Tomasz Myrta
I have something like this: billy=# EXPLAIN SELECT * from kursy where id_trasy=1 and data_kursu=date('2001-12-12'); NOTICE: QUERY PLAN: Index Scan using pp on kursy (cost=0.00..51.55 rows=1 width=18) billy=# EXPLAIN SELECT * from kursy where id_trasy=1 and data_kursu='2001-12-12'; NOTICE:

[BUGS] problem with foreign key

2001-09-13 Thread pie yves
hello, I have a problem with a foreign key. I have got a 7.1 PGSQL and pg_dump version I've got a foreign key error whereas i'm sure that the value exists since i make a SELECT before. It's a PHP/PGSQL application. There is what it returns : (it's what i have into my HTML page) ---

[BUGS] PQexec infinite loop

2001-09-13 Thread Angus Lees
we have some perl code that used a DBD::Pg statement handle after the parent database handle had been disconnected. by doing this we could consistently put libpq into a spin: PQexec (conn=0x829e120, query=0x82a2b80 "SELECT \"login\"\n\t FROM \"account\"\n", ' ' , "WHERE \"id\" = '1'\n"

[BUGS] dynamic-static date once again

2001-09-13 Thread Tomasz Myrta
Tom Lane wrote: > > Tomasz Myrta <[EMAIL PROTECTED]> writes: > > Why the first expression is 25 times slower? > > Hard to say, when you haven't shown us the schema. (Column datatypes, > definitions of available indexes, etc are all critical information for > this sort of question.) OK Don't pa

Re: [BUGS] PQexec infinite loop

2001-09-13 Thread Tom Lane
Angus Lees <[EMAIL PROTECTED]> writes: > by doing this we could consistently put libpq into a spin: Hmmm ... the patch you give is no good as-is, since it will break the behavior for "normal" errors. If we want to work around this, we'll need some way to distinguish persistent inside-libpq failu

Re: [BUGS] Re: timestamps cannot be created without time zones

2001-09-13 Thread Rainer Mager
I posted this about 2 weeks ago and saw no further follow ups. Is this timestamp thing not considered a bug? Or am I just doing something wrong? Thanks, --Rainer > -Original Message- > Sorry to reopen this issue but I still think there is a bug > somewhere, > perhaps in the JDBC dr

Re: [BUGS] SQLCODE==-209

2001-09-13 Thread Peter Eisentraut
John Summerfield writes: > I'm using 7.2devel from CVS, and as I've already reported, the documentation doesn't >build. http://www.ca.postgresql.org/devel-corner/docs/postgres/index.html > Consequently I'm forced to rely on documentation for 7.1.2/3 which > does not mention -209, at least in t

Re: [BUGS] plpgsql & temp table -bug

2001-09-13 Thread Peter Eisentraut
Szima Gabor writes: > Table-OID are cached and not flushed after DROP TABLE? Something like that, but what are you expecting? -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 2: you can ge