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