Nigel J. Andrews [EMAIL PROTECTED] writes:
Doesn't that just force the delivering system to send the spam through your
secondary server?
A 500-series error isn't supposed to be retried is it? But in any case,
I run the same filters on my secondary server. Both the IP and the HELO
checks would
On Mon, 19 Apr 2004, 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 is slipping by the
Hi,
Im not sure if this is right place to ask this question, but here goes.
I have have declared a cursor with an query within a transaction. I
need to get the current position of the cursor and also the number of
rows it represents. Is there any way to do this? I was thinking i could
do
On Tue, 13 Apr 2004 12:56:09 +0200, Holger Klawitter wrote:
Oh please. Reiser is as unstable as postgres is slow - in other words,
both have to suffer prejudice which used to be true lng ago. ;-)
True.
In cases of large directories ext2/3 perform extremely bad (as in the
original post)
Title: Message
I'm getting this
when i do an insert. I have a 'c' trigger doing an SPI_connect. If i
remove this it goes away, but i don't think it's my trigger generating it.
The table has a lot of foreign key constraints. Could be postgres is
generating code to do this. Is there a way
Karel Zak wrote:
It must be pretty difficult maintain these header and body patterns
and the others lists. I had same problem and I resolve if by
spamassassin, it knows learn and it's more simple than procmailrc
coding. Now I have cca 5% of all spams in my INBOX.
It's not
I am experiencing a problem when I run my visual basic database
program on windows 2000.
The error message states activex components can not create an
object, I have installed mdac_typ 2.8 and reinstalled visual studio
2000 on my computer, but I still get he smae error message when I run
the
Hi!
How do i convert a result to upper/lowercase?
I'ld like to do the following:
SELECT UPPER(lang) from languages;
and get for example uk as UK, dk AS DK and so on
Sincerely
Victor
---(end of broadcast)---
TIP 7: don't forget to increase your
We are looking at implementing a large Postgresql database (50GB -
100GB) and are wondering if there are any limitations or problems for
a database of this size running on 32-bit architecture. I have seen
some older posts where it appears that Postgresql seemed to have
performance problems when
I have a Data General server with Basix Program and i would like change for
the Sco Unix server. I would like use my Basix Program on Sco Unix, but i
can't find the program for run Basix on Sco Unix (or Linux, or any Unix).
Thank you for help!.
---(end of
On Tue, Apr 20, 2004 at 05:35:51AM - I heard the voice of
Jim Wilson, and lo! it spake thus:
Tom Lane said:
3. I have noticed that bouncing any machine that sends HELO
sss.pgh.pa.us gets rid of a ton of spam and viruses. I don't know of
any real clean way to do this, but I have a
I want the following trigger to update a related table when ever a
record is inserted/updated. I have the following trigger:
CREATE TRIGGER update_status
AFTER INSERT OR UPDATE
ON public.Bug Status
FOR EACH ROW
EXECUTE PROCEDURE public.update_status();
Which Calls this function:
CREATE OR
Chris Browne [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]...
[EMAIL PROTECTED] (Anthony) writes:
Our Database is having errors. We are currently using PostgreSQL to
store 2.5 Million records per day. The average addition to our primary
table is 4.5 Gigs of data.
We are
Title: Message
I was
missing SPI_finish() here.
Sorry.
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Alan TreeceSent: Friday, April 16, 2004 3:29
PMTo: [EMAIL PROTECTED]Subject: [GENERAL]
plpgsql: cannot connect to SPI manager
I'm
Hi,
I've been playing about with array's, and found the concat operator
'||' quite
useful, apart from the fact that prepending an element places it in a
lower subscript.
Is there a way of either:
a) prepending an element, but shifting existing elements up a subscript,
so that the lower
Replying to my own post, tch, tch... :-)
Thanks to those of you who have contacted me off list. It seems that
there's a fair bit of interest in replication in general at the moment.
I fixed my problem with pgReplicator, so the test system is merrily
replicating between Perth and Brisbane as I
I'd like to compute some row like results and return them from a
function (and pass the result to PHP[*]).
Well I've read about composite type but all the references I've seen
are about coding in C. That's not the way I'd like to follow by now.
I was expecting to declare composite types in
Marc G. Fournier wrote:
do you force learn those spam that get through the cracks? I get about 20
or 30 messages that slip through the cracks, which I process through with
sa-learn nightly ...
No, I haven't been doing that, but I guess I ought to start. Thanks for
the suggestion!
Joe
On Mon, 19 Apr 2004, Gregory S. Williamson wrote:
FWIW, this site gives:
404 - File Not Found
These aren't the droids files you're looking for.
Sorry, but that file could not be found. And believe you me, we looked! We checked
all the likely directories, then all the unlikely
Hi all,
I try to visit the web site of PostgreSQL but my browser doesn't show the
intro page correctly. I also tried to visit the site with mozilla. The
result was the same. Spesifially, I can only view the background color and a
white horizontal line. Do you know what is wrong. Thank you advance
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 ?
Thank´s for the help
Jorge
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to
I have an embedded system running FreeBSD (5.1) that does not have any local
(rotating) storage (i.e disk drives).
PostgreSQL also runs on this box and (at this point) has two tables. It is
an extremely simple PostgreSQL configuration with the tables having less
than 20 fields each, and no
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?
Thanks
Matt
--
Matt Adams [EMAIL PROTECTED] voice +1 (903) 939-7641
Systems
Over the weekend, I reviewed several of my database programs written
in visual Basic 6.0. Discovered that all had DAO 3.51 reference in
common. Aparantly this corrupted file was causing the error 429.
To solve the problem, copy the DAO 3.5 or DAO 3.6.dll Located on
C:\Program Files\Commons
Quoting csysi [EMAIL PROTECTED]:
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 ?
Thank´s for the help
Jorge
---(end of broadcast)---
TIP
I just want a general idea of what Postgresql can handle. I know the guru's
will say it depends on many different things, but in general what can this
bad boy handle?
50gb to 100gb is by no means small. But how does Postgresql 7.4 handle
database of 900G, or 1 Terabyte or greater?
How
Am Dienstag, 13. April 2004 14:17 schrieb Victor Spng 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 this:
SELECT UPPER('dk');
results in 'DK'
kind regards,
Janning
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 dump and reload to go between major releases (e.g.
from 7.1.x to
-Original Message-
From: Matt Adams [mailto:[EMAIL PROTECTED]
Sent: Monday, April 19, 2004 2:25 PM
To: [EMAIL PROTECTED]
Subject: [GENERAL] Downgrading from Postgresql 7.4 to 7.1
Hello:
I have an awkward situation where I must downgrade from 7.4
to 7.1. I
have two
On Tue, 20 Apr 2004, Joe Conway wrote:
Marc G. Fournier wrote:
do you force learn those spam that get through the cracks? I get about 20
or 30 messages that slip through the cracks, which I process through with
sa-learn nightly ...
No, I haven't been doing that, but I guess I ought to
Hello everyone,
I try to see if i can make a recursive function with a trigger set on
INSERT and doing an insert under my trigger function.
So i wrote a test function :
CREATE OR REPLACE FUNCTION testfunc() RETURNS SETOF RECORD AS '
DECLARE
use_t RECORD;
BEGIN
How do i convert a result to upper/lowercase?
I'ld like to do the following:
SELECT UPPER(lang) from languages;
and get for example uk as UK, dk AS DK and so on?
That looks right to me. Are you getting an error?
lee=# select version();
version
[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't employ the same anti-UCE checks on a
hi! im new to SQL, and i need to find a solution
to this problem:
i have a table with two columns, the first column
is of type timestamp.
the table contains hundreds of thousands of records.
i need to get all the entries/records at every 10 seconds
interval. example, given a table:
hh/mm/ss |
The Slony-I project is currently heading for release. The plan is to
start BETA around May 12 with a target release date end of June.
Nightly CVS exports can be downloaded from here:
http://gborg.postgresql.org/project/slony1/projdisplay.php
I would like to encourage everyone who intends
Hello,
We are trying to import the TPC-H data into postgresql using the COPY
command and for the larger files we get an error due to insufficient
memory space.
We are using a linux system with Postgresql-7.3.4
Is it that Postgresql cannot handle such large files or is there some
other possible
36 matches
Mail list logo