From: | "Klaus Ummenhofer" <info(at)deciphe-it(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Problem with C# TableAdapter |
Date: | 2009-10-10 14:33:14 |
Message-ID: | 200910101433.n9AEXEHN021287@post.webmailer.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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;
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2009-10-10 15:37:23 | Re: Problem with C# TableAdapter |
Previous Message | noreply | 2009-10-09 14:05:04 | [ psqlodbc-Bugs-1010713 ] Bug with datatype lo and server side cursor |