Hi guys,
I have a fairly big PostgreSQL 7.4.0 database running here and I am currently busy managing the rights of the different database users. I have a lot of tables, vieuws, sequences etc.
If I use Grant / Revoke to manage user rights, I have to name all of the different tables/views to grant or
On Wednesday 18 February 2004 13:38, Alexander Priem wrote:
> Is there a way in which I can give rights to a user for a set of
> tables/views/sequences WITHOUT having to name all of the
> table/view/sequence names?
You can use schemas. Just put everything under schema and grant user rights to
the
Thanks for your reply.I already have all the tables/views/sequences set up and filled. Can I create a new schema and 'assign' the existing tables/views/sequences to this new schema? Will this affect current queries I have created?Kind regards,Alexander Priem.> On Wednesday 18 February 2004 13:38, A
On Wednesday 18 February 2004 08:45, Shridhar Daithankar wrote:
> On Wednesday 18 February 2004 13:38, Alexander Priem wrote:
> > Is there a way in which I can give rights to a user for a set of
> > tables/views/sequences WITHOUT having to name all of the
> > table/view/sequence names?
>
> You can
You could try something like this:
Assuming you are using perl+DBI (as per your examples).
If you are using modperl:
[modperl can override the "connect to db" for connection reuse/pooling]
begin cgi web app:
connect to db
rollback
do stuff
do more stuff
commit if ok
by default rollback
disconnect
At 04:14 PM 2/17/2004 -0700, scott.marlowe wrote:
custom type (hex, foobar, etc...) from one to another. What this means
too you, the user, is that:
create table test (id int8, info text);
select * from test where id=456;
will result in a sequential scan. Why? Because the default integer type
i
the reason I ask is I have always used postgres at home and work, but my new
web host only has mysql :(
I want to know what sort of differences I will have in regards to
programming php/perl webpages using the database.
I current use sequences in postgres and understand this will be different in
On 18/02/2004 11:50 Mark Cubitt wrote:
the reason I ask is I have always used postgres at home and work, but my
new
web host only has mysql :(
I want to know what sort of differences I will have in regards to
programming php/perl webpages using the database.
I current use sequences in postgres and
On Wednesday 18 February 2004 11:50, Mark Cubitt wrote:
> the reason I ask is I have always used postgres at home and work, but my
> new web host only has mysql :(
>
> I want to know what sort of differences I will have in regards to
> programming php/perl webpages using the database.
Perhaps your
I have this table
content (id int8,owner int8,position int8,timestamp int8,description text,batch int8)
Table is inserted/deleted frequently, 'id' is almoust random.
I insert to the table following set of rows :
12345, 1000,1,timestamp,blabla,0
12349, 1000,2,timestamp,blabla,0
12355, 1001,
On Wed, 2004-02-18 at 06:50, Mark Cubitt wrote:
> the reason I ask is I have always used postgres at home and work, but my new
> web host only has mysql :(
>
> I want to know what sort of differences I will have in regards to
> programming php/perl webpages using the database.
>
> I current use s
On Wednesday 18 February 2004 12:56, NTPT wrote:
> I have this table
>
> content (id int8,owner int8,position int8,timestamp int8,description
> text,batch int8)
>
> Table is inserted/deleted frequently, 'id' is almoust random.
>
> I insert to the table following set of rows :
>
> 12345, 1000,1,tim
cheers everybody for the help, I think I can do what I need with mysql, but
would much prefer postgres.
> There's a little voice telling me this is a troll, but in case not
a just another quick question, "troll" ???
Thanks in advance
Regards
Mark Cubitt
---(end of bro
i On Mon, 2004-02-16 at 14:26, Simone Crider wrote:
> Could you please tell me where I would find the GPG MD5 Checksum values
> for the postgres 7.4?
>
http://www.gtsm.com/postgres_sigs.html
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
-
Lincoln Yeoh wrote:
At 04:14 PM 2/17/2004 -0700, scott.marlowe wrote:
custom type (hex, foobar, etc...) from one to another. What this means
too you, the user, is that:
create table test (id int8, info text);
select * from test where id=456;
will result in a sequential scan. Why? Because the de
> the reason I ask is I have always used postgres at home and work, but my new
> web host only has mysql :(
Have you tried asking them to support postgreSQL? A client of mine had to
switch ISP's rather abruptly last fall, in the middle of a lengthy project
to convert them to postgreSQL from a le
Dear All,
I have been using postgresql-autodoc with great results, however, recently I
have been getting a "segmentation fault" when using it.
I contacted the author of autodoc, who said that it appears to be a debian
problem (other debian users have experienced the same problems). However,
si
On Wed, 2004-02-18 at 09:20, Mark Cubitt wrote:
> cheers everybody for the help, I think I can do what I need with mysql, but
> would much prefer postgres.
>
> > There's a little voice telling me this is a troll, but in case not
>
> a just another quick question, "troll" ???
>
http://info.astri
Mike Nolan <[EMAIL PROTECTED]> writes:
> MySQL's poor implementation of the 'alter table' process.
Interesting you should say that, because for years we were getting beat
up regularly about how poor our ALTER capabilities were compared to
MySQL's. Have we really passed them up in ALTER flexibilit
Tom Lane wrote:
Mark Kirkwood <[EMAIL PROTECTED]> writes:
So it seems to me that there is nothing to be gained using a 64-bit
binary with the current or previous Pg releases. However, with the new
cache replacement system being used in 7.5devel, the situation *may* be
different (wonder if anyon
Hello,
i'm quite a newbie using postgres 7.2 so this may be an easy question, but how do i
add new funtionality? I mean, i wanna add a couple of new functions, and i've found
this files, pg_proc.h and fmgrtab.c, but i don't know the meaning of the fields, so i
can't add anything.
For instance,
> Interesting you should say that, because for years we were getting beat
> up regularly about how poor our ALTER capabilities were compared to
> MySQL's. Have we really passed them up in ALTER flexibility? Or is
> there some other limitation you are thinking of?
I wasn't commenting on the flexi
That stuff defines the pg_proc table. Generally you use the CREATE FUNCTION
command to add functions. It takes care of all these details for you :)
\d pg_proc might give you some info.
On Wed, Feb 18, 2004 at 11:49:39AM -0500, Fernando Alonso Renault wrote:
> Hello,
>
> i'm quite a newbie using
I read about the CREATE FUNCTION command, but the problem is that i must do it the
hard way (orders are orders :( ). i learnt to do it like that in mysql, by using the
CREATE FUNCTION and by adding the lines to the different files, but know i must do it
adding the lines.
i tried downloading a co
On Wed, 18 Feb 2004, Lincoln Yeoh wrote:
> At 04:14 PM 2/17/2004 -0700, scott.marlowe wrote:
> >custom type (hex, foobar, etc...) from one to another. What this means
> >too you, the user, is that:
> >
> >create table test (id int8, info text);
> >
> >select * from test where id=456;
> >
> >will
Fernando Alonso Renault <[EMAIL PROTECTED]> writes:
> i'm quite a newbie using postgres 7.2 so this may be an easy question, but how do i
> add new funtionality? I mean, i wanna add a couple of new functions, and i've found
> this files, pg_proc.h and fmgrtab.c, but i don't know the meaning of th
At 10:35 AM 2/18/2004 -0700, scott.marlowe wrote:
It works, I just like writing things in the most self documenting manner
possible, since one day somebody else may look at:
select * from test where id='456'
and go, "hey, that's just an int, no need for the quotes" and take them
out not knowing wh
I have a database where I remove the schema public. When I
try to use the createlang script, it fails like this ...
createdb foo
CREATE DATABASE
psql foo -c "select version()"
version
-
PostgreSQL 7.4.
Hello,
I asked one time for more "benchmark" soft to know where is the cpu
average, and read the post about optimising the postgresql.conf (and use
them), but i allways get a load > 1 on fire time (dunno the right name,
"coup de feu" in french (10h00 -> 14h00, 18h00 -> 21h00).
For
On Wednesday 18 February 2004 19:24, Lee Harr wrote:
> I have a database where I remove the schema public. When I
> try to use the createlang script, it fails like this ...
>
[snip]
> DROP SCHEMA
>
> >createlang plpgsql foo
>
> createlang: language installation failed: ERROR: no schema has been
>
On Wed, 18 Feb 2004, Froggy / Froggy Corp. wrote:
> The problem is that on "fire time", the load go to > 1 and stay long
> time. But with top (i use top -d 1 to have "real" load average) i can
> see that the CPU is more than 50% idling.
>
> For exemple, i have this kind of stat :
>
> 0s -
First thx for your quick answer :)
iostat dont return bad load average. I never grow up to 1Mb/s and the
IDE drive can go faster.
I really can't change the server, its a locative server which i own
(only me on the server, no cooperative, but i dont have physically
access to it). So the configurat
32 matches
Mail list logo