Re: Oracle to PGSQL -- need help

On Sun, 21 Jul 2002 13:02:43 +0900
Masaru Sugawara <rk73(at)sea(dot)plala(dot)or(dot)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