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
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
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
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
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
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
,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
] 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
10 matches
Mail list logo