Thomas Hallgren <[EMAIL PROTECTED]> writes: > Peter Eisentraut wrote: >> You can use GetUserId() and SetUserId() to flip the current user >> identity around as you like. For such a simple query, however, it >> might seem better to bypass SPI altogether and do a straight table >> lookup through lower-level functions. >> > Brilliant! I had no idea it was that simple.
Well, it's not. Exactly what are you going to flip it *to*? You can't hardwire a particular userid and expect to have a robust solution. I'd recommend the lower-level approach myself. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings