Re: Contrib -- PostgreSQL shared variables - Mailing list pgsql-hackers

From Jonathan Gardner
Subject Re: Contrib -- PostgreSQL shared variables
Date
Msg-id 200408271618.37394.jgardner@jonathangardner.net
Whole thread Raw
In response to Contrib -- PostgreSQL shared variables  (pgsql@mohawksoft.com)
Responses Re: Contrib -- PostgreSQL shared variables  (pgsql@mohawksoft.com)
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wednesday 25 August 2004 02:15 pm, pgsql@mohawksoft.com wrote:
> This is a first pass on a simple shared memory variable system for
> PostgreSQL. I would appriciate anyone interested in this functionality to
> rip it apart.
>
> It basically adds this functionality:
>
> SetShared('name', value);
> GetSharedInt('name');
> SetSharedText('name);
> RemovedShared('name');
>
> I also added two extra functions that are sort of a kludge, but could be
> very helpful.
>
> AddSharedInt('name', value);
> SubSharedInt('name', value);
>
> These add or subtect the 'value' from the variable and return the result.

I don't see how this is different from "CREATE TABLE shared_variables (name
VARCHAR PRIMARY KEY, value VARCHAR)" and
inserting/updating/deleting/selecting from that. Perhaps these are
per-session shared variables? IN which case, what is the utility if sharing
them across shared memory?

- --
Jonathan Gardner
jgardner@jonathangardner.net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQFBL8FMqp6r/MVGlwwRAl4KAJ4oC02uGs5IjO0basUCxNPd3/CCqQCfcepL
NLDzKJPINHKK9adjKue2qlQ=
=Z8mP
-----END PGP SIGNATURE-----


pgsql-hackers by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: psql questions: SQL, progname, copyright dates
Next
From: Jon Jensen
Date:
Subject: Re: psql questions: SQL, progname, copyright dates