Received: from erm1.u-strasbg.fr (erm1.u-strasbg.fr [130.79.74.61]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eB4NAoG56779 for ; Mon, 4 Dec 2000 18:10:51 -0500 (EST) (envelope-from bboett@erm1.u-strasbg.fr) Received: (qmail 1745 invoked by uid 501); 4 Dec 2000 23:30:34 -0000 Date: Tue, 5 Dec 2000 00:30:34 +0100 From: Bruno Boettcher To: pgsql-sql@postgresql.org Subject: reinitialize a sequence? Message-ID: <20001205003034.D31987@erm1.u-strasbg.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.0.1i X-Archive-Number: 200012/27 X-Sequence-Number: 358 hello, played a bit around with the serial type.... wanted to adapt my already existing tables to this system... dumped the DB, created the new tables, loaded old data in.... all works, until i try to insert something without specifying the id field (that's the now sequential field). And the reason is that the sequene is set to 1..... is there a simple way to tell all sequences to take the max value +1 of their respective tables? (a bit like the vacuum command?) i tryed to set the value by hand, but did something wrong :D the command didn't completed: fibu=> update journal_id_seq set last_value=1187; ERROR: You can't change sequence relation journal_id_seq surely something real stupid again, but i never used sequences till now... and there's no example in the docu.... (BTW would be nice if this was addressed in the documentation) -- ciao bboett ============================================================== bboett@earthling.net http://inforezo.u-strasbg.fr/~bboett http://erm1.u-strasbg.fr/~bboett =============================================================== the total amount of intelligence on earth is constant. human population is growing....