Hi
I wanted to create a user who can create other users. But this causes
some problems:
* I did not find any CREATE USER system privilege. So I have to create
the first user as Superuser? What I do not want!
--> Is this correct?
* So I decided to write a function owned by a superuser which can
Hi
Again boring admin question:
I found that all users have access to pg_class etc. by default. In my
opinion this causes some security questions or at least can make users
curious about things they should not.
e.g. SELCT * FROM pg_tables where table_name like '%customer_accountings%';
Probab
Oli Sennhauser <[EMAIL PROTECTED]> writes:
> I wanted to create a user who can create other users.
That is a superuser.
> --> Why does CREATE USER $1 fail???
You need to use EXECUTE to construct this query as a string.
Utility statements in general don't handle parameters.
Oli Sennhauser <[EMAIL PROTECTED]> writes:
> I found that all users have access to pg_class etc. by default. In my
> opinion this causes some security questions or at least can make users
> curious about things they should not.
This isn't going to change, because it would break too many clients
- Original-Nachricht
Von: Tom Lane <[EMAIL PROTECTED]>
An: Stefan Holzheu <[EMAIL PROTECTED]>
Cc: ADMIN <[EMAIL PROTECTED]>
Betreff: Re: [ADMIN] plperl does not build on RH7.1
Datum: 22/12/03 00:34
Thanks, Tom. I will try after Christmas.
>
> You need this patch:
>
> 2003-11-24
I missed a constraint the last time that I loaded my database. Can I
add an additional constraint without having to drop and rerun the table?
If not, can I do just that one table without having to do the entire
schema?
Jodi
--
__
On Sat, 20 Dec 2003, C. Bensend wrote:
>
> >> pg_dumpall seems to do this for me, without any command-line args
> >> needed. Am I correct in saying that 'pg_dumpall > filename' will
> >> produce
> >> a PostgreSQL dump that includes _everything_ I need to go from a clean
> >> PG install to acce
Dear all,
Before reading all this let me assure you nothing is out of control just
DONT PANIC
I was just going through the pages of http://www.2038.org
and was concerned by the fact my computer using Linux will rollover to
Fri Dec 13 20:45:52 1901
after
Tue Jan 19 03:14:07 2038
Now thi
You should probably read about the specifics in the documentation
(see http://www.postgresql.org/docs/)
But you could use something like (e.g.)
ALTER TABLE ONLY question_category
ADD CONSTRAINT question_category_external_id_key UNIQUE (external_id);
which adds a UNIQUE
