dbTalk Databases Forums  

[BUGS] BUG #2232: Function (store procedure) prublem

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] BUG #2232: Function (store procedure) prublem in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Michael Grossman
 
Posts: n/a

Default [BUGS] BUG #2232: Function (store procedure) prublem - 02-02-2006 , 05:06 PM







The following bug has been logged online:

Bug reference: 2232
Logged by: Michael Grossman
Email address: michael.grossnab (AT) newconcept (DOT) 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

Reply With Quote
  #2  
Old   
Richard Huxton
 
Posts: n/a

Default Re: [BUGS] BUG #2232: Function (store procedure) prublem - 02-03-2006 , 02:19 AM






Michael Grossman wrote:
Quote:
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 (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly


Reply With Quote
  #3  
Old   
Richard Huxton
 
Posts: n/a

Default Re: [BUGS] BUG #2232: Function (store procedure) prublem - 02-03-2006 , 02:25 AM



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

Michael Grossman wrote:
Quote:
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 (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.