Re: PostgreSQL query failed: COPY state must be terminated first

--- Shane Wright <me(at)shanewright(dot)co(dot)uk> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi
>
> Thanks, that sounds plausible. However IIRC 7.1.x
> doesn't have cursors :(
>

Sure it does:
http://www.us.postgresql.org/users-lounge/docs/7.1/reference/sql-declare.html


> It would be prohibitively complex to try to rework
> the queries - is there a
> particular memory chunk its likely to be (and how to
> increase whats
> available?) The server isn't short of RAM so should
> be a reasonable
> workaround for now.
>

Others more knowledgable will have to answer that. I
had assumed that you are hitting some hard limit.

> Thanks
>
> Shane
>
>
> On Thursday 17 October 2002 2:58 pm, Jeff Eckermann
> wrote:
> > This kind of error usually indicates that your
> result
> > set has exceeded the available memory. I think
> the
> > "COPY" message is just noise.
> > The workaround would be to declare your query as a
> > cursor, and fetch the results in manageable
> chunks.
>
> - --
> Shane
> http://www.shanewright.co.uk/
> Public key:
> http://www.shanewright.co.uk/files/public_key.asc
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.0.7 (GNU/Linux)
>
>
iD8DBQE9rt505DXg6dCMBrQRAgyQAKDC/FPOms8mwd+PgLSqkl5u5SoJcwCeKXeh
> T/7JHmvzRk4Me687TJgq6BU=
> =WeS6
> -----END PGP SIGNATURE-----
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

__________________________________________________
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo.com