Re: [HACKERS] Problem on PG7.2.2

2002-09-24 Thread Roberto Fichera
At 09.31 24/09/02 -0400, Tom Lane wrote: >Roberto Fichera <[EMAIL PROTECTED]> writes: > > At 10.40 23/09/02 -0400, you wrote: > >> I think you've got *serious* hardware problems. Hard to tell if it's > >> disk or memory, but get out those diagnostic programs now ... > > > database=# DROP TABLE TS

Re: [HACKERS] Problem on PG7.2.2

2002-09-24 Thread Roberto Fichera
At 09.31 24/09/02 -0400, Tom Lane wrote: >Roberto Fichera <[EMAIL PROTECTED]> writes: > > At 10.40 23/09/02 -0400, you wrote: > >> I think you've got *serious* hardware problems. Hard to tell if it's > >> disk or memory, but get out those diagnostic programs now ... > > > database=# DROP TABLE T

Re: [HACKERS] Problem on PG7.2.2

2002-09-24 Thread Tom Lane
Roberto Fichera <[EMAIL PROTECTED]> writes: > At 10.40 23/09/02 -0400, you wrote: >> I think you've got *serious* hardware problems. Hard to tell if it's >> disk or memory, but get out those diagnostic programs now ... > database=# DROP TABLE TS; > ERROR: cannot find attribute 1 of relation ts_

Re: [HACKERS] Problem on PG7.2.2

2002-09-24 Thread Roberto Fichera
At 10.40 23/09/02 -0400, you wrote: >Roberto Fichera <[EMAIL PROTECTED]> writes: > > database=# select count(*) from detail; > > count > > > > 181661 > > (1 row) > > > database=# select count(*) from detail; > > count > > > > 181660 > > (1 row) > > > database=# select co

Re: [HACKERS] Problem on PG7.2.2

2002-09-23 Thread Roberto Fichera
At 10.40 23/09/02 -0400, Tom Lane wrote: >Roberto Fichera <[EMAIL PROTECTED]> writes: > > database=# select count(*) from detail; > > count > > > > 181661 > > (1 row) > > > database=# select count(*) from detail; > > count > > > > 181660 > > (1 row) > > > database=# sele

Re: [HACKERS] Problem on PG7.2.2

2002-09-23 Thread Tom Lane
Roberto Fichera <[EMAIL PROTECTED]> writes: > database=# select count(*) from detail; > count > > 181661 > (1 row) > database=# select count(*) from detail; > count > > 181660 > (1 row) > database=# select count(*) from detail; > FATAL 2: open of /var/lib/pgsql/data/pg

[HACKERS] Problem on PG7.2.2

2002-09-23 Thread Roberto Fichera
Hi All, When I try 2 or 3 consecutive select count(*) on my database I've the problem shown below. Here is a psql session log: [root@foradada root]# psql -d database Welcome to psql, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL comm