Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECTs inside of VIEWs (WAS: INSTEAD OF trigger on VIEWs) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: SELECTs inside of VIEWs (WAS: INSTEAD OF trigger on VIEWs)
Date
Msg-id 20525.1116944856@sss.pgh.pa.us
Whole thread Raw
In response to SELECTs inside of VIEWs (WAS: INSTEAD OF trigger on VIEWs)  ("Jan B." <jan@monso.de>)
List pgsql-hackers
Tree view 
"Jan B." <jan@monso.de> writes:
> Does anyone know, if it is intended that one query can create multiple 
> result tables with some of them carrying an empty string as cmdStatus? 
> Perhaps this is a bug?

Yes it is, and no it isn't.  Check the archives --- there was extensive
discussion of what multi-command rules should return, a couple years
back when we settled on the current behavior.
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Jeff Eckermann"
Date:
Subject: Re: SELECTs inside of VIEWs (WAS: INSTEAD OF trigger on VIEWs)
Next
From: Gaetano Mendola
Date:
Subject: Re: 8.0.x RPM issues