[GENERAL] DELETE statement KILL backend

1998-08-21 Thread Sferacarta Software
Hello all, I have a strange problem that I can't understand. I have been my PostgreSQL-6.3.2 on Linux-ELF-2.0.34 working without any problem for many months. This morning I can't DELETE anymore. If I try to delete a row from any table I have this message: PGexec() -- Request has sent to

[GENERAL] 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

Re: [GENERAL] Listing viewing triggers

1998-08-21 Thread David Hartwig
select * from pg_trigger; Andrew Gibson wrote: > Greetings to the list from DownUnder! > > I have created a number of triggers and do not remember exactly what I > called them. How do I list the triggers (to refint.c) I have created and > which tables they reference etc.?? > > --