Postgresql error Failed :array_in:

[Anon]

Hello all,

I am setting up a second database server, I am going to use postresql, I have the server running, created a db, created several test tables. But when I try to insert a record into the table I get the following error:

Failed :array_in: Need to specify dimension

Can anyone tell me what I am doing wrong.

This is my insert statement:

insert into test_tbl values(1, '2000/07/11', 44534, 'new', null, null);

TIA
John Pierce

[kid_c]

can you give us your table structure? you must have an array field, into which the data should be inserted like

'{1,2,3,4}' for example........or fieldname[2]='lalala', fieldname[4]='hjghjsad'

that's where your error is :>

Keith Bussey
[e-mail]
Programmer - WISOL.com
[phone] ext. 225

[jlpierce]

This is the create statement that I used to define the table.

create table test_tbl ("tractor_id" int4 not null, "op_date" date not null, "odometer" float4 not null, "operation_type" VARCHAR[15] not null, "axle" varchar, "axle_location" varchar, "detail" varchar, primary key ("tractor_id", "op_date", "odometer" ), foreign key ( "tractor_id" ) references tractor_mst(tractor_id) );

I think I found the problem, and I made it uppercase in this post, VARCHAR[15].

If this is indeed the problem, how do i specify the size of the varchar field.

TIA

John

[kid_c]

that is your error

define it as varchar(15) NOT varchar[15]

[] = array

voila! =)

--
Keith Bussey
[e-mail]
Programmer - WISOL.com
[phone] ext. 225

[jlpierce]

Hello Keith!

One quick question, if I specify a varchar(15) field type does that mean that the field cannot have an entry larger than 15 characters, or can the field still grow to it's maximum size?

John

[kid_c]

If you specify a varchar(15) field, the field will allow entries of 0-15 characters...anything longer will be truncated to 15 characters (ie. abcdefghijklmnopqrs would be stored as abcdefghijklmno).

using char(15) would mean anything entered into that field MUST be 15 chars, if its less it would pad it i believe....anything mroe would be truncated.

so if you think you'll have larger entries, set your varchar higher!

--
Keith Bussey
[e-mail]
Programmer - WISOL.com
[phone] ext. 225