Re: Error on creating new customer

["Chris Travers" <..hidden..>]

Which version of PostgreSQL?  You may also want to try on the
PostgreSQL list (pg-general).  We have a few PostgreSQL geeks on this
list, but they have more, and better :-)

Best Wishes,
Chris Travers

On 2/8/07, DK <..hidden..> wrote:
> 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
>
> -------------------------------------------------------------------------
> 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