Re: How to insert either a value or the column default? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: How to insert either a value or the column default?
Date
Msg-id 53FB47A8.5080100@aklaver.com
Whole thread Raw
In response to Re: How to insert either a value or the column default?  ("W. Matthew Wilson" <matt@tplus1.com>)
Responses Re: How to insert either a value or the column default?  (Daniele Varrazzo <daniele.varrazzo@gmail.com>)
List pgsql-general
On 08/25/2014 06:32 AM, W. Matthew Wilson wrote:
> On Sun, Aug 24, 2014 at 2:50 PM, Daniele Varrazzo
> <daniele.varrazzo@gmail.com> wrote:
>> It should be added to the library (it was first discussed in 2003...),
>> but it's one of these things that will stop working when psycopg will
>> start using the "extended query protocol" (together with other nifty
>> features such as string literals for table/columns names) so in my
>> mind it can only be included when psycopg will be able to do both
>> client-side parameter interpolation and server-side arguments passing,
>> and when the distinction between the two strategies will be clear
>> (this is planned for a future psycopg3 but there is no timeline for it
>> yet).
>
> First of all, thanks for showing this trick!
>
> But I am confused.  Will this trick stop working in a future version
> of psycopg2?  Should I avoid using it?

Here is the email laying out the issues:

http://www.postgresql.org/message-id/AANLkTi=ym3SCQKCQBtp8RJHUswwAPOpjXYKTXS=aHWzp@mail.gmail.com



>
> Thanks again!
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Emanuel Calvo
Date:
Subject: Re: Constraint exclusion on tables partitioned over range types
Next
From: Daniele Varrazzo
Date:
Subject: Re: How to insert either a value or the column default?