Postgres Domains don't work
Posted: 19.12.2005, 22:46
I have an application which uses Postgresql 8.0.3 as the backend. I have been using ZeosDbo 6.1.5 but thought I'd try install '6.5.1 alpha CVS as of 13/10/2005' version of ZeosLib.
Now when I try to connect one of the datasets I get 'Type mismatch for field 'location', expecting: String actual: Unknown.
The location field is defined as follows:
CREATE DOMAIN short_text_dom
AS varchar(250);
ALTER TABLE job_list ADD COLUMN "location" short_text_dom;
I'm assuming this problem is to do with the domain. Does anyone know what the problem is? It used to work without problems in 6.1.5.
Regards,
Ben.
Now when I try to connect one of the datasets I get 'Type mismatch for field 'location', expecting: String actual: Unknown.
The location field is defined as follows:
CREATE DOMAIN short_text_dom
AS varchar(250);
ALTER TABLE job_list ADD COLUMN "location" short_text_dom;
I'm assuming this problem is to do with the domain. Does anyone know what the problem is? It used to work without problems in 6.1.5.
Regards,
Ben.