Difference between revisions of "Postgres Dev."

From Earlham CS Department
Jump to navigation Jump to search
(New page: == Postgres Internals Notes== *Declaration of RelationGetRelationNamespace: <pre><nowiki> postgresql-8.3.7/src/include/utils/rel.h </pre></nowiki> ** RelationGetNamespace *** There's...)
 
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 20:15, 13 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