On Sun, 21 Jul 2002 13:02:43 +0900
Masaru Sugawara <rk73@sea.plala.or.jp> wrote:
> CREATE TABLE xeroxlogentries (q int4, jobid int4 UNIQUE);
> INSERT INTO xeroxlogentries VALUES(1,2);
> INSERT INTO xeroxlogentries VALUES(1,5);
> INSERT INTO xeroxlogentries VALUES(1,200);
> INSERT INTO xeroxlogentries VALUES(1,4356);
> INSERT INTO xeroxlogentries VALUES(1,483);
> INSERT INTO xeroxlogentries VALUES(3,10);
> INSERT INTO xeroxlogentries VALUES(2,6);
> INSERT INTO xeroxlogentries VALUES(2,3);
>
>
> CREATE SEQUENCE seq_n;
>
You probably use TEMP SEQUENCE so as not to be interfered with increasing
the number of seq_n by other sessions.
CREATE TEMP SEQUENCE seq_n;
Regards,
Masaru Sugawara