PostgreSQL

[GoogleCodeExporter]

This code won't work width postgresql db's

$selectZendDb->columns ( array ('TOTAL' => new Zend_Db_Expr ( "COUNT(*)" ) ) );

Original issue reported on code.google.com by pao.fre...@gmail.com on 16 Jan 2010 at 3:23

[GoogleCodeExporter]

hallo,

Just to add a comment which can maybe help about zfdatagrod and PostgreSQL, I 
tested
it today and on PostgreSQL it's work, in the begin, only datas were show and if 
I
clicked on a header column (to order by a column), I received an error message,
needed to add column name in group by or in agregate function (sorry if it's 
not the
good translation, but I'm french and my english is a little ropey)

I just added 1 line to see order and filter works on PostgreSQL:

in file DataGrid.php, found: (+- line 2767)
$selectZendDb->reset ( Zend_Db_Select::COLUMNS );
$selectZendDb->reset ( Zend_Db_Select::GROUP );

write just after:
$selectZendDb->reset ( Zend_Db_Select::ORDER);

so the part of the code become:
$selectZendDb->reset ( Zend_Db_Select::COLUMNS );
$selectZendDb->reset ( Zend_Db_Select::GROUP );
$selectZendDb->reset ( Zend_Db_Select::ORDER);

$selectZendDb->columns ( array ('TOTAL' => new Zend_Db_Expr ( "COUNT(*)" ) ) );
$stmt = $selectZendDb->query();
[...]
some warning about table index, but for me it's work, so I hope it'll work for 
people
who use ZFdatagrid with PostgreSQL

tested on OpenBSD 4.5, Apache 1.3.29, php5.2.10, pdo_pgsql, ZF 1.9.7 and 
PostgreSQL
8.3.7 and the last version of Zfdatagrid and with only 1 table (not tested with 
more
table join)

have a nice day

Original comment by lve...@gmail.com on 25 Jan 2010 at 7:56

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

Original comment by pao.fre...@gmail.com on 22 Feb 2010 at 2:19

• Changed state: Fixed
• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

Original comment by bento.vi...@gmail.com on 3 Mar 2010 at 4:56

• Added labels: ****
• Removed labels: ****