Problem with C# TableAdapter

Hello community,

I try to access a PostgreSql database with C# and have some problems creating a TableAdapter.

The problem is that a new TableAdapter does only create the SELECT command but not the commands for UPDATE, INSERT and DELETE. I am using the ODBC driver PSQLODBC30A.DLL 8.04.01.00, PostgreSql 8.4 and VS2005.

I found some information affecting my problem which are related to primary keys. So far I am aware of needing a primary key in order to generate these commands. Please could someone inspect the CREATE scripts below which are not working properly and let me know, how I should change them.

What else could I do in order to use the database via a TableAdapter object?

Thank you.

Klaus

CREATE TABLE films (
code char(5) CONSTRAINT firstkey PRIMARY KEY,
title varchar(40) NOT NULL,
did integer NOT NULL,
date_prod date,
kind varchar(10),
len interval hour to minute
);

CREATE TABLE script
(
id serial NOT NULL,
"name" character varying(10) NOT NULL,
script_data text,
CONSTRAINT script_pk PRIMARY KEY (id)
)
WITH (
OIDS=FALSE
);
ALTER TABLE script OWNER TO postgres;