Jebus scrisse in data 03/27/06 19:03:
I could be wrong but primary keys and other constraints are not inherited.
Thank you very much Jebus; in effect I've found in the mailing list
archives a 2003 thread "INHERITS and Foreign keys" that claim the same
problem. Someone (Stephan Szabo) answered saying that "At some point in
the future, that's likely to change"
(http://archives.postgresql.org/pgsql-sql/2003-12/msg00101.php). Now I'm
using postgres 7.4.7 and I've found the same problem; do you know if
this problem is solved in postgres 8.1?
Thank you very much
Piviul
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
