[GENERAL] Help!!

2005-04-10 Thread Edson Vilhena de Carvalho
Hi, I hould like to know how cant I disable autocommit using the windows version. I've tried set autocommit to off in SQL but the message was : ERROR: SET AUTOCOMMIT TO OFF is no longer supported. I've tried \set autocommit off in the command-line, I have no error but the autocommit its still

[GENERAL] database monitor

2005-03-30 Thread Edson Vilhena de Carvalho
When I say database monitor I mean a program that will keep an eye on the database showin what's appening (with transactions, users, memory, etc...) on the database helping the database administrator doing is job. My problem is to know exactly the most importante things what this program must

[GENERAL] Database monitor (again)

2005-03-30 Thread Edson Vilhena de Carvalho
Sorry but perhaps it is a database monitorizer that makes the monitorization on the databases. It's my english Edson Carvalho __ Converse com seus amigos em tempo real com o Yahoo! Messenger http://br.download.yahoo.com/messenger/

[GENERAL] Database monitoring

2005-03-30 Thread Edson Vilhena de Carvalho
I´m a estudante and I am making a project where I am developing a database monitor, PostgreSQL is one of the database's that my aplication will monotorize. I have only started working with postgreSQL recently. I would like to know what do you think it is importante and useful to be monitorized

[GENERAL] database monitor

2005-03-29 Thread Edson Vilhena de Carvalho
I´m a estudante and I am making a project where I am developing a database monitor, PostgreSQL is one of the database's that my aplication will monotorize. I have only started working with postgreSQL recently I am likin it. I would like to know what do you think it is importante and useful do be

[GENERAL] relid and relname

2005-03-24 Thread Edson Vilhena de Carvalho
Hi, I'm a new guy from Portugal Can anyone tell me what is a relid, a relname and schemaname data outputs resulting from the SQL: select * from pg_stat_all_tables; There are also other data outputs that I don´t understand but they are probably related: indexrelid (oid) indexrelname (name) I

[GENERAL] backend process

2005-03-23 Thread Edson Vilhena de Carvalho
I'm a new user of postgreSQL I was loking at the documentation and testing some things and I make: select * from pg_stat_database; pg_stat_database is writen on the table of page 317, one os the outputs is numbackends that is the number of active backend server processes. I would like to know