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