• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag
 

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: PostgreSQL plugin
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

  • Follow-Ups:
    • Re: PostgreSQL plugin
      • From: Leo Lutz <email@hidden>
References: 
 >PostgreSQL plugin (From: Leo Lutz <email@hidden>)

  • Prev by Date: PostgreSQL plugin
  • Next by Date: Re: Tracking Fields and EOF
  • Previous by thread: PostgreSQL plugin
  • Next by thread: Re: PostgreSQL plugin
  • Index(es):
    • Date
    • Thread