[postgis-users] psql -f postgis.sql -d , ERROR: parser: parse error at or near "class"
strk at refractions.net
strk at refractions.net
Tue Dec 21 10:01:00 PST 2004
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
> > >
More information about the postgis-users
mailing list