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
keyin order to generate these commands. Please could someone inspect the CREATE scripts below which are not working
properlyand 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;