Re: Extension upgrade, patch v0: debug help needed

Dimitri Fontaine <dimitri@2ndquadrant.fr>

From: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
To: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2011-01-02T10:57:02Z
Lists: pgsql-hackers
Dimitri Fontaine <dimitri@2ndQuadrant.fr> writes:
> The problem occurs on ALTER OPERATOR FAMILY ... SET EXTENSION, that's
> what dichotomy on the citext.upgrade.sql tells me.

The code in question was copy/pasted from the SET SCHEMA code path in
gram.y then other related files.  So I just tested a clean HEAD checkout
then the following steps:

  make -C contrib/citext install
  psql -f .../head/share/contrib/citext.sql
  psql
  dim=# do $$ begin execute 'alter operator class public.citext_ops using btree set schema utils'; end; $$;
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

Will try to debug that as soon as possible, but spare time here tends to
be sparse so I preferred sending this mail first.  Preliminary
investigation leads me thinking the cause is using n->objarg rather than
n->addname to host the access_method.  Working on a fix.

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support