View Single Post

   
  #5 (permalink)  
Old 04-12-2008, 05:25 AM
Greg Sabino Mullane
 
Posts: n/a
Default Re: [COMMITTERS] pgsql: Sequences were not being shown due to the use of lowercase `s`


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> SELECT *,has_schema_privilege(oid,'USAGE') FROM pg_namespace;


>> Well, if you test it as a superuser, it's going to return TRUE every
>> time.


Exactly. So I'm not seeing how we can use USAGE as a reliable test for
the case where a temporary table was created by the same user, but in
another session.

- --
Greg Sabino Mullane greg@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200609041941
http://biglumber.com/x/web?pk=2529DF...9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFE/LsJvJuQZxSWSsgRAt5mAKDWAWmnljELeRJn+LvdAnpfkwhDIwC fSls8
hR0xST8C88uA4xXrEP6pAh0=
=bHRd
-----END PGP SIGNATURE-----



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply With Quote