| From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | Postgres User <postgres(dot)developer(at)gmail(dot)com> |
| Cc: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Selecting from table into an array var |
| Date: | 2009-12-19 18:41:55 |
| Message-ID: | b42b73150912191041v54299aedi2c7f33688aabd8d3@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, Dec 19, 2009 at 1:30 PM, Postgres User
<postgres(dot)developer(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrus | 2009-12-19 19:24:17 | How to use read uncommitted transaction level and set update order |
| Previous Message | Postgres User | 2009-12-19 18:37:22 | How to call a function that returns a refcursor ? |