Re: where's the reference to a view, here?

From: "will trillich" <will(at)serensoft(dot)com>

> inv=# update _invitem set descr=
> inv-# substring(descr from 1 for position('==' in
descr)-1)||'--'||substring(descr from position('==' in descr)+2)
> inv-# where descr like '%==%';
> ERROR: system column oid not available - inv is a view

This query isn't in a function is it? I've seen all sorts of weirdness if I
drop & recreate tables/views that compiled functions depend on.

[snip]

> inv=# \d inv
> View "inv"
> Attribute | Type | Modifier
> -----------+----------------------+----------
[snip]
> amt | numeric(65535,65531) |

Is this large a numeric deliberate, or has something got mangled here?

- Richard Huxton