[BUGS] Outer join does not report rows with null values

2001-05-30 Thread pgsql-bugs
Mirek Hankus ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Outer join does not report rows with null values Long Description I'm running two databases (7.1.2). Same structure, the only difference is data stored in them. When

[BUGS] "pg_ctl restart" in 7.1.2

2001-05-30 Thread Trond Eivind Glomsrød
"pg_ctl restart" seems to not work as documented in postgresql 7.1.2. bash-2.04$ /usr/bin/pg_ctl restart -w -D /var/lib/pgsql/data -m fast waiting for postmaster to shut down..done postmaster successfully shut down /usr/bin/postmaster: invalid argument -- '-D' Try '/usr/bin/postmaster --help'

[BUGS] [Fwd: PygreSQL]

2001-05-30 Thread albert DURANTON
I write a french account software in Python. I need PostgreSQL but i can not connect to it with Python. I always get this : python >>> import pg >>> dc = pg.connect('testdb','localhost') pg.error : connectDB() -- connect() failed : connection refused Is the postmaster running (with -i) at

[BUGS] BUG REPORT

2001-05-30 Thread Frank Contrepois
Hi I use Postgresql 7.1.1 compiled on a P3 running slackware 7.1 with glibc-2.2.1 make-3.79.1 and gxx-2.95.2 and others dev tools upgraded if needed ask me for more. I create this function: DROP FUNCTION inserisci(int4,int4,char(1)); CREATE FUNCTION inserisci(int4,int4,char(1)) RETURNS int4 AS

[BUGS] dlopen() of libpsqlodbc.so fails in 7.1.2

2001-05-30 Thread pgsql-bugs
Bob Deblier ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description dlopen() of libpsqlodbc.so fails in 7.1.2 Long Description While trying to upgrade Postgres from version 7.0.3 to 7.1.2, I find that a program which dlopens the libra

Re: [BUGS] BUG REPORT

2001-05-30 Thread Tom Lane
"Frank Contrepois" <[EMAIL PROTECTED]> writes: > everything work fine if the query"FOR riga IN SELECT * FROM fr_tab_conv1 > WHERE ordre >= or AND gnum = gn AND glettre = gl ORDER BY ordre DESC LOOP" > return something if not: This is fixed in 7.1.2. regards, tom lane

[BUGS] INSTALL procedure doesn't create data dir.

2001-05-30 Thread pgsql-bugs
Josh Burdick ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description INSTALL procedure doesn't create data dir. Long Description when doing an install-from-source of 7.1.2, on an Intel Red Hat 6.1 box, following the INSTALL "short v

[BUGS] pg_dump dumps view ACLs before the view

2001-05-30 Thread pgsql-bugs
Mark Reibert ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description pg_dump dumps view ACLs before the view Long Description System Configuration: - Intel Pentium - Red Hat 6.2 (Linux 2.2.19) Version [output of "select version()"

RE: [BUGS] a typo in Docs, 7.1

2001-05-30 Thread Maxim Maletsky
That's not the page I'm talking about, What I have is the downloaded version of the manual. Mine chapter is 2.2 (not 11-1) and the page contains just one (two?) paragraph where that bug was seen. (no graphics and schemas are on that page) Do you get any idea what manual am I referring to? If no I

RE: [BUGS] a typo in Docs, 7.1

2001-05-30 Thread Maxim Maletsky
True, I cannot find it on the web. And what's even more confusing is that here, at home I always though I had the exactly same downloaded copy of the manual but instead it is the one you are talking about. (same versions, close were download times,... same sources too?) Guess no real problem then