Re: records zapped to null - Mailing list pgsql-general

From Tom Lane
Subject Re: records zapped to null
Date
Msg-id 3956.985669786@sss.pgh.pa.us
Whole thread Raw
In response to records zapped to null  (Stephen Davies <scldad@sdc.com.au>)
Responses Re: records zapped to null  (Stephen Davies <scldad@sdc.com.au>)
List pgsql-general
Stephen Davies <scldad@sdc.com.au> writes:
> I have just had to restore a database from backup because the majority
> of records in one table had "magically" become null.

There's no such thing as a null record in Postgres.  What do you mean
exactly: were the records still present but their fields all read as
nulls?

What is the declaration of the table?

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: WAL file lifespan (7.1RC1)
Next
From: Stephen Davies
Date:
Subject: Re: records zapped to null