On Fri, 2010-08-20 at 12:46 +, Lou Picciano wrote:
> Pg Admins,
>
>
> As many of you have done these things already (and yes, I have to dig
> further into the docs...)
>
>
> - Is there a privileges incantation which will limit a user's view,
> within a given cluster, to only those databases
Lou Picciano wrote:
> - Is there a privileges incantation which will limit a user's
> view, within a given cluster, to only those databases to which he
> can connect? Ie, he'd see only the 3 or 4 databases to which he
> has privileges? Does the privileges model permit this level of
> granularity
Pg Admins,
As many of you have done these things already (and yes, I have to dig further
into the docs...)
- Is there a privileges incantation which will limit a user's view, within a
given cluster, to only those databases to which he can connect? Ie, he'd see
only the 3 or 4 databases to
Ouch. My mistake. :(
The copy had of course duplicate data sets, because I trapped errors during its
creation and because of the missing 'WHERE 1=0'.
Sorry,
Peter
--
GMX DSL SOMMER-SPECIAL: Surf & Phone Flat 16.000 für nur 19,99 ¿/mtl.!*
http://portal.gmx.net/de/go/dsl
--
Sent via pgsql-ad
Hello,
I thought I had some experience with plpgsql functions by now. However, when
trying to do this query (generic column/table names):
UPDATE table_a cus SET spalte1 = ( SELECT spalte1 FROM table_a_copy cl WHERE
cl.tabname = cus.tabname );
from within a plpgsql funtion I get the error messa
