Ange Michel POZZO <[EMAIL PROTECTED]> writes:
> CREATE VIEW browser
> AS
> SELECT
> agent_i,
> CASE
> < massive CASE expression >
> ELSE agent_i END AS navigateur, count (agent_i)
> as total from access group by agent_i;
> pqReadData() -- backend closed the channel unexpectedly.
Not sure why you are seeing a crash instead of a complaint, but
there's no chance of making such a huge VIEW expression work in
6.5 --- the rule text won't fit in 8K. Try it in 7.0.2 (which
has still got the 8K limit, but at least it compresses the text).
BTW I tend to agree with the other comment that this seems a clumsy
way to go about it. I'd think about making a table containing a
pattern column and a browser-name column and doing the view as a
join. Might be a little tricky to ensure you get only one match,
however ...
regards, tom lane
