pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Frederic boucher <dziablo@hotmail.com>
To: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] Accessing other database...
Date: Fri, 05 Nov 1999 07:09:37 PST
Message-ID: <19991105150937.63594.qmail@hotmail.com> (raw)

I'll probably have to do something like that...  But the table will still 
contains the data off all the users.  Since, unlike my first example, there 
will be a lot more than 2 users, the action (update,select,add,delete) will 
be much slower than if only the good records would be in the table.  if I do 
something like :

delete from TheTable;

or

delete from TheTable where User_ID = THE_ID

the first will be faster even with an index on UserID.  And deleting all 
data is a "simple" action...  I'm not talking about more complicated 
actions.

\fb

Thanks for your help and if you have an other idea... don't hesitate!



>
>One thing you might want to do is to create the first (shared) table as you
>do now.  For the second table (different info for each user), create the
>table as you planned but add a column to identify the user.  You can then
>create a view on this second table to filter out rows based on the user's
>login id, so they will only see their own records.
>
>Will this work for your application?
>
>Jim Seach
>
>-----Original Message-----
>From: Frederic boucher <dziablo@hotmail.com>
>To: pgsql-sql@postgreSQL.org <pgsql-sql@postgreSQL.org>
>Date: Friday, November 05, 1999 8:30 AM
>Subject: Re: [SQL] Accessing other database...
>
>
> >Ok so what can I do if I would like 2 user to have two tables.  The first
> >tabl would be a common table for both user (with the same synch data)  
>and
> >the other one would be the same "table_name" but each user would see
> >different records?
> >
> >is this kind of thing possible?
> >
> >\fb
> >
> >Thanks
> >>In-reply-to: Your message of "Thu, 04 Nov 1999 07:36:56 PST."
> >><19991104153657.40198.qmail@hotmail.com>
> >>
> >>Hello,
> >>
> >>It is NOT possible to access another database from a database.
> >>Is the case so specific that you cannot create different databases for 
>the
> >>different groups of users? Doing this, you can fairly easy regulate 
>users'
> >>access to databases through GRANT/REVOKE and pg_hba.conf
> >>
> >>Stoyan Genov
> >>
> >
> >______________________________________________________
> >Get Your Private, Free Email at http://www.hotmail.com
> >
> >************
> >
>
>

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com



view thread (8+ messages)  latest in thread

Message-ID: <19991105150937.63594.qmail@hotmail.com>
Permalink:  ../19991105150937.63594.qmail@hotmail.com/
Also on:    postgresql.org/message-id/19991105150937.63594.qmail@hotmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: dziablo@hotmail.com
  Subject: Re: [SQL] Accessing other database...
  In-Reply-To: <19991105150937.63594.qmail@hotmail.com>
  References: <19991105150937.63594.qmail@hotmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox