How to delete my avatar?
Further information RE: Possible bug with psqlodbc driver
Hello Guest		   
  • Login
• Register…
• Start blog		   • Who, Where, When
• What can I do?
• What to Read?		   • Polls
• Avatars
• Interests		   • Cities and Countries
• Random blog
• Users search		   • Search
• Games
• Tests
• QAIX		   • Сообщества
• Talxy Chat
• Horoscope
• Online		  
Зарегистрируйся!
QAIX > PostgreSQL database development > Further information RE: Possible bug with psqlodbc driver 31 October 2003 05:12:53
  Recent blog posts: 
Free iPod nano raffle for…
Aimersoft 2008 Christmas promotion: "Free iPod nano raffle for Chrismas" and "Buy 1 Get…

How to convert Rhapsody to…
Music purchased from Rhapsody is under DRM protection, which stops customers from playing the downloaded&helli­p;

PS3 firmware update adds full…
Eric Lempel, Sony's Director of PlayStation Network Operations, has posted on the official PlayStation 3…

Nintendo makes $6 profit on…
According to Macquarie Securities analyst David Gibson, Nintendo makes $6 USD operating profit on each…

Maintenance in winter
Skin for winter very easy to do, if does not supplement the moisture in time, like persimmons, flat and…

'Jasper' Xbox 360s finally…
'Jasper' Xbox 360s finally available According to a flooding of posts over at xbox-scene, it appears…

How to transfer Napster music…
Music purchased from Napster is under DRM protection, which stops customers from playing the downloaded&helli­p;

The song my brother taught me
Don't let your heart be hardened Don't let your love grow cold May it always stay so childlike May it…

My brother taught me this…
God grant me the serenity to accept the things I cannot change; courage to change the things I can;…

baz-baz-baz-baz pam-parabaram…
baz-baz-baz-baz pam-parabaram baz-baz-baz-baz pam-parabaram baz-baz-baz-baz pam-parabaram-baz ba-ra-ba…

  They have birthday today: 
xiongchong
henna diah
  Forums:   
    topic feeds

• QAIX  all topics, blogs and comments

• PHP web-programming

• Perl web-programming

• ASP web-programming

• Visual Basic Programming

• .Net Development

• C/C++ Programming

• Java Programming

• Javascript web-programming

• Apache HTTP Server

• Web-design

• Web-hosting, dedicated, colocation

• HTML web-programming

• XML development

• General Web-programming

• Content Management Systems

• ColdFusion

• Search Engine Optimization

• Hardware

• Software, Computer Help

• MySQL database development

• PostgreSQL database development

• MS Access database development

• Oracle database development

• MS SQL database development

• Informix database development

• Buy / Sell

• Open discussion

• Anonymous
  Discuss: 
plpgsql - Insert from a record…
Dear Postgresql experts, I'm writing a simple plpgsql function that selects a row from a table…

calling a pl/pgsql function…
Hello, i am tryin to pass an array like argument to a pl/pgsql function but i can not find the correct…

