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

SQL display of inheriting tables wrong

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: SQL display of inheriting tables wrong
Date: 2006-01-31 11:47:28
Message-ID: 200601311247.29311.peter_e@gmx.net (view raw or flat)
Thread:
Lists: pgadmin-hackers
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 person (
    name text,
    age integer,
    "location" point
);

CREATE TABLE emp (
    salary integer,
    manager name
)
INHERITS (person);


pgAdmin produces this:

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

While this also works (the common columns are merged), executing this and 
redumping it with pg_dump produces 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.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

Responses

pgadmin-hackers by date

Next:From: Dave PageDate: 2006-01-31 12:05:51
Subject: Re: Patch: Query favourites
Previous:From: Andreas PflugDate: 2006-01-31 11:33:20
Subject: Re: Data type display

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group