Re: [SQL] unique constraints

2004-01-07 Thread Kenneth Gonsalves
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

Re: [SQL] unique constraints

2004-01-07 Thread Michael Fuhr
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 reprod

[SQL] unique constraints

2004-01-07 Thread Kenneth Gonsalves
in 7.4 i'm getting an error message - UNIQUE constraint matching keys for table 'xxx' not found - any clues? -- regards kg http://www.ootygolfclub.org poor man's tally: http://avsap.sourceforge.net ---(end of broadcast)--- TIP 9: the planner will

Re: [SQL] Unique constraints for a list

2003-08-29 Thread Richard Huxton
On Friday 29 August 2003 06:50, Anuradha Ratnaweera wrote: [snipped description of groups consisting of unique lists of members, i.e. group A contains (1,2,3) so B can't contain the same] I was looking at something almost identical a few days ago. > Then we added a unique string field to t3 whic

[SQL] Unique constraints for a list

2003-08-29 Thread Anuradha Ratnaweera
Hi all, o We have a table t1 which has a primary key id and other fields. (say, 10 rows with ids 1 to 10). o We need to group rows (unordered, and arbritrary size) in t1 and assign a unique id to each group. (e.g.: {1, 3, 4} is group 1, {1, 5} is group 2 etc.) o A group shouldn't change