How do I prevent users from seeing the names of tables/structure of tables
on which they do not have permission to perform operations. I would like
to make the database appear, to clients, to only contain the view to which
they have permissions, and nothing else.
Hi,
I have the following situation:
I AM USING THE C LANGUAGE INTERFACE (LIBPQ) but I
have also tried the situation described below from
within psql and got the same results.
I am using PostgreSQL version 6.4.
- I Have to keep a cursor for a select * from table1
open most of the time
Greetings,
I'm having problems with what I believe to be a simple query and I assume
that either there is a bug in PostgreSQL in handling functions during a
select or I'm doing something very stupid.
I have a table of words and abbreviations where the word is being
used as a primary key.
Hello all,
I have quite strange problem.
I have one table for lots of dicts:
CREATE TABLE dicts (
id serial,
type int4,
name text
);
And dicts_type table with textual description of types. Don't blame me... I know that
this is not
fast. I just try to be as close as the
Hi Travis,
I know this is not what you're asking for, and I
imagine you have already thought of this, but just
in case . . .
You could add an extra column to each of your
tables. These columns would be populated by a
procedure that runs through the existing recordset
and assigns sequential
John Cochran [EMAIL PROTECTED] writes:
John Cochran [EMAIL PROTECTED] writes:
Why isn't the upper() function working in the first query?
Odd. You aren't by some chance working in a non-ASCII locale where
"upper('Boulevard')" yields something besides 'BOULEVARD', are you?
Nope, using the
test
I'm Your Handiman -Online- wrote:
test
kewl i'm in..sorry all for the test...:(
anywayjust installed postgresSQL 7.0 and everything took fine
is this normal?
[postgres@localhost postgres]$ /usr/local/pgsql/bin/postmaster -D
/usr/local/pgsql/data
DEBUG: Data Base System is
On Mon, 12 Jun 2000, I'm Your Handiman -Online- wrote:
# test
#
# kewl i'm in..sorry all for the test...:(
# anywayjust installed postgresSQL 7.0 and everything took fine
It's OK to just post your question, the test is kinda redundant if
you're going to ask a question
Is there a source distribution to install just psql? What I'm looking
for is a quick and easy way to install psql and DBD::Pg (which needs
libpq) on a bunch of different unix client machines.
I realize that all the source is there in the main postgresql
distribution but I can't make heads or
hi,
we have a 34 million row table. after many inserts, updates, deletes
the performance degraded so we vacuumed the table. the output indicated
that the index was also vacuumed but the size didn't change. it was still
80m so we dropped and recreated it reducing it to 20m. no big deal but
#create group "users";
CREATE GROUP
#create user "user1" with password 'pass1' in group "users";
CREATE USER
#create user "user2" with password 'pass2' in group "users";
CREATE USER
#create user "user3" with password 'pass3' in group "users";
CREATE USER
.
#create user "user2012" with
mikeo [EMAIL PROTECTED] writes:
we have a 34 million row table. after many inserts, updates, deletes
the performance degraded so we vacuumed the table. the output indicated
that the index was also vacuumed but the size didn't change. it was still
80m so we dropped and recreated it
John Daniels wrote:
(After I have installed 7.0.2, I will send a diff and comments to the port
maintainer to help him when he updates the port.)
John,
Since Andreas is busy for so long, I'd suggest you send-pr your
patches so people can upgrade postgres before he gets back and
commits
Toast will be in 7.1, scheduled for August.
[ Charset ISO-8859-1 unsupported, converting... ]
As part of the Fmaps project (Fmaps.sourceforge.net), Eric Miller is
developing some new geographic types for Postgres. We have several questions
relating to the implementation of new types, variable
15 matches
Mail list logo