Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id A495C9E8853 for ; Wed, 9 May 2012 14:06:53 -0300 (ADT) Received: from mail-qc0-f174.google.com ([209.85.216.174]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SSALk-0007Af-I3 for pgsql-admin@postgresql.org; Wed, 09 May 2012 17:06:53 +0000 Received: by qcro28 with SMTP id o28so403967qcr.19 for ; Wed, 09 May 2012 10:06:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:subject :content-type:content-transfer-encoding; bh=f4bzj8cV37h1uvOh9yFCu6MDnUeskuTTmcnqMAgnOrs=; b=h6AMtpg3ulbzGis5AAuuipMC2/YUayS41SqTdqVrWci1SNN9eIiVk10hrbH1q3cxjn cbjf9Xoix6qZSuUom7cwsw0GUhJhwuM+ovueTTovDBvh3mVBRNrrxp72oSyn3RgmnMWc GBZ5ngWiSIavXl0dLz/6D6bG3FIzBCa18O76HOdR3oBYLukl21+y0Rypk4E91HWwnwG2 A9EjczV1n37kR++UjhDHwExpSwVXDFIKCGl8Z5X+sK9itVqdRTUb3xdLmjxUIL0Im0v2 k8sJD9RGHe6f2IPJz+7KIIi6jvsN+EwHVmMjhdQaGdQmugxwJqiC2MRg7PLMp36iSfYD sYUg== Received: by 10.224.176.148 with SMTP id be20mr6398296qab.64.1336583200216; Wed, 09 May 2012 10:06:40 -0700 (PDT) Received: from Chander-Ganesans-MacBook-Pro-2.local (cpe-071-070-226-197.nc.res.rr.com. [71.70.226.197]) by mx.google.com with ESMTPS id r19sm11145238qae.14.2012.05.09.10.06.39 (version=TLSv1/SSLv3 cipher=OTHER); Wed, 09 May 2012 10:06:39 -0700 (PDT) Message-ID: <4FAAA41E.8080501@gmail.com> Date: Wed, 09 May 2012 13:06:38 -0400 From: Chander Ganesan User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:12.0) Gecko/20120428 Thunderbird/12.0.1 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Extension prevents dumping table? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201205/51 X-Sequence-Number: 39540 With PostGIS 2.0 if I load/install postgis using the command: create extension postgis schema postgis; And then use the command: pg_dump -t postgis.spatial_ref_sys dbname > spatial_ref_sys.sql I get an output that contains a few "set" statements, but no table definition or data from the table. However, if I install the PostGIS components the "old" way (not using the extension loader), the pg_dump of the table works just fine. Any ideas how to fix this or why this happens? thanks chander