"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