On Wednesday 07 January 2004 23:01, Michael Fuhr wrote: > On Wed, Jan 07, 2004 at 07:47:32PM +0530, Kenneth Gonsalves wrote: > > in 7.4 i'm getting an error message - UNIQUE constraint matching keys for > > table 'xxx' not found - any clues? > > It would be helpful to see the *exact* wording of the error message and > the SQL statements that can be used to reproduce the error. ok, got it now - the key in question was a 'serial' key. in older versions of postgres, since serial keys are anyway unique, apparently we could get away with not explicitly giving an unique constraint - sigh, a lot of work lies ahead ... -- regards kg
http://www.ootygolfclub.org poor man's tally: http://avsap.sourceforge.net ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
