Postgre not working

[eluser]doktorcivanim[/eluser]
Hi,

I am new to Code Ignitor.

I am working with PostgreSQL. When I set the configuration, the page that must be rendered, waits one second and then displayes nothing (also when looking at sources). The (db_)debug flag is set to true. When I use MySQL, I get errors when making them (bad syntax, authentication). So there must be something else. I have the php_pdo_pgsql driver and it worked in the Zend Framework.

My configuration:

Code:

$db['default']['hostname'] = "localhost";
$db['default']['username'] = "postgres";
$db['default']['password'] = "pass";
$db['default']['database'] = "public";
$db['default']['dbdriver'] = "postgre";
$db['default']['dbprefix'] = "";
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";
$db['default']['char_set'] = "utf8";//??
$db['default']['dbcollat'] = "utf8_general_ci";//??
$db['default']['port'] = 5432;

What can be wrong?

Thanks by advance.

EDIT: I have a header and footer, they also are not rendered.

[eluser]doktorcivanim[/eluser]
Ok, I see that it (8.3 is my version) has not yet a good supported: http://hasin.wordpress.com/2007/03/14/ig...e-igniter/

I'll stick with MySQL.

[eluser]bharata[/eluser]
hi,

why don't you use pgsql instead of pdo_pgsql, just enabling it in your php.ini, and for hand-craft query (without using active record) don't forget to add DB_NAME.TABLE_NAME instead of just TABLE_NAME for your query.