Skip site navigation (1) Skip section navigation (2)

"sql_features" does not exist( Very Urgent)

From: <rajaguru(at)rajahsoft(dot)net>
To: Claudio Natoli <claudio(dot)natoli(at)memetrics(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: "sql_features" does not exist( Very Urgent)
Date: 2004-02-26 17:18:29
Message-ID: E1AwP9Z-0000CI-Us@server.yourhostingaccount.com (view raw or flat)
Thread:
Lists: pgsql-patches
<FONT size=2>
<P>Hai,</P>
<P>&nbsp; I create a plpgsql function for grant rights for the postgres users.&nbsp; The same function is working properly in the previous versions. But it gives the following error message.</P>
<P>// Error Message given by the postgres</P>
<P>ERROR:&nbsp; relation "sql_features" does not exist<BR>CONTEXT:&nbsp; PL/pgSQL function "unlockuser" line 6 at execute statement</P>
<P>//***********</P>
<P>//******** Function i created ****************</P>
<P>create or replace function unlockuser(name) returns integer as'</P>
<P>declare</P>
<P>usrname alias for $1;</P>
<P>tablelist record;</P>
<P>begin</P>
<P>for tablelist in select * from pg_tables where tablename not like ''pg_%'' and tablename not like ''pb%'' order by tablename loop</P>
<P>execute ''grant all on ''|| quote_ident(tablelist.tablename)</P>
<P>||'' to ''|| usrname;</P>
<P>end loop;</P>
<P>if not found then</P>
<P>return 0;</P>
<P>end if;</P>
<P>for tablelist in select * from pg_views where viewname not like ''pg_%'' order by viewname loop</P>
<P>execute ''grant all on ''|| quote_ident(tablelist.viewname)||'' to ''|| usrname;</P>
<P>end loop;</P>
<P>if not found then</P>
<P>return 0;</P>
<P>end if;</P>
<P>for tablelist in select * from pg_statio_user_sequences order by relname loop</P>
<P>execute ''grant all on ''|| quote_ident(tablelist.relname)||'' to ''|| usrname;</P>
<P>end loop;</P>
<P>if not found then</P>
<P>return 0;</P>
<P>end if;</P>
<P>return 1;</P>
<P>end;</P>
<P>'language 'plpgsql';</P>
<P>// ******************&nbsp;*****************</P>
<P>Thanks in advance</P></FONT><BR>


Attachment: unknown_filename
Description: text/html (1.6 KB)

Responses

pgsql-patches by date

Next:From: Stephan SzaboDate: 2004-02-26 17:27:04
Subject: Re: "sql_features" does not exist( Very Urgent)
Previous:From: Andrew DunstanDate: 2004-02-26 14:57:03
Subject: log_line_info

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group