[CAY-750] Stored procedures without parameters fail on Postgres 8

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.2 branch, 2.0 branch, 3.0
• Fix Version/s: 3.0M1
• Environment: PostgreSQL 8.1, Mac OS X Intel, postgresql-8.1-405.jdbc3.jar
• Assignee: Andrus Adamchik
• Reporter: Andrus Adamchik
• Created: 08/Feb/07 14:20
• Updated: 09/Nov/08 01:14
• Resolved: 08/Feb/07 15:10

Description

This was first reported here:

http://objectstyle.org/cayenne/lists/cayenne-user/2007/02/0043.html

and I can reproduce the issue with a unit test. We need to add a set of empty parenthesis at the end of the proc invocation.

Need to test other DB's too - curious how they will behave..