Can anyone recommend a reasonably efficient system for changing a view
definition (say by adding a column) when it has a bunch of dependent
functions?
Right now I work with the output from pg_dump to recreate things after
doing "DROP VIEW ... CASCADE". But the pg_dump schema output is only
approx
t, Dec 27, 2008 at 1:14 AM, Craig Ringer
wrote:
> Eric Worden wrote:
>
>> The recursive function creates a temp table [...] I
>> have version 8.1.10.
>
> While I haven't looked in detail, I'd be surprised if this wasn't an
> issue with pre-8.3 versions la
Hello, I'm guessing the rows aren't really disappearing but how else
to describe it?
I have a trigger function that calls another function that is
recursive. The recursive function creates a temp table and inserts
rows into it. After the recursive function returns, the trigger
function exam
