pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedSPI_exec vs. CREATE/DROP RULE
3+ messages / 3 participants
[nested] [flat]
* SPI_exec vs. CREATE/DROP RULE
@ 1999-07-22 11:01 Zakkr <zakkr@zf.jcu.cz>
0 siblings, 1 reply; 3+ messages in thread
From: Zakkr @ 1999-07-22 11:01 UTC (permalink / raw)
To: pgsql-interfaces
Hi,
I try in my function use SPI_exec() with CREATE or DROP RULE, but if I call
my func. - server return this message:
"Backend send D message without prior T".
What is it (or where is more information about it)?
Zakkr
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] SPI_exec vs. CREATE/DROP RULE
@ 1999-07-23 00:54 Tom Lane <tgl@sss.pgh.pa.us>
parent: Zakkr <zakkr@zf.jcu.cz>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 1999-07-23 00:54 UTC (permalink / raw)
To: Zakkr <zakkr@zf.jcu.cz>; +Cc: pgsql-interfaces
Zakkr <zakkr@zf.jcu.cz> writes:
> I try in my function use SPI_exec() with CREATE or DROP RULE, but if I call
> my func. - server return this message:
> "Backend send D message without prior T".
That's a known bug with utility statements executed via SPI. Someone
was looking into a fix a few months ago, but I haven't heard anything
about it since then...
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: [INTERFACES] SPI_exec vs. CREATE/DROP RULE
@ 1999-07-23 03:05 Hiroshi Inoue <Inoue@tpf.co.jp>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Hiroshi Inoue @ 1999-07-23 03:05 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; Zakkr <zakkr@zf.jcu.cz>; +Cc: pgsql-interfaces
> -----Original Message-----
> From: owner-pgsql-interfaces@postgreSQL.org
> [mailto:owner-pgsql-interfaces@postgreSQL.org]On Behalf Of Tom Lane
> Sent: Friday, July 23, 1999 9:54 AM
> To: Zakkr
> Cc: pgsql-interfaces
> Subject: Re: [INTERFACES] SPI_exec vs. CREATE/DROP RULE
>
>
> Zakkr <zakkr@zf.jcu.cz> writes:
> > I try in my function use SPI_exec() with CREATE or DROP RULE,
> but if I call
> > my func. - server return this message:
> > "Backend send D message without prior T".
>
> That's a known bug with utility statements executed via SPI. Someone
> was looking into a fix a few months ago, but I haven't heard anything
> about it since then...
>
Sorry,I missed the change of "CREATE RULE".
Here is a patch.
Hiroshi Inoue
Inoue@tpf.co.jp
inline patch 1: backend/rewrite/rewriteDefine.c (+1/-1 lines) download inline-1.patch
*** backend/rewrite/rewriteDefine.c.orig Wed May 26 16:04:41 1999
--- backend/rewrite/rewriteDefine.c Fri Jul 23 11:22:09 1999
***************
*** 131,137 ****
rulname, evtype, eventrel_oid, evslot_index, actionbuf,
qualbuf, is_instead);
! pg_exec_query_acl_override(rulebuf);
return LastOidProcessed;
}
--- 131,137 ----
rulname, evtype, eventrel_oid, evslot_index, actionbuf,
qualbuf, is_instead);
! pg_exec_query_dest(rulebuf, None, true);
return LastOidProcessed;
}
end of thread, other threads:[~1999-07-23 03:05 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-07-22 11:01 SPI_exec vs. CREATE/DROP RULE Zakkr <zakkr@zf.jcu.cz>
1999-07-23 00:54 ` Tom Lane <tgl@sss.pgh.pa.us>
1999-07-23 03:05 ` Hiroshi Inoue <Inoue@tpf.co.jp>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox