Re: [PHP-DB] PHP5 + Postgres 8.0.0 + pg_transaction_status

2005-07-05 Thread Martín Marqués
source and php 5.0.4 also from source. Update PostgreSQL to the latest 8.0.x version (lots of bugs were fixed since). -- 09:33:15 up 2 days, 18:18, 1 user, load average: 0.83, 0.70, 0.63 - Lic. Martín Marqués | select

Re: [PHP-DB] Postgre SQL query error with PHP

2005-07-02 Thread Martín Marqués
personally think he should start here: http://pear.php.net/manual/en/package.database.db.php -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; - Martín Marqués | Programador, DBA Centro de Telemática| Administrador

Re: [PHP-DB] show tables

2005-06-28 Thread Martín Marqués
- Martín Marqués| select 'mmarques' || '@' || 'unl.edu.ar' Centro de Telematica | DBA, Programador, Administrador Universidad Nacional del Litoral - -- PHP Database Mailing List (http

Re: [PHP-DB] Re: PostgreSQL error with PHP

2005-06-27 Thread Martín Marqués
; - Martín Marqués | Programador, DBA Centro de Telemática| Administrador Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] PostgreSQL 7.2 - 8.0 replication issue

2005-06-27 Thread Martín Marqués
thing, giving the case that he's using Linux, is to use scp. -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; - Martín Marqués | Programador, DBA Centro de Telemática| Administrador Universidad Nacional

Re: [PHP-DB] PostgreSQL 7.2 - 8.0 replication issue

2005-06-27 Thread Martín Marqués
Never used pg_restore. I just do this: $ psql -f db.out Always worked for me. -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; - Martín Marqués | Programador, DBA Centro de Telemática| Administrador

Re: [PHP-DB] Efficient way to count rows when using GROUP BY

2005-06-26 Thread Martín Marqués
; - Martín Marqués | Programador, DBA Centro de Telemática| Administrador Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] GROUP BY with a string column

2001-11-28 Thread Martín Marqués
about obtain the same behaviour, when column2 contains strings (and SUM is string concatenation)? With which database engine? -- Porqué usar una base de datos relacional cualquiera, si podés usar PostgreSQL? - Martín Marqués