Re: AW: [HACKERS] The lightbulb just went on...

2000-10-22 Thread Michael J Schout
On Thu, 19 Oct 2000, Tom Lane wrote: > Zeugswetter Andreas SB <[EMAIL PROTECTED]> writes: > >> SELECT session_data, id > >> FROM sessions > >> WHERE id = ? > >> FOR UPDATE > >> > >> I think part of my problem might be that sessions is a view > >> and not a table, > > > Did you create an o

Re: AW: [HACKERS] The lightbulb just went on...

2000-10-19 Thread Tom Lane
Zeugswetter Andreas SB <[EMAIL PROTECTED]> writes: >> SELECT session_data, id >> FROM sessions >> WHERE id = ? >> FOR UPDATE >> >> I think part of my problem might be that sessions is a view >> and not a table, > Did you create an on update do instead rule ? > This is currently not done auto

AW: [HACKERS] The lightbulb just went on...

2000-10-19 Thread Zeugswetter Andreas SB
> what happens to sessions is that it does: > > SELECT session_data, id > FROM sessions > WHERE id = ? > FOR UPDATE > > client does some processing ... > > UPDATE sesssions set session_data = ? WHERE id = ?; > > (this is where the error happens) > > I think part of my problem might