Quick Links

Re: Using row_to_json with %ROWTYPE ?

From:	Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To:	Tim Smith <randomdev4+postgres(at)gmail(dot)com>, David Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc:	pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject:	Re: Using row_to_json with %ROWTYPE ?
Date:	2015-02-05 23:58:22
Message-ID:	54D4039E.6070206@aklaver.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

On 02/05/2015 03:25 PM, Tim Smith wrote:
>> PostgreSQL doesn't lie
>
> Well if its not lying its one big stinking bug !

In my experience Postgres does not randomly make up error messages.
Somewhere it is seeing a duplicate column.

>
> How about you tell me where you see these duplicate columns in my view
> that PostgreSQL is apparently not lying to me about ....
>

So then this is not the problem, which moves the troubleshooting to the
function.

Have you tried the previous suggestions on modifying the function?

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

	From	Date	Subject
Next Message	Adrian Klaver	2015-02-06 00:02:52	Re: Using row_to_json with %ROWTYPE ?
Previous Message	Tom Lane	2015-02-05 23:50:03	Re: Using row_to_json with %ROWTYPE ?