Re: ALTER EXTENSION .. ADD/DROP weirdness

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: ALTER EXTENSION .. ADD/DROP weirdness
Date: 2011-10-10 16:34:21
Message-ID: 376.1318264461@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> rhaas=# alter extension pg_stat_statements drop type pg_stat_statements[];
> ERROR: syntax error at or near "["
> LINE 1: ...extension pg_stat_statements drop type pg_stat_statements[];
> ^

> Hmm. So just how do I do this?

"alter extension pg_stat_statements drop type _pg_stat_statements",
probably.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2011-10-10 16:38:15 Re: patch: move dumpUserConfig call in dumpRoles function of pg_dumpall.c
Previous Message Tom Lane 2011-10-10 16:14:06 Re: patch: move dumpUserConfig call in dumpRoles function of pg_dumpall.c