Postgres Pro
Downloads
Home   >   mailing lists

Re: Schema and Namespace Oid confusion - Mailing list pgsql-admin

From Tom Lane
Subject Re: Schema and Namespace Oid confusion
Date
Msg-id 22060.1546011582@sss.pgh.pa.us
Whole thread Raw
In response to Schema and Namespace Oid confusion  (ZongtianHou <zongtianhou@icloud.com>)
List pgsql-admin
Tree view 
ZongtianHou <zongtianhou@icloud.com> writes:
> First, what is the difference between namespace and schema?

None.

> Second, why the Oid of public namespace is 2200, the same between databases? Does oid is unique for every object
acrosscluster?  

CREATE DATABASE physically clones the template database, so all objects
have the same OIDs they had in the template.  OID uniqueness is only
expected for objects within one database (and even then, only across
objects in the same system catalog), not across the whole cluster.

            regards, tom lane

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Schema and Namespace Oid confusion
Next
From: ZongtianHou
Date:
Subject: Re: Schema and Namespace Oid confusion