Postgres Dev.

Postgres Internals Notes

Current Efforts

• Declaration of RelationGetRelationNamespace:

postgresql-8.3.7/src/include/utils/rel.h

RelationGetNamespace

There's a member variable: relnamespace in Form_pg_class data type. It is of type id0, potentially representing a unique namespace identifier. I just replaced the appearance of RelationGetRelationName(relation) with RelationGetNamespace(relation) and am waiting on the test enviroment to see whether this function returns the id number of the namespace (schema) in our simple example, this should refer to the public namespace.

• Error "violates foreign key constraint:

postgresql-8.3.7/src/backend/utils/adt/ri_triggers.c:

Test Environment

We are currently creating a test environment on db-devel.cs.earlham.edu where a query causes a foreign key constraint. I created a simpler case, with a single relation. When I query

SELECT * FROM (wrong relation name)

An error gets returned, and only the relation name is reported. Our fix plans to address this case, however searching for error messages containing "does not exist" yielded too many result to be useful.

I was able to locate the error messages generated by foreign key constraints. They come from one file, called ri_triggers.c

I am currently creating a test enviroment where we can reproduce this error, and hopefully change the contents of the error message.

Open Questions

• What's the difference between a tablespace and a namespace?
• Is there a way to take a namespace identifier and get a namespace object? It seems like once we can find the namespace lookup function, extracting the name will be trivial.