Re: [GENERAL] Modelling Oracle Sequences

2003-11-21 Thread Shridhar Daithankar
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

Re: [GENERAL] Modelling Oracle Sequences

2003-11-21 Thread Julian North
]' Subject: Re: [GENERAL] Modelling Oracle Sequences 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,

Re: [GENERAL] Modelling Oracle Sequences

2003-11-21 Thread Pavel Stehule
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

[GENERAL] Modelling Oracle Sequences

2003-11-21 Thread Julian North
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 t