PgDatabase, on heap…
I am having a problem constructing a PgDatabase object. If I create the object on the stack (as a var…

Backup and restore through JDBC
Hello List I am trying to develop, a API to carry through backup and restore through JDBC. I think that…
  Recent forum topics: 
why infix:<div>:(Int, Int…
HaloO, I realized from the typed literal thread that S03 now explicitly states that div on two Ints…

[rt.cpan.org #41329] VMS…
<URL: http://rt.cpan.org/­Ticket/Display.html?­id=41329 > Thanks, applied

how to write literals of some…
Hello, I'm wondering how to write anonymous value literals of some Perl 6 basic types, and I didn't…
  Recent forum comments:
RE: Updating A Portion Of A Site
Thanks! I remembered just before I came back to check. It's amazing the things you forget. Thanks…

RE: Updating A Portion Of A Site
Use a FrontPage include file - see Help on Included Content. Or, if all pages are asp or PHP, use a…

RE: Index Files
What they are telling you is the home page of your site (before you publish it) must be named index.htm…

RE: Website diifers from local copy
I see it as a 40x68 icon (clear your cache) - as for the position check w/ Google API help Neither issue…

RE: Forced submit
"Ellie" <ellymay999nospam@n­ospamnetzero.com> wrote in message…

RE: access denied
IUSR account doesn't have access to cmd.exe by default (assuming you are using anonymous…

RE: access denied
Hey guys, I'm totally out of my league here, I don't even know how I got stuck with this problem, it's…

RE: Forced submit
Ellie wrote on 05 sep 2008 in microsoft.public.in­etserver.asp.general­: You cannot…

RE: [patch@34995] vms.c - Memory…
On Wed, Dec 3, 2008 at 7:38 PM, John E. Malmberg <wb8tyw@qsl.net> wrote: Thanks, applied as…

RE: why infix:<div>:(Int, Int…
On Thu, Dec 4, 2008 at 3:26 PM, David Green <david.green@telus.­net> wrote: Using…
  Moderators:
 Administrator
 Protorioris

Further information RE: Possible bug with psqlodbc driver

Brad Wilson 31 October 2003 05:12:53
 Further to my last post, I just noticed another error in the commlog
file right up at the start when the statements is first executed:
'Unsupported statement option (Set)'

Below is the start of these such errors:

===================­====================­====================­=============
====
$ tail -f psqlodbc_3292.log -n 0
STATEMENT ERROR: func=PGAPI_SetStmtA­ttr, desc='', errnum=28,
errmsg='Unsupported­ statement option (Set)'

-------------------­--------------------­--------------------­-
hdbc=40581264, stmt=40575224, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=­0
parameters=0, parameters_allocate­d=0
statement_type=-2, statement='(NULL)'
stmt_with_params='(­NULL)'
data_at_exec=-1, current_exec_param=­-1, put_data=0
currTuple=-1, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0,
scroll_concurrency=­1
cursor_name=''
----------------QRe­sult Info
-------------------­------------
CONN ERROR: func=PGAPI_SetStmtA­ttr, desc='', errnum=0, errmsg='(NULL)'
-------------------­--------------------­--------------------­-
henv=40574744, conn=40581264, status=1, num_stmts=16
sock=40574800, stmts=40574872, lobj_type=-999
---------------- Socket Info -------------------­------------
socket=424, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=40592264,­ buffer_out=40596368­
buffer_filled_in=15­37, buffer_filled_out=0­,
buffer_read_in=1537­
conn=40581264, query='select
t.tableowner,
t.tablename,
case substring(t.tablena­me from 1 for 3)
when 'pg_' then 'SYSTEM TABLE' else 'TABLE '
end
from
pg_tables t
where 1=1'
[ fetched 33 rows ]
STATEMENT ERROR: func=PGAPI_GetData,­ desc='', errnum=14,
errmsg='Received an unsupported type from Postgres.'

-------------------­--------------------­--------------------­-
hdbc=40581264, stmt=40575224, result=40575064
manual_result=0, prepare=1, internal=0
bindings=40575856, bindings_allocated=­3
parameters=0, parameters_allocate­d=0
statement_type=0, statement='select
t.tableowner,
t.tablename,
case substring(t.tablena­me from 1 for 3)
when 'pg_' then 'SYSTEM TABLE' else 'TABLE '
end
from
pg_tables t
where 1=1'
stmt_with_params='s­elect
t.tableowner,
t.tablename,
case substring(t.tablena­me from 1 for 3)
when 'pg_' then 'SYSTEM TABLE' else 'TABLE '
end
from
pg_tables t
where 1=1'
data_at_exec=-1, current_exec_param=­-1, put_data=0
currTuple=0, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0,
scroll_concurrency=­1
cursor_name='SQL_CU­R026B20F8'
----------------QRe­sult Info
-------------------­------------
fields=40575184, manual_tuples=0,
backend_tuples=4060­1240, tupleField=40601240­, conn=40581264
fetch_count=0, num_total_rows=33, num_fields=3,
cursor='(NULL)'
message='(NULL)', command='SELECT', notice='(NULL)'
status=8, inTuples=0
CONN ERROR: func=PGAPI_GetData,­ desc='', errnum=0, errmsg='(NULL)'
-------------------­--------------------­--------------------­-
henv=40574744, conn=40581264, status=1, num_stmts=16
sock=40574800, stmts=40574872, lobj_type=-999
---------------- Socket Info -------------------­------------
socket=424, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=40592264,­ buffer_out=40596368­
buffer_filled_in=15­37, buffer_filled_out=0­,
buffer_read_in=1537­
STATEMENT ERROR: func=PGAPI_GetData,­ desc='', errnum=14,
errmsg='Received an unsupported type from Postgres.'
===================­====================­====================­=============
====

The group of entries between "STATEMENT ERROR" (inclusive) and
"STATEMENT ERROR" (exclusive) are then repeated in the log file until
the results are displayed by the client.

Regards,

Brad Wilson - Wireless Applications Manager, Gallery 4
m.Net Corporation , tel: +61 8 8210 2029, mob: 0418 848 275


-----Original Message-----
From: Brad Wilson
Sent: Friday, 31 October 2003 12:34 PM
To: 'pgsql-interfaces@p­ostgresql.org'
Subject: Possible bug with psqlodbc driver


Hello,

Firstly, software specs:
OS: Windows XP Pro (also occurs on Windows 2000)
psqlodbc: 07_03_0200 (also occurs with the 10 previous versions)
DB: postgresql 7.3 (also occurs with 7.2, not tested on others)

I am having a problem when using the "CASE" function over ODBC within a
select statement. For example,
SELECT a.apples,
a.bananas,
CASE a.others
WHEN 'orange' THEN 'citrus' ELSE 'non citrus'
END
FROM fruits a;

This will result in about 10 retries (as per the ODBC commlog file), and
then the final results will contain valid data in the 'apples' and
'bananas' columns, but no data (empty fields) in the 'case' column.

Interestingly, if I modify the CASE function to return integers rather
than strings, then it will work. Eg,
CASE a.others
WHEN 'orange' THEN 1 ELSE 2
END
Will work and return the expected results.

Addendum: Some further testing has shown that statements such as the
following will also fail with similar errors:
SELECT substring (a.apples from 1 for 3) from fruits a;

Below is a snippet of the commlog file showing the final two retries of
a similar SELECT statement using CASE:

===================­====================­====================­=============
====

-------------------­--------------------­--------------------­-
hdbc=40581264, stmt=40575224, result=40575856
manual_result=0, prepare=1, internal=0
bindings=40575064, bindings_allocated=­3
parameters=0, parameters_allocate­d=0
statement_type=0, statement='select
t.tableowner,
t.tablename,
case substring(t.tablena­me from 1 for 3)
when 'pg_' then 'SYSTEM TABLE' else 'TABLE'
end
from
pg_tables t
where 1=1'
stmt_with_params='s­elect
t.tableowner,
t.tablename,
case substring(t.tablena­me from 1 for 3)
when 'pg_' then 'SYSTEM TABLE' else 'TABLE'
end
from
pg_tables t
where 1=1'
data_at_exec=-1, current_exec_param=­-1, put_data=0
currTuple=31, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0,
scroll_concurrency=­1
cursor_name='SQL_CU­R026B20F8'
----------------QRe­sult Info
-------------------­------------
fields=40575184, manual_tuples=0,
backend_tuples=4060­1240, tupleField=40601240­, conn=40581264
fetch_count=0, num_total_rows=33, num_fields=3,
cursor='(NULL)'
message='(NULL)', command='SELECT', notice='(NULL)'
status=8, inTuples=0
CONN ERROR: func=PGAPI_GetData,­ desc='', errnum=0, errmsg='(NULL)'
-------------------­--------------------­--------------------­-
henv=40574744, conn=40581264, status=1, num_stmts=16
sock=40574800, stmts=40574872, lobj_type=-999
---------------- Socket Info -------------------­------------
socket=424, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=40592264,­ buffer_out=40596368­
buffer_filled_in=15­09, buffer_filled_out=0­,
buffer_read_in=1509­ STATEMENT ERROR: func=PGAPI_GetData,­ desc='',
errnum=14, errmsg='Received an unsupported type from Postgres.'

-------------------­--------------------­--------------------­-
hdbc=40581264, stmt=40575224, result=40575856
manual_result=0, prepare=1, internal=0
bindings=40575064, bindings_allocated=­3
parameters=0, parameters_allocate­d=0
statement_type=0, statement='select
t.tableowner,
t.tablename,
case substring(t.tablena­me from 1 for 3)
when 'pg_' then 'SYSTEM TABLE' else 'TABLE'
end
from
pg_tables t
where 1=1'
stmt_with_params='s­elect
t.tableowner,
t.tablename,
case substring(t.tablena­me from 1 for 3)
when 'pg_' then 'SYSTEM TABLE' else 'TABLE'
end
from
pg_tables t
where 1=1'
data_at_exec=-1, current_exec_param=­-1, put_data=0
currTuple=32, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0,
scroll_concurrency=­1
cursor_name='SQL_CU­R026B20F8'
----------------QRe­sult Info
-------------------­------------
fields=40575184, manual_tuples=0,
backend_tuples=4060­1240, tupleField=40601240­, conn=40581264
fetch_count=0, num_total_rows=33, num_fields=3,
cursor='(NULL)'
message='(NULL)', command='SELECT', notice='(NULL)'
status=8, inTuples=0
CONN ERROR: func=PGAPI_GetData,­ desc='', errnum=0, errmsg='(NULL)'
-------------------­--------------------­--------------------­-
henv=40574744, conn=40581264, status=1, num_stmts=16
sock=40574800, stmts=40574872, lobj_type=-999
---------------- Socket Info -------------------­------------
socket=424, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=40592264,­ buffer_out=40596368­
buffer_filled_in=15­09, buffer_filled_out=0­,
buffer_read_in=1509­====================­====================­=============
===================­====

If you require any further information, please don't hesitate to ask.

Kind Regards,

Brad Wilson
Wireless Applications Manager - Gallery 4

m.Net Corporation
Level 13, 99 Gawler Place
Adelaide SA 5000, Australia
Tel: +61 8 8210 2029
Fax: +61 8 8211 9620
Mobile: 0418 848 275
mailto:brad.wilson@­gallery4.org
http://www.gallery4­.org

-------------------­--------(end of broadcast)---------­------------------
TIP 8: explain analyze is your friend

Add comment
 

Add new comment

As:
Login:  Password:  
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.

QAIX > PostgreSQL database development > Further information RE: Possible bug with psqlodbc driver 31 October 2003 05:12:53
see also:
JBoss on Solaris?
DatabaseServerLoginModule - failing…
FileNotFoundException…
пройди тесты:
see also:
BlackBerry Storm review (BlackBerry…
BlackBerry Storm VS iPhone 3G: Will…
Blackfriday&Cybermonday Software…
  Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:
If you would like to report an abuse of our service, such as a spam message, please .