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