On Fri, May 31, 2013 at 6:36 PM, Joshua Boshi <joshuaboshi@gmail.com> wrote: > 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.
PostgreSQL doesn't keep track of multi vs. single dimensional array declarations, as array types are undimensioned anyway. You'll see the same in psql:
postgres=# CREATE TABLE test (
id serial NOT NULL, test character varying(150)[][], PRIMARY KEY (id) ) WITH ( OIDS = FALSE );
NOTICE: CREATE TABLE will create implicit sequence "test_id_seq" for serial column "test.id" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "test_pkey" for table "test" CREATE TABLE postgres=# \d test
Table "public.test" Column | Type | Modifiers --------+--------------------------+--------------------------------------------------- id | integer | not null default nextval('test_id_seq'::regclass) test | character varying(150)[] | Indexes: "test_pkey" PRIMARY KEY, btree (id)
