Re: why does this select hang postgres???

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: Jeremy Hansen <jeremy(at)xxedgexx(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: why does this select hang postgres???
Date: 2001-08-10 18:49:12
Message-ID: 3B742CA8.9000502@selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How do you know it is just sitting there. Do you see that cpu isn't
being used? How many rows do you expect this to return? What version of
postgres? (do a select version())

Jeremy Hansen wrote:
> select * from env_info,summary,plat_info;
>
> Is my statement broken? Is this not legal? Postgres just sits there....
>
> My goal is to select everything from multiple tables with one sql
> statement.
>
> Thank You!
> -jeremy
>
>

--
Joseph Shraibman
jks(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Susan Lane 2001-08-10 19:01:55 Ora2pg.pl - some feedback
Previous Message Bruce Momjian 2001-08-10 18:42:59 Re: why does this select hang postgres???