[BUGS] Bug in SQL function with returntype void

2003-06-12 Thread "Zíka Aleš, Ing."
Your name : Ales Zika Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : Intel Pentium Operating System (example: Linux 2.0.26 ELF) : Windows 2002 Professionl CZ + cygwin PostgreSQL v

[BUGS] Pg_dumpall in batch

2003-06-12 Thread Serge Obeuf
Hi all. I recently posted here some questions about pg_dumpall (7.2) on solaris8. Investigating, I reduce my problem cases. When I plan by crontab 'pg_dumpall > dball.sql', I receive this error connected to template1... ld.so.1: /usr/local/public/pgsql/bin/psql: fatal: libpq.so.2: open failed: No

Re: [BUGS] Pg_dumpall in batch

2003-06-12 Thread Achilleus Mantzios
On Thu, 12 Jun 2003, Serge Obeuf wrote: > Hi all. > > I recently posted here some questions about pg_dumpall (7.2) on solaris8. > Investigating, I reduce my problem cases. > > When I plan by crontab 'pg_dumpall > dball.sql', I receive this error > connected to template1... > ld.so.1: /usr/local/

[BUGS] pg_dumpall not working in batch

2003-06-12 Thread Serge Obeuf
Hi all, I've recently posted here some question about pg_dumpall (7.2) on Solaris8. Investigating, I reduce my problem cases. When I plan in crontab 'pg_dumpall > dball.sql', I receive this error: connected to template1... ld.so.1: /usr/local/public/pgsql/bin/psql: fatal: libpq.so.2: open failed:

Re: [BUGS] pg_dumpall not working in batch

2003-06-12 Thread Dmitry Tkach
You must have some environment setting (like LD_LIBRARY_PATH?) in your .login or .bashrc (or whatever shell you are using), that tells psql where to find that library. When you run it via cron, that environment isn't being set and causes it to fail. I hope, it helps... Dima Serge Obeuf wrot

Re: [BUGS] Bug in SQL function with returntype void

2003-06-12 Thread Tom Lane
=?iso-8859-2?Q?=22Z=EDka_Ale=B9=2C_Ing=2E=22?= <[EMAIL PROTECTED]> writes: > I tried the example "CREATE FUNCTION clean_EMP () RETURNS void AS > 'DELETE FROM EMP WHERE EMP.salary <= 0' LANGUAGE SQL;" in chapter 9.2.1 of > Programmer's guide. > When the function was invoked, it delete on

Re: [BUGS] Bug in SQL function with returntype void

2003-06-12 Thread Bruce Momjian
Thanks. That bug looked really weird! --- Tom Lane wrote: > =?iso-8859-2?Q?=22Z=EDka_Ale=B9=2C_Ing=2E=22?= <[EMAIL PROTECTED]> writes: > > I tried the example "CREATE FUNCTION clean_EMP () RETURNS void AS > > 'DELETE FR

Re: [BUGS] PostgreSQL client has problems when libbind is installed

2003-06-12 Thread Tom Lane
"Yves R. Crevecoeur" <[EMAIL PROTECTED]> writes: > Don't break BeOS support. > A new version of BeOS will be released very soon. Well, the BeOS port is already broken, and has been for awhile, because no one's bothered to step up and maintain it. Are you volunteering? It needs work on semaphore

Re: [BUGS] db growing out of proportion

2003-06-12 Thread Tomas Szepe
> [EMAIL PROTECTED] > > > Peter Childs <[EMAIL PROTECTED]> writes: > > > On Fri, 30 May 2003, Tomas Szepe wrote: > > >> Trouble is, as the rows in the tables get deleted/inserted/updated > > >> (the frequency being a couple thousand rows per minute), the database > > >> is growing out of proportio

Re: [BUGS] PostgreSQL client has problems when libbind is installed

2003-06-12 Thread Tom Lane
Palle Girgensohn <[EMAIL PROTECTED]> writes: > [ linking libbind causes some obscure problems ] > http://www.freebsd.org/cgi/query-pr.cgi?pr=ports/47218 Given that we're not supporting BeOS at the moment anyway, I wonder whether we need libbind on any platform. I know linking it causes some minor

Re: [BUGS] PostgreSQL client has problems when libbind is installed

2003-06-12 Thread Yves R. Crevecoeur
Don't break BeOS support. A new version of BeOS will be released very soon. http://www.yellowtab.com http://www.yellowtab.com/board/ http://www.yellowtab.com/support/ Regards, Yves - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Palle Girgensohn" <[EMAIL PROTECTED]> Cc: <