View Single Post

   
  #2 (permalink)  
Old 04-17-2008, 04:27 PM
Hiroshi Inoue
 
Posts: n/a
Default Re: 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

Reply With Quote