pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedNEW and a subselect in a rule
3+ messages / 2 participants
[nested] [flat]
* NEW and a subselect in a rule
@ 2003-07-28 22:50 Denis Zaitsev <zzz@anda.ru>
0 siblings, 0 replies; 3+ messages in thread
From: Denis Zaitsev @ 2003-07-28 22:50 UTC (permalink / raw)
To: pgsql-sql
So, I met such a problem: it's impossible to use NEW in a subselect
used in a (non-select) rule. The error is: <Relation "*NEW*" does not
exist>. Is this a way to do that newertheless (without using of a
function, of course)?
Thanks in advance.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: NEW and a subselect in a rule
@ 2003-07-31 08:00 Christoph Haller <ch@rodos.fzk.de>
2003-08-01 20:12 ` Re: NEW and a subselect in a rule Denis Zaitsev <zzz@anda.ru>
0 siblings, 1 reply; 3+ messages in thread
From: Christoph Haller @ 2003-07-31 08:00 UTC (permalink / raw)
To: pgsql-sql; zzz@anda.ru
>
> So, I met such a problem: it's impossible to use NEW in a subselect
> used in a (non-select) rule. The error is: <Relation "*NEW*" does not
> exist>. Is this a way to do that newertheless (without using of a
> function, of course)?
>
Could we see the CREATE RULE command causing the error?
Regards, Christoph
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: NEW and a subselect in a rule
2003-07-31 08:00 Re: NEW and a subselect in a rule Christoph Haller <ch@rodos.fzk.de>
@ 2003-08-01 20:12 ` Denis Zaitsev <zzz@anda.ru>
0 siblings, 0 replies; 3+ messages in thread
From: Denis Zaitsev @ 2003-08-01 20:12 UTC (permalink / raw)
To: Christoph Haller <ch@rodos.fzk.de>; +Cc: pgsql-sql
On Thu, Jul 31, 2003 at 10:00:07AM +0200, Christoph Haller wrote:
> >
> > So, I met such a problem: it's impossible to use NEW in a subselect
> > used in a (non-select) rule. The error is: <Relation "*NEW*" does not
>
> > exist>. Is this a way to do that newertheless (without using of a
> > function, of course)?
> >
> Could we see the CREATE RULE command causing the error?
I've sent the other message (with the Subject: Nonexistent NEW
relation...) into the list. The code is there. The problem is
already closed (not solved!). Thanks anyway.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-08-01 20:12 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-07-28 22:50 NEW and a subselect in a rule Denis Zaitsev <zzz@anda.ru>
2003-07-31 08:00 Re: NEW and a subselect in a rule Christoph Haller <ch@rodos.fzk.de>
2003-08-01 20:12 ` Denis Zaitsev <zzz@anda.ru>
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