| From: | Catalin Iacob <iacobcatalin(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Adam Brightwell <adam(dot)brightwell(at)crunchydatasolutions(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, dinesh kumar <dineshkumar02(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: proposal: multiple psql option -c |
| Date: | 2015-11-25 16:13:23 |
| Message-ID: | CAHg_5gpW5Af5y32_DKvzboDSNJrFrBM2YsdMv78hn+ckKXv64Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Nov 18, 2015 at 5:49 PM, Catalin Iacob <iacobcatalin(at)gmail(dot)com> wrote:
> On Tue, Nov 17, 2015 at 10:13 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> 1. -c no longer implies --no-psqlrc. That's a backwards incompatibility,
>> but very easy to explain and very easy to work around.
>>
>> 2. You can have multiple -c and/or -f. Each -c is processed in
>> the traditional way, ie, either it's a single backslash command
>> or it's sent in a single PQexec. That doesn't seem to me to have
>> much impact on the behavior of adjacent -c or -f.
>>
>> 3. If you combine -1 with -c and/or -f, you get one BEGIN inserted
>> at the beginning and one COMMIT at the end. Nothing else changes.
> I'll try to write the documentation patch for these semantics sometime
> next week.
Attached is my attempt at a documentation patch, feedback welcome. I'm
assuming Pavel will pick up the implementation, if not I could also
try it.
| Attachment | Content-Type | Size |
|---|---|---|
| Update-docs-for-repeated-c.patch | binary/octet-stream | 8.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Janes | 2015-11-25 17:29:22 | Re: GIN pending list clean up exposure to SQL |
| Previous Message | Tom Lane | 2015-11-25 16:12:25 | Re: New email address |