Bug #7792

Generator.php doesn't handle several postgresql array type columns

Details

Submitted	2006-06-02 09:26 UTC
From	antonio at c17 dot net
Assigned	alan_k
Status	Closed
Package	DB_DataObject
PHP Version	Irrelevant
OS	Debian Sarge 3.1
Roadmaps	(Not assigned)

Comments

[2006-06-02 09:26 UTC] antonio at c17 dot net

Description:
------------
I have a table (postgresql database) with the column types 'integer[]', 'boolean[]'
In the auto-generated database schema (db_name.ini) I found, that it is
marked as wrong field type because this array types are not correctly handled by Generator.php.

I write a workaround adding a default condition to switch clause:
switch (strtoupper($t->type)) {
.....
default :
$type = DB_DATAOBJECT_STR;
break;
}

[2006-09-02 22:02 UTC] antonio at c17 dot net

Maybe a too late answer, sorry... long holidays.

Yes, integer[], boolean[] and all other postgresql array types must be STR.