Re: [GENERAL] PostgreSQL 7.4.3 Now Available ...

2004-06-17 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Tue, 15 Jun 2004, Tom Lane wrote: > I will push out a Fedora Core package within the next few days as well. I've already built (S)RPMS for FC 2 by just modifying spec file and modifying some patches for rpm build. All are tested and they ar

Re: [GENERAL] Tracking down deadlocks

2004-06-17 Thread Csaba Nagy
Ben, My personal solution is to patch the postgres sources so the foreign key check does NOT lock the parent record. This has the disadvantage that in some situations the foreign key semantics are not guarrantied, but for my application works just fine. I think there was a patch posted to do exact

[GENERAL] Join a varchar array

2004-06-17 Thread Robin Ericsson
Hi, I have a field in which I save the follow: {{8,0.58},{9,972420},{10,239544},{6,0.49},{7,0.63}} The first field is a reference to an id in another table and the second field is a value. Can these values be used somehow in a select query to join the other table? I don't mind getting them on d

Re: [GENERAL] why no answer? [Fwd: backup and restore just with use

2004-06-17 Thread [EMAIL PROTECTED]
hello scott, this is good news (for me ;-) )! what kind of client should be available (if i search for a good hoster in near future)? greetings hans Scott Marlowe schrieb: On Wed, 2004-06-16 at 23:28, [EMAIL PROTECTED] wrote: hello, thank you for your short - but informative

Re: [GENERAL] index with LIKE

2004-06-17 Thread Henrik Steffen
hello scott, disable enable_seqscan still does no force the backend to use indexes. so it looks like a locale problem, right? I checked lc_* vars on both servers: typemainserver slave lc_collate Cde_DE.UTF-8 lc_ctype[EMAIL PROTECTED] de_DE.UTF-8 lc_messages [EMAIL

Re: [GENERAL] index with LIKE

2004-06-17 Thread John Sidney-Woollett
Henrik Steffen wrote: hello scott, disable enable_seqscan still does no force the backend to use indexes. so it looks like a locale problem, right? I checked lc_* vars on both servers: typemainserver slave lc_collate Cde_DE.UTF-8 lc_ctype[EMAIL PROTECTED] de_DE.UTF-8 lc

Re: [GENERAL] Join a varchar array

2004-06-17 Thread Richard Huxton
Robin Ericsson wrote: Hi, I have a field in which I save the follow: {{8,0.58},{9,972420},{10,239544},{6,0.49},{7,0.63}} The first field is a reference to an id in another table and the second field is a value. Can these values be used somehow in a select query to join the other table? You appear t

Re: [GENERAL] Join a varchar array

2004-06-17 Thread Robin Ericsson
On Thu, 2004-06-17 at 11:38, Richard Huxton wrote: > Robin Ericsson wrote: > > Hi, > > > > I have a field in which I save the follow: > > {{8,0.58},{9,972420},{10,239544},{6,0.49},{7,0.63}} > > > > The first field is a reference to an id in another table and the second > > field is a value. > >

Re: [GENERAL] Join a varchar array

2004-06-17 Thread Richard Huxton
Robin Ericsson wrote: On Thu, 2004-06-17 at 11:38, Richard Huxton wrote: You appear to be using the array as a replacement for a table. Don't do that. From the little information you've provided, it looks like you want a separate table (a_ref, b_ref, float_val) where a_ref references the current

[GENERAL] [Fwd: Postfix SMTP server: errors from avalanche.netmar.com[198.69.224.177]]

2004-06-17 Thread Tom Allison
Can someone tell me if I'm blocking spam here of if I'm somehow blocking some of the emails from this list? I'm definitely getting email, but I keep getting these messages popping up on my servers. Does anyone know why? Original Message Return-Path: <[EMAIL PROTECTED]> X-Orig

Re: [GENERAL] index with LIKE

2004-06-17 Thread Henrik Steffen
hello john, thanks for your email! changing the index type to "text_pattern_ops" solved the problem. I didn't quite get the point, when Joseph Shraibman first sent the link regarding operator classes. My apologies. However, I would not fancy to change all (hundrets) of indexes now. Would chang

Re: [GENERAL] [PERFORM] Visual Explain

2004-06-17 Thread Paul Thomas
On 17/06/2004 12:10 Adam Witney wrote: Will this run on other platforms? OSX maybe? It's a Java app so it runs on any any platform with a reasonably modern Java VM. -- Paul Thomas +--+-+ | Thomas Micro Systems Limited | Softw

[GENERAL] Off Topic: Book about High available / Load Balancing / Cluster

2004-06-17 Thread Renato Cramer
Hi All, Someone will can say me anything about the Tony Bourke's book "Server Load Balancing"? I need study these subjects. Any recommendation? Thanks in advance. Renato Cramer. ---(end of broadcast)--- TIP 7: don't forget to increase your free s

Re: [GENERAL] index with LIKE

2004-06-17 Thread John Sidney-Woollett
Henrik Thanks for the info. What encoding you should use depends on your data, and how you want records sorted etc. You'll have to figure out what is more suitable for you - I cannot answer that for you. To solve your master/slave index problem, why not rebuild the slave databases using the C e

[GENERAL] MySQL to Postgres.

2004-06-17 Thread Prabu Subroto
Dear my friends... I am planning to migrate my database from MySQL to Postgres since the MySQL does not have subquery except it 4.1. And I can not wait until the 4.1 stable version released and included in SuSE distro. I did mysqldump (into a file, basisdata.txt) and I am going to do its query qi

Re: [GENERAL] Database accesss using plperl

2004-06-17 Thread Robert Fitzpatrick
On Wed, 2004-06-16 at 19:05, Paul Thomas wrote: > On 16/06/2004 21:27 Robert Fitzpatrick wrote: > > I have plperl installed my PostgreSQL 7.4.2 server, but from what I > > understand in chapter 39.3 of the docs, you cannot access the databases > > without DBD::PgSPI. According to the readme for tha