Joseph Kiniry <kiniry@xxxxxxx> writes:
> I'm currently blocked on the system catalog schema "pg_catalog";
> whence is it initialized?
That row in pg_namespace is missing, you mean? That's very odd ... what
rows do you see in pg_namespace? That should be loaded as part of the
basic bootstrap operation, and if basic bootstrap had failed you'd
definitely not have failed to notice ;-)
> I have looked though all initdb-related
> scripts, SQL files, and BKI files and have found several references to
> pg_catalog, but I have not found its definition/initialization.
The definition/initialization is basically driven from macros in
src/include/catalog/pg_namespace.h; in particular all the rows defined
by DATA macros in that file should have been created during bootstrap.
You might look in the .bki file to verify that there is a section
creating and loading pg_namespace.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
