Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Interfaces Odbc > When using tem*...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 2288 of 2384
Post > Topic >>

When using tem****ary tables, Excel do not refresh data

by j6m@[EMAIL PROTECTED] ("J6M") Feb 20, 2008 at 06:34 PM

Hi,

I run in a bit of trouble with configuring psqlODBC that I use to retrieve
data from a PG box to Excel sheets. On my PC, queries with multiple
statements using tem****ary tables just work fine. On the other computers
of
our school, such queries do execute without apparent errors (ps axuw |
grep 
postgres) but data are not refreshed when returned.

E.g.

select now();  works OK on all computers

but

select now() into temp table t; select * from t;  works only on mine.


I have psqlODBC 7.3.2 installed on my computer. I installed psqlODBC 8.2.x

and 8.3.0 on other computers. There must be something I missed in the 
configuration of  these new releases of psqlODBC. (Server is 8.1.11)

I suppose this is a known question but I could not find any online or
downloadable do***entation from www.postgresql.org regarding psqlODBC. In
appandix H of the postgesql 8.2 A4 PDF manual (pages 1618 or 1666) there
is
a given site for psqlODBC. However, it is not reachable. :(

I could not find any answer in the last 4 months of psql-odbc mailing list

archives either.



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match
 




 3 Posts in Topic:
When using tem****ary tables, Excel do not refresh data
j6m@[EMAIL PROTECTED] (&  2008-02-20 18:34:28 
Re: When using tem****ary tables, Excel do not refresh data
inoue@[EMAIL PROTECTED]   2008-02-23 08:03:33 
Re: When using tem****ary tables, Excel do not refresh data
j6m@[EMAIL PROTECTED] (&  2008-02-25 12:25:28 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Thu Jul 24 6:56:13 CDT 2008.