[EMAIL PROTECTED] writes:
> I was initially thinking, there 'should' be some way to limit the access
> in the desired way. So now I know, there is not.
Well, if you were using 8.2 then the CONNECT privilege would help...
regards, tom lane
---(end o
> Thomas Mack wrote:
>> Hello!
>>
>> I face a problem here with restricting access to databases to
>> the owners of the database (Postgres 8.1.4).
>>
>> We would like any postgres user to have database access restricted
>> to their own databases only. This is so, as we use postgres for
>> education
Hello,
I'm not sure why wish not to pre-create a database for each student
and limiting them to that database with the no create database priv.
Depending on why you want to do that, I think you might be able to
give each user a schema. I think access to schemas has to be
explicitly gran
Thomas Mack wrote:
Hello!
I face a problem here with restricting access to databases to
the owners of the database (Postgres 8.1.4).
We would like any postgres user to have database access restricted
to their own databases only. This is so, as we use postgres for
educational purposes.
I looked
Nicola Mauri <[EMAIL PROTECTED]> writes:
> Data stored in the database didn't groove very much in the last months
> (pg_dump still generates a 4GB compressed file), but data files now
> occupies 20 GB on disk.
> I know that a vacuum full or a full dump/restore is needed to reclaim
> filesystem s
Anup Gosh from India wrote:
Sir,
There is a .jar file,a dump file,a .sql file.My question is that how
i create a database in PosrgreSQL8.1 in windowsXP platform.Please explain it
clearly step by step.
Am Donnerstag, 24. Mai 2007 15:57 schrieben Sie:
> Thomas Mack wrote:
> > Hello!
> >
> > I face a problem here with restricting access to databases to
> > the owners of the database (Postgres 8.1.4).
> >
> > We would like any postgres user to have database access restricted
> > to their own databas
I'm using 8.1.4 on linux.
Autovacuum is enable with these settings:
stats_start_collector = on
stats_row_level = on
autovacuum = on
autovacuum_naptime = 60
autovacuum_vacuum_threshold = 1000
autovacuum_analyze_threshold = 500
Data stored in the database didn't groov
"Igor Neyman" <[EMAIL PROTECTED]> writes:
> CREATE OR REPLACE FUNCTION exec_plpgsql_block(exec_string text)
> RETURNS BOOLEAN
> AS $THIS$
> DECLARE lRet BOOLEAN;
> BEGIN
> EXECUTE 'CREATE OR REPLACE FUNCTION any_block()
> RETURNS VOID
> AS $$ ' || exec_string || ' $$LANGUAGE PLPGSQL;' ;
> PERFORM a
Fuzzygoth <[EMAIL PROTECTED]> writes:
> I have been attempting to move our database to our new database server
> but i have encountered a few problems along the way. One of the errors
> that I encountered was the error below when trying to drop a table so
> I could re-build it.
> ERROR: cache loo
Coming from Oracle world, I also was missing the ability to execute anonymous
blocks.
So I wrote this function:
CREATE OR REPLACE FUNCTION exec_plpgsql_block(exec_string text)
RETURNS BOOLEAN
AS $THIS$
DECLARE lRet BOOLEAN;
BEGIN
EXECUTE 'CREATE OR REPLACE FUNCTION any_block()
RETURNS VOID
AS $$
"Abraham, Danny" <[EMAIL PROTECTED]> writes:
> This code is my first "like Oracle anonymous blocl". It does not go =
> through.
There are no anonymous blocks in Postgres --- you must create a
function.
regards, tom lane
---(end of broadcast)---
Hello All,
I have been attempting to move our database to our new database
server
but i have encountered a few problems along the way. One of the
errors
that I encountered was the error below when trying to drop a table so
I
could re-build it.
ERROR: cache lookup failed for relation 411727
Never
How to monitor PgSQL performance, like JConsole for Java Virtual Machine?
Usage of memory, CPU, etc.
Thank you,
Jair.
Thomas Mack wrote:
> Hello!
>
> I face a problem here with restricting access to databases to
> the owners of the database (Postgres 8.1.4).
>
> We would like any postgres user to have database access restricted
> to their own databases only. This is so, as we use postgres for
> educational purpo
#!/bin/sh
psql --quiet -t << EOF
declare
x varchar(80);
begin
x:='Hello World';
raise notice x;
end;
\q
EOF
==
Hi,
This code is my first "like Oracle anonymous blocl". It does not go through.
Can anyone help?
Thanks
Danny
Hello!
I face a problem here with restricting access to databases to
the owners of the database (Postgres 8.1.4).
We would like any postgres user to have database access restricted
to their own databases only. This is so, as we use postgres for
educational purposes.
I looked into pg_hba.conf, bu
Hi,
I'm writing some papers about PostgreSQL physical storage and I'm
bumping into the HeapTupleHeaderData layout as descripted here
http://www.postgresql.org/docs/8.2/static/storage-page-layout.html
Reading the source code in src/include/access/htup.h I got a question.
The t_cmin and t_cmax st
---
v13nr wants to stay in touch using some of Google's most sophisticated
new products.
If you already have Google Mail or Google Talk, visit:
http://mail.google.com/mail/b-eb8070e345-091c6847d3-a6ca8f131684d071
You will need to
Purusothaman A wrote:
Richard Huxton,
In my system also its 2048 bytes chunk.
The below output shows clearly that the last chunk differs in its length.
You might have noticed in my previous mail that the string
"\015\012\015\012" is
missing some characters in SFRS2, SFRS1 and FASP_AVT database
Richard Huxton,
In my system also its 2048 bytes chunk.
The below output shows clearly that the last chunk differs in its length.
You might have noticed in my previous mail that the string
"\015\012\015\012" is
missing some characters in SFRS2, SFRS1 and FASP_AVT database outputs.
Have a look a
21 matches
Mail list logo
