[postgis-users] psql -f postgis.sql -d , ERROR: parser: parse error at or near "class"

[strk at refractions.net]

On Tue, Dec 21, 2004 at 06:58:17PM +0100, strk at refractions.net wrote:
> On Tue, Dec 21, 2004 at 11:55:00AM -0600, ajaramil wrote:
> > 
> > FUNCTION 7 gbox_same (box, box, internal);  <<< (1825)
> 
> mmm.. where is "class" ?
> Anyway, try replaceing 'internal' with 'opaque'
> --strk;

BTW, postgis.sql is created by postgis.sql.in, in which  that
line is:

CREATEFUNCTION gbox_same(box, box, OPAQUE_TYPE)

Where OPAQUE_TYPE is defined as follow:

#if USE_VERSION < 73
#define OPAQUE_TYPE opaque
#else
#define OPAQUE_TYPE internal
#endif

... Are you sure you compiled postgis against postgres-7.2 sources ?
If you didn't you might encounter other problems, check for 
-DUSE_VERSION in make output (make clean first).

--strk;

> 
> > 
> > UPDATE pg_opclass                           <<< (1827)
> >        SET opckeytype = (select oid from pg_type where
> > typname = 'box') WHERE ...........          <<< (1828)
> > 
> > 
> > > On Tue, Dec 21, 2004 at 11:31:17AM -0600, ajaramil wrote:
> > > > I installed postgres (7.2) -postgis (0.9.1) in fedora 3,
> > > > everything goes well until the last step.
> > > >
> > > > psql -f postgis.sql -d
> > > >
> > > > where I receive this error:
> > > >
> > > > [postgres at hst000014811um ~]$ /usr/local/pgsql/bin/psql
> > > > -f postgis.sql -d oxford
> > > > BEGIN
> > > >         message
> > > > ------------------------
> > > >  PL/PgSQL is installed.
> > > > (1 row)
> > > >
> > > > CREATE
> > > > ....
> > > > CREATE
> > > > CREATE
> > > > CREATE
> > > > psql:postgis.sql:1825: ERROR:  parser: parse error at or
> > > > near "class"
> > >
> > > Can you show us line 1825 of postgis.sql ?
> > > --strk;
> > >
> > > > psql:postgis.sql:1829: NOTICE:  current transaction is
> > > > aborted, queries ignored until end of transaction block
> > > > *ABORT STATE*
> > > > ........
> > > > psql:postgis.sql:2354: NOTICE:  current transaction is
> > > > aborted, queries ignored until end of transaction block
> > > > *ABORT STATE*
> > > > COMMIT
> > > > [postgres at hst000014811um ~]$
> > > >
> > > > Any idea about the error? I checked the archives, the
> > > > only reference there suggest to execute the pgsql as
> > > > postgres, I'm doing that and still doesn't work.
> > > >
> > > >
> > > > I previously got an error in line 436, then since
> > > > "rename_geometry_table_constrains" is used only for
> > > > updates I erased that function. I hope it is not a big
> > > > deal.
> > > > Thanks, Alex Jaramillo
> > > > _______________________________________________
> > > > postgis-users mailing list
> > > > postgis-users at postgis.refractions.net
> > > >
> > >
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > >