"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
=?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
* 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/
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
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
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
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
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