Обсуждение: When using temporary tables, Excel do not refresh data

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 temporary 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 documentation 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.

J6M wrote:
> 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 temporary 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.

Could you send me directly the Mylog output of the other computers ?

regards,
Hiroshi Inoue

Hi,

I tried this European morning. The problem gets more obscure. Although I
checked the two "create log" boxes, there is no log created.

Ithen came to the network administrator for any permission difference. He
said there is none. Each user has the rights of a local administrator on his
station. The only difference between mine and others is that I have a fixed
IP. This is just to allow me to pass through the firewall to access servers
via SSH on diffrent networks.

However, my PC, the PCs where I tried to refres data with no success and the
PG server are on the same network. Soo there is no firewalling involved (and
if there was any both queries would be blocked).

Huhh ?? Any suggestion ?

Regards
J6M

----- Original Message -----
From: "Hiroshi Inoue" <inoue@tpf.co.jp>
To: "J6M" <j6m@adm.estp.fr>
Cc: <pgsql-odbc@postgresql.org>
Sent: Saturday, February 23, 2008 12:03 AM
Subject: Re: [ODBC] When using temporary tables, Excel do not refresh data


> J6M wrote:
>> 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 temporary 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.
>
> Could you send me directly the Mylog output of the other computers ?
>
> regards,
> Hiroshi Inoue
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq