Re: [BUGS] Problem with 7.1.3 and -DUSE_AUSTRALIAN_RULES

2001-11-13 Thread Thomas Lockhart
... > Is there no way to get this working? Sure there is. The code in 7.1.x needs to have USE_AUSTRALIAN_RULES evaluate to "true" (there is an #if, not #ifdef), so you should set it equal to one (rather than just have it exist). I think that "-DUSE_AUSTRALIAN_RULES=1" should work; you can set it

Re: [BUGS] Problem with 7.1.3 and -DUSE_AUSTRALIAN_RULES

2001-11-13 Thread Justin Clift
Hi Bruce, There is ZERO possibility of using 7.2betaX on this server. It's a critical production machine and requirements are such that it's been migrated to RedHat 7.1. Is there no way to get this working? Regards and best wishes, Justin Clift Bruce Momjian wrote: > > Please try 7.2beta2.

Re: [BUGS] Problem with 7.1.3 and -DUSE_AUSTRALIAN_RULES

2001-11-13 Thread Tom Lane
Justin Clift <[EMAIL PROTECTED]> writes: > Does anyone have any ideas? Please bear in mind that everything > compiles fine without the -DUSE_AUSTRALIAN_FLAGS option. > Haven't tried current CVS, but it's an interesting thought (can't do it > on this server). FWIW, there is no AUSTRALIAN_anything

Re: [BUGS] Problem with 7.1.3 and -DUSE_AUSTRALIAN_RULES

2001-11-13 Thread Bruce Momjian
Please try 7.2beta2. Australian time is now controlled by a postgresql.conf option so things are much easier. --- > Hi, > > I'm trying to compile PostgreSQL 7.1.3 on Redhat 7.1, and whenever I > define USE_AUSTRALIAN_RULE

[BUGS] Problem with 7.1.3 and -DUSE_AUSTRALIAN_RULES

2001-11-13 Thread Justin Clift
Hi, I'm trying to compile PostgreSQL 7.1.3 on Redhat 7.1, and whenever I define USE_AUSTRALIAN_RULES with : export CFLAGS=-DUSE_AUSTRALIAN_RULES When doing make I get the error ": warning: ISO C requires whitespace after the macro name" after every invocation of gcc. After a while the whole pr

Re: [BUGS] Bug #514: Backend crashes periodically

2001-11-13 Thread Tom Lane
Hiroshi Inoue <[EMAIL PROTECTED]> writes: > What I meant is > Session 2 invokes the session_del rule and really > updates a sis_user row by the rule though it deletes > no session row. Hmmm ... that's an ugly thought, isn't it? And I'm not sure there's anything we can do to defend against

Re: [BUGS] Bug #514: Backend crashes periodically

2001-11-13 Thread Hiroshi Inoue
Tom Lane wrote: > > Hiroshi Inoue <[EMAIL PROTECTED]> writes: > > BTW I have a question about this example. > > Session 2 deletes no row because *session 1* already > > deleted the rows but the session_del rule seems to > > be invoked. Is it a right behavior ? > > Certainly the rule should be inv

Re: [BUGS] Installation problem

2001-11-13 Thread Tom Lane
"N Waanders" <[EMAIL PROTECTED]> writes: > gmake [4] entering directory > `/usr/INSTALL/Postgres-7.1.1/src/backend/access/common' > gcc -02 -Wall -Wmissing-prototypes -Wmissing-declarations > -I../../../../src/include -c -o heaptuple.o heaptyple.c > - repeated for various files Looks perfectly

Re: [BUGS] Perl script failure => Postgres 7.1.2 database corruption

2001-11-13 Thread Frank McKenney
** Reply to message from Tom Lane <[EMAIL PROTECTED]> on Fri, 09 Nov 2001 12:36:38 -0500 Tom, Thanks for taking the time to reply. I have to say that I'm very impressed with the "expressive power" and performance of PostgreSQL's inplementation of SQL; I used it in this situation because "i

[BUGS] Error.

2001-11-13 Thread Kauê S. Ewbank
When try to eexecute a query in a jsp program this error is reeturned ("No results were returned by the query."), but if i execute de same query in "phpPgAdmin" the query return a result.   Kauê S. EwbankSystem Analystcel: (11) 9673-2057

[BUGS] Installation problem

2001-11-13 Thread N Waanders
Hello, I have been trying to install postgresql v.7.1.1 (downloaded from pgsql.com) on my SuSE 7.2 linux system, using default settings. I unpacked the tarball in /usr/INSTALL/ and proceeded from there. However, on the second stage of the process (gmake install) I noticed a stream of messages li

[BUGS] Incorrect text to timestamp conversion

2001-11-13 Thread Derrick Hamner
Your name : Derrick Hamner Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : AMD Athlon Operating System (example: Linux 2.0.26 ELF) : Linux 2.4.9 PostgreSQ

[BUGS] run-time error!

2001-11-13 Thread ¹ÚºÎ½Ä
For a few days after install, psql did well. now psql can't do but show messeages, "error while loading shared libraries. undefined symbol: pg_encoding_to_char" 'psql -l' command do well now but 'psql [database name]' can't do. Next Entertainment, LYCOS

Re: [BUGS] 7.1.3 w/ Perl/DBI application hangs

2001-11-13 Thread Tom Lane
"Doran L. Barton" <[EMAIL PROTECTED]> writes: > The problem I'm having with the queries "hanging" is apparently happening > as soon as a VACUUM ANALYZE is done on the database. Until a VACUUM ANALYZE > is done, the database is speedy and responsive. As soon as a VACUUM ANALYZE > is performed, the

Re: [BUGS] 7.1.3 w/ Perl/DBI application hangs

2001-11-13 Thread Doran L. Barton
I have made an interesting observation that SHOULD have been made before (yeah, stupid of me not to have made this connection before): The problem I'm having with the queries "hanging" is apparently happening as soon as a VACUUM ANALYZE is done on the database. Until a VACUUM ANALYZE is done, the