[vox-tech] Postgres Oracle Compatibility - serial column type

Eric Engelhard vox-tech@lists.lugod.org
Fri, 25 Jan 2002 11:13:38 -0800


Keywords: postgres, oracle, RDBMS computability issues

I'm trying to anticipate scripting computability issues for Postgres and
Oracle. I have already migrated from Perl Pg to Perl DBI, but there are
also RDBMS function issues to consider. Does anyone know whether Oracle
has a data (column) type equivalent to Postgres SERIAL, or does one have
to create a sequence and use nextval()/currval()/setval()?

--
Eric Engelhard