Great call, someone did hose the data. Oddly enough the circular
reference caused no problem when running the stand alone recursive SQL
(with clause).
On Sat, Dec 19, 2009 at 10:41 AM, Merlin Moncure <mmoncure@gmail.com> wrote:
> On Sat, Dec 19, 2009 at 1:30 PM, Postgres User
> <postgres.developer@gmail.com> wrote:
>>
>> Thanks, your syntax does compile and run.
>>
>> This is where it gets interesting. With your syntax (and variations
>> of it), I'm able to successfully compile and execute. However, as
>> soon as I add a dozen rows to the table, the query failes to complete.
>> It runs until timing out.
>> This prolem does not occur when I remove the SELECT INTO ARRAY
>> statement and simply run the recursive query.
>>
>> Has anyone else seen this behavior?
>
> are you sure you don't have a circular dependency? maybe you have a
> variable/column name clash?
>
> merlin
>