Re: Materialized View Patch File - Mailing list pgadmin-hackers

From Dave Page
Subject Re: Materialized View Patch File
Date
Msg-id CA+OCxozavBu2c6cWQrnTgx+Wq7uL462RYGyU_3viP8JY-GjLxA@mail.gmail.com
Whole thread Raw
In response to Re: Materialized View Patch File  (Neel Patel <neel.patel@enterprisedb.com>)
Responses Re: Materialized View Patch File  (Neel Patel <neel.patel@enterprisedb.com>)
List pgadmin-hackers
On Wed, Jul 17, 2013 at 12:23 PM, Neel Patel
<neel.patel@enterprisedb.com> wrote:
> Hi Dave,
>
> Just want to know.
>
> Now we are passing GetName() to qtDbString() and to form the complete query
> we need to use qtDbString() to compare the string.
>
> We have added below string.
>
> wxString sql = wxT("SELECT count(*) FROM pg_matviews WHERE matviewname = ")
> + qtDbString(this->GetName()) + wxT(" AND schemaname = ") +
> qtDbString(this->GetSchema()->GetName());
>
> Is it correct ?

I'd expect you to be using GetQuotedIdentifier() there. For a view and
schema, the identifier is the name anyway.


--
Dave Page
Chief Architect, Tools & Installers
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake


pgadmin-hackers by date:

Previous
From: Neel Patel
Date:
Subject: Re: Materialized View Patch File
Next
From: Javier Urbano Contreras
Date:
Subject: comparison schema/data