Re: plpgsql question - Mailing list pgsql-general

From Tom Lane
Subject Re: plpgsql question
Date
Msg-id 20864.1029203927@sss.pgh.pa.us
Whole thread Raw
In response to plpgsql question  ("Andrew Bartley" <abartley@evolvosystems.com>)
List pgsql-general
"Andrew Bartley" <abartley@evolvosystems.com> writes:
> In the plpgsql function I am trying to update this column.

> update    test
> set          "Test Column" = ''test data'';

> The function fails with
> Error: Error while executing the query;

plpgsql doesn't cope with embedded spaces in identifiers, even
when double-quoted :-(

This is fixed as of a couple days ago in development sources, but
until 7.3 comes out you'll have to avoid such names.  Sorry.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: question about upper limit on TEXT size
Next
From: Edmund Dengler
Date:
Subject: Slow deletes