Search Postgresql Archives

Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Wed, 23 Nov 2016 10:44:14 -0500
Cc: Poul Kristensen <bcc5226@xxxxxxxxx>, John McKown <john.archie.mckown@xxxxxxxxx>, PostgreSQL General <pgsql-general@xxxxxxxxxxxxxx>
Comments: In-reply-to "David G. Johnston" <david.g.johnston@xxxxxxxxx> message dated "Wed, 23 Nov 2016 08:25:38 -0700"
In-reply-to: <CAKFQuwb-iiuL6x0kwbrWJ_suenCpN8UQ-HuO+xx+N_GXT7m=Xg@mail.gmail.com>
References: <CAAOuvVq-2PPmweM7MJornOk-qnedwtdUM_hHbMQhmJg=ORAJYQ@mail.gmail.com> <CAAJSdjinub7JGjZtDo7q7CnJq627O6vdnusudJ3h-QdQZVbrYQ@mail.gmail.com> <CAAOuvVqhAu=U-S6N59==mPFNMctFEiM5+-xK-JB75Rb5SrqYZw@mail.gmail.com> <CAAJSdji024ecwvCreTviPpO4KPGTw=AB=yPe1cE=NtvmTcKDMA@mail.gmail.com> <CAAOuvVrK17P9y_PpdH1vQV958nAxVnz=khD2NOMagHvLOMfNrg@mail.gmail.com> <CAAJSdjgOSYikk_y8K3afJP8zxGbZqrh8BOkrLhV8Dk4hpsqnrQ@mail.gmail.com> <CAAOuvVoEEJpM60UNyJR6DU=Ezf56a8R9yzMrzi_tDCwT88ofWQ@mail.gmail.com> <CAKFQuwb-iiuL6x0kwbrWJ_suenCpN8UQ-HuO+xx+N_GXT7m=Xg@mail.gmail.com>

"David G. Johnston" <david.g.johnston@xxxxxxxxx> writes:
> On Wed, Nov 23, 2016 at 3:46 AM, Poul Kristensen <bcc5226@xxxxxxxxx> wrote:
>> In the postgresql.log I get "select datname from $1".

> That is expected when you parameterize a query - the query string includes
> parameters instead of values.

It looks like Poul is hoping to use a parameter as a table name,
which doesn't work.  Parameters can only represent values (constants).

			regards, tom lane


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used
  - From: Poul Kristensen

References:
- Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used
  - From: Poul Kristensen
- Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used
  - From: John McKown
- Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used
  - From: John McKown
- Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used
  - From: Poul Kristensen
- Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used
  - From: John McKown
- Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used
  - From: Poul Kristensen
- Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used
  - From: David G. Johnston

Prev by Date: Re: query locks up when run concurrently
Next by Date: Methods to quiesce PostgreSQL DB without configuring log archival
Previous by thread: Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used
Next by thread: Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]