Databases
StackOverflow2013
Postsdbo
POInstalling PL/Ruby for PostgreSQL 8.3
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POInstalling PL/Ruby for PostgreSQL 8.3
    primarykey
    data
    text
    <p>This is to enable the development of <strong>postgres</strong> functions with embedded <strong>ruby</strong> code, but I have been unable to build it.</p> <p>As advised by <a href="http://www.robbyonrails.com/articles/2005/08/22/installing-untrusted-pl-ruby-for-postgresql" rel="nofollow noreferrer">http://www.robbyonrails.com/articles/2005/08/22/installing-untrusted-pl-ruby-for-postgresql</a></p> <p>I am trying to build the needed plruby.so from the latest version (plruby-0.5.3.tar.gz) provided at <a href="ftp://moulon.inra.fr/pub/ruby/" rel="nofollow noreferrer">ftp://moulon.inra.fr/pub/ruby/</a></p> <p>I've sorted out where my local postgres set up is and adjusted the invocation to:</p> <pre><code>ruby extconf.rb --with-pgsql-include=/usr/postgresql-8.3.4/include/server --enable-shared --disable-conversion --with-pgsql-version=83 </code></pre> <p>I've tried quite number of variations on that, but it does not seem to be able to successfully make the 'conftest.c' file</p> <p>It says this:</p> <pre><code>checking for catalog/pg_proc.h... yes *** extconf.rb failed *** Could not create Makefile due to some reason, probably lack of necessary libraries and/or headers. Check the mkmf.log file for more details. You may need configuration options. </code></pre> <p>And here is what I end up with in my mkmf.log </p> <pre><code>have_header: checking for catalog/pg_proc.h... -------------------- yes "gcc -E -I. -I/usr/lib/ruby/1.8/x86_64-linux -I. -I/usr/postgresql-8.3.4/include/server -g -O2 -fPIC conftest.c -o conftest.i" checked program was: /* begin */ 1: #include &lt;catalog/pg_proc.h&gt; /* end */ </code></pre> <p>When I run the gcc line manually, it says there is no 'conftest.c' (and there is not, but it is supposed to be generated).</p> <pre><code>'uname -a' ... gives Linux vdev1 2.6.18.8-xen #2 SMP Thu May 8 11:52:29 PDT 2008 x86_64 x86_64 x86_64 GNU/Linux 'ruby -v' ... gives ruby 1.8.6 (2008-08-11 patchlevel 287) [x86_64-linux] </code></pre> <p>Any help and/or advice would be appreciated.</p> <p>-- Mike Berrow</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USVictor
    1. USMike Berrow
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POInstalling PL/Ruby for PostgreSQL 8.3
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POInstalling PL/Ruby for PostgreSQL 8.3
      1. USArto Bendiken
      1. VTFavorite
    3. VO
      singulars
      1. POInstalling PL/Ruby for PostgreSQL 8.3
      1. USNicholas White
      1. VTFavorite
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload