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
|