Skip site navigation (1) Skip section navigation (2)

Re: Inserting values into a variable table

From: "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Cc: "Greg Quinn" <greg(at)officium(dot)co(dot)za>, "Stephan Szabo" <sszabo(at)megazone(dot)bigpanda(dot)com>
Subject: Re: Inserting values into a variable table
Date: 2006-11-25 23:00:50
Message-ID: b35603930611251500hd78af44gcc4865f3c98e9db6@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On 11/26/06, Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> wrote:

> You may consider seeing whether or not there's another way to lay out
> the data as well that might be easier to work with.
I'm with Stephan on this one - I'd say that having all mail in one
table, and using the "random string" that denominates the inbox
to select the messages on a per user basis.  Makes the code
to handle things much cleaner, and I can't see a security (or
other) benefit in the separate tables.


Cheers

In response to

Responses

pgsql-novice by date

Next:From: operationsengineer1Date: 2006-11-26 00:47:44
Subject: Re: Integer Question - Does Limit Value Make Sense
Previous:From: Stephan SzaboDate: 2006-11-25 22:48:30
Subject: Re: Inserting values into a variable table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group