Re: [GENERAL] Some MySQL features

From: Ed Loehr <ELOEHR(at)austin(dot)rr(dot)com>
To: keithmur(at)mindspring(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Some MySQL features
Date: 1999-12-03 22:40:33
Message-ID: 384846E1.B503C120@austin.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message V Krishnaraj 1999-12-04 00:42:30 Urgent - unable to get postgres up
Previous Message Jesse Kipp 1999-12-03 22:21:33 Re: [GENERAL] All writes make postgresql a slow database?