Home > Archive > PostgreSQL Bugs > February 2006 > BUG #2232: Function (store procedure) prublem









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author BUG #2232: Function (store procedure) prublem
Michael Grossman

2006-02-02, 8:24 pm


The following bug has been logged online:

Bug reference: 2232
Logged by: Michael Grossman
Email address: michael.grossnab@newconcept.co.il
PostgreSQL version: 8.1.2 windows
Operating system: windows xp q windows 2003
Description: Function (store procedure) prublem
Details:

Hi!

I am working have a year with PostgreSQL Windows Database.
I am very happy with the Database and its looks good.

I have to report of critical bug:
I am using functions (Store procedure) to update database.

When I passing for example 20 prams' to update a database its work fine.
But yesterday a saw when one of the parameters the value is – "109922:11"
I gut an error parameter 11 is empty – he thinks the value is a
parameter.
When a change this value to – "109922.11" the function works fine.

I working with the latest release 8.1.2 windows addition.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Richard Huxton

2006-02-03, 3:24 am

Michael Grossman wrote:
> When I passing for example 20 prams' to update a database its work fine.
> But yesterday a saw when one of the parameters the value is "109922:11"
> I gut an error parameter 11 is empty he thinks the value is a
> parameter.
> When a change this value to "109922.11" the function works fine.


You'll need to give some more details - can you produce a small function
that reproduces the error so others can test it on their machines?

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Richard Huxton

2006-02-03, 3:24 am

NOTE - wrong email address for Michael on my last reply.

Michael Grossman wrote:
> When I passing for example 20 prams' to update a database its work fine.
> But yesterday a saw when one of the parameters the value is "109922:11"
> I gut an error parameter 11 is empty he thinks the value is a
> parameter.
> When a change this value to "109922.11" the function works fine.


You'll need to give some more details - can you produce a small function
that reproduces the error so others can test it on their machines?

--
Richard Huxton
Archonet Ltd


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com