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

[phreakdawg]

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?

[nicklas]

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

[phreakdawg]

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

[phreakdawg]

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

[nicklas]

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

[phreakdawg]

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.

[phreakdawg]

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

[robe]

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

[phreakdawg]

Yes should

close it