| From: | Ivan <iv(at)psycho(dot)pl> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Few Simple Questions |
| Date: | 2003-02-27 20:05:57 |
| Message-ID: | Pine.LNX.4.44.0302272103490.3726-100000@rex.anfa.pl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
HI
how can i get user ip, who can only connect by tcp/ip , for example in
plpgsql function . ??
how can declare and define my own variables in each connect to db, and
read it / or change it in plpgsql function ?
is possible to create this same name of users in one postmaster but in
different db ?
how to change default grant to created objects, (tables ,functions, etc) ?
where can i change max length of function's name ? its can be only in one
place ?
how can i return more then 1 row in one time in function with SETOF
same_type; (plpgsql) like : RETURN NEXT SELECT f FROM BIG_TABLE ;
how to disallow user to create anything, user for example can select from
same function. this user also can not see others databases and objects in
actual db .. etc ( it should be default ?? ) ?
how set default value of function's args.
Can someone help me with this problems ?
thx :>
bye
ivan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Cornelia Boenigk | 2003-02-27 20:25:21 | PostgreSQL vs. Cache |
| Previous Message | Andrew Sullivan | 2003-02-27 19:57:30 | Re: 7.4? |