Re: [BUGS] pg_class_aclcheck: relation [oid] not found...

2003-05-29 Thread Tom Lane
Sean Chittenden <[EMAIL PROTECTED]> writes: > Hrm... this limitation makes temporary tables that drop on commit + > pl/pgsql unusable beyond the 1st transaction. Is there a mechanism to > test to see if a relation in a plan is a temporary table? It seems as > though in pl_exec.c that around 1926

Re: [BUGS] pg_class_aclcheck: relation [oid] not found...

2003-05-29 Thread Sean Chittenden
> > CREATE FUNCTION s.f() > > RETURNS BIGINT > > EXTERNAL SECURITY DEFINER > > AS ' > > BEGIN > > EXECUTE ''CREATE LOCAL TEMP TABLE t ( > > a TEXT NOT NULL, > > b TEXT > > ) WITHOUT OIDS ON COMMIT DROP;''; > > EXECUTE '