Re: [PHP-DB] local queries vs remote queries

2006-09-20 Thread Chris
Stuart Kendrick wrote: hi chris, right. if i run 'psql -d soma' and then type the first SELECT, i get results ... if i type the second SELECT, i get zero rows. this seemed odd to me ... i wouldn't think that postgres would care. but perhaps it does hmm. ok, i just tried this again ...

Re: [PHP-DB] local queries vs remote queries

2006-09-19 Thread Stuart Kendrick
hi chris, right. if i run 'psql -d soma' and then type the first SELECT, i get results ... if i type the second SELECT, i get zero rows. this seemed odd to me ... i wouldn't think that postgres would care. but perhaps it does hmm. ok, i just tried this again ... and now i'm getting

Re: [PHP-DB] local queries vs remote queries

2006-09-18 Thread Chris
Stuart Kendrick wrote: hi, i'm looking for trouble-shooting pointers, particularly around how to debug query results on one host, i have a PHP reporting tool querying a PostGres back-end. Recently (i must have changed something ... but ... i don't remember even logging into this box recently,

[PHP-DB] local queries vs remote queries

2006-09-14 Thread Stuart Kendrick
hi, i'm looking for trouble-shooting pointers, particularly around how to debug query results on one host, i have a PHP reporting tool querying a PostGres back-end. Recently (i must have changed something ... but ... i don't remember even logging into this box recently, let alone changing

[PHP-DB] local queries vs remote queries

2006-09-13 Thread Stuart Kendrick
hi, i'm looking for trouble-shooting pointers, particularly around how to debug query results on one host, i have a PHP reporting tool querying a PostGres back-end. Recently (i must have changed something ... but ... i don't remember even logging into this box recently, let alone changing