nd be to grant
permissions to yourself first and then to all other users?
Scott
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 05, 2000 5:38 PM
To: Saltsgaver, Scott
Cc: '[EMAIL PROTECTED]'
Subject: Re: [SQL] Granting of permissions on tables
I have PostgreSQL v7.02 running on a HP-UX 11.00 box. I as the owner of
some tables granted permissions to another user. I executed the following
command from psql
GRANT ALL on to ;
after running the command I lost permissions to the tables once I exited
psql. I had to run psql as the postgr
Which procedural language is best for writing PostgreSQL functions:
'PL/pgSQL', 'PL/perl', or 'PL/Tcl'?
I know that I can't do table creates in 'PL/pgSQL'?
Is there an obvious choice as far speed and size?
Thanks,
Scott Saltsgaver
[EMAIL PROTECTED]
Is it possible to issue a CREATE TABLE statement from inside of a PostgreSQL
function? If not, then how about from within a PL/pgSQL function? I have
tried a lot of different permutations but can't seem to get it to compile
and/or run cleanly. For example, consider:
CREATE FUNCTION _te
