[BUGS] Error in returning setof records

2006-04-27 Thread Anjali Arora
Hi all, when i am returning function as setof record then it will give error "ERROR: set-valued function called in context that cannot accept a set CONTEXT: PL/pgSQL function "gfs_ls" while casting return value to function's return type" plz help me to get rid of it -- With Regards, Anjali Aro

Re: [BUGS] BUG #2406: Not all systems support SHM_SHARE_MMU

2006-04-27 Thread Paul van der Zwan
On 25-apr-2006, at 16:46, Tom Lane wrote: Paul van der Zwan <[EMAIL PROTECTED]> writes: AFAIK getpagesizes() appeared in 2001 so that probably means it is missing in anything before Solaris 9. We could handle this without relying on getpagesizes() by just trying and falling back: #ifdef SHM

Re: [BUGS] BUG #2406: Not all systems support SHM_SHARE_MMU

2006-04-27 Thread Paul van der Zwan
On 25-apr-2006, at 20:34, Tom Lane wrote: Paul van der Zwan <[EMAIL PROTECTED]> writes: On 25-apr-2006, at 16:46, Tom Lane wrote: AFAICS, SHM_SHARE_MMU has no guaranteed semantic effect anyway, it's just a performance hint; so ignoring it on platforms that can't handle it is reasonable. I d

Re: [BUGS] Error in returning setof records

2006-04-27 Thread Richard Huxton
Anjali Arora wrote: Hi all, when i am returning function as setof record then it will give error "ERROR: set-valued function called in context that cannot accept a set CONTEXT: PL/pgSQL function "gfs_ls" while casting return value to function's return type" This is not a bug - see the manuals