.
can anyone explain what i'm doing wrong in the attached example?
cheers,
raf
#!/usr/bin/env python
# Why is this program idle in transaction while sleeping?
import pgdb, time
def psql(db, sql, commit=True):
try:
c = db.cursor()
c.execute(sql)
rows = c.fetchall()
if commit: db.commit
of information_schema.
Thank you very much to both of you.
note that this method doesn't produce a complete function
signature. the precision and scale of numerics are not
included in the output. hopefully, that won't matter for
your needs.
cheers,
raf
--
Sent via pgsql-admin mailing list
Milen A. Radev wrote:
raf :
hi,
in my database, normal users can't select, insert, update or
delete anything directly. they can only call functions which
are all security defining functions which give access to the
data. that's the way i like it.
however, i
Kevin Grittner wrote:
raf r...@raf.org wrote:
revoke all privileges on schema public from public;
revoke all privileges on schema public from staff; -- staff is a role
then i get two warnings:
WARNING: no privileges could be revoked for public
WARNING: no privileges
. is there any way to prevent this?
i couldn't find any grant/revoke syntax in the doco that
looked relevant.
cheers,
raf
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
documentation which tells me how
to clear this cache.
Versions:
pg: postgresql v 8.0.1-r4
os: Gentoo Linux/Kernel 2.6.12.5 #1
Any help would be of value?
Cheers,
Raf
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project
. Is this best way forward?
Cheers,
Raf
On Thu, 17 May 2007, Raf wrote:
Greetings,
In the face of shabby google results, I hoped that someone hear might know
something about the postgres function cache. We have a server which reports
an error of the form cache lookup failed for function oid
the for relating oid's in pg_depend and
pg_trigger. Nadda.
If anyone else has manually done something similar before, I would be
grateful for some guidence.
Many Thanks.
Raf
On Thu, 17 May 2007, Raf wrote:
Update on the status of my findings relating to the bug below:
I did:
[EMAIL
slony
corruptting internal pg_tables or postgres not correctly respecting the
integrity of drop-trigger type transactions and their respective
dependencies.
On Thu, 17 May 2007, Raf wrote:
Please read from bottom up. I've proceeded further with this investigation
and have removed slony
Hi Tom,
Thanks for the feedback.
On Thu, 17 May 2007, Tom Lane wrote:
Raf [EMAIL PROTECTED] writes:
The final step was the decrement the reltriggers counter for the parent
table's pg_class entry to 0. This appears to have resolved the problem.
You should probably have set it to 3 not 0
On Thu, 17 May 2007, Tom Lane wrote:
Raf [EMAIL PROTECTED] writes:
On Thu, 17 May 2007, Tom Lane wrote:
Even though there were 0 rows associated with the table's oid in
pg_depend and pg_triggers ?
Oh, OK, you want zero then. I had misread it to indicate that only one
of four triggers had
11 matches
Mail list logo