From: Andrew Dunstan <andrew@dunslane.net>
To: Josh Berkus <josh@agliodbs.com>
Cc: Pavel Stehule <pavel.stehule@gmail.com>
Cc: Dimitri Fontaine <dfontaine@hi-media.com>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-hackers@postgresql.org, Nikhil Sontakke <nikhil.sontakke@enterprisedb.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Petr Jelinek <pjmodos@pjmodos.net>
Cc: Stephen Frost <sfrost@snowman.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: GRANT ON ALL IN schema
Date: Sat, 15 Aug 2009 18:36:54 -0400
Message-ID: <4A873886.5020209@dunslane.net> (raw)
In-Reply-To: <4A871F46.1040002@agliodbs.com>
References: <4A37BF63.50008@pjmodos.net>
<603c8f070908050951s3e5df452se4c610f01b80bb7d@mail.gmail.com>
<21246.1249491592@sss.pgh.pa.us>
<200908101042.35024.peter_e@gmx.net>
<4A7FE7F902000025000296E3@gw.wicourts.gov>
<4A803A89.9020509@dunslane.net>
<2CCE9C1D-919D-45D5-BFC2-C7723C45064E@hi-media.com>
<162867790908150434j7aef36ecm202e81c4bb4740fa@mail.gmail.com>
<4A86B5D5.6060807@dunslane.net>
<4A871F46.1040002@agliodbs.com>
Josh Berkus wrote:
>> I'm also not sure I want to be trying to execute any arbitrary string
>> that accidentally gets placed there because someone forgot to put a
>> keyword or accidentally deleted it.
>>
>> But I'm not too dogmatic on the subject. What do others think?
>>
>
> Given that $$ is also used to quote non-procedural strings, I don't like
> the idea that psql would be trying to execute any string I gave it after
> forgetting "select". If nothing else, that would lead to confusing and
> misleading error messages.
>
> Ideally, we'd be able to execute *any* PL that way by setting a shell
> variable:
>
> \pl plperl
> DO $f$ foreach ( @_ ) { ...
>
>
>
I think you have misunderstood.
I am not talking at all about doing this in psql. It would be built into
the server's SQL so you could use any client, and the default language
would be a GUC as Tom suggested upstream.
cheers
andrew
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: andrew@dunslane.net, josh@agliodbs.com, pavel.stehule@gmail.com, dfontaine@hi-media.com, Kevin.Grittner@wicourts.gov, peter_e@gmx.net, nikhil.sontakke@enterprisedb.com, robertmhaas@gmail.com, pjmodos@pjmodos.net, sfrost@snowman.net, tgl@sss.pgh.pa.us
Subject: Re: GRANT ON ALL IN schema
In-Reply-To: <4A873886.5020209@dunslane.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox