select - PostgreSQL query not working via ODBC (invalid object name) -


i'm stuck @ irritating message postgresql. can connect server correctly through odbc, attempt of runnig common select query ends message "invalid object name 'some_view'" (where 'some_view' view should able read data). what's interesting, query works fine when executed via pgadmin.

[edit]

the project in mfc. use crecordset. tried using options crecordset::executedirect , crecordset::nodirtyfieldcheck, no success.

seems problem caused mfc and/or crecordset class. when tried connect , execute same query using same dsn .net app, works fine.

[edit2] pasted content of both postgres logs:

1) mfc app:

[0.000]conn=05e711f8, pgapi_driverconnect( in)='dsn=mpk_local;uid=my_uid;pwd=my_pwd;', fdrivercompletion=1 [0.000]dsn info: dsn='mpk_local',server='localhost',port='5432',dbase='mpk_sql',user='my_uid',passwd='xxxxx' [0.000]          onlyread='0',protocol='7.4',showoid='1',fakeoidindex='0',showsystable='0' [0.016]          conn_settings='(null)', conn_encoding='(null)' [0.016]          translation_dll='',translation_option='' [0.016]driver version='09.03.0400,oct 26 2014' linking 1600 dynamic multithread library [0.016]global options: fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=255, max_longvarchar_size=8190 [0.016]                disable_optimizer=0, ksqo=1, unique_index=1, use_declarefetch=0 [0.016]                text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1 namedatalen=64 [0.016]                extra_systable_prefixes='dd_;', conn_settings='(null)' conn_encoding='' [0.047]    [ postgresql version string = '9.3.5' ] [0.047]    [ postgresql version number = '9.3' ] [0.047]conn=05e711f8, query='select oid, typbasetype pg_type typname = 'lo'' [0.047]    [ fetched 0 rows ] [0.047]    [ large object oid = -999 ] [0.047]    [ client encoding = 'win1250' (code = 29) ] [0.047]conn=05e711f8, pgapi_driverconnect(out)='dsn=mpk_local;database=mpk_sql;server=localhost;port=5432;uid=my_uid;pwd=my_pwd;sslmode=disable;readonly=0;protocol=7.4-1;fakeoidindex=0;showoidcolumn=1;rowversioning=0;showsystemtables=0;connsettings=;fetch=100;socket=4096;unknownsizes=0;maxvarcharsize=255;maxlongvarcharsize=8190;debug=0;commlog=1;optimizer=0;ksqo=1;usedeclarefetch=0;textaslongvarchar=1;unknownsaslongvarchar=0;boolsaschar=1;parse=1;cancelasfreestmt=0;extrasystableprefixes=dd_;;lfconversion=1;updatablecursors=1;disallowpremature=0;trueisminus1=0;bi=0;byteaaslongvarbinary=0;useserversideprepare=1;lowercaseidentifier=0;gssauthusegss=0;xaopt=1' [0.821]conn=05e711f8, pgapi_disconnect 

2) .net app

[0.000]conn=062d3f08, pgapi_driverconnect( in)='dsn=mpk_local;uid=my_uid;pwd=my_pwd;', fdrivercompletion=0 [0.016]dsn info: dsn='mpk_local',server='localhost',port='5432',dbase='mpk_sql',user='my_uid',passwd='xxxxx' [0.016]          onlyread='0',protocol='7.4',showoid='1',fakeoidindex='0',showsystable='0' [0.016]          conn_settings='(null)', conn_encoding='(null)' [0.016]          translation_dll='',translation_option='' [0.016]driver version='09.03.0400,oct 26 2014' linking 1600 dynamic multithread library [0.016]global options: fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=255, max_longvarchar_size=8190 [0.016]                disable_optimizer=0, ksqo=1, unique_index=1, use_declarefetch=0 [0.016]                text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1 namedatalen=64 [0.016]                extra_systable_prefixes='dd_;', conn_settings='(null)' conn_encoding='' [0.047]    [ postgresql version string = '9.3.5' ] [0.047]    [ postgresql version number = '9.3' ] [0.047]conn=062d3f08, query='select oid, typbasetype pg_type typname = 'lo'' [0.047]    [ fetched 0 rows ] [0.047]    [ large object oid = -999 ] [0.047]    [ client encoding = 'win1250' (code = 29) ] [0.063]conn=062d3f08, query='select line_id, name comm_lines_v order name' [0.063]    [ fetched 5 rows ] [0.063]conn=062d3f08, query='select current_schema()' [0.063]    [ fetched 1 rows ] [0.063]conn=062d3f08, query='select nspname pg_namespace n, pg_class c c.relnamespace=n.oid , c.oid='"comm_lines_v"'::regclass' [0.063]    [ fetched 1 rows ] [0.063]conn=062d3f08, query='select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, pg_get_expr(d.adbin, d.adrelid), case t.typtype when 'd' t.typbasetype else 0 end, t.typtypmod, c.relhasoids (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace , c.relname = 'comm_lines_v' , n.nspname = 'public') inner join pg_catalog.pg_attribute on (not a.attisdropped) , a.attnum > 0 , a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef , d.adrelid = a.attrelid , d.adnum = a.attnum order n.nspname, c.relname, attnum' [0.078]    [ fetched 2 rows ] [0.078]pgapi_columns: table='comm_lines_v',field_name='line_id',type=23,name='int4' [0.078]pgapi_columns: table='comm_lines_v',field_name='name',type=1043,name='varchar' [1.451]conn=062d3f08, pgapi_disconnect 

the query in question:

select * some_view 

thanks help.


Comments

Popular posts from this blog

java - Oracle EBS .ClassNotFoundException: oracle.apps.fnd.formsClient.FormsLauncher.class ERROR -

c# - how to use buttonedit in devexpress gridcontrol -

nvd3.js - angularjs-nvd3-directives setting color in legend as well as in chart elements -