From: | Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz> |
---|---|
To: | Julian North <jnorth(at)lastminute(dot)com> |
Cc: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Modelling Oracle Sequences |
Date: | 2003-11-21 09:42:15 |
Message-ID: | Pine.LNX.4.44.0311211039560.28005-100000@kix.fsv.cvut.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello
why can't use normal sequence? There isn't difference betwen Oracle and
PostgreSQL?
http://www.postgresql.org/docs/7.3/static/sql-createsequence.html
regards
Pavel
On Fri, 21 Nov 2003, Julian North wrote:
> Hi,
>
> I am in the process of porting a number of large MSSQL databases to
> Postgres.
>
> The current id generation model in SQL server is an oracle style sequence
> generator i wrote using a pretty simple stored proc and table structure.
>
> I now need to do the same thnig in postgres.
>
> In MSSQL I was able to open an UPDATE cursor, which places a lock on the row
> in the sequence table. I then update, release and return.
>
> Has anyone done something similar or have any pointers on how to do this
> safely, securely without an update cursor?
>
> Any infor appreciated.
>
> Cheers,
>
>
>
> Julian.
>
> ________________________________________________________________________
> This e-mail has been scanned for all viruses by Star Internet. The
> service is powered by MessageLabs. For more information on a proactive
> anti-virus service working around the clock, around the globe, visit:
> http://www.star.net.uk
> ________________________________________________________________________
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
From | Date | Subject | |
---|---|---|---|
Next Message | rob | 2003-11-21 09:43:53 | Re: PGSQL on shared hosting |
Previous Message | Holger Klawitter | 2003-11-21 09:41:07 | Re: PGSQL on shared hosting |