Re: [GENERAL] Some MySQL features - Mailing list pgsql-general

From Ed Loehr
Subject Re: [GENERAL] Some MySQL features
Date
Msg-id 384846E1.B503C120@austin.rr.com
Whole thread Raw
In response to Some MySQL features  ("vincent leycuras" <lv68@hotmail.com>)
List pgsql-general
"Aaron J. Seigo" wrote:

> > This is a question that could be an answer.  What do y'all think about
> > using the OID to get the same functionality (unless he really needs a
> > sequence of nice small numbers)?
>
> OIDs don't survive dump/reloads and sequences already provide this
> functionality, surviving dump/reloads

The postgres SERIAL type, which is a sequence, is fairly well-suited to
primary key usage.  See PG documentation for details...

Cheers.
Ed Loehr


pgsql-general by date:

Previous
From: Jesse Kipp
Date:
Subject: Re: [GENERAL] All writes make postgresql a slow database?
Next
From: Peter Eisentraut
Date:
Subject: Re: [GENERAL] Date & Time