Opened 10 years ago

Closed 10 years ago

#3047 closed defect (worksforme)

ERROR: function st_astwkb(geometry, integer) does not exist

Reported by: phreakdawg Owned by: nicklas
Priority: medium Milestone: PostGIS 2.2.0
Component: postgis Version: master
Keywords: Cc:

Description

For a couple different machines, any attempt to issue a 'CREATE EXTENSION postgis' results in the following error:, when I have the latest repository version installed:

ERROR: function st_astwkb(geometry, integer) does not exist

make check passes all tests. Does anyone know why this is happening?

Change History (10)

comment:1 by nicklas, 10 years ago

Is it latest trunk you are using, or is it precompiled windows binaries? If so, from what date and revision?

comment:2 by phreakdawg, 10 years ago

This is the latest trunk from the official svn repository, as of yesterday evening.

comment:3 by phreakdawg, 10 years ago

Also, in case it's relevant, these are from 2 different Linux machines, not Windows.

comment:4 by nicklas, 10 years ago

I works as expected for me.

Is it a fresh database that you are trying to install in?

It is correct that function st_astwkb(geometry, integer) does not exist. It is a replaced with a version using default values instead of multiple functions.

see below.

So I don't really understand why that signature is requested at all.

CREATE OR REPLACE FUNCTION st_astwkb(
    geometry,
    integer,
    bigint DEFAULT NULL::bigint,
    boolean DEFAULT false,
    boolean DEFAULT false)
  RETURNS bytea AS
'$libdir/postgis-2.2', 'TWKBFromLWGEOM'
  LANGUAGE c IMMUTABLE
  COST 1;
ALTER FUNCTION st_astwkb(geometry, integer, bigint, boolean, boolean)

The only thing I can think of is if you haven't run ./configure after update. Then you might have old .sql files but new .sql.in files

comment:5 by phreakdawg, 10 years ago

It is a fresh database, and I am running configure. That is interesting to know that this function is replaced now. Tomorrow or Monday when I have time, I'm going to completely blow away both postgres and postgis on one of the machines and see what I get after that.

comment:6 by phreakdawg, 10 years ago

Well, blowing all my postgis files and reinstalling everything seemed to fix it. Somehow along the way they stopped updating some files I think.

comment:7 by pramsey, 10 years ago

Milestone: PostGIS 2.2.0
Owner: changed from pramsey to nicklas

comment:8 by robe, 10 years ago

Can we close this one out? I can't replicate the issue so seems like a corrupt install to me.

comment:9 by phreakdawg, 10 years ago

Yes should

close it

comment:10 by robe, 10 years ago

Resolution: worksforme
Status: newclosed
Note: See TracTickets for help on using tickets.