Has there ever been any discussion on
using Free Pascal to create functions (C Style)?
I know pascal can be used to create user defined functions in other
databases like Firebird (which was originally coded in C and now C++)
Thanks
Tony
---(end of broadcast)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Greg Sabino
Mullane
Sent: Friday, December 09, 2005 9:02 PM
To: pgsql-general@postgresql.org
Cc: pgsql-announce@postgresql.org; pgsql-announce@postgresql.org
Subject: [ANNOUNCE] GnuPG / PGP signed MD5 and SH
Hi,
On Sun, 2005-12-11 at 08:39 +0100, stig erikson wrote:
> i have compiled postgresql 8.1.1 rpms for redhat 8.0 based on the
> official srpms for redhat 9.
They are tagged as "PGDG", however they are not built by our RPM
Building Project.
Please either consider joining to our project
(http:
stig erikson wrote:
> i would like to ask if there are some plans or if there has been any
> discussions about allowing any one query to run on more then one
> processor?
It is certainly on most people's wishlists but there is no concrete plan
for it yet.
--
Peter Eisentraut
http://developer.po
hi.
i have compiled postgresql 8.1.1 rpms for redhat 8.0 based on the
official srpms for redhat 9.
i just installed the rpms and it looks like they are working well.
if somebody is interested i have put the compiled files here:
ftp://82.182.149.199/pub/postgresql/unofficial/
feel free to grab
Welcome
Simon Riggs wrote:
Tune your wal settings and bgwriter to improve things, plus upgrade to
8.1 which has made leaps forward with this issue.
What is best settings for that case?
I have the same on 7.4 but for me it's not critical issue or big problem.
I have database (size 2-3 GB) wi
from what i understand PostgreSQL only uses one CPU for any one query.
i do understand that on systems where there are many more connections
and simultaneous transactions (relatively small transactions) then the
number of processors, the queries would most likely run on a single
processor even
"Foster, Stephen" <[EMAIL PROTECTED]> writes:
> WHILE (--Lost on variable name for end of query;
> EmptyQueryResponse <> 0? --)
WHILE FOUND
LOOP
...
END LOOP
Although as Michael mentioned, this is all the hard way; any experienced
plpgsql programmer w
Thanks Michael! Guess I should have drunk more coffee before replying.
I must have miss that.
-Original Message-
From: Michael Fuhr [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 11, 2005 11:22 AM
To: Douglas McNaught
Cc: Foster, Stephen; pgsql-general@postgresql.org;
pgsql-sql@postgre
Trying a totally different approach. Simple procedure that I'm using to
use as learn opportunity in stored procedures in PostgreSQL prior to
migrating a complex web site. Call it a training example if you will.
Goal is to learn the correct process of working with cursors on complex
queries in Pos
On Sun, Dec 11, 2005 at 11:38:47AM -0500, Douglas McNaught wrote:
> "Foster, Stephen" <[EMAIL PROTECTED]> writes:
>
> > WHILE (--Lost on variable name for end of query; EmptyQueryResponse <>
> > 0? --)
> > BEGIN
> > IF LastName = fname THEN
> > DELETE FROM Maili
On Sun, Dec 11, 2005 at 01:17:42PM +0100, Hannes Dorbath wrote:
> Is there a practical way to make a guess what language a document is
> written in and auto magically use the adequate TSearch config? I thought
> of looking up the document's words in various dicts and use the one with
> the most
"Foster, Stephen" <[EMAIL PROTECTED]> writes:
> This is one of the simple ones that has me hung up. It currently errors
> out on the first line. Why I have no idea. It looks right to me.
You should show us the error message; most of us are not psychics.
> CREATE FUNCTION sp_removedups() RETURN
Ok, I tried it in that I'm still getting errors. Happy to do so but
well is my errors?
-Original Message-
From: Douglas McNaught [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 11, 2005 10:39 AM
To: Foster, Stephen
Cc: 'Michael Fuhr'; pgsql-general@postgresql.org;
pgsql-sql@postgresql.o
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> On Sun, Dec 11, 2005 at 16:31:59 +0100,
> Frank van Vugt <[EMAIL PROTECTED]> wrote:
>> Ratio: when deferred triggers on table A are used to calculate field values
>> of
>> table B (which then obviously need an update), one might want to prevent
>>
"Foster, Stephen" <[EMAIL PROTECTED]> writes:
> WHILE (--Lost on variable name for end of query; EmptyQueryResponse <>
> 0? --)
> BEGIN
> IF LastName = fname THEN
> DELETE FROM MailingList WHERE id = id;
> END IF;
> LastName :=
Michael,
This is one of the simple ones that has me hung up. It currently errors
out on the first line. Why I have no idea. It looks right to me. One
of the harder ones that I have to work on is on the security
sub-routines to pull together the security rights for a person during
login and I'm
On Sun, Dec 11, 2005 at 16:31:59 +0100,
Frank van Vugt <[EMAIL PROTECTED]> wrote:
>
> Ratio: when deferred triggers on table A are used to calculate field values
> of
> table B (which then obviously need an update), one might want to prevent
> direct updates on these fields of table B
It mig
Please start new threads to ask unrelated questions, rather than replying
to an existing thread. This makes the archives less useful, and may keep
people from seeing your question.
On Sat, Dec 10, 2005 at 15:37:01 -0800,
Benjamin Arai <[EMAIL PROTECTED]> wrote:
> To be more specific, there are
L.S.
I'd like to prevent updates on a specific field when done during regular use
or during the execution of any non-deferred trigger, while allowing them when
done from deferred triggers. (BTW, we're talking version 8.1 here).
Currently there doesn't seem to be a way to know whether code is e
Benjamin Arai wrote:
For the most part the updates are simple one liners. I currently commit
in large batch to increase performance but it still takes a while as
stated above. From evaluating the computers performance during an
update, the system is thrashing both memory and disk. I am curr
Is there a practical way to make a guess what language a document is
written in and auto magically use the adequate TSearch config? I thought
of looking up the document's words in various dicts and use the one with
the most matches.. doesn't matter if performance will be bad.
Any ideas? :)
Th
22 matches
Mail list logo
