Re: Core Extensions relocation - Mailing list pgsql-hackers

Hello Greg, hello All,<br /><br />This is my first post at Hackers, so sorry if I am been a noob here, but I am pretty
confusedabout <br />how to create the extension pg_buffercache.<br /><br />First of all, I was trying to create using
theold method by calling the pg_buffercache--1.0.sql directly.<br /> Then I discover the change that occurs recently to
useCREATE EXTENSION, but even now I am getting the weird error:<br /><br /><pre><font size="2"># select * from
pg_available_extensions;<br/>      name      | default_version | installed_version |             comment<br /> 
----------------+-----------------+-------------------+---------------------------------<br /> plpgsql        | 1.0
       | 1.0               | PL/pgSQL procedural language<br /> pg_buffercache | 1.0             |                   |
examinethe shared buffer cache<br /> 
(2 rows)<br /><br />postgres=# CREATE EXTENSION pg_buffercache SCHEMA pg_catalog;<br />ERROR:  syntax error at or near
"NO"</font></pre>Rightnow, talking with some fellows at #postgresql they tell that the error is NOT occurring for
they.<br/> This was about 9.1beta from git.<br /><br />But even so, I need to ask, because my production is on another
versions:<br /><br />What is the right way to install this contrib at 9.0.1, 9.0.2 and 9.0.4 ?<br /><br /><br /><br
/>Manythanks,<br /><br />Best regards,<br />vinnix <br /><br /><br /><br /><div class="gmail_quote">On Thu, Jun 9, 2011
at1:14 AM, Greg Smith <span dir="ltr"><<a href="mailto:greg@2ndquadrant.com">greg@2ndquadrant.com</a>></span>
wrote:<br/><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left:1ex;"> Following up on the idea we've been exploring for making some extensions more prominent, attached
isthe first rev that I think may be worth considering seriously.  Main improvement from the last is that I reorganized
thedocs to break out what I decided to tentatively name "Core Extensions" into their own chapter.  No longer mixed in
withthe rest of the contrib modules, and I introduce them a bit differently.   If you want to take a quick look at the
newpage, I copied it to <a href="http://www.2ndquadrant.us/docs/html/extensions.html"
target="_blank">http://www.2ndquadrant.us/docs/html/extensions.html</a><br/><br /> I'm not completely happy on the
worderingthere yet.  The use of both "modules" and "extensions" is probably worth eliminating, and maybe that continues
onto doing that against the language I swiped from the contrib intro too.  There's also a lot of shared text at the end
there,common wording from that and the contrib page about how to install and migrate these extensions.  Not sure how to
refactorit out into another section cleanly though.<br /><br /> Regression tests came up last time I posted this.
 Doesn'tlook like there are any for the modules I'm suggesting should be promoted.  Only code issue I noticed during
anotherself-review here is that I didn't rename contrib/pgrowlocks/pgrowlocks--unpackaged--1.0.sql cleanly, may need to
dothat one over again to get the commits as clean as possible.<br /><br /> Updated code is at <a
href="https://github.com/greg2ndQuadrant/postgres/tree/move-contrib"
target="_blank">https://github.com/greg2ndQuadrant/postgres/tree/move-contrib</a>too, and since this is painful as a
patchthe compare view at <a href="https://github.com/greg2ndQuadrant/postgres/compare/master...move-contrib"
target="_blank">https://github.com/greg2ndQuadrant/postgres/compare/master...move-contrib</a>will be easier for
browsingthe code changes.<br /><font color="#888888"><br /> -- <br /> Greg Smith   2ndQuadrant US  
 greg@2ndQuadrant.com  Baltimore, MD<br /> PostgreSQL Training, Services, and 24x7 Support  <a
href="http://www.2ndQuadrant.us"target="_blank">www.2ndQuadrant.us</a><br /><br /><br /></font><br /><br /> --<br />
Sentvia pgsql-hackers mailing list (<a href="mailto:pgsql-hackers@postgresql.org">pgsql-hackers@postgresql.org</a>)<br
/>To make changes to your subscription:<br /><a href="http://www.postgresql.org/mailpref/pgsql-hackers"
target="_blank">http://www.postgresql.org/mailpref/pgsql-hackers</a><br/><br /></blockquote></div><br /><br clear="all"
/><br/>-- <br /><pre>Vinícius Abrahão Bazana Schmidt<br />Desenvolvimento <br />Dextra Sistemas<br /><a
href="http://www.dextra.com.br"target="_blank">www.dextra.com.br</a><br />+55 19 3256-6722 Ramal 246<br /> 
<br />Este email é confidencial. Mais informações em:<br />This message is confidential. More information at:<br /><a
href="http://www.dextra.com.br/confidencial.htm"target="_blank">www.dextra.com.br/confidencial.htm</a></pre><br />--<br
/>vi[nnix]™<br/>aka: Vinícius Abrahão Bazana Schmidt<br /><a href="http://vischmidt.wordpress.com"
target="_blank">vischmidt.wordpress.com</a><br/><a href="http://twitter.com/vischmidt"
target="_blank">twitter.com/vischmidt</a><br/><br />