Re: PostgreSQL plugin
Re: PostgreSQL plugin
- Subject: Re: PostgreSQL plugin
- From: Omar <email@hidden>
- Date: Mon, 13 Jun 2005 13:55:30 -0400
I had this same problem this weekend, what I did was change the "bpchar"
in my model to varchar, I think just "char" should work though...
Omar
Leo Lutz wrote:
>I've tried the modified files I found posted on this list and they
>seem to work great except I still can't run a simple query.
>
>I'm getting this as the query and error.
>
>SELECT t0.correcting, t0.formid, t0.moddate, t0.status FROM
>public.status t0 WHERE UPPER(t0.status) LIKE UPPER($1::bpchar(1))
>ESCAPE '|'
>
>ERROR: 42601: syntax error at or near "(" at character 122
>
>122 starts at (1)) in bpchar(1))
>
>I've asked about this and it seems that the plugin should be putting
>in a char(1) instead of a bpchar(1) because the parser doesn't know
>how to handle (n) for bpchar.
>
>Is it possible to get the source for the plugin or is there some other
>reason for this problem?
>
>--Leo
> _______________________________________________
>Do not post admin requests to the list. They will be ignored.
>Webobjects-dev mailing list (email@hidden)
>Help/Unsubscribe/Update your Subscription:
>
>This email sent to email@hidden
>
>
>
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden