RE: primary key lost

Posted in 2005

Dirk Moolman — Mon, 7 Mar 2005 11:42:37 +0200 — source: Usenet: comp.databases.informix

Do you have access to all the program code - can you search for alter table statements ? There must be a process somewhere dropping the primary key, or else someone who has access to your database, who can do it manually ..... -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of roger huang Sent: 05 March 2005 09:14 AM To: informix-list@iiug.org Subject: Re: primary key lost "Dirk Moolman" <DirkM@mxgroup.co.za> wrote in message news:<1109941833.b7e88f1e4e9afacc8e3aba1c423c20b0@teranews>... > Does this table get dropped & recreated ? Have you looked at the table > creation date ? table did'nt get dropped & recreated ,and table's creation date is correct. > > > -----Original Message----- > From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] > On Behalf Of roger huang > Sent: 04 March 2005 10:47 AM > To: informix-list@iiug.org > Subject: primary key lost > > Hi all, > Any one can help me? > my box is : > redhat 7.3, ids9.40UC5 > I have a table with primary key, but it often disappeared like ghosts. > I had to recreate it again. Is anyone happened this before? > Or somebody can give me some tips that I can find out how it did that. > Any information will be appreciated. Thank you in advance. > > sending to informix-list sending to informix-list