Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: sqlstate is HY000 for not_null_violation
- From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
- To: ning <mailxiening(at)gmail(dot)com>
- Cc: pgsql-odbc(at)postgresql(dot)org
- Subject: Re: sqlstate is HY000 for not_null_violation
- Date: Thu, 27 Aug 2009 21:00:33 +0900
- Message-id: <4A967561.6060702@tpf.co.jp> <text/plain>
ning wrote:
Thank you Inoue-san, By setting in odbc.ini, Protocol = 7.4 I got sqlstate=23502 from SQLGetDiagRec() as expected. Since I am using psqlodbc08.02.0400 with unixODBC connecting to PostgreSQL8.2.4, I think that setting Protocol=8.2.4 is also reasonable, but that is not true, I got "HY000" by setting to 8.2.4. I cannot find information about available protocol numbers, could you help to give a clue?
The protocol option means FE/BE protocol and must be 6.2, 6.3, 6.4 or 7.4 . regards, Hiroshi Inoue
- References:
- sqlstate is HY000 for not_null_violation
- From: ning
- Re: sqlstate is HY000 for not_null_violation
- From: Hiroshi Inoue
- Re: sqlstate is HY000 for not_null_violation
- From: ning
- sqlstate is HY000 for not_null_violation
- Prev by Date: Re: Error in psqlodbc configuration
- Previous by thread: Re: sqlstate is HY000 for not_null_violation
- Next by thread: 08.04.0100 truncates bytea fields
- Indexes: