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

Re: Error on creating new customer



I new that I'm lucky.
=======================
test1=> insert into customer(name) values ('something');
ERROR:  attribute 9 has wrong type
DETAIL:  Table has type character varying, but query expects character varying.
=======================
something wrong with postgre I suppose.

On 09/02/07, Chris Travers <..hidden..> wrote:
I have never seen that error before.

If you copy the query and run it manually against psql, do you get an error?

Best Wishes,
Chris Travers

On 2/8/07, DK <..hidden..> wrote:
> perl-DBD-Pg-1.49-1.fc6
>
> On 09/02/07, Chris Travers <..hidden..> wrote:
> > Which version of DBD::Pg are you using?
> >
> > Best Wishes,
> > Chris Travers
> >
> > On 2/8/07, DK <..hidden..> wrote:
> > > After filling the 'Add customer' form and pressing button Save I have
> > > this message:
> > >
> > > ======= quote ========
> > > DBD::Pg::db do failed: ERROR: attribute 9 has wrong type
> > > DETAIL: Table has type character varying, but query expects character varying.
> > > Error!
> > >
> > > INSERT INTO customer (name)
> > > VALUES ('Fri Feb 9 01:46:00 20073589')
> > > ERROR: attribute 9 has wrong type
> > > DETAIL: Table has type character varying, but query expects character varying.
> > >
> > > ======= unquote ========
> > > version 1.1.8
> > > postgre encoding UTF8
> > >
> > > The error occures irrespective of the values entered in specific
> > > fields. Any ideas please?
> > >
> > > -------------------------------------------------------------------------
> > > Using Tomcat but need to do more? Need to support web services, security?
> > > Get stuff done quickly with pre-integrated technology to make your job easier.
> > > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> > > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> > > _______________________________________________
> > > Ledger-smb-users mailing list
> > > ..hidden..
> > > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> > >
> >
> > -------------------------------------------------------------------------
> > Using Tomcat but need to do more? Need to support web services, security?
> > Get stuff done quickly with pre-integrated technology to make your job easier.
> > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> > _______________________________________________
> > Ledger-smb-users mailing list
> > ..hidden..
> > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> >
>
>
> --
> Dmitri Kourbatsky
>
> Suris Accwel Ltd.
> tel: +357 99 608290
> fax +357 25 311517
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users



--
Dmitri Kourbatsky

Suris Accwel Ltd.
tel: +357 99 608290
fax +357 25 311517