If PostgreSQL failed to compile on your computer or you found a bug that
is likely to be specific to one platform then please fill out this form
and e-mail it to pgsql-ports@postgresql.org.

To report any other bug, fill out the form below and e-mail it to
pgsql-bugs@postgresql.org.

If you not only found the problem but solved it and generated a patch
then e-mail it to pgsql-patches@postgresql.org instead.  Please use the
command "diff -c" to generate the patch.

You may also enter a bug report at http://www.postgresql.org/ instead of
e-mail-ing this form.

============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name		:	Bernie Huang
Your email address	:	Bernie.Huang@ec.gc.ca


System Configuration
---------------------
  Architecture (example: Intel Pentium)  	:	Intel PIII

  Operating System (example: Linux 2.0.26 ELF) 	:	RH Linux 6.2

  PostgreSQL version (example: PostgreSQL-6.5.1):	PostgreSQL-7.0

  Compiler used (example:  gcc 2.8.0)		:	Don't know


Please enter a FULL description of your problem:
------------------------------------------------
When you inherit table B from table A, the primary key in A won't be
inherited to B, but only the columns.

I was wondering how do you inherit a primary key or, even, a foreign
key?  If it's not possible, what are the ways going around it?  (not
null index or...???)

Thanks for your help!

- Bernie


Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible: 
----------------------------------------------------------------------
CREATE TABLE parent (
  col1 INT4 PRIMARY KEY,
  col2 text);

CREATE TABLE child (
  col3 text) inherits (parent);

CREATE TABLE foreign_to_child (
  col1 INT4,
  FOREIGN KEY (col1) REFERENCES child
    ON UPDATE CASCADE
    ON DELETE SET NULL);


If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
I tried using not null index on the column that's supposed to be the
primary key in the child table, but failed to work.