Horton

Re: ALTER EXTENSION .. ADD/DROP weirdness

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-hackers@postgresql.org
Date: 2011-10-10T16:34:21Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Rethink behavior of CREATE OR REPLACE during CREATE EXTENSION.

Robert Haas <robertmhaas@gmail.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