Re: [ADMIN] close connection

Freddy Expósito Moreno wrote: I need to close all connections from one database and keep all connection from the other databases in my postgresql server. Can some body help me? Hello Freddy This could be a solution, but probably not a good/the best one: 1.) Mark out the database in pg_hba.conf

[ADMIN] small table occupies many relpages

Hi, we log access log data to a PostgreSQL 7.3.4 database. There is this small table virtual_domains access_logs2=# \d virtual_domains Table "public.virtual_domains" Column | Type | Modifiers

Re: [ADMIN] vacuum full problem

pginfo wrote: Hi, I am running pg 7.3.4 on linux red hat 9.0. If I try to execute vacuum full analyze verbose, the pg vacuum some tables and hang after this lines: INFO: --Relation pg_toast.pg_toast_16408-- INFO: Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, UnUsed

[ADMIN] pg_atoi: zero-length string

Hi all, I am sure this has been asked many times, but I have not found anything in the archives... I have an Application (www.phpgroupware), which submits suboptimal Queries like SELECT * FROM phpgw_accounts WHERE account_id='' Now Postgresql responds like this: *PostgreSQL Error*: 1 (ERROR: pg_a

[ADMIN] I feel a bit dumb, but getting a bit clueless

I am certainly not awake, that I have troubles with a simple thing like this, but there it is I have three tables: Names(NameID INT4 PRIM INDEX, Name VARCHAR(30)), Groups(GroupID INT4 PRIM INDEX, Group VARCHAR(30)) And a table Members(NameID,GroupID) PRIM INDEX ON (NameID, GroupID) Now I pu

[ADMIN] Out of buffer error

Hi all, during a sql statement (running in pgadmin III) I got an error message: Out of buffer error - Time to abort Which buffers are meant? How could I increase the amount of these buffers? I hope someone could help me ... Regards, Christian ---(end of broadcast)--

Re: [ADMIN] read only connection

On Thu, 06 Nov 2003 23:59:29 +0100 Gaetano Mendola <[EMAIL PROTECTED]> wrote: > Already asked, I try again: > > 7.4 give the feature to have transaction in > read only mode, is it possible give permission > to an user to perform db connection in read only > mode ? > create user readonlyuser; r

Re: [ADMIN] close connection

This is a good idea if I want to reject the access to this database every time but in my case I need to close de access to one database one time and could be any database in any moment. A need a dynamic solution. Thanks any way Oli Oli Sennhauser wrote: Freddy Expósito Moreno wrote: I need t

Re: [ADMIN] I feel a bit dumb, but getting a bit clueless

On Fri, 7 Nov 2003, Michiel Lange wrote: > I am certainly not awake, that I have troubles with a simple thing like > this, but there it is > > I have three tables: Names(NameID INT4 PRIM INDEX, Name VARCHAR(30)), > Groups(GroupID INT4 PRIM INDEX, Group VARCHAR(30)) > And a table Members(NameI

Re: [ADMIN] small table occupies many relpages

Markus Bertheau <[EMAIL PROTECTED]> writes: > It has a unique index on virtual_domain. Every day we do <1 queries > of the form > insert into virtual_domains values (default, 'www.something.de') So you're expecting these inserts to fail because of unique index violations? > The big table size

Re: [ADMIN] Out of buffer error

"Christian Brosig" <[EMAIL PROTECTED]> writes: > during a sql statement (running in pgadmin III) I got an error message: > Out of buffer error - Time to abort If this is 7.3.something, update to 7.3.4. regards, tom lane ---(end of broadcast)-

Re: [ADMIN] close connection

=?ISO-8859-1?Q?Freddy_Exp=F3sito_Moreno?= <[EMAIL PROTECTED]> writes: > This is a good idea if I want to reject the access to this database > every time but in my case I need to close de access to one database > one time and could be any database in any moment. A need a dynamic solution. If you

Re: [ADMIN] I feel a bit dumb, but getting a bit clueless

Yes, that's the one :) Strange though that I really thought that I had done that first, but that gave no results at all... might have had something to do with double and single quotes ("Names"."NameID") is what I did now, and that works, but 'Names.NameID' gave no results, but no error either...

[ADMIN] OT: Re: pg_atoi: zero-length string

Dani Oderbolz wrote: I have an Application (www.phpgroupware), which submits suboptimal Queries like SELECT * FROM phpgw_accounts WHERE account_id='' Now Postgresql responds like this: *PostgreSQL Error*: 1 (ERROR: pg_atoi: zero-length string ) Is there a workaround for this (eg. a Startu

Re: [ADMIN] pg_atoi: zero-length string

Upgrade phpgroupware. This started with 7.3, and the PHPGroupware folks fixed it based on a bug report I filed. LER --On Friday, November 07, 2003 12:57:47 +0100 Dani Oderbolz <[EMAIL PROTECTED]> wrote: Hi all, I am sure this has been asked many times, but I have not found anything in the archi

Re: [ADMIN] read only connection

Jeff wrote: On Thu, 06 Nov 2003 23:59:29 +0100 Gaetano Mendola <[EMAIL PROTECTED]> wrote: Already asked, I try again: 7.4 give the feature to have transaction in read only mode, is it possible give permission to an user to perform db connection in read only mode ? create user readonlyuser; rev

Re: [ADMIN] Out of buffer error

Tom Lane wrote: "Christian Brosig" <[EMAIL PROTECTED]> writes: during a sql statement (running in pgadmin III) I got an error message: Out of buffer error - Time to abort If this is 7.3.something, update to 7.3.4. I suspect that is an pgadmin III related problem, not a postgres problem. Regard

Re: [ADMIN] read only connection

On Fri, Nov 07, 2003 at 19:53:42 +0100, Gaetano Mendola <[EMAIL PROTECTED]> wrote: > > I know but is not system/tables wide. > Each time that a table is created I shall remember > to revoke the permission, what I was looking for > was an option to insert into pg_hba.conf When you create a table

Re: [ADMIN] small table occupies many relpages

Ð ÐÑÐ, 07.11.2003, Ð 16:45, Tom Lane ÐÐÑÐÑ: > Markus Bertheau <[EMAIL PROTECTED]> writes: > > It has a unique index on virtual_domain. Every day we do <1 queries > > of the form > > insert into virtual_domains values (default, 'www.something.de') > > So you're expecting these inserts to fail b

Re: [ADMIN] Out of buffer error

Gaetano Mendola <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> "Christian Brosig" <[EMAIL PROTECTED]> writes: >>> Out of buffer error - Time to abort >> >> If this is 7.3.something, update to 7.3.4. > I suspect that is an pgadmin III related problem, > not a postgres problem. No, it's definite

Re: [ADMIN] vacuum full problem

Hi, I try to reindex and reindex run ok, but the vacuum still not running. regards, ivan. Antonis Antoniou wrote: > pginfo wrote: > > >Hi, > >I am running pg 7.3.4 on linux red hat 9.0. > > > >If I try to execute vacuum full analyze verbose, the pg vacuum some > >tables and hang after this lines:

Re: [GENERAL] [ADMIN] [HACKERS] retrieve statement from catalogs

Hi everybody, can anyone tell me if there's a way to retrieve the select instruction executed from the catalogs, or maybe via some structure in a trigger? The reason is that i have some selects constructed on-the-fly (just part of it) and i want to save that in a table in order to know what are