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