Hi,
I would like to report a bug on pgAdmin 1.16.1 installed on Ubuntu 13.04 from repository.
PgAdmin ignores multidimensional array types in it's outputs.
I defined a table using this command:
CREATE TABLE test (
id serial NOT NULL,
test character varying(150)[][],
PRIMARY KEY (id)
) WITH (
OIDS = FALSE
);
And when I selected the table in pgAdmin this was shown in the SQL pane:
-- Table: test
-- DROP TABLE test;
CREATE TABLE test
(
id serial NOT NULL,
test character varying(150)[],
CONSTRAINT test_pkey PRIMARY KEY (id)
)
WITH (
OIDS=FALSE
);
ALTER TABLE test
OWNER TO joshua;
I don't know if this is a known issue, but it confused me for a moment.
Regards,
Josh