Re: [ADMIN] see previous queries

2003-12-04 Thread Andrei Bintintan
Look in postgresql.conf file: # # Message display # server_min_messages = info # Values, in order of decreasing detail: # debug5, debug4, debug3, debug2, debug1, # info, notice, warning, error, log, fatal, # panic client_min_messages = info # Values, in order of decreasing

Re: [ADMIN] see previous queries

2003-12-04 Thread Sai Hertz And Control Systems
Dear Ashok, Hope you are not using Postgresql 7.4 if this is the case I think some insert /update statements are waiting for commit command Regards, V Kashyap hi i am a new user in postgresql. problem:- in postgresql there is any command to see history (previous day queries) like as history

Re: [ADMIN] see previous queries

2003-12-04 Thread Stephan Szabo
On Wed, 4 Dec 2003, Ashok Chauhan wrote: i am a new user in postgresql. problem:- in postgresql there is any command to see history (previous day queries) like as history command in linux. Not precisely. For the backend, you can log the statements that are run by changing the

Re: [ADMIN] PGSQL and DNCL

2003-12-04 Thread Bruce Momjian
Renney Thomas wrote: Has anyone any experience with PGSQL 7.x and implenting the FTC do-not-call list - which is about 50 million 10 digit N. American phone numbers? If so what structures have you used and what have you done interms of performance tweaks? Is there an equivalent to Oracle's

Re: [ADMIN] incremental backup

2003-12-04 Thread Bruce Momjian
Ashok Chauhan wrote: hi there is any utility or command in postgresql for incremental backup or incremental restore. No, but we are working on it. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a

[ADMIN] Trigger to call an external program

2003-12-04 Thread Alan Graham
I'm doing a low cost, low performance roll your own replication project, between various offices around Australia. The replication is asynchronous, and peer to peer. I've looked at the various replication projects, and for one reason or another, they're too hard. My design uses jabber as

Re: [ADMIN] Trigger to call an external program

2003-12-04 Thread Peter Childs
On Thu, 4 Dec 2003, Alan Graham wrote: I'm doing a low cost, low performance roll your own replication project, between various offices around Australia. The replication is asynchronous, and peer to peer. I've looked at the various replication projects, and for one reason or another,

Re: [ADMIN] Trigger to call an external program

2003-12-04 Thread Stephan Szabo
On Thu, 4 Dec 2003, Alan Graham wrote: I'm doing a low cost, low performance roll your own replication project, between various offices around Australia. The replication is asynchronous, and peer to peer. I've looked at the various replication projects, and for one reason or another,

Re: [ADMIN] see previous queries

2003-12-04 Thread Glenn Wiorek
problem:- in postgresql there is any command to see history (previous day queries) like as history command in linux. In addition to server and client logging levels adjusted via the postgresql.config file, psql also has a command history like bash that is preserved between sessions. The

[ADMIN] Index not used. WHY?

2003-12-04 Thread Andrei Bintintan
Hi, I have the following table: CREATE TABLE public.rights (id int4 DEFAULT nextval('"rights_id_seq"'::text) NOT NULL, id_user int4 NOT NULL, id_modull int4 NOT NULL, CONSTRAINT rights_pkey PRIMARY KEY (id)) and I created the following indexes: CREATE INDEX right_id_modull_idx ON rights

[ADMIN] pg_dump and schemas

2003-12-04 Thread ow
pgSql 7.4.0 Hi, If a *schema* is dumped and then restored on a different server, will it be necessary to also restore system schemas, e.g. pg_catalog? Thanks __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/

Re: [ADMIN] see previous queries

2003-12-04 Thread Andrei Bintintan
Look in postgresql.conf file: # # Message display # server_min_messages = info # Values, in order of decreasing detail: # debug5, debug4, debug3, debug2, debug1, # info, notice, warning, error, log, fatal, # panic client_min_messages = info # Values, in order of decreasing

Re: [ADMIN] PGSQL and DNCL

2003-12-04 Thread Christopher Browne
After a long battle with technology, [EMAIL PROTECTED] (Renney Thomas), an earthling, wrote: Has anyone any experience with PGSQL 7.x and implenting the FTC do-not-call list - which is about 50 million 10 digit N. American phone numbers? If so what structures have you used and what have you

Re: [ADMIN] eRserver

2003-12-04 Thread Christopher Browne
[EMAIL PROTECTED] (Renney Thomas) writes: I would like to hear about any issues related to erserver. I was a little concerned about its use of Java. Java is a great tool for creating application frameworks for the payroll department, but using it for back-end system-level application

Re: [ADMIN] eRserver

2003-12-04 Thread Andrew Rawnsley
On Dec 1, 2003, at 2:34 PM, Christopher Browne wrote: [EMAIL PROTECTED] (Renney Thomas) writes: I would like to hear about any issues related to erserver. I was a little concerned about its use of Java. Java is a great tool for creating application frameworks for the payroll department, but

Re: [ADMIN] pg_dump and schemas

2003-12-04 Thread Peter Eisentraut
ow writes: If a *schema* is dumped and then restored on a different server, will it be necessary to also restore system schemas, e.g. pg_catalog? No. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all

Re: [ADMIN] Index not used. WHY?

2003-12-04 Thread Stephan Szabo
On Thu, 4 Dec 2003, Andrei Bintintan wrote: Hi, I have the following table: CREATE TABLE public.rights ( id int4 DEFAULT nextval('rights_id_seq'::text) NOT NULL, id_user int4 NOT NULL, id_modull int4 NOT NULL, CONSTRAINT rights_pkey PRIMARY KEY (id) ) and I created the following