Re: records zapped to null

From: Stephen Davies <scldad(at)sdc(dot)com(dot)au>
To: Larry Rosenman <ler(at)lerctr(dot)org>
Cc: Stephen Davies <scldad(at)sdc(dot)com(dot)au>, pgsql-general(at)postgresql(dot)org
Subject: Re: records zapped to null
Date: 2001-03-27 03:56:15
Message-ID: 200103270356.NAA29111@mustang.sdc.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sdc(dot)com(dot)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(at)sdc(dot)com(dot)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(at)lerctr(dot)org
> US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

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

Browse pgsql-general by date

  From Date Subject
Next Message Paul Tomblin 2001-03-27 04:15:23 point data type
Previous Message Larry Rosenman 2001-03-27 03:38:09 Re: records zapped to null