problems with test/version

[Åsmund Østvold]

Trying again with out attachment :)  I can send it as a separate email if  
it is needed.

hi again

Thank you Joachim for your answer about the Network_inter problem I had!

Now I have some problem getting the test/version test to pass.  When the  
run the test in version_datatype things passes:

[aostvold@localhost version_datatype]$ LD_PRELOAD=./libtvnbr.so ./test_vnbr
version_nbr_in: parse error (NULL ptr or empty string)
version_nbr_in: parse error (NULL ptr or empty string)
version_nbr_in: parse error in  
5015710751050157107051701015805105801851.1:32 (number too long)
version_nbr_in: parse error in 1.13a.1:5 (dots in release type)
version_nbr_in: parse error in 1.2.3.4.5.6:7 (too many dots)
version_nbr_in: parse error in 1.2.3.4.:7 (too many dots)
version_nbr_in: parse error in 1.2-rc3.0:7 (dots in quantifier)
version_nbr_in: parse error in 1.2 rc3v1:7 (duplicate release type string)
version_nbr_in: parse error in 1.2 rc*3:6 (invalid character '*')
version_nbr_in: parse error in 1.2 ?:4984820 (only 7-bit ASCII is  
supported)
version_nbr_in: parse error in 1.2 release_canditate3:18 (release type too  
long)
version_nbr_in: parse error in rc3:0 (must start with number)
VALID: IN: 1, OUT: 1
VALID: IN: 1.3.0-rc2, OUT: 1.3.0rc2
VALID: IN: 2.0a, OUT: 2.0a
VALID: IN: 2.0  , OUT: 2.0
VALID: IN: 2.0  test, OUT: 2.0test
VALID: IN: 12.3.4.5 beta 2, OUT: 12.3.4.5beta2
VALID: IN: 1., OUT: 1
CMP: IN: 1.2, OUT: 1.2
CMP: IN: 1.19, OUT: 1.19
CMP: IN: 1.3.0-rc1, OUT: 1.3.0rc1
CMP: IN: 1.3.0-rc2, OUT: 1.3.0rc2
CMP: IN: 2.0.1a, OUT: 2.0.1a
CMP: IN: 2.0.1b, OUT: 2.0.1b
CMP: IN: 2alpha, OUT: 2alpha
CMP: IN: 2beta, OUT: 2beta
CMP: IN: 1.1.2a, OUT: 1.1.2a
CMP: IN: 1.1.2 a, OUT: 1.1.2a
CMP: IN: 2.01, OUT: 2.1
CMP: IN: 2.1, OUT: 2.1
CMP: IN: 1.2.3.4a2, OUT: 1.2.3.4a2
CMP: IN: 1.2.3.4a1, OUT: 1.2.3.4a1
SUCCESS.


This looks OK to me.


When I try to run `make` in test/version i get:

[aostvold@localhost version]$ make
*** running 2 tests in 'version'
#* ERROR in version: could not setup experiment. See test.log
make: *** [testing] Error 1


The test.log file is attached and the start is like this:

#* ERROR: creating SQL datatype 'version_nbr' failed.
ERROR:  btree procedures must return integer


CREATE FUNCTION version_nbr_in(opaque)
         RETURNS version_nbr AS 'libvnbr.so'
         LANGUAGE 'c';

CREATE FUNCTION version_nbr_out(opaque)
         RETURNS opaque AS 'libvnbr.so'
         LANGUAGE 'c';

CREATE TYPE version_nbr (
         internallength=24,
         input=version_nbr_in,
         output=version_nbr_out
);

CREATE FUNCTION version_nbr_eq(version_nbr, version_nbr)
         RETURNS bool AS 'libvnbr.so'
         LANGUAGE 'c';

[...]


And the end of the file is like this:

[...]
CREATE OPERATOR = (
         leftarg = version_nbr,
         rightarg = version_nbr,
         procedure = version_nbr_eq,
         restrict = eqsel,
         join = eqjoinsel,
         commutator = =,
         negator = <>,
         sort1 = <,
         sort2 = <
);

