| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Diogo Biazus <diogo(at)ikono(dot)com(dot)br> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Strange problem with PL/PgSQL stored procedures |
| Date: | 2003-08-24 22:25:37 |
| Message-ID: | 12998.1061763937@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Diogo Biazus <diogo(at)ikono(dot)com(dot)br> writes:
> From time to time I'm getting this error message:
> WARNING: Error occurred while executing PL/pgSQL function atualizabusca
> WARNING: line 25 at for over select rows
> ERROR: unknown cmdtype 136748160 in exec_stmt
> It's a 7.3.3 running on a FreeBSD 4.8
> When I recreate the function it works well for some time, but after
> using the database for some hours this error shows up again.
Hm. By "for some hours" do you mean a single open session that's been
using the database for that long? If so, does exiting that session and
starting a new one make the problem disappear?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-08-24 22:39:18 | Re: Single-file DBs WAS: Need concrete 'Why Postgres |
| Previous Message | ruben20@superguai.com | 2003-08-24 21:25:24 | Upgrading PostgreSQL 7.1.3 |