Skip site navigation (1) Skip section navigation (2)

Re: Column is of type date but expression is of type text

From: list_usr(at)spacebox(dot)net
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Column is of type date but expression is of type text
Date: 2010-02-21 18:00:50
Message-ID: 1e11c2271002211000h1a833eeaq4c16983f7ee83c6c@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
So I don't know what happened.. but I dropped the database and
reloaded it and now it works.  I had made some small updates to the
stored procedure but had been recreating it (CREATE OR REPLACE
FUNCTION) with the updates - should I have been restarting Postgres
after recreating the stored procedure?

I think the issue was the ordering of the parameters - after your
initial answer to my question I updated the stored procedure so the
ordering of the parameters matched the order that they appeared in the
insert statement.  I recreated the stored procedure and continued to
encounter the problem which led me to believe that wasn't the issue.

Anyhow, after recreating the database it's now working.

Thanks for all your help!

     -- Matt

On Sat, Feb 20, 2010 at 2:21 PM, Kris Jurka <books(at)ejurka(dot)com> wrote:
>
>
> On Fri, 19 Feb 2010, list_usr(at)spacebox(dot)net wrote:
>
>> Re: version, good question - I have both postgresql-8.4-701.jdbc3.jar
>> and postgresql-8.4-701.jdbc4.jar in my Apache Tomcat 5.5 common/lib
>> directory.  Would that cause a problem?
>>
>> I'm using PostgreSQL 8.4.  Java 1.6.
>>
>> Your example code worked with both jdbc3 and jdbc4, but my code still
>> isn't working.
>
> Well those versions are all recent enough not to have any problems.  If my
> code works and yours doesn't it's likely you're not telling us something
> about your code.  If you can create a self-contained testcase like I did
> then I'd be happy to look at it, but it doesn't look like a driver problem.
>
> Kris Jurka
>

In response to

Responses

pgsql-jdbc by date

Next:From: Tom LaneDate: 2010-02-21 18:17:51
Subject: Re: Column is of type date but expression is of type text
Previous:From: LewDate: 2010-02-20 20:59:50
Subject: Re: Column is of type date but expression is of type text

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group