Thread: [Fwd: [pgsql-es-ayuda] Problema con ODBC de Postgresql]
I i have a sql sentence:
select valoracion.svmame.co_item as codigo,
valoracion.svmame.nb_item as nombre,
public.systab02.nb_tipo as modelo
from valoracion.svmame ,
public.systab02
where valoracion.svmame.id_estado = 'SA' and
public.systab02.co_tipo = valoracion.svmame.co_tipo_modelo
order by valoracion.svmame.co_tipo_modelo, valoracion.svmame.co_item
when the execute from the server side it`s run well, but when the execute
from a client aplication with postgresql odbc say:
ERROR: la referencia a la columna "ctid" es ambigua
the versión of postgrsqlODBC es 7.03.02
please any idea
thank you
Mario Soto
---------------------------(end of broadcast)---------------------------
TIP 5: ¿Has leído nuestro extenso FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
--- "Mario A. Soto Cordones" <mario_soto@venezolanadeavaluos.com> wrote: > I i have a sql sentence: > > select valoracion.svmame.co_item as codigo, > valoracion.svmame.nb_item as nombre, > public.systab02.nb_tipo as modelo > from valoracion.svmame , > public.systab02 > where valoracion.svmame.id_estado = 'SA' and > public.systab02.co_tipo = > valoracion.svmame.co_tipo_modelo > order by valoracion.svmame.co_tipo_modelo, > valoracion.svmame.co_item > > when the execute from the server side it`s run well, > but when the execute > from a client aplication with postgresql odbc say: > > ERROR: la referencia a la columna "ctid" es ambigua Try setting the "row versioning" driver option to true. > > the versi�n of postgrsqlODBC es 7.03.02 > > please any idea > > thank you > > Mario Soto > > > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 5: �Has le�do nuestro extenso FAQ? > > > http://www.postgresql.org/docs/faqs/FAQ.html > > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 8: explain analyze is your friend > __________________________________ Do you Yahoo!? Yahoo! Mail - 250MB free storage. Do more. Manage less. http://info.mail.yahoo.com/mail_250
Thank you very much, with this change the problem it´s solve Mario Soto > --- "Mario A. Soto Cordones" > <mario_soto@venezolanadeavaluos.com> wrote: > >> I i have a sql sentence: >> >> select valoracion.svmame.co_item as codigo, >> valoracion.svmame.nb_item as nombre, >> public.systab02.nb_tipo as modelo >> from valoracion.svmame , >> public.systab02 >> where valoracion.svmame.id_estado = 'SA' and >> public.systab02.co_tipo = >> valoracion.svmame.co_tipo_modelo >> order by valoracion.svmame.co_tipo_modelo, >> valoracion.svmame.co_item >> >> when the execute from the server side it`s run well, >> but when the execute >> from a client aplication with postgresql odbc say: >> >> ERROR: la referencia a la columna "ctid" es ambigua > > Try setting the "row versioning" driver option to > true. > >> >> the versión of postgrsqlODBC es 7.03.02 >> >> please any idea >> >> thank you >> >> Mario Soto >> >> >> >> >> >> ---------------------------(end of >> broadcast)--------------------------- >> TIP 5: ¿Has leído nuestro extenso FAQ? >> >> >> http://www.postgresql.org/docs/faqs/FAQ.html >> >> >> >> >> ---------------------------(end of >> broadcast)--------------------------- >> TIP 8: explain analyze is your friend >> > > > > > __________________________________ > Do you Yahoo!? > Yahoo! Mail - 250MB free storage. Do more. Manage less. > http://info.mail.yahoo.com/mail_250 > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster