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

[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:

[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

[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

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; revoke

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

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 are

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...

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

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;

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. Regards

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 you

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 because of unique

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 definitely a backend

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: INFO:

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