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

From Stephen Davies
Subject Re: records zapped to null
Date
Msg-id 200103270356.NAA29111@mustang.sdc.com.au
Whole thread Raw
In response to Re: records zapped to null  (Larry Rosenman <ler@lerctr.org>)
List pgsql-general
Oops! Sorry.

7.0.2 and Linux.

The database is accessed from a VB5 app via ODBC.

Stephen

On Mon, 26 Mar 2001 21:38:09 -0600, Larry Rosenman said:
> * Stephen Davies <scldad@sdc.com.au> [010326 21:36]:
> > Hello again.
> >
> > I have just had to restore a database from backup because the majority
> > of records in one table had "magically" become null.
> >
> > Last Friday morning there were some 700 valid rows in the table but yesterd
> ay
> > all but 42 had become totally null.
> >
> > Restoring from Thursday night's backup repaired things so I am
> > wondering what could have happened in between to cause this strange
> > phenomenon.
> What version of PostgreSQL?
>
> What Platform?
>
> What type of queries?
>
> LER
>
>
>
> >
> > Cheers and thanks,
> > Stephen Davies
> >
> >
> > ========================================================================
> > Stephen Davies Consulting                              scldad@sdc.com.au
> > Adelaide, South Australia.                             Voice: 08-8177 1595
> > Computing & Network solutions.                         Fax: 08-8177 0133
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> --
> Larry Rosenman                     http://www.lerctr.org/~ler
> Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
> US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749


========================================================================
Stephen Davies Consulting                              scldad@sdc.com.au
Adelaide, South Australia.                             Voice: 08-8177 1595
Computing & Network solutions.                         Fax: 08-8177 0133



pgsql-general by date:

Previous
From: Larry Rosenman
Date:
Subject: Re: records zapped to null
Next
From: Paul Tomblin
Date:
Subject: point data type