[Pljava-dev] CVS HEAD is now Java 6.

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