Re: [bug] Execute pgScript Returns Error Without Executing The Query

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Emre Hasegeli <emre(dot)hasegeli(at)tart(dot)com(dot)tr>
Cc: PgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: [bug] Execute pgScript Returns Error Without Executing The Query
Date: 2012-01-27 23:20:38
Message-ID: 1327706438.3355.12.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

On Fri, 2012-01-27 at 14:09 +0200, Emre Hasegeli wrote:
> On Fri, 27 Jan 2012 12:32:45 +0200, Guillaume Lelarge
> <guillaume(at)lelarge(dot)info> wrote:
>
> > On Fri, 2012-01-27 at 11:05 +0200, Emre Hasegeli wrote:
> >> On Thu, 26 Jan 2012 23:18:29 +0200, Guillaume Lelarge
> >> <guillaume(at)lelarge(dot)info> wrote:
> >>
> >> > You do know that 1.12 is obsolete, right? if ever we had to fix an
> >> > issue, it would be on 1.14, and not 1.12.
> >>
> >> No problem. I thought it could be serious even it effects only previous
> >> version.
> >>
> >
> > Actually, I don't even know your issue. All I see in your previous is
> > three queries, and they all work for me.
>
> I should have include outputs of the queries:
>
> > On Thu, 2012-01-26 at 12:41 +0200, Emre Hasegeli wrote:
>
> >> How to reproduce:
> >>
> >> * Open an SQL window
> >> * Execute pgScript: Select true from ATable
>
> [WARNING ] Select true from ATable
> ERROR: relation "atable" does not exist
> LINE 1: Select true from ATable
>
> >> * Execute query: Create table ATable (id int)
> >> * Execute pgScript: Select true from ATable
>
> [WARNING ] Select true from ATable
> ERROR: relation "atable" does not exist
> LINE 1: Select true from ATable
>

I tried 1.15, 1.14, and 1.12. They all work for me. First query,
launched with pgScript, gave me an error because the table doesn't
exist. Second query creates the table. Third query, launched with
pgScript, just works.

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
PostgreSQL Sessions #3: http://www.postgresql-sessions.org

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2012-01-27 23:23:00 Re: can't delete a database which does not exist
Previous Message Giuseppe Sacco 2012-01-27 16:05:58 error "permission denied for relation" on postgresql 9.0.6 during CREATE TABLE