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
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
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
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
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
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
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
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
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.
> >
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
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
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
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
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
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
-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
16 matches
Mail list logo
