Re: [HACKERS] last built-in oid

2000-11-23 Thread Tom Lane
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > Ah. What about in 7.0.3 and below? There is no good way --- if there were, we'd not have bothered to invent datlastsysoid. pg_dump used to use the OID of the template1 database as an estimate of the last built-in OID. This was wrong to be

RE: [HACKERS] last built-in oid

2000-11-23 Thread Christopher Kings-Lynne
, 2000 11:47 AM > To: Christopher Kings-Lynne; Pgsql-Hackers > Subject: Re: [HACKERS] last built-in oid > > > At 11:27 24/11/00 +0800, Christopher Kings-Lynne wrote: > > > >SELECT datlastsysoid from pg_database where datname = 'dbname' > > > >But as

Re: [HACKERS] last built-in oid

2000-11-23 Thread Philip Warner
At 11:27 24/11/00 +0800, Christopher Kings-Lynne wrote: > >SELECT datlastsysoid from pg_database where datname = 'dbname' > >But as far as I can tell, the datlastsysoid field does not exist in >pg_database. > If you build from CVS and do an initdb, you will find datlastsysoid should exist... --

[HACKERS] last built-in oid

2000-11-23 Thread Christopher Kings-Lynne
Hi, What is the current way of getting the last built-in oid? I looked at the source of pg_dump, and it does this: SELECT datlastsysoid from pg_database where datname = 'dbname' But as far as I can tell, the datlastsysoid field does not exist in pg_database. What gives? -- Christopher Kings-