On Fri, 2010-03-05 at 17:39 -0500, John A. Sullivan III wrote:
> On Fri, 2010-03-05 at 14:13 -0800, Bob Lunney wrote:
> >
> > --- On Fri, 3/5/10, John A. Sullivan III
> > wrote:
> >
> > > From: John A. Sullivan III
> > > Subject: [ADMIN] Quer
On 03/05/2010 08:44 PM, John A. Sullivan III wrote:
On Fri, 2010-03-05 at 19:59 +, Daniel J. Summers wrote:
On 03/05/2010 07:44 PM, John A. Sullivan III wrote:
I'm trying to avoid making a thousand call like
select user1.session_id from user1.sessions;
when I could do it in a si
On Fri, 2010-03-05 at 14:13 -0800, Bob Lunney wrote:
>
> --- On Fri, 3/5/10, John A. Sullivan III
> wrote:
>
> > From: John A. Sullivan III
> > Subject: [ADMIN] Querying the same column and table across schemas
> > To: pgsql-admin@postgresql.org
> >
--- On Fri, 3/5/10, John A. Sullivan III wrote:
> From: John A. Sullivan III
> Subject: [ADMIN] Querying the same column and table across schemas
> To: pgsql-admin@postgresql.org
> Date: Friday, March 5, 2010, 2:44 PM
> Hello, all. I'm working on a
> project using t
On Fri, 2010-03-05 at 19:59 +, Daniel J. Summers wrote:
> On 03/05/2010 07:44 PM, John A. Sullivan III wrote:
> > I'm trying to avoid making a thousand call like
> >
> > select user1.session_id from user1.sessions;
> >
> > when I could do it in a single query especially since the database is
>
On 03/05/2010 07:44 PM, John A. Sullivan III wrote:
I'm trying to avoid making a thousand call like
select user1.session_id from user1.sessions;
when I could do it in a single query especially since the database is
remote and secured with SSL.
CREATE VIEW all_sessions AS
SELECT user1.sessi
Hello, all. I'm working on a project using the X2Go terminal server
project (www.x2go.org). They record session data in a postgresql
database. Our environment is a little more secure than typical and we
do not want it possible for one user to see another's session data. We
thus have divided the
