Re: SQL display of inheriting tables wrong

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: SQL display of inheriting tables wrong
Date: 2006-01-31 12:30:08
Message-ID: 43DF5850.2070803@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

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

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2006-01-31 12:45:43 Re: Patch: Query favourites
Previous Message svn 2006-01-31 12:28:45 SVN Commit by andreas: r4981 - in branches/REL-1_4_0_PATCHES/pgadmin3/src: dlg schema