Home » Database » DB_DataObject » Bug #413
Postgresql & interval column type
Details
| Submitted | 2003-12-12 14:47 UTC |
|---|---|
| From | admin at dying dot art dot pl |
| Assigned | alan_k |
| Status | Closed |
| Package | DB_DataObject |
| PHP Version | 4.3.3 |
| OS | Linux Debian |
| Roadmaps | (Not assigned) |
Comments
[2003-12-12 14:47 UTC] admin at dying dot art dot pl
Description:
------------
I have a table (postgresql database) with the column type 'interval'
In the auto-generated database schema (db_name.ini) I found, that it is marked as integer field type (1). As it is not an integer, the query fails because of not quoted (and bad represented) value.
Changing the type in the db schema from 1 to 2 solves the problem