Re: Article on MySQL vs. Postgres

"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