[ADMIN] FATAL 1: Sorry, too many clients already

2002-11-08 Thread A.M.
OMG, I'm about to rip my hair out. I've been writing a webapp using DBD::Pg and it has been accessing postgresql for weeks without problems. Suddenly this morning with no changes to the setup, I get: FATAL 1: Sorry, too many clients already whenever I try to use the webapp (running under user "a

Re: [ADMIN] Weird processes

2002-11-14 Thread A.M.
What you're looking for is SQLRelay. You will need to work a little bit around the DBI driver to get the cached connections, but since the driver uses its native interface, this is possible (or you can scrap DBI altogether- not recommended). Get it here: http://taonix.org/ because firstworks.com

[ADMIN] table vs. view maximum columns

2003-06-10 Thread A.M.
I have 560 columns of NUMERIC(10,14). In order not to run up against max column constraints, I split the information into two tables. Does the column limit on tables imply the same limit for views or selects or could I potentially select a row across both tables and make a view that hides the s