[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 ch
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 r
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 to
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
--
Bob Ghodsi wrote:
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 w
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
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 ou
> -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
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.
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 this:
SELECT UPPER('dk');
results in 'DK'
kind regards,
Janning
-
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 does
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)--
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 Files\M
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 Engine
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 relati
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 [EMAIL
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
K
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 unlik
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
--
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 plps
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 t
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 bou
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
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.
> >
>
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
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
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 broadcast)--
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 th
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 incre
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 pro
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
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
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 pos
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 "SELE
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
"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
37 matches
Mail list logo
