So this works fine in 1.6.3 (and psql), but in 1.8.0 beta's query window:


-- Executing query:
select now()

Total query runtime: 32 ms.
1 rows retrieved.

-- Executing query:
select now()::time

Total query runtime: 3766 ms.
1 rows retrieved.

-- Executing query:
select now()::time

Total query runtime: 12141 ms.
1 rows retrieved.

-- Executing query:
select now()::time

Total query runtime: 1938 ms.
1 rows retrieved.

-- Executing query:
select now()::time

Total query runtime: 15 ms.
1 rows retrieved.

-- Executing query:
select now()::time

Total query runtime: 2031 ms.
1 rows retrieved.

-- Executing query:
select now()::time

Total query runtime: 13032 ms.
1 rows retrieved.

-- Executing query:
select now()::time

Total query runtime: 1250 ms.
1 rows retrieved.

-- Executing query:
select now()::time

Total query runtime: 1000 ms.
1 rows retrieved.

-- Executing query:
select now()::time

Total query runtime: 219 ms.
1 rows retrieved.

-- Executing query:
select now()::time

Total query runtime: 16 ms.
1 rows retrieved.


The weird part is, it always returns the row right away like it should,
but most times also keeps executing forever, until I press F5 again. To
get it to stop, pressing repeatedly a few times seems to help.

Kev

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Kevin Field wrote:
> So this works fine in 1.6.3 (and psql), but in 1.8.0 beta's query window:
>
> The weird part is, it always returns the row right away like it should,
> but most times also keeps executing forever, until I press F5 again. To
> get it to stop, pressing repeatedly a few times seems to help.

I committed a fix for that a couple of weeks back - it'll be in beta 3
(probably tomorrow).

http://svn.pgadmin.org/cgi-bin/viewc...=6499&view=rev

Thanks, Dave.

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate