Skip site navigation (1) Skip section navigation (2)

Re: TYPE of TEMP table does not seem to get set

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bill MacArthur <webmaster(at)dhs-club(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: TYPE of TEMP table does not seem to get set
Date: 2012-04-16 20:11:29
Message-ID: 4379.1334607089@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Bill MacArthur <webmaster(at)dhs-club(dot)com> writes:
> I have a view "configurations.tp_transactions" which is a blend of many tables using INNER and LEFT JOINs. I want to populate a temp table from which I can obtain the data and programmatically write queries to operate on that data using certain PLPGSQL functions in a uniform fashion. I have several functions which all expect a single argument of the type "configurations.tp_transactions".

I think you would need to create the temp table as a child of the main
table for this to work.  As you're doing it, the rowtype of the temp
table is independent of the main (and the fact that they happen to have
the same columns is NOT good enough to make it acceptable to a function
declared to take the main table's rowtype).

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Bill MacArthurDate: 2012-04-16 20:29:00
Subject: Re: TYPE of TEMP table does not seem to get set
Previous:From: Bill MacArthurDate: 2012-04-16 19:46:34
Subject: TYPE of TEMP table does not seem to get set

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group