Re: [pgadmin-support] Help for Migration

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
Cc: Mamatha_Kagathi_Chan(at)DELL(dot)com, haramrae(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: [pgadmin-support] Help for Migration
Date: 2011-12-07 13:30:22
Message-ID: 1323264622.2244.34.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-general

On Wed, 2011-12-07 at 21:23 +0800, Craig Ringer wrote:
> On 12/07/2011 06:57 PM, Mamatha_Kagathi_Chan(at)DELL(dot)com wrote:
> [...]
> > I can also get the same result if I execute it in pgadmin (version downloaded from postgres community) which is on a different client machine but connected to the server on enterpriseDB version
> > As EXEC proc.
> If you're connected to EnterpriseDB, I'd expect that.
>
> If you're connected to PostgreSQL, maybe PgAdmin is translating EXEC
> into a SELECT ?
>

pgAdmin doesn't translate queries executed by the user. If EXEC works on
EDB AS, then pgadmin will fire it with success. If it doesn't, pgadmin
will fire it, and the result will be a failure.

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2011-12-07 13:33:59 Re: [pgadmin-support] Help for Migration
Previous Message Craig Ringer 2011-12-07 13:23:21 Re: [pgadmin-support] Help for Migration

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2011-12-07 13:33:59 Re: [pgadmin-support] Help for Migration
Previous Message Pavel Stehule 2011-12-07 13:26:22 is there example of update skript?