Re: [BUGS] BUG #1750: recurrentive views terminates connection

2005-07-04 Thread Tom Lane
"BartÅomiej Rychtarski" <[EMAIL PROTECTED]> writes: > PostgreSQL version: 7.3.4 > selecting from recurrent views couses termination of all client connections > to the postgres server: This is fixed in 7.4 and up. regression=# select * from test2; ERROR: infinite recursion detected in rules for

Re: [BUGS] Select on pkey returned more than one row

2005-07-04 Thread Tom Lane
=?ISO-8859-2?Q?Sz=FBcs_G=E1bor?= <[EMAIL PROTECTED]> writes: >> Version: 7.4.6, Debian "Woody" linux. >> Source: max func args increased to 64, but I doubt it matters. Well, it might, if you were sloppy about making sure that the software had been completely rebuilt (including plpgsql and any othe

Re: [BUGS] BUG #1736: endless loop in PQconnectdb

2005-07-04 Thread Karsten Desler
* Tom Lane wrote: > Karsten Desler <[EMAIL PROTECTED]> writes: > > * Bruce Momjian wrote: > >> I think what you are seeing is that the getaddrinfo memory is placed in > >> the PGconn structure that isn't freed until PQclear is called. Does > >> your test call PQclear()? > > > s/PQclear/PQfinish/

[BUGS] BUG #1750: recurrentive views terminates connection

2005-07-04 Thread Bartłomiej Rychtarski
The following bug has been logged online: Bug reference: 1750 Logged by: Bartłomiej Rychtarski Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.4 Operating system: red hat 9 Description:recurrentive views terminates connection Details: selecting from recurr

[BUGS] BUG #1749: date_trunc('week', ...) is incorrect for some dates

2005-07-04 Thread Nick Johnson
The following bug has been logged online: Bug reference: 1749 Logged by: Nick Johnson Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: FreeBSD Description:date_trunc('week', ...) is incorrect for some dates Details: numa=# SELECT date_tru

Re: [BUGS] Select on pkey returned more than one row

2005-07-04 Thread Szűcs Gábor
Dear Gurus, I'm not sure if this mail reached the list members (at least, it reached the archive). If there's some formal problem that prevents delivery, please point me to the appropriate form's description. Yours, -- G. On 2005.06.28. 15:05, Szűcs Gábor wrote: Dear Gurus, As always, ple

Re: [BUGS] Field add error

2005-07-04 Thread Richard Huxton
Jozsef Aron wrote: CREATE TABLE X.tabla ( razon bigserial, 2e00 varchar(11), AS varchar(5) ... .. . PRIMARY KEY (razon) ) WITHOUT OIDS; Fields name is not ok., denied : 'AS','1e00','2e00' I believe this is normal as regards identifier names. The word "AS" is probably reserved (sorry, haven't

[BUGS] Field add error

2005-07-04 Thread Jozsef Aron
Hello Everybody! Sorry, my English is very peer. This is Database: CREATE DATABASE TVGAR WITH ENCODING='LATIN1' OWNER=tvgaruser TEMPLATE=template0 TABLESPACE=pg_default; GRANT ALL ON DATABASE TVGAR TO GROUP "TVGAR"; This is Shema: CREATE SCHEMA 'X' AUTHORIZATION postgres; GRANT ALL ON SCHEMA