[ psqlodbc-Bugs-1000540 ] GenerateBDDirectMethod fails in VS studio 2005 with ODBC
От | |
---|---|
Тема | [ psqlodbc-Bugs-1000540 ] GenerateBDDirectMethod fails in VS studio 2005 with ODBC |
Дата | |
Msg-id | 20060514092414.D742486C541@pgfoundry.org обсуждение исходный текст |
Список | pgsql-odbc |
Bugs item #1000540, was opened at 2006-01-31 14:50 You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000540&group_id=1000125 Category: None Group: None >Status: Closed Resolution: None Priority: 3 Submitted By: Nobody (None) Assigned to: Ludek Finstrle (luf) Summary: GenerateBDDirectMethod fails in VS studio 2005 with ODBC Initial Comment: 1) i create new table in my databaze 2) I have installed 8.102 odbc driver and update it with latest dll libreries 8.108. 3)In visual studio a vreated simply database viewer with datagrid wirh ODBC driver. 4) it generate commands for update, select, insert and delete with GenerateBDDirectMethod = true 5) i added new column to my table and create new select with this new column 6) after this i lost update, insert and delete commands and GenerateBDDirectMethod is now to false and i cant set i to true.But horhers unchanged tables is OK. Here is SQL select command: SELECT "id_list", "zakazka", "nazev", "dat_prijeti", "dat_predani", "predano", "typy", "poznamky", "barva", "kontakt","faktura" FROM "public"."list" connection string: Dsn=test;database=test;server=192.168.0.227;port=5432;sslmode=prefer;uid=stoupa;readonly=0;protocol=6.4;fakeoidindex=0;showoidcolumn=0;rowversioning=0;showsystemtables=0;fetch=100;socket=8192;unknownsizes=0;maxvarcharsize=254;maxlongvarcharsize=8190;debug=0;commlog=0;optimizer=1;ksqo=1;usedeclarefetch=0;textaslongvarchar=1;unknownsaslongvarchar=0;boolsaschar=1;parse=0;cancelasfreestmt=0;extrasystableprefixes=dd_;lfconversion=1;updatablecursors=0;disallowpremature=0;trueisminus1=0;bi=0;byteaaslongvarbinary=0;useserversideprepare=0;lowercaseidentifier=0 And here is table scheme: CREATE TABLE list ( id_list int4 NOT NULL DEFAULT nextval('list_id_list_seq'::regclass), zakazka varchar(15), nazev varchar(45), dat_prijeti date, dat_predani date, typy text, poznamky text, barva varchar(15), kontakt varchar(45), predano varchar(10), faktura varchar(20), CONSTRAINT id_list PRIMARY KEY (id_list) ) WITHOUT OIDS; ALTER TABLE list OWNER TO postgres; Thats all Jirka ---------------------------------------------------------------------- >Comment By: Dave Page (dpage) Date: 2006-05-14 09:24 Message: Continued in bug 1000630, with logs from 08.02.0002 ---------------------------------------------------------------------- Comment By: Patrick Donelan (patspam) Date: 2006-05-11 02:38 Message: Please also refer to my bug (http://pgfoundry.org/tracker/index.php?func=detail&aid=1000630&group_id=1000125&atid=538) whichdeals with the same issue. I have reproduced the problem in 08.02.0002. Cheers, Patrick ---------------------------------------------------------------------- Comment By: Dave Page (dpage) Date: 2006-04-28 09:00 Message: Please test version 08.02.0002 (available from http://pgfoundry.org/frs/?group_id=1000125) and report whether or not theproblem still exists. ---------------------------------------------------------------------- Comment By: Ludek Finstrle (luf) Date: 2006-02-06 15:44 Message: Yes I see it. I have been ill since Friday. to others: As you can see I communicate privately with this user. I'll post the results here ASAP. It's faster for us tocommunicate in mohter tongue ;-) ---------------------------------------------------------------------- Comment By: Nobody (None) Date: 2006-02-06 08:31 Message: I sent you couple mail to you in friday. So check your mail ;-P ---------------------------------------------------------------------- Comment By: Ludek Finstrle (luf) Date: 2006-01-31 20:50 Message: It would be the best if you send me the compiled minimalistic reproduceable application. I need at least mylog output. I have to see what's going wrong. Maybe you may enable Parse Statement option (broken in 08.01.0102). Feel free to contact me direactly via mail in czech ;-) ---------------------------------------------------------------------- You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000540&group_id=1000125
В списке pgsql-odbc по дате отправления:
Предыдущее
От:Дата:
Сообщение: [ psqlodbc-Bugs-1000496 ] FOR UPDATE NOWAIT returns no error in case of locking