Incomplete PostgreSQL Adapter

[vaibhav]

When using the PostgreSQL (currently version 8.4.8) with QCubed, I found that the database reports an error as below.

PostgreSql? Error: Unsupported Field Type: timestamp with time zone

I looked into the code in includes/qcubed/_core/database/QPostgreSqlDatabase.class.php and found that it was actually not supported, indeed.

Since PostgreSQL is one of the MAJOR open source databases and supports the 'timestamp with time zone' datatype, here is the patched file.

The patch is actually of only two lines (one line code, another comment). The lines are 672, 673.

[vaibhav]

The file with the patch. The line number 672 is the modified line.

[vaibhav]

Here is how the error looks without the patch I applied : <a href=" http://tinypic.com?ref=2vvw8w6" target="_blank"><img src=" http://i56.tinypic.com/2vvw8w6.png" border="0" alt="Image and video hosting by TinyPic?"></a>

[VexedPanda]

Please create a .patch file for review.

[vakopian]

the fix as patch

[vakopian]

(In [1326]) Fixes #738