] wrote:
On Sun, 2004-07-18 at 20:52, Randall Perry wrote:
This is a pain. Couldn't we gave something simple like
GRANT ALL ON database.* TO JOE;
Which would grant full access to all objects in the database to JOE for all
time?
You can do it like this in psql:
\a
\t
\o /tmp/grant.sql
,functions,... and then executes grant
statements for each one of them. This would have to repeated each
time a new object is created.
Yes, that's the most popular method so far. You could also write a
stored procedure.
--
Randall Perry
sysTame
Xserve Web Hosting/Co-location
Website Design
a call to the startup
script directly in /etc/rc, as the last command.
--
Randall Perry
sysTame
Xserve Web Hosting/Co-location
Website Development/Promotion
Mac Consulting/Sales
http://www.systame.com/
---(end of broadcast)---
TIP 1: subscribe
on 6/7/04 12:57 PM, Jeff Self at [EMAIL PROTECTED] wrote:
On Mon, 2004-06-07 at 10:28, Randall Perry wrote:
On searching the archives I noticed Bob Smith in Jul, 2002 had a similar
problem to mine, but never posted a solution.
I'm using pgsql 7.4.2 on Mac OS 10.3.4. I installed the startup
The O'Reilly book is good. That and the manuals should be all you need
--
Randall Perry
sysTame
Xserve Web Hosting/Co-location
Website Development/Promotion
Mac Consulting/Sales
http://www.systame.com/
---(end of broadcast)---
TIP 1: subscribe
on 12/19/01 11:08 AM, Tom Lane at [EMAIL PROTECTED] wrote:
Randall Perry [EMAIL PROTECTED] writes:
Anyone know what this means:
getTables(): SELECT (funcname) for trigger cust_modification_date returned 0
tuples. Expected 1.
It would seem you have dropped the function which that trigger
Anyone know what this means:
getTables(): SELECT (funcname) for trigger cust_modification_date returned 0
tuples. Expected 1.
pg_dump failed on tasbill, exiting
Tried deleting and recreating the trigger. After restarting the postmaster
pgdump works ok once. The next time it runs it fails again
Suddenly getting this error on start on a Solaris 8 system (after applying a
bunch of patches)
/usr/local/pgsql/bin/postmaster -D /export/spare/home/postgres/data
ld.so.1: /usr/local/pgsql/bin/postmaster: fatal: libssl.so.0.9.6: open
failed: No such file or directory
[1] 1959
[1]Killed
I'm new at PostgreSQL.
So far, succesfully compiled installed it. Created a db, created a table,
and 'copied' tab-delim data into it.
Also downloaded and installed Perl Pg mod (that was a pain; had to sen ENV
variables, and had to force install because of the "root" does not exist
error in
on 4/22/01 11:25 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote:
use Pg;
$conn = Pg::connectdb(dbname=tasbill);
$res = $conn-exec(SELECT * from cust);
while (@row = $res-fetchrow) {
print join( , @row);
}
Works fine if I log in as 'postgres' before executing script, but fails if
10 matches
Mail list logo