Scott Marlowe wrote:
Why not change the keys that currently connect them to something
different (i.e. random noise) and make a NEW table that could join them
with those random keys that is restriced access wise to only the chosen
few.
This might work rather nicely. It would enable us to restrict d
an only use the views and not query the tables directly.
Michael Fuhr wrote:
On Tue, Feb 22, 2005 at 02:51:09PM -0500, Heather Johnson wrote:
Is there a way to revoke permission to join two or more tables, even for
users who have all other permissions (e.g., select, insert, update,
delete) on t
Is there a way to revoke permission to join two or more tables, even for
users who have all other permissions (e.g., select, insert, update,
delete) on those tables?
Heather Johnson
Senior Database Programmer
New York Post
---(end of broadcast
Could you configure the two volumes as one volume with RAID? If so, then
Postgres shouldn't require any special adjusting to accomplish what you
are after.
Heather Johnson
Senior Database Programmer
New York Post
Igor Maciel Macaubas wrote:
Hi Guys,
I have a PostgreSQL server, running
Hi Jodi--
No, you shouldn't have to go to that amount of
trouble. Try this instead (change the name of the table, the default value, the
column name, and the column type to suit your needs):
BEGIN WORK;LOCK
TABLE table_adding_stuff_to IN ACCESS EXCLUSIVE MODE;
ALTER TABLE table_adding_s
It looks like the user you are when you install postgres does not know the
path to your compiler. Try installing gcc and use it instead of cc to
compile postgres. Make sure your user's .profile has the path to gcc before
installing.
Heather
- Original Message -
From: "Allan C. Huffman" <
I'm not sure how to go about doing that Tom. If it doesn't inconveniece you
too much, could you let me know how to go about it?
Heather
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Heather Johnson" <[EMAIL PROTECTED]>
Cc:
Thanks Brandon---that's a very good idea. I'd still like to know why my x86
box can handle the less effecient query better than an E-450, but this is
what I'll do until I can get my curiosity satisfied. ;)
Heather
- Original Message -
From: "bpalmer" <[EM
Thanks! That's also a good idea.
Heather
- Original Message -
From: "Peralta Miguel-MPERALT1" <[EMAIL PROTECTED]>
To: "Heather Johnson" <[EMAIL PROTECTED]>
Sent: Monday, December 10, 2001 5:43 PM
Subject: RE: [ADMIN] problems doing sub-selects on
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Heather Johnson" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; "Harry
Ford" <[EMAIL PROTECTED]>; "Serge
Canizares" <[EMAIL PROTECTED]>; "Marie
Musacchio"
FYI--Here are the table creation statements for the
tables involved in the sample query.
-- user_id_sequenceCREATE SEQUENCE
user_id_sequence INCREMENT 1 START 100;
-- users-- table for basic user
dataCREATE TABLE users (
id
INTEGER NOT NULL PRIMARY KEY --
unique id for
f the x86 box makes it sound like
there is some kind of system problem responsible. Is anyone aware of any
problems with doing subselects in PostgreSQL with Solaris 7? Might there be
other system-related issues or Postgres-related issues responsible for
this? I would appreciate any suggesti
12 matches
Mail list logo
