[Catalyst] Catalyst and Oracle

[Simon Miner]

Is PostgresSQL's "serial" like MySQL's "auto increment".  If so, I don't
believe Oracle supports this.  It uses sequence objects instead.

-----Original Message-----
From: Philip Edelbrock [mailto:phil at edgedesign.us] 
Sent: Monday, August 15, 2005 2:20 PM
To: Simon Miner
Cc: The elegant MVC web framework
Subject: Re: [Catalyst] Catalyst and Oracle



Simon Miner wrote:
> 
>     * Created a table called "page" in Oracle with the same structure
as
>       the SqlLite version in the article.

If it's like PostgreSQL, you need to make the primary key column a 
'serial' instead of, say, integer (which SQLite seems to like).


Phil