Re: [ADMIN] Updating tuples based on max time

1998-08-21 Thread Bruce Momjian
6.4 will have the HAVING clause, that will testing of aggregates. 6.4 beta is September 1. > I keep crashing my backend doing the following > UPDATE logins SET > logoff_time='now' > WHERE > login_time=max(login_time) > AND > account_name='tempuser' > ; > > login_time is type 'dateti

Re: [ADMIN] Backup of postgres

1998-08-21 Thread Przemyslaw Bak
On Wed, 19 Aug 1998, Marc Howard Zuckman wrote: > > On Wed, 19 Aug 1998, Przemyslaw Bak wrote: > > > Hi all, > > > > I have following script to backup database: > > - cut -- > > #!/bin/sh > > > > PSQL=/usr/local/pgsql/bin/psql > > DUMP=/usr/local/pgsql/bin/pg_dump > > PREFIX=`d