[GENERAL] 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] running out of oids
On Wed, Aug 3, 2011 at 2:41 PM, Geoffrey Myers li...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] running out of oids
Merlin Moncure wrote: On Wed, Aug 3, 2011 at 2:41 PM, Geoffrey Myers li...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] running out of oids
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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] running out of oids
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
