From: pierce at hogranch.com (John R Pierce)
Date: Thu, 01 Dec 2011 16:39:07 -0800
Subject: [Pljava-dev] CVS HEAD is now Java 6.
In-Reply-To: <4ED7FFC1.4050001@hogranch.com>
References: <x6r51s1vrt.fsf@2ndquadrant.com> <4ED7E5DE.7040703@hogranch.com>
	<4ED7FFC1.4050001@hogranch.com>
Message-ID: <4ED81E2B.6010307@hogranch.com>

On 12/01/11 2:29 PM, John R Pierce wrote:
> On 12/01/11 12:38 PM, John R Pierce wrote:
>> I need to setup pljava on 64bit postgres 9.0 and sun jdk 6 on centos6...
>
> After a couple stumbles and false starts, CVS HEAD builds and loads 
> with the install.sql without errors. 

just to confirm that...

$ psql -f src/sql/install.sql
CREATE SCHEMA
GRANT
CREATE FUNCTION
CREATE LANGUAGE
CREATE FUNCTION
CREATE LANGUAGE
psql:src/sql/install.sql:23: NOTICE:  CREATE TABLE will create implicit 
sequence "jar_repository_jarid_seq" for serial column "jar_repository.jarid"
psql:src/sql/install.sql:23: NOTICE:  CREATE TABLE / PRIMARY KEY will 
create implicit index "jar_repository_pkey" for table "jar_repository"
psql:src/sql/install.sql:23: NOTICE:  CREATE TABLE / UNIQUE will create 
implicit index "jar_repository_jarname_key" for table "jar_repository"
CREATE TABLE
GRANT
psql:src/sql/install.sql:32: NOTICE:  CREATE TABLE will create implicit 
sequence "jar_entry_entryid_seq" for serial column "jar_entry.entryid"
psql:src/sql/install.sql:32: NOTICE:  CREATE TABLE / PRIMARY KEY will 
create implicit index "jar_entry_pkey" for table "jar_entry"
psql:src/sql/install.sql:32: NOTICE:  CREATE TABLE / UNIQUE will create 
implicit index "jar_entry_jarid_entryname_key" for table "jar_entry"
CREATE TABLE
GRANT
ALTER TABLE
psql:src/sql/install.sql:43: NOTICE:  CREATE TABLE / PRIMARY KEY will 
create implicit index "classpath_entry_pkey" for table "classpath_entry"
CREATE TABLE
GRANT
psql:src/sql/install.sql:50: NOTICE:  CREATE TABLE will create implicit 
sequence "typemap_entry_mapid_seq" for serial column "typemap_entry.mapid"
psql:src/sql/install.sql:50: NOTICE:  CREATE TABLE / PRIMARY KEY will 
create implicit index "typemap_entry_pkey" for table "typemap_entry"
CREATE TABLE
GRANT
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION

$ psql
...
piercej=# set search_path=sqlj,public;
SET
piercej=# \df+
                                                                                                   List of functions
  Schema |        Name        | Result data type  |              
Argument data types              |  Type  | Volatility |  Owner  | 
Language |                        Source code                        | 
Description
--------+--------------------+-------------------+-----------------------------------------------+--------+------------+---------+----------+-----------------------------------------------------------+-------------
  sqlj   | add_type_mapping   | void              | character varying, 
character varying          | normal | volatile   | piercej | java     | 
org.postgresql.pljava.management.Commands.addTypeMapping  |
  sqlj   | drop_type_mapping  | void              | character 
varying                             | normal | volatile   | piercej | 
java     | org.postgresql.pljava.management.Commands.dropTypeMapping |
  sqlj   | get_classpath      | character varying | character 
varying                             | normal | stable     | piercej | 
java     | org.postgresql.pljava.management.Commands.getClassPath    |
  sqlj   | install_jar        | void              | bytea, character 
varying, boolean             | normal | volatile   | piercej | java     
| org.postgresql.pljava.management.Commands.installJar      |
  sqlj   | install_jar        | void              | character varying, 
character varying, boolean | normal | volatile   | piercej | java     | 
org.postgresql.pljava.management.Commands.installJar      |
  sqlj   | java_call_handler  | language_handler  
|                                               | normal | volatile   | 
piercej | c        | 
java_call_handler                                         |
  sqlj   | javau_call_handler | language_handler  
|                                               | normal | volatile   | 
piercej | c        | 
javau_call_handler                                        |
  sqlj   | remove_jar         | void              | character varying, 
boolean                    | normal | volatile   | piercej | java     | 
org.postgresql.pljava.management.Commands.removeJar       |
  sqlj   | replace_jar        | void              | bytea, character 
varying, boolean             | normal | volatile   | piercej | java     
| org.postgresql.pljava.management.Commands.replaceJar      |
  sqlj   | replace_jar        | void              | character varying, 
character varying, boolean | normal | volatile   | piercej | java     | 
org.postgresql.pljava.management.Commands.replaceJar      |
  sqlj   | set_classpath      | void              | character varying, 
character varying          | normal | volatile   | piercej | java     | 
org.postgresql.pljava.management.Commands.setClassPath    |
(11 rows)



-- 
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast