Re: [SQL] Execute permsissions on fuctions

2001-08-24 Thread Zot O'Connor
Christopher Sawtell wrote: > > On Fri, 24 Aug 2001 06:52, Zot O'Connor wrote: > > Other SQL servers have the concept of stored procedures having different > > permissions. > > > > For instance a procedure that can update a table. > > > > Since a

[SQL] Execute permsissions on fuctions

2001-08-23 Thread Zot O'Connor
is to create a stored procedure that could update the table, and allow the webuser to update the table. The procedure had perms of a user who could update the table, but the webuser could not. How can I do this in Postgres? Thanks. -- Zot O'Connor http://www.ZotConsulting.com

[SQL] Building RPMS with plperl (solution)

2001-07-17 Thread Zot O'Connor
ne pltcl 1} %{!?forceplperl:%define forceplperl 1} %{!?plperl:%define plperl 1} And it built. Then I loaded it: rpm -Uvh /usr/src/redhat/RPMS/i386/postgresql-plperl-7.1.2-4PGDG.i386.rpm Now to test it :) -- Zot O'Connor http://www.ZotConsulting.com http://www.WhiteKn

[SQL] [Fwd: I will be at Linux World]

2000-08-11 Thread Zot O'Connor
-- Zot O'Connor http://www.ZotConsulting.com http://www.WhiteKnightHackers.com I will be at Linux World in San Jose next week, Aug 15th, and 16th. This is a generic spam/post to see if anyone I know will be there, who wants to meet with me. I will also be in Atlanta the last we

[SQL] Views on Unions

2000-07-24 Thread Zot O'Connor
work? -- Zot O'Connor http://www.ZotConsulting.com http://www.WhiteKnightHackers.com

[SQL] Finding entries not in table..differnce?

2000-07-10 Thread Zot O'Connor
, I do not know if that is important. -- Zot O'Connor http://www.ZotConsulting.com http://www.WhiteKnightHackers.com