Re: [SQL] Handling mutliple clients access with views

2011-10-24 Thread bricklen
On Mon, Oct 24, 2011 at 8:50 PM, Craig Ringer wrote: > > Declarative row-level security (row ownership) would be really nice... > here's hoping the SELinux work can be extended to support a simpler, > OS-agnostic non-SELinux-based row-level RBAC mechanism. > -- > Craig Ringer Veil might do what y

Re: [SQL] Handling mutliple clients access with views

2011-10-24 Thread Craig Ringer
On 25/10/11 11:36, David Johnston wrote: > Except database roles cannot strictly enforce row-level security (i.e., > multiple-tenant) which is the goal of this setup. Ah, yes, if theyr'e relying on _row_ level security then that's very much the case. I misread their post as suggesting that they

Re: [SQL] Handling mutliple clients access with views

2011-10-24 Thread David Johnston
On Oct 24, 2011, at 22:54, Craig Ringer wrote: > On 25/10/11 03:23, Brice André wrote: >> Hello everyone, >> >> I am developping a web service where some tables are handling the data >> of different clients. Depending on configured rights, one client can >> have no access, or read access, or rea

Re: [SQL] Handling mutliple clients access with views

2011-10-24 Thread Craig Ringer
On 25/10/11 03:23, Brice André wrote: > Hello everyone, > > I am developping a web service where some tables are handling the data > of different clients. Depending on configured rights, one client can > have no access, or read access, or read and write access to other > clients data. > > In orde

Re: [SQL] CTE or Subselect and outer joins not behaving as expected?

2011-10-24 Thread bricklen
On Mon, Oct 24, 2011 at 5:46 PM, Joel Stevenson wrote: > Hi all, I'm trying to enumerate a list of months between a date in the past > and now and display a value from an existing table if there is one for the > date or NULL if there isn't. > > I'm using this SQL to generate the months: > > sele

[SQL] CTE or Subselect and outer joins not behaving as expected?

2011-10-24 Thread Joel Stevenson
Hi all, I'm trying to enumerate a list of months between a date in the past and now and display a value from an existing table if there is one for the date or NULL if there isn't. I'm using this SQL to generate the months: select distinct date_trunc( 'month', '2011-06-01'::date + tally_day )::d

Re: [SQL] new user on mac

2011-10-24 Thread Guillaume Lelarge
On Thu, 2011-10-20 at 12:22 +0200, Guillaume Lelarge wrote: > On Wed, 2011-10-19 at 01:13 -0700, Basil Bourque wrote: > [...] > > I may have once had an inexplicable glitch, but after restart all was well. > > I've only been bitten by 2 recurring bugs: > > > > • (Cosmetic) Changing font size for

[SQL] Handling mutliple clients access with views

2011-10-24 Thread Brice André
Hello everyone, I am developping a web service where some tables are handling the data of different clients. Depending on configured rights, one client can have no access, or read access, or read and write access to other clients data. In order to handle that, I am using views and, to ensure that

Re: [SQL] RPostgreSQL Win32 package

2011-10-24 Thread tuan
En réponse à votre message, Jira, Marcel: Hi! 8>< Unfortunately I only found the RPostgreSQL source but couldn’t find a package for Win XP (32 bit). As my user rights are limited, I am also not able to compile the package myself. Therefore I wanted to kindly ask if somebody has already co

[SQL] RPostgreSQL Win32 package

2011-10-24 Thread Jira, Marcel
Hi! I'd like to use the statistics software GNU R (http://www.r-project.org/) as a PostgreSQL client. Currently I use RpgSQL but this package seems to be fitting better for smaller projects. As my project is about really big amounts of data, the package RPostgreSQL (http://code.google.com/p/rpo