Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: SQL display of inheriting tables wrong



Peter Eisentraut wrote:
The SQL visualization of tables that inherit from another table is wrong in pgAdmin. You can check that with the table "emp" in the regression test database. The actual definition (as produced by pg_dump) is this:

CREATE TABLE emp (
    name text,
    age integer,
    "location" point,
    salary integer,
    manager name
)
INHERITS (person);

which is not the same we started out with.

I'm not exactly sure what is going on here, but it's confusing.

The columns are probably overloaded.
The table code didn't obey the column's inherit flag, fixed in SVN for HEAD and 1.4, thanks for reporting.

We didn't catch trying to edit an inherited column from the table dialog; corrected now too.

Regards,
Andreas




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group