Postgre Adapter: better handling of timestamps

[marcosdsanchez]

I have patched the Postgresql adapter with this features:

- multiples schemas (thanks to disaster in the Qcodo forums)
- added new "interval" type (thanks krusty in the Qcodo forums)

[marcosdsanchez]

new patch

[alex94040]

Can somene who uses Postgre code-review and test this, please?

[alex94040]

I've looked for a person with Postgre for a while to test this, but lo and behold, we can't find one. Well, that's fine. I've looked at the code, it seems clean; the amount of changes is small, so I suggest we check this in and allow the community to chip in if there are issues.

[basilieus]

- current_schemas: If you have two postgresql databases you are using and they both share a table name I think the ANY(current_schemas(false)) will return all of the indexes from both tables. I think this is why the current_schema() was used. I will test on my box at home. It has postgresql.

- Interval type: looks fine

- Timestamp looks fine, is varchar the best way to handle it?

[VexedPanda]

Split into #171 for timestamp issues to be resolved in RC1 and this ticket for remaining issues.

[alex94040]

We need someone with Postgre experience to test this. That someone is not me :-).

[tompalan]

I would be able to test postgres-patches. I think there is something wrong with the patch in ticket:171, as I had to revert it to get the postgres-adapter running correctly. Feel free to contact me about any postgres-stuff.

Tom

[bithead]

This patch is ok, but incomplete. As an extension of this, the QApplicationBase::InitializeDatabaseConnections?()

$objConfigArray would have to be extended with a parameter for "Schema". This parameter would be passed down to QDatabaseBase and then to QPostgreSqlDatabase, where Query("SET search_path TO $objschema" ) would be issued after pg_connect.

Issues:
No other database connectors support the concept of schemas fully. This parameter is only valid for QPostgreSql.

Patch file for QApplicationBase.class.php, QDatabaseBase.class.php and QPostgreSqlDatabase.class.php with cumulative support patch for schemas will be attached.

[bithead]

Additions to QPostgreSqlDatabase, QDatabaseBase, QApplicationBase

[bithead]

bug fix patch to QPostgresqlDatabase.class.php

[alex94040]

We need someone with Postgre to review this. Anyone?