Search Postgresql Archives

Re: ERROR: 42601: a column definition list is only allowed for functions returning "record"

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Gopal" <gopal@xxxxxxxxxxxxxx> writes:
> I am using c# and npgsql 1.0 (same behaviour with 0.7) to call a
> function that has 6 input parameters and 4 output parameters.
> When I call .ExecuteNonQuery(), I get the following message
> ERROR: 42601: a column definition list is only allowed for functions
> returning "record"

I think you need a newer version of npgsql, ie, one that understands
about OUT parameters.  It sounds to me like it is noticing the function
result type is RECORD and it doesn't realize that that doesn't mean
it has to specify the output column types in the query.

			regards, tom lane


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux