Received: from argh.demon.co.uk (grim@argh.demon.co.uk [193.237.6.55]) by hub.org (8.8.8/8.7.5) with ESMTP id NAA29897 for ; Thu, 11 Jun 1998 13:50:00 -0400 (EDT) Received: (from grim@localhost) by argh.demon.co.uk (8.8.7/8.8.7) id SAA02055 for pgsql-sql@postgreSQL.org; Thu, 11 Jun 1998 18:46:07 +0100 From: M Simms Message-Id: <199806111746.SAA02055@argh.demon.co.uk> Subject: sequence problems To: pgsql-sql@postgreSQL.org Date: Thu, 11 Jun 1998 18:46:05 +0100 (BST) Content-Type: text OK, this is my third attempt to post, lets see if maybee this one goes through I am trying to incriment values in a table. Fair enough, should be easy. I have read the manpage for create_sequence, but it doesnt seem to do what I want it to. I will be using a large database, maybee 50,000 instances of a table, and from the documentation it seems I have to create a sequence, with a separate identity for every instance of the table if I want to incriment values in it. Or am I wrong. All I want to be able to do is to incriment 2 different numbers at will within a whole lot of instances of a table. If I have to craete a sequence for EVERY table, that will become WAY too cumbersome to use. Thanx