Re: Inconsistent compilation error

On 04/25/2018 05:33 AM, raf wrote: Adrian Klaver wrote: On 04/18/2018 06:02 PM, r...@raf.org wrote: Hmm, wonder if there is an oops in the below: http://www.pygresql.org/contents/changelog.html Version 5.0 (2016-03-20) Changes in the DB-API 2 module (pgdb): "SQL commands are always

Re: Inconsistent compilation error

Adrian Klaver wrote: > On 04/18/2018 06:02 PM, r...@raf.org wrote: > > Hi, > > > > > > > But I'm getting this compilation error when it tries to load this > > function: > > > > ERROR: too many parameters specified for RAISE > > CONTEXT: compilation of PL/pgSQL function

Re: Inconsistent compilation error

Adrian Klaver wrote: > On 04/18/2018 06:02 PM, r...@raf.org wrote: > > Hi, > > > > postgresql-9.5.12 on debian-9 > > > > I have a stored function with code that looks like: > > > > create or replace function tla_audit_delete_thing() > > returns boolean stable language plpgsql as $$ >

Re: Inconsistent compilation error

David G. Johnston wrote: > On Wed, Apr 18, 2018 at 7:04 PM, Melvin Davidson > wrote: > > > > > Normally, literals are inside the first quotes. IE: raise notice ' > > blah_history.original_id' %', r; > > > > ​But a compiler doesn't care about human concepts like "normally"

Re: Inconsistent compilation error

Tom Lane wrote: > r...@raf.org writes: > > I have a stored function with code that looks like: > > > raise notice '% %', 'blah_history.original_id', r; > > > But I'm getting this compilation error when it tries to load this > > function: > > > ERROR: too many parameters

Re: Inconsistent compilation error

On Thu, Apr 19, 2018 at 8:13 AM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wednesday, April 18, 2018, Adrian Klaver > wrote: >> >> Hmm, wonder if there is an oops in the below: >> >> http://www.pygresql.org/contents/changelog.html >> >> Version 5.0

Re: Inconsistent compilation error

On Wednesday, April 18, 2018, Adrian Klaver wrote: > > Hmm, wonder if there is an oops in the below: > > http://www.pygresql.org/contents/changelog.html > > Version 5.0 (2016-03-20) > Changes in the DB-API 2 module (pgdb): > "SQL commands are always handled as if they

Re: Inconsistent compilation error

On 04/18/2018 06:02 PM, r...@raf.org wrote: Hi, But I'm getting this compilation error when it tries to load this function: ERROR: too many parameters specified for RAISE CONTEXT: compilation of PL/pgSQL function "tla_audit_delete_thing" near line 9 Traceback (most

Re: Inconsistent compilation error

On 04/18/2018 06:02 PM, r...@raf.org wrote: Hi, postgresql-9.5.12 on debian-9 I have a stored function with code that looks like: create or replace function tla_audit_delete_thing() returns boolean stable language plpgsql as $$ declare r record; status boolean

Re: Inconsistent compilation error

On Wed, Apr 18, 2018 at 7:04 PM, Melvin Davidson wrote: > > Normally, literals are inside the first quotes. IE: raise notice ' > blah_history.original_id' %', r; > ​But a compiler doesn't care about human concepts like "normally" - it just cares about "syntactically

Re: Inconsistent compilation error

On 19 April 2018 at 13:28, Melvin Davidson wrote: > It is not fine. You have specifed TWO percent signs (%) which requires TWO > argumenrts, > but you have only provided ONE -> r. I'm confused about this statement. Did you perhaps overlook the fact that there are in fact

Re: Inconsistent compilation error

On Wed, Apr 18, 2018 at 9:02 PM, wrote: > Hi, > > postgresql-9.5.12 on debian-9 > > I have a stored function with code that looks like: > > create or replace function tla_audit_delete_thing() > returns boolean stable language plpgsql as $$ > declare > r record;

Inconsistent compilation error

Hi, postgresql-9.5.12 on debian-9 I have a stored function with code that looks like: create or replace function tla_audit_delete_thing() returns boolean stable language plpgsql as $$ declare r record; status boolean := 1; begin for r in select _.* from