Ignore that email of mine - you've zipped the database, not a
backup...sorry!

N

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Nigel Weeks
> Sent: Tuesday, 12 July 2005 9:43 AM
> To: firebird-support@yahoogroups.com
> Subject: RE: [firebird-support] Duplicate Primary Keys
>
> Was that backup in transportable format?
> Gbak complains with 'gbak: ERROR: expected backup description record'
>
> N
>
> > -----Original Message-----
> > From: firebird-support@yahoogroups.com
> > [mailto:firebird-support@yahoogroups.com] On Behalf Of Ryan Thomas
> > Sent: Tuesday, 12 July 2005 8:49 AM
> > To: firebird-support@yahoogroups.com
> > Subject: [firebird-support] Duplicate Primary Keys
> >
> > Hi all,
> >
> > I came across this database this morning. It belongs to a client of
> > ours who was reporting some errors when using our software. On
> > inspection of the database the table in question seems to have
> > duplicates in the primary key column.
> >
> > Has anyone ever seen this before, or do they know of how it could
> > occur? The table does not have any foreign keys and the database is
> > generally only accessed by the one connection.
> >
> > I have made a copy of the database available, however all of the
> > triggers / stored procedures / views and non-related tables
> have been
> > removed. The only table in the database is titled MBUSERCOMPANY, if
> > you look at the row where COMPANYNAME is 'Seaside Home
> Loans' you will
> > see that there are two entries both with the same key.
> >
> > The database zipped down to ~3Mb, I tried doing a
> backup/restore on it
> > but the restore failed with an integrity check error (the duplicate
> > PK).
> >
> > Here's the database:
> > http://www.transactive.com.au/dup_pk.zip
> >
> > Any insight into this would be great.
> >
> > Cheers,
> >
> > Ryan Thomas
> > TransActive Systems
> >
> > P: (02) 4322 3302
> > F: (02) 4325 1141
> > E: ryan@...
> > W: http://www.transactive.com.au/
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://firebird.sourceforge.net and click the
> Resources item on
> > the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> > __________ NOD32 1.1166 (20050711) Information __________
> >
> > This message was checked by NOD32 antivirus system.
> > http://www.eset.com
> >
> >
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources
> item on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
> __________ NOD32 1.1166 (20050711) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.eset.com
>
>