| << 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:
|
j6m@[EMAIL PROTECTED]
(& |
2008-02-20 18:34:28 |
|
inoue@[EMAIL PROTECTED]
|
2008-02-23 08:03:33 |
|
j6m@[EMAIL PROTECTED]
(& |
2008-02-25 12:25:28 |
|
Post A Reply:

|