On Sat, Aug 07, 2010 at 08:34:12AM +0100, Richard Huxton wrote: > On 07/08/10 01:13, Joshua Tolley wrote: >> Is there some justification for this behavior that I should know already? It >> seemed awfully strange when some folkds here stumbled on it: > [snip] >> The key point seems to be that the owner of the referenced table has no >> permissions on the table, although the referencing user does. > > Presumably the underlying trigger functions are executing as the owner > of the table. This would make sense in the (more common) case that you > want to reference a table you don't necessarily have full read access > for (e.g. member-id vs the whole row including address/phone).
Yeah, that appears to be what's happening, based on the code. It's certainly confusing to look at, and I'm not sure it couldn't be described a bug. I'll continue to ponder that. -- Joshua Tolley / eggyknap End Point Corporation http://www.endpoint.com
signature.asc
Description: Digital signature
