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

From W. Matthew Wilson
Subject Re: How to insert either a value or the column default?
Date
Msg-id CAGHfCUDme7mQixru2_gRbif6kcLLaf3SQBQMTitPHmcsrLa4xw@mail.gmail.com
Whole thread Raw
In response to Re: How to insert either a value or the column default?  (Daniele Varrazzo <daniele.varrazzo@gmail.com>)
Responses Re: How to insert either a value or the column default?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
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?

Thanks again!


pgsql-general by date:

Previous
From: Marc Mamin
Date:
Subject: Re: Way to identify the current session's temp tables within pg_class ?
Next
From: Sameer Thakur
Date:
Subject: Re: Using fmgr_hook