Re: [ADMIN] Hello Testing

2003-08-16 Thread Stephan Szabo
On Sat, 16 Aug 2003, [iso-8859-1] Deepak Malhotra wrote: > Hello > > Any idea why I am getting > "ERROR: More than one tuple returned by a subselect > used as an expression" > while running update statement using subselect > statement. That usually means you're using a subselect that returns mul

[ADMIN] Hello Testing

2003-08-16 Thread Deepak Malhotra
Hello Any idea why I am getting "ERROR: More than one tuple returned by a subselect used as an expression" while running update statement using subselect statement. = Deepak Malhotra Phoenix, AZ [EMAIL PROTECTED] Wan

Re: [ADMIN] Host configuration

2003-08-16 Thread Nick Fankhauser
In addition to making sure you do a reload to pick up the new values, make sure that the pg_hba.conf file you are editing is in fact the one being read by the postmaster. There have been a few situations where a symbolic link pointing from the data directory to a conf file living somewhere else ge

Re: [ADMIN] Host configuration

2003-08-16 Thread Gregory S. Williamson
I had a similar problem recently and in the end it seems to have been me not restarting the postmaster; changes to the pg_hba.conf file weren't seen until then (I am sure this is documented but I managed to overlook it; Informix' sqlhosts file is read at connection time so changes are immediate

[ADMIN] limit number of connections per database

2003-08-16 Thread "bognár, attila"
Dear List, Is there a way to limit the number of connections per database? The maximum number of connections to all databases can be limited, but I need to restrict it for each database (db1: 10 connections, db2: 40 connections...). If there is no direct way, is there some workaround or is thi