Postgres Dev.: Difference between revisions

From Earlham CS Department
Jump to navigation Jump to search
Purcebr (talk | contribs)
New page: == Postgres Internals Notes== *Declaration of RelationGetRelationNamespace: <pre><nowiki> postgresql-8.3.7/src/include/utils/rel.h </pre></nowiki> ** RelationGetNamespace *** There's...
 
Purcebr (talk | contribs)
No edit summary
Line 3: Line 3:
*Declaration of RelationGetRelationNamespace:
*Declaration of RelationGetRelationNamespace:


<pre><nowiki>
<pre>
postgresql-8.3.7/src/include/utils/rel.h
postgresql-8.3.7/src/include/utils/rel.h
</pre></nowiki>
</pre>
** RelationGetNamespace
** RelationGetNamespace
*** There's a member variable: relnamespace in Form_pg_class data type.
*** There's a member variable: relnamespace in Form_pg_class data type.
What type is that?
It is of type id0, potentially representing a unique namespace identifier.


*** What are it's member functions, and can we extract a char[] from this type representing the name of the namespace?
*** What are it's member functions, and can we extract a char[] from thistype representing the name of the namespace?


*What's the difference between a tablespace and a namespace?
*What's the difference between a tablespace and a namespace?


*Error "violates foreign key constraint:
*Error "violates foreign key constraint:
<pre><nowiki>
<pre>
postgresql-8.3.7/src/backend/utils/adt/ri_triggers.c:
postgresql-8.3.7/src/backend/utils/adt/ri_triggers.c:
</pre></nowiki>
</pre>
 
 
== Test Environment ==
 
== Open Questions ==

Revision as of 01:15, 14 April 2009

Postgres Internals Notes

  • 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.

      • What are it's member functions, and can we extract a char[] from thistype representing the name of the namespace?
  • What's the difference between a tablespace and a namespace?
  • Error "violates foreign key constraint:
postgresql-8.3.7/src/backend/utils/adt/ri_triggers.c:


Test Environment

Open Questions