[Bug] Postgres column types broken in 220.127.116.1176
Now, I see varchar fields simply listed as 'CHAR', with no length set.
Bonus bug: Heidi doesn't yet recognize column types of 'uuid' either.
CREATE TABLE test_char_types ( id character varying(60) NOT NULL, name character varying(128) NOT NULL, country_code character varying(6) NOT NULL, locale character varying(6) NOT NULL, targeting_type character varying(32) NOT NULL, CONSTRAINT test_pkey PRIMARY KEY (id) ) WITH ( OIDS=FALSE, autovacuum_enabled=true );
But once created, i fyou look at the table details, all fields show "CHAR".
PostgreSQL: Let longer data type matches win over shorter ones, in TDBConnection.GetDatatypeByName. Important e.g. for CHARACTER and CHARACTER VARYING. See http://www.heidisql.com/forum.php?t=17061
Please login to leave a reply, or register at first.