Re: [SQL] simple? query

2009-08-13 Thread Relyea, Mike
From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of Jan Verheyden Subject: [SQL] simple? query Hi, I was trying to run following query but doesn't work: if (uid='janvleuven10') then insert into test (registered) values ('1'); else insert into

Re: [SQL] mail alert

2009-08-13 Thread Jasen Betts
On 2009-08-12, Jan Verheyden jan.verhey...@uz.kuleuven.ac.be wrote: --_000_E30C7040DE22624185BAD4093190B54437BE5DB4A9EX2007MBX2uzk_ Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable It's on Windows I'd go with notify and a listener written in C using

Re: [SQL] mail alert

2009-08-13 Thread Alvaro Herrera
Jasen Betts wrote: On 2009-08-12, Jan Verheyden jan.verhey...@uz.kuleuven.ac.be wrote: --_000_E30C7040DE22624185BAD4093190B54437BE5DB4A9EX2007MBX2uzk_ Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable It's on Windows I'd go with notify and a

Re: [SQL] mail alert

2009-08-13 Thread Tim Landscheidt
Alvaro Herrera alvhe...@commandprompt.com wrote: It's on Windows I'd go with notify and a listener written in C using c-client to send emails, but only because I've used those before. I wouldn't write it in C but rather Perl or Python, but whatever suits your fancy should work (Visual

Re: [SQL] mail alert

2009-08-13 Thread Alvaro Herrera
Tim Landscheidt wrote: The main disadvantage in using a listener is that it is your responsibility to make sure that the listener is listening 24/7 - from before the database accepts other connections, through network failures, bugs, etc. - otherwise notifica- tions will be lost. Therefore I

Re: [SQL] mail alert

2009-08-13 Thread Adrian Klaver
On Wednesday 12 August 2009 6:27:25 am Jan Verheyden wrote: Hi, I got a bit stuck... I was looking for a solution for option a) Maybe I'll first explain the situation a bit more: I have one database for patient registration Another one for image storage And a third one for book keeping