0005325: Not able to use PDO with postgres

(0006127)
nam
12-28-12 00:05

How are you using it? I am able to use PDO with postgres:

<?php

$dsn = "pgsql:dbname=test;user=caucho;password=caucho";

$pdo = new PDO($dsn);

$sql = "SELECT (TIMESTAMP '2012-12-04' - TIMESTAMP '2012-12-02')::interval AS x";
$stmt = $pdo->prepare($sql);

var_dump($stmt->execute());
var_dump($stmt->errorInfo());
var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));

?>

(0006133)
publicocean0
12-30-12 03:26

Try to pass alo the port of the postgres server in the your example :)

(0006134)
nam
12-01-12 16:06

php/1s79
php/1s7a

Thanks for pointing that out :). I just committed a fix into our repository.

Issue History
Date Modified	Username	Field	Change
12-27-12 13:07	publicocean0	New Issue
12-28-12 00:05	nam	Note Added: 0006127
12-30-12 03:26	publicocean0	Note Added: 0006133
12-01-12 16:05	nam	Status	new => assigned
12-01-12 16:05	nam	Assigned To	=> nam
12-01-12 16:06	nam	Status	assigned => closed
12-01-12 16:06	nam	Note Added: 0006134
12-01-12 16:06	nam	Resolution	open => fixed
12-01-12 16:06	nam	Fixed in Version	=> 4.0.34

Notes
(0006127) nam 12-28-12 00:05	How are you using it? I am able to use PDO with postgres: <?php $dsn = "pgsql:dbname=test;user=caucho;password=caucho"; $pdo = new PDO($dsn); $sql = "SELECT (TIMESTAMP '2012-12-04' - TIMESTAMP '2012-12-02')::interval AS x"; $stmt = $pdo->prepare($sql); var_dump($stmt->execute()); var_dump($stmt->errorInfo()); var_dump($stmt->fetchAll(PDO::FETCH_ASSOC)); ?>

(0006133) publicocean0 12-30-12 03:26	Try to pass alo the port of the postgres server in the your example :)

(0006134) nam 12-01-12 16:06	php/1s79 php/1s7a Thanks for pointing that out :). I just committed a fix into our repository.

Relationships