Re: [GENERAL] Changing from default configuration options in 7.1?

2001-04-20 Thread Karl DeBisschop
Steve Wampler wrote: I just upgraded from 7.0.3 to 7.1 (using the RH rpms) with no major problems. Nice! However, I'm getting some strange behaviour from the init script (/etc/rc.d/init.d/postgresql). In particular, a restart when the database is running fails because the "sleep 2"

[GENERAL] Re: Latin2 and Unicode problems

2001-04-20 Thread Grzegorz Mucha
Well, I didn't state it correctly, then. When I use iso8859-2, Postgres is compiled with --enable-locale only (though compiling it with UNICODE support, then creating database with ISO encoding works fine - sorting, upper/lower case conversion). However, when creating db with Unicode, no

RE: [GENERAL] Best practice

2001-04-20 Thread Willis, Ian (Ento, Canberra)
What would the the best choice for the WAL mirroring, raid3 or 5. How big does the WAL grow? mirroring is fine as long as the size isn't too big. -- Ian Willis -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Friday, 20 April 2001 9:22 AM To: [EMAIL PROTECTED] Cc:

Re: [GENERAL] Re: Latin2 and Unicode problems

2001-04-20 Thread Tatsuo Ishii
Well, I didn't state it correctly, then. When I use iso8859-2, Postgres is compiled with --enable-locale only (though compiling it with UNICODE support, then creating database with ISO encoding works fine - sorting, upper/lower case conversion). I'm confused. Did you enable the locale

[GENERAL] static variables in functions

2001-04-20 Thread Gyozo Papp
hello everyone, is there any possibility to keep the value of an arbitrary type variable in a plpgsql function between its invocations? If not, can it be made with functions written in C instead? I've "static storage" in my mind. Can it be made thread-safe? - Papp Gyozo -

Re: [GENERAL] Re: Latin2 and Unicode problems

2001-04-20 Thread Grzegorz Mucha
I'm confused. Did you enable the locale support only? Sorry then. Well, I tested two cases: - pg compiled only with enable locale and iso8859-2 works - pg compiled with locale, enable unicode and unicode conversion doesn't work as it should. That's because locale support (--enable-locale)

[GENERAL] Database Connect

2001-04-20 Thread Michaƫl Fiey
Hi, I installed Postgresql 7.1 (RPMs for Redhat 7.0). When I start psql with the command 'psql mydb', everything's ok But whan I start psql with the command 'psql mybase@myhost' I receive : psql: FATAL 1: Database "mybase@myhost" does not exist in system catalog I used this syntax with

Re: [GENERAL] very slow execution of stored procedures

2001-04-20 Thread Richard Huxton
From: "Vilson farias" [EMAIL PROTECTED] Greetings, I found something very weird related with stored procedures execution. I have this stored procedure to finalize a phone call, writing tha time of call finalization and some other values to a calls table, called cham_chamada. Please

Re: [GENERAL] password authentication

2001-04-20 Thread Oliver Elphick
Phuong Ma wrote: Hi, I was wondering what the different methods of creating a password accomplish because I created a password for a test user using the command WITH PASSWORD. I tried testing to see if I could log on without a password, and it worked. Is there anything else I

Re: [GENERAL] PL/Perl Question

2001-04-20 Thread Doug McNaught
Hitesh Patel [EMAIL PROTECTED] writes: I need to be able to execute SQL commands from inside a plperl function and can't figure if I can do this. Also.. after executing the query I need to be able to grab the number of tuples returned and there values.. how would I go about doing this.. any

[GENERAL] Re: problems with pg_dumplo (was Re: backup with blobs)

2001-04-20 Thread Peter Pilsl
On Fri, Apr 20, 2001 at 12:48:36PM +0200, Karel Zak wrote: when working on an own database things works perfect. However I have a reproduceable problem on a different database when importing blobs into a single table while the old blobs still existing (no matter if using -r or not)

Re: [GENERAL] very slow execution of stored procedures

2001-04-20 Thread Vilson farias
Richard, I've tried all your advices and still nothing. It's been very hard to me understand why this is happening. The only solution is to modify the stored procedure.

[GENERAL] Logical expn not shortcircuiting in trigger function?

2001-04-20 Thread Joel Burton
Problem: PostgreSQL apparently isn't short-circuiting a logical expression, causing an error when it tries to evaluate OLD in an INSERT trigger. PostgreSQL normally 'short-circuits' logical expressions; that is, once it figures out that it can't resolve an expression to truth, it stops

Re: [GENERAL] Database Connect

2001-04-20 Thread Tom Lane
=?iso-8859-1?Q?Micha=EBl_Fiey?= [EMAIL PROTECTED] writes: But whan I start psql with the command 'psql mybase@myhost' I receive : psql: FATAL 1: Database "mybase@myhost" does not exist in system catalog This syntax isn't supported. I used this syntax with Postgresql 7.03. There was some

[GENERAL] Re: problems with pg_dumplo (was Re: backup with blobs)

2001-04-20 Thread Karel Zak
On Fri, Apr 20, 2001 at 02:12:23AM +0200, Peter Pilsl wrote: On Wed, Apr 18, 2001 at 06:07:33PM -0400, Tom Lane wrote: No need to re-invent the wheel; use the attached. Thanx to Tom for this great tool. Sure :-) Unfortunately it does not work in my testenvironment. When

[GENERAL] Re: static variables in functions

2001-04-20 Thread Karel Zak
On Fri, Apr 20, 2001 at 10:35:36AM +0200, Gyozo Papp wrote: hello everyone, is there any possibility to keep the value of an arbitrary type variable in a plpgsql function between its invocations? If not, can it be made with functions written in C instead? I've "static storage" in my mind.

[GENERAL] Re: problems with pg_dumplo (was Re: backup with blobs)

2001-04-20 Thread Peter Pilsl
On Fri, Apr 20, 2001 at 10:27:11AM +0200, Karel Zak wrote: Thanx to Tom for this great tool. Sure :-) sorry !! I ment to say, Thnx for giving this tool to me. Even more thanx for writing this great tool to you !! :) pg_dumplo -i (without -r) add *new* LO to DB and update LO oid

[GENERAL] Re: PL/Perl Question

2001-04-20 Thread Travis Bauer
I think this is problematic with the default compilation fo PL/Perl. The perl interpretor you get in a plperl function is inside of a "sandbox" (can't remember the official name) where it is limited to only a relatively small set of functions. I don't think that SQL commands are included. --

[GENERAL] I want to unsubscribe, how can i do it?

2001-04-20 Thread Guilherme Fortunato
Tha is it! What I want to know is in this messages's subject. Thanks -- Guilherme Fortunato e-mail: [EMAIL PROTECTED] -- ---(end of

[GENERAL] I want to unsubscribe!

2001-04-20 Thread Guilherme Fortunato
-- Guilherme Fortunato e-mail: [EMAIL PROTECTED] -- ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go

Re: [GENERAL] Database Connect

2001-04-20 Thread webb sprague
Aahh! I have a million Perl scripts that rely on this syntax in the DBI to connect to remote databases. like: $dbh=DBI-connect( "dbi:Pg:dbname=datab@remotehost",'wsprague','pass', {RaiseError = 1, AutoCommit = 1}) or print STDERR "$DBI::errstrp"; Umm, do you have