Re: [GENERAL] 8.1 removed functions

2006-01-01 Thread Michael Fuhr
On Wed, Dec 28, 2005 at 05:34:47PM -0800, [EMAIL PROTECTED] wrote: > With PG 8.0 I was using a query using makeaclitem() and aclcontains() > to extract permissions. Here is a sample query for database > permissions ... [...] > What is the recommended manner to extract object permissions for 8.1 >

Re: [GENERAL] 8.1 removed functions

2006-01-01 Thread nielsgron
Hi Tom, With PG 8.0 I was using a query using makeaclitem() and aclcontains() to extract permissions. Here is a sample query for database permissions ... SELECT ((grantee.name)::character varying) AS grantee, ((nc.datname)::character varying)AS database, (pr."

Re: [GENERAL] 8.1 removed functions

2005-12-05 Thread Tom Lane
=?UTF-8?B?0JDQvdC00YDQtdC5?= <[EMAIL PROTECTED]> writes: > Can someone answer - why in PostgreSQL 8.1 have been removed such > functions as 'makeaclitem(...)' and > 'information_schema.pg_keypositions()'. Because code using them would be broken anyway by other changes in 8.1 --- for example,

[GENERAL] 8.1 removed functions

2005-12-05 Thread Андрей
Hello! Can someone answer - why in PostgreSQL 8.1 have been removed such functions as 'makeaclitem(...)' and 'information_schema.pg_keypositions()'. Are there any similar functions now and where can I find the list of all deprecated functions?