472,373 Members | 1,849 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,373 software developers and data experts.

Strange problem with PL/PgSQL stored procedures

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.
Very strange, does anyone has a clue?

Thanks in advance,

--
Diogo Biazus
di***@ikono.com.br
http://www.ikono.com.br

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 11 '05 #1
1 2152
Diogo Biazus <di***@ikono.com.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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 11 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Penn Markham | last post by:
Hello all, I am writing a script where I need to use the system() function to call htpasswd. I can do this just fine on the command line...works great (see attached file, test.php). When my...
2
by: FET | last post by:
Hello, I am in a bit of a conflict here. I would like to know if the stored procedures that I write in PL/PGSQL to run on PostgreSQL 7.4.2 are ANSI compliant. The point of asking this question is...
24
by: LineVoltageHalogen | last post by:
Greetings All, I was hoping that someone out there has run into this issue before and can shed some light on it for me. I have a stored procedure that essentially does a mini ETL from a source...
7
by: helmut woess | last post by:
Hi, has anybody knowledge about the safetyness of encrypting stored procs in SQL-Server 2005 using WITH ENCRYPTION? Or can they be hacked with the same old tools which exists for SQL 2000? ...
2
by: Clay Luther | last post by:
I had been having good luck writing stored procs in C++ with Postgres. But, today, I needed to include the SPI interface to help a trigger along, aka #include "executor/spi.h" and this is...
1
by: Bruno BAGUETTE | last post by:
Hello, Is it possible to make PL/PGSQL stored procedures with a variable number of args ? If yes, is it possible to have a sample ? Thanks you in advance :-) ...
1
by: Paramveer.Singh | last post by:
Hi! I am a developer working for a company which typically deploys apps on Oracle. We would like to move to postgres for obvious reasons. However, most of our legacy apps use the exception...
6
by: Scott Nixon | last post by:
New to Postgres 7.3 from 7.0. Am having some trouble with a query that worked in 7.0 but not in 7.3.....can't seem to figure out the syntax or find info about how to do this anywhere. ...
1
by: Shoma | last post by:
Hi, I have a function(stored procedure) in the database. I need to pass the table name which is a variable. How do i do that? Example : I have 1st table : table name - cities location | city ...
2
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
1
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...
0
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
2
by: Ricardo de Mila | last post by:
Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...
1
by: Johno34 | last post by:
I have this click event on my form. It speaks to a Datasheet Subform Private Sub Command260_Click() Dim r As DAO.Recordset Set r = Form_frmABCD.Form.RecordsetClone r.MoveFirst Do If...
1
by: ezappsrUS | last post by:
Hi, I wonder if someone knows where I am going wrong below. I have a continuous form and two labels where only one would be visible depending on the checkbox being checked or not. Below is the...
0
DizelArs
by: DizelArs | last post by:
Hi all) Faced with a problem, element.click() event doesn't work in Safari browser. Tried various tricks like emulating touch event through a function: let clickEvent = new Event('click', {...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.