Re: [SQL] Problem inserting data

2008-06-20 Thread Tk421
Adrian Klaver escribió: On Friday 20 June 2008 5:20 am, Tk421 wrote: Hello everybody. I''ve just converted an access database to postgres. The conversion was ok, but when i'm trying to insert data on some tables with boolean types from a Visual Basic application i receive a

Re: [SQL] Problem inserting data

2008-06-20 Thread Tom Lane
Adrian Klaver <[EMAIL PROTECTED]> writes: > Two options: > 1) Change the column in Postgres to an integer type. > 2) Change the assignment in pg_cast from explicit to implied for the > int4,bool cast. See for more details: > http://www.postgresql.org/docs/8.3/interactive/catalog-pg-cast.html Mak

Re: [SQL] Problem inserting data

2008-06-20 Thread Adrian Klaver
On Friday 20 June 2008 5:20 am, Tk421 wrote: >Hello everybody. > > I''ve just converted an access database to postgres. The conversion > was ok, but when i'm trying to insert data on some tables with boolean > types from a Visual Basic application i receive an error. A sample: > > table

[SQL] Problem inserting data

2008-06-20 Thread Tk421
Hello everybody. I''ve just converted an access database to postgres. The conversion was ok, but when i'm trying to insert data on some tables with boolean types from a Visual Basic application i receive an error. A sample: table example, with firs field of integer, second of type tex