On Wed, 21 Apr 2004, Mike Mascari wrote:
> Doesn't sa-learn also require you to teach it Ham as well? My problem
> has been that sa-learn appears to ignore white-listed emails and
> therefore can't learn from 90% of my Ham. Meanwhile, I get spam that
> slips through SA that my Mozilla client *corr
I have a strange
error.
when I do a ps aux
I get:
postgres
15018 0.0 0.6 9192 7396
? S
09:20 0:00 /usr/bin/perl
/www/nexum/cgi-bin/accounting/posting/automatic_postingpostgres 15019
0.0 0.3 25696 4176 ?
S 09:20 0:00 postgres: postgres nexum [local]:
idle
hello again,
i did some mistakes, site-id was wrong in my simple select querys.
(interesting that no matches would take double time on 7.4)
here are the 'right' results, showing to me postgres 7.4 is slightly
slower with simple querys (but 1000-times faster with more complex
querys ;-)
wit
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 21 April 2004 04:53 pm, Shanta McBain wrote:
> On April 21, 2004 13:26, Karsten Hilbert wrote:
> > If you follow this sage advice you'll open up your financial
> > data to anyone happening to have an account on the machine in
> > question.
hello,
>Richard Huxton wrote:
>What I suggest:
>1. Compare the two postgresql.conf files and any other config settings and
>make sure you know what differences there are and why.
>2. Identify what queries seem to be the cause of the problem, and pick one you
>think is a good example.
>3. VA
> In fact the problem seems to come from the "INSERT INTO". I delete
> everything from the function and only keep the "INSERT INTO" and get the
> same problem.
Given that this is supposed to be a trigger function, what's
your 'create trigger' statement look like?
Part of the problem may be
Greetings,
Does anyone know what the effect of sending an INT signal (kill -2) to
each of:
- pg backend
- psql running an insert or select into
- Perl script with DBI connection to pg, running insert or
select into
- vacuumdb
I'm getting some database corr
Michael Chaney wrote:
Make sure you have the latest SA and make sure that Bayesian filtering
is turned on and working, and make sure to train the filter. Reply to
me offlist if you need a group of 5000 or so spams to help train it.
I've got the latest SA and I'm using Bayesian filtering, autolearn
Hello,
postgresql 7.3.4 on Debian or the redhat packaged 7.3.4-8 on RHEL AS3 -
same issue, so I somewhat cut out RH is playing things on me.
Tested on two different PCs, too (say, one debian, one RHEL).
While running
UPDATE banner SET counterhalf=counterhalf+1 WHERE BannerID=50
several thousand t
Andrew Rawnsley wrote:
The java code is reasonably agnostic, provided the JDBC driver is smart
enough to
deal with any datatype properly as strings, although that intelligence
can be added.
Something else as a slave would be considerable easier, of course. For
something
else to be the master, y
On Wed, 21 Apr 2004, Froggy / Froggy Corp. wrote:
> In fact the problem seems to come from the "INSERT INTO". I delete
> everything from the function and only keep the "INSERT INTO" and get the
> same problem.
A function like:
create function fz1() returns void as '
begin
INSERT INTO cate
On Wed, 21 Apr 2004, Michael Chaney wrote:
> On Tue, Apr 20, 2004 at 01:30:59PM -0300, Marc G. Fournier wrote:
> > Also check to make sure that you don't have autolearn disabled ... you
> > would have had to do it manually, as it is enabled by default, but, for
> > instance, if you are a user on a
hi, maybe it's not the right place to ask this, but hope somebody can
helpme.
i've downloaded the "peer direct" pgsql version for windows, and i've
installed it on windows 200 professional and server with no problems
until now.
yesterday we installed it on a customer's server with windows 2000
Priem, Alexander said:
> Could this be due to the fact that the database was CREATED using
> SQL_ASCII
> encoding? Maybe your solution only works when the database was created
> using
> LATIN1 or UNICODE encoding.
Yes, I suspect
> Maybe I'll just try recreating the database using UNICODE or LATIN
Hello,
In fact the problem seems to come from the "INSERT INTO". I delete
everything from the function and only keep the "INSERT INTO" and get the
same problem.
Thx in advance for answers,
regards,
Stephan Szabo wrote:
>
> On Tue, 20 Apr 2004, Froggy / Froggy Corp. wrote:
>
> > I
Andrew Sullivan wrote:
On Tue, Apr 20, 2004 at 11:26:24AM +0200, Pailloncy Jean-G?rard wrote:
Hi,
I just see that Mysql will propose at the end of the month a full
synchronous replication system with auto-recovery.
Well, sort of. It seems to be yet another 80/20 Solution From MySQL
(tm).
It loo
Hi everyone,
I have a PostgreSQL 7.4 database running, which was initdb-ed using standard
(SQL_ASCII) encoding, with -lc-collate=C option set.
Everything is running fine, but I just discovered something funny. If text
containing characters like ë is inserted into the database (text field), the
in
I am also using postgres database with delphi. Therefor I don't use ODBC
but I use the Zeos Database components for delphi.
I had similar problems though. My database is in iso8859-7 and I needed
Greek chars to appear corectly in my application. What I did is I am
running an sql statement when m
On Tue, 20 Apr 2004, Bruno Wolff III wrote:
> On Tue, Apr 20, 2004 at 14:36:57 +0100,
> csysi <[EMAIL PROTECTED]> wrote:
> > Hello, i upgrade postgres version 7.1 to version 7.4.2 and it tell me that
> > the databases are incompatible.
> >
> > Can i convert the databases ?
>
> You need to do a
> Hi Stijn,
Hy Alexander,
> I tried adding "set client_encoding to 'LATIN1'" to the
> Connect Settings of
> psqlODBC. It didn't help. I still get the same weird
> characters when I look
> at the data using SQL explorer.
Damn (pardon me). I realy hoped that would do the trick.
> Could this be
On Tue, Apr 20, 2004 at 05:44:53PM +, Jeff Boes wrote:
>
> I'm having a devil of a time getting this installed on my system ...
> anybody here willing to give me a walk-through?
I did it just yesterday, to show it to someone. What's the problem?
Do you have the proper jdk and ant? Are the
> Hi everyone,
>
> I have a PostgreSQL 7.4 database running, which was initdb-ed
> using standard
> (SQL_ASCII) encoding, with -lc-collate=C option set.
>
> Everything is running fine, but I just discovered something
> funny. If text
> containing characters like ë is inserted into the database
On Tue, Apr 20, 2004 at 01:30:59PM -0300, Marc G. Fournier wrote:
> Also check to make sure that you don't have autolearn disabled ... you
> would have had to do it manually, as it is enabled by default, but, for
> instance, if you are a user on a system, the site-wide may be set to
> disable autol
Hi Stijn,
I tried adding "set client_encoding to 'LATIN1'" to the Connect Settings of
psqlODBC. It didn't help. I still get the same weird characters when I look
at the data using SQL explorer.
Could this be due to the fact that the database was CREATED using SQL_ASCII
encoding? Maybe your soluti
On Mon, Apr 19, 2004 at 09:19:05PM -0700, Joe Conway wrote:
> Marc G. Fournier wrote:
> >Huh? I just use Spamassassin myself, with Razor/Pyzor/DCC and Bayes all
> >enabled ...
>
> I use exactly the same setup. But recently I've noticed that the
> spammers are getting smarter -- I think 20% of it
Tom Lane wrote:
> [EMAIL PROTECTED] (Jim Seymour) writes:
> > Tom Lane <[EMAIL PROTECTED]> wrote:
> >> But in any case,
> >> I run the same filters on my secondary server. Both the IP and the HELO
> >> checks would be quite useless if I used an MX that wouldn't support 'em.
>
> > Yup. If you can
> > Hi everyone,
> >
> > I have a PostgreSQL 7.4 database running, which was initdb-ed
> > using standard
> > (SQL_ASCII) encoding, with -lc-collate=C option set.
> >
> > Everything is running fine, but I just discovered something
> > funny. If text
> > containing characters like ë is inserted
Am Mittwoch, 21. April 2004 14:37 schrieb Priem, Alexander:
> I have a PostgreSQL 7.4 database running, which was initdb-ed using
> standard (SQL_ASCII) encoding, with -lc-collate=C option set.
>
> Everything is running fine, but I just discovered something funny. If text
> containing characters li
That makes sense since the "connection reset by peer" statement is
always followed immediately by
"unexpected EOF on client connection"
I should have noticed that before :-0
Thanks!
On Apr 20, 2004, at 10:04 PM, Doug McNaught wrote:
Joe Lester <[EMAIL PROTECTED]> writes:
I'm seeing this mess
Jeff Boes wrote:
Fernando Nasser wrote:
Jeff, have tou set the environment variable JAVA_HOME to where your
SDK is installed?
Please try:
echo $JAVA_HOME
It was undefined ... I set it to "/usr/java/j2sdk1.4.2_04".
and
which javac
Nothing found in my path. However, with or without the above
Jeff Boes wrote:
I'm hoping there's someone here with experience in building the Visual
Explain tool from Red Hat. I downloaded it and the J2 SDK, but when I
attempt to follow the build instructions, I get messages like:
error: Type `JTableHeader' not found in the declaration of the local
variable
On Tue, Apr 20, 2004 at 10:45:33AM -0700, Jeff Boes wrote:
> variable `header'.
> [javac] JTableHeader header = null;
>
> To me, this indicates that the SDK isn't installed (properly). But I
> admit I'm pretty much a Java know-nothin'.
java -version ?
A
--
Andrew Sullivan | [E
On Mon, Apr 19, 2004 at 04:25:21PM -0500, Matt Adams wrote:
> Hello:
>
> I have an awkward situation where I must downgrade from 7.4 to 7.1. I
> have two databases already in 7.4. I'm largely ignorant concerning
> postgresql: am I going to have any severe problems downgrading?
Almost certainl
On Tue, 2004-04-20 at 23:39, Janning Vygen wrote:
> Am Dienstag, 13. April 2004 14:17 schrieb Victor Spång Arthursson:
> > Hi!
> >
> > How do i convert a result to upper/lowercase?
>
> This is a question
>
> > SELECT UPPER(lang) from languages;
>
> and this is the answer. It works exactly like t
34 matches
Mail list logo
