Bug: Little mistake in comment in inheriting table

From: Vojtěch Látal <vojtech(at)latal(dot)name>
To: pgadmin-support(at)postgresql(dot)org
Subject: Bug: Little mistake in comment in inheriting table
Date: 2010-11-11 18:53:08
Message-ID: AANLkTin2kHbaLXMnNKsVmZqDD9bwOP4wWF2ARE_nd7kk@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,
just a little thing: I wanted to try inheriting. So I made a table
"del" which inherits from table "vehicles".

Create script follows:
-- Table: del

-- DROP TABLE del;

CREATE TABLE del
(
-- Inherited from table del: id integer NOT NULL DEFAULT
nextval('vehicle_id_seq'::regclass),
-- Inherited from table del: vin character varying(20) NOT NULL,
-- Inherited from table del: licence_plate character varying(12) NOT NULL,
a boolean
)
INHERITS (vehicles)
WITH (
OIDS=FALSE
);
ALTER TABLE del OWNER TO gary;

It seems it should be "-- Inherited from table vehicles:" instead of
current "-- Inherited from table del:".

Version: 1.12.1 from Community repo
OS: ArchLinux, kernel 2.6.35
PostgreSQL: 9.0.1

Steps to reproduce:
1) (create database,) create table, put some columns into.
2) create another table from contextual menu, select "New Table..."
3) "New Table..." dialog opens, put some table name in, open "Inherits" tab
4) select table you created in 1), click Add
5) select "Columns" tab, add some column
6) create table by clicking "OK"
7) select newly created table from step 6) and in SQL pane you'll see
what I've included.

Thanks guys for huge piece of good work. I really appreciate what you are doing.

Regards
Vojtěch Látal

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Kevin Field 2010-11-11 19:25:17 Re: Is pl/pgsql debugging broken in PostgreSQL 9.0, or is it just me?
Previous Message Elizondo Julio César 2010-11-11 16:32:08 Re: copy