Bug #3852

MDB2_Tools_Manager text field with defaults in PostgreSQL

Details

Submitted	2005-03-16 22:45 UTC
From	justinh at superglobals dot com
Assigned	lsmith
Status	Closed
Package	MDB2
PHP Version	5.0.3
Roadmaps	(Not assigned)

Comments

[2005-03-16 22:45 UTC] justinh at superglobals dot com

Description:
------------
When using MDB2_Tools_Manager to import an XML document for a database, <type>text</type> fields with <default>[...]</default> get converted to TIME instead of TEXT in the SQL statement.

Looks like the problem is in MDB2/Driver/Datatype/pgsql.php on line 122:
$default = isset($field['default']) ? ' DEFAULT TIME'.

Changing this to:
$default = isset($field['default']) ? ' DEFAULT'.

seemed to fix everything.

[2005-03-17 17:10 UTC] smith at backendmedia dot com

This bug has been fixed in CVS.

In case this was a documentation problem, the fix will show up at the
end of next Sunday (CET) on pear.php.net.

In case this was a pear.php.net website problem, the change will show
up on the website in short time.

Thank you for the report, and for helping us make PEAR better.