hi,
i would like to allow updates to a view, but pgsql crashes,
presummably from an infinite loop.
i add a rule like so:
CREATE RULE update_myview AS ON UPDATE TO myview DO INSTEAD SELECT
updater(OLD, NEW);
where updater is a plperl function. the function updater does a few
comparisons of
hi tom,
so maybe i'm using the word crash too liberally. this is the error
message i get:
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting rese
ya'da man tom!
applied the patch, rebuilt, and postgres doesn't crash anymore. fixed
my syntax error, and all is working properly.
phew, my first experience with sql
thanks!
matt
On Thu, Dec 14, 2006 at 09:23:40PM -0500, Tom Lane wrote:
> [EMAIL PROTECTED] writes:
> > so maybe i'm using