CREATE OPERATOR CLASS version_nbr_ops
     DEFAULT FOR TYPE version_nbr USING btree AS
         OPERATOR        1       < ,
         OPERATOR        2       <= ,
         OPERATOR        3       = ,
         OPERATOR        4       >= ,
         OPERATOR        5       > ,
         FUNCTION        1       version_nbr_lt_int(version_nbr,  
version_nbr);


#* ERROR: could not add value 'v_prot' to database!
     'ERROR:  type "version_nbr" does not exist\n\nALTER TABLE rundata_once  
ADD COLUMN v_prot version_nbr'
#* Setting up the experiment failed. No database created.


My OS is FC4 and I believe I have installed libvnbr.so files on the  
correct place.  I even installed it bothe in /usr/lib/ and /
usr/lib/pgsql:


[aostvold@localhost version]$ locate nbr|grep lib
/home/aostvold/perfbase/perfbase-0.9.0/pgsql/version_datatype/libvnbr.so.1.0
/home/aostvold/perfbase/perfbase-0.9.0/pgsql/version_datatype/libtvnbr.so
/usr/lib/pgsql/libvnbr.so.1.0
/usr/lib/pgsql/libvnbr.so.1
/usr/lib/pgsql/libvnbr.so
/usr/lib/libvnbr.so.1.0
/usr/lib/libvnbr.so.1
/usr/lib/libvnbr.so


I believe this is the corrcet place but I am not sure.  ld.so should be  
albe to find the filse to because:

[aostvold@localhost version_datatype]$ /sbin/ldconfig -p |grep libvnbr
         libvnbr.so.1 (libc6) => /usr/lib/libvnbr.so.1


I have for sure done something stupid but I am not able to find out what.  
If somebody see what I have done wrong do tell!


Best regards

Åsmund

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Joachim Worringen-3]

Åsmund Østvold wrote:

> When I try to run `make` in test/version i get:
>
> [aostvold@localhost version]$ make
> *** running 2 tests in 'version'
> #* ERROR in version: could not setup experiment. See test.log
> make: *** [testing] Error 1
>
>
> The test.log file is attached and the start is like this:
>
> #* ERROR: creating SQL datatype 'version_nbr' failed.
> ERROR:  btree procedures must return integer

The installation of custom datatypes in PostgreSQL seems to be a delicate issue,
and I could not yet find any real specification/documentation, only examples.
Different types of problems show up depending on your PostgreSQL version, access
rights of the user and possibly security configuration of the database server.

But I could reproduce your problem with PostgreSQL 8.1.4 (the latest version)
and have submitted a fix to the repository. If you previously downloaded the
tarball, you need to use svn now to get this version (see perfbase.tigris.org ->
Subversion -> Access Options for a mini-HowTo).

Please let me know if this works o.k., and which version of PostgreSQL you are
using.

   Joachim


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Åsmund Østvold]

On Thu, 08 Jun 2006 10:08:30 +0200, Joachim Worringen <joachim@...>  
wrote:

> The installation of custom datatypes in PostgreSQL seems to be a  
> delicate issue, and I could not yet find any real  
> specification/documentation, only examples. Different types of problems  
> show up depending on your PostgreSQL version, access rights of the user  
> and possibly security configuration of the database server.
>
> But I could reproduce your problem with PostgreSQL 8.1.4 (the latest  
> version) and have submitted a fix to the repository. If you previously  
> downloaded the tarball, you need to use svn now to get this version (see  
> perfbase.tigris.org -> Subversion -> Access Options for a mini-HowTo).
>
> Please let me know if this works o.k., and which version of PostgreSQL  
> you are using.

Thank you again!  It worked.

PostgreSQL version:
[aostvold@dpc-50 ~]$ rpm -qa|grep post
postgresql-server-8.0.8-1.FC4.1
postgresql-python-8.0.8-1.FC4.1
postgresql-devel-8.0.8-1.FC4.1
postgresql-odbc-08.00.0100-1
postgresql-libs-8.0.8-1.FC4.1
postgresql-8.0.8-1.FC4.1

Best regards

Åsmund

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...