"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
, 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
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...
--
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-