pgAdmin III Issues when creating tables

From: "Donald Fraser" <demolish(at)cwgsy(dot)net>
To: "[pgADMIN]" <pgadmin-support(at)postgresql(dot)org>
Subject: pgAdmin III Issues when creating tables
Date: 2003-07-07 15:28:18
Message-ID: 00a501c3449c$67159340$1664a8c0@DEMOLITION
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

pgAdmin III Version 0.1.1 Devel (Jul 3 2003)

A few minor issues when creating a table via pgAdmin III

1) Using the dialog via menu "New Object->New Table" to create a table always sets "Has OIDs" to true, even though you specify it to be not true.

2) Object type "serial8" (or "bigserial") no longer exists as a data type to select.

3) When specifying timestamp, it is not possible to set the precision or whether you do not want time zones e.g. timestamp (0) without time zone.

4) The SQL definition when creating a table probably should not be editable if it is not going to be used by pgAdmin III to create the table. I tried overriding or modifying the SQL here to get the correct definition for timestamp and it ignored my modifications.

5) When viewing the column SQL definitions for a particular column, there is always a line that contains a column name "pgadmin_tmpcol" which obviously doesn't exist. Should this be part of the definition?

For example a column named "id" has the following:

-- ALTER TABLE public.id DROP COLUMN id

ALTER TABLE public.tbl_test ADD COLUMN id int4;
ALTER TABLE public.tbl_test ALTER COLUMN pgadmin_tmpcol SET STORAGE PLAIN;

6) This one may be something to do with 5). The property named "Storage" is listed twice in the main window when viewing a column.

Regards
Donald Fraser

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Andreas Pflug 2003-07-07 17:29:08 Re: pgAdmin III Issues when creating tables
Previous Message Donald Fraser 2003-07-07 07:37:46 Re: pgAdmin III - No security privileges shown for Groups