Thread: running out of oids

Am I correct in assuming that the 'running out of oids' issue was
resolved with a design change within Postgresql?

--
Until later, Geoffrey

"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson

On Wed, Aug 3, 2011 at 2:41 PM, Geoffrey Myers
<lists@serioustechnology.com> wrote:
> Am I correct in assuming that the 'running out of oids' issue was resolved
> with a design change within Postgresql?

not exactly -- for quite some time now the use of oids in user tables
has been discouraged.  The right way to deal with this problem is not
to use oids at all.

merlin

Merlin Moncure wrote:
> On Wed, Aug 3, 2011 at 2:41 PM, Geoffrey Myers
> <lists@serioustechnology.com> wrote:
>> Am I correct in assuming that the 'running out of oids' issue was resolved
>> with a design change within Postgresql?
>
> not exactly -- for quite some time now the use of oids in user tables
> has been discouraged.  The right way to deal with this problem is not
> to use oids at all.
>
> merlin

Thanks.

--
Until later, Geoffrey

"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson

On 08/03/2011 12:41 PM, Geoffrey Myers wrote:
> Am I correct in assuming that the 'running out of oids' issue was
> resolved with a design change within Postgresql?

Yes, many, many, many years ago. The only way to encounter the problem
now is through user error, e.g; don't use WITH OIDS when creating a table.

Joshua D. Drake

>


--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference - http://www.postgresqlconference.org/
@cmdpromptinc - @postgresconf - 509-416-6579

On Wednesday, August 03, 2011 04:24:32 PM Joshua D. Drake wrote:

> On 08/03/2011 12:41 PM, Geoffrey Myers wrote:

> > Am I correct in assuming that the 'running out of oids' issue was

> > resolved with a design change within Postgresql?

>

> Yes, many, many, many years ago. The only way to encounter the problem

> now is through user error, e.g; don't use WITH OIDS when creating a table.

>

> Joshua D. Drake

Great! Geoff works with me and we don't use OIDs at all.

--

The Tuckers

Home: 336-372-5432