Re: [GENERAL] visual query builder for Postgres?

2006-01-15 Thread Michael Schmidt
A Visual Query Builder is available in PG Lightning Admin. Michael Schmidt  

Re: [GENERAL] Drupal and postgreSQL

2006-01-15 Thread brew
On Sat, 14 Jan 2006, John DeSoi wrote: > > In the meantime.. can anybody around here shed any light on using > > the Drupal ecommerce module with postgreSQL? > > I have used parts of the module (primarily the address management) and > I did not find it difficult to port for PostgreSQL. It ap

[GENERAL] visual query builder for Postgres?

2006-01-15 Thread Zlatko Matić
Is there any visual tool for creating queries in PostgreSQL?   Zlatko

Re: [GENERAL] Apache::DBI and DBD::Pg

2006-01-15 Thread Jeremy Nixon
Tyler MacDonald <[EMAIL PROTECTED]> wrote: > [Fri Jan 13 23:46:28 2006] [error] [client 192.168.99.112] DBD::Pg::db > prepare_cached failed: FATAL: terminating connection due to administrator Here's the thing: if your database connection goes away, and Apache::DBI opens a new one, any prepared s

Re: [GENERAL] Apache::DBI and DBD::Pg

2006-01-15 Thread Tim Bunce
On Sun, Jan 15, 2006 at 02:00:15AM +, Jeremy Nixon wrote: > Tyler MacDonald <[EMAIL PROTECTED]> wrote: > > > [Fri Jan 13 23:46:28 2006] [error] [client 192.168.99.112] DBD::Pg::db > > prepare_cached failed: FATAL: terminating connection due to administrator > > Here's the thing: if your data

Re: [GENERAL] Row Size and Indexing

2006-01-15 Thread Martijn van Oosterhout
On Fri, Jan 13, 2006 at 06:48:28AM -0800, tschak wrote: > Hi guys, > > I have some questions about postgres and would be glad if you could > help me... > Here ist what I am planning to do: > Build a database with 1 Billion (10^9) rows describing geometric > properties: > Question Nr ONE --- Con

Re: [GENERAL] Moving PostgreSQL data directory on Windows

2006-01-15 Thread Jonel Rienton
Hi Otto, The reason I didn't initialized a new cluster is because I was going to use the old cluster that I have, just pointed the data directory to that location in the installation and everything worked fine so I was able to roll back to my 8.1.1 install from 8.1.2. You can set the old locatio