| From: | Kris Jurka <jurka(at)ejurka(dot)com> |
|---|---|
| To: | mario(dot)splivalo(at)mobart(dot)hr |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Calling functions with table-based-type parametars |
| Date: | 2007-02-26 17:53:18 |
| Message-ID: | 45E31E8E.9070305@ejurka.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Mario Splivalo wrote:
>> This is saying you need to write it with a cast from the row to the table
>> type:
>>
>> conn.prepareCall("{call f1(ROW(?, ?)::t1)}")
>
> Can't do that either. Postgres tells me that there is no type t1:
>
> 2007-02-26 18:25:19.004 CET [10324] <jura> PARSEERROR: type "t1" does
> not exist
>
> I even tried creating type _t1 wich has same member variables as table
> rows, and created function f2 wich takes _t1 as parametar, still same
> error: type "_t1" does not exsit.
>
The attached test case works fine for me without a cast. Perhaps you
can modify this to show the failure you're getting.
Kris Jurka
| Attachment | Content-Type | Size |
|---|---|---|
| RowFunc.java | text/java | 816 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2007-02-26 18:30:37 | Re: bug with PGXADataSource in JNDI |
| Previous Message | Gene | 2007-02-26 17:41:24 | Re: does prepareThreshold work? forced to use old driver |