[GENERAL] PANIC: cannot abort transaction 140578842, it was already committed

2009-06-23 Thread sergio nogueira
Hi, all. any idea about causes and consequences? C:\>psql -U postgres monitor Welcome to psql 8.2.4, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to e

[GENERAL] where is the table?

2009-06-20 Thread sergio nogueira
Hi, all. Where is the table? dmonitor=> create table wereisthetable(col int); CREATE TABLE dmonitor=> select tablename, tablespace from pg_tables where tablename='wereisthetable'; tablename| tablespace + wereisthetable | (1 row) dmonitor=> alter table wereisth

[GENERAL] terminating connection because of crash of another server process

2009-06-14 Thread sergio nogueira
em is ready to accept connections Any idea on how to prevent this? i'm using PostgreSQL 8.3.6 on Fedora10 Sorry by my english. I hope you can understand ... Att., Sergio Nogueira