From: | Hannu Krosing <hannu(at)tm(dot)ee> |
---|---|
To: | "Robert B(dot) Easter" <reaster(at)comptechnews(dot)com> |
Cc: | Tim Perdue <tperdue(at)valinux(dot)com>, The Hermit Hacker <scrappy(at)hub(dot)org>, pgsql-hackers(at)hub(dot)org |
Subject: | Re: Article on MySQL vs. Postgres |
Date: | 2000-07-05 11:51:39 |
Message-ID: | 3963214B.6298F39E@tm.ee |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
"Robert B. Easter" wrote:
>
>
> While it is slow, I've been able to store unlimited amounts of text into
> the database by using the following code.
Thanks for a really nice exaple !
> I've tested inserting over 4
> megabytes from a TEXTAREA web form using PHP. When inserting such massive
> amounts of text, you will have to wait a while, but it will eventually succeed
> if you don't run out of memory. If you do run out of memory, the backend
> terminates gracefully and the transaction aborts/rollsback.
>
> -- Load the PGSQL procedural language
> -- This could also be done with the createlang script/program.
> -- See man createlang.
> CREATE FUNCTION plpgsql_call_handler()
> RETURNS OPAQUE AS '/usr/local/pgsql/lib/plpgsql.so'
> LANGUAGE 'C';
>
> CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql'
> HANDLER plpgsql_call_handler
> LANCOMPILER 'PL/pgSQL';
You probably meant pl/tcl as all your code is using that ?
---------
Hannu
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 2000-07-05 11:54:35 | Re: Article on MySQL vs. Postgres |
Previous Message | eisentrp | 2000-07-05 11:48:39 | Re: createlang and PGLIB (was Re: [GENERAL] sequential test error) |