[postgis-users] Running createlang and postgis.sql
Mike Leahy
mgleahy at fes.uwaterloo.ca
Wed Jun 4 07:55:14 PDT 2003
Robert,
You are correct about the commit. I've found in the postgis.sql file
that I'm using there is an extraneous "end transaction;" about two
thirds of the way through the script (Line 761 of the attached file). I
think that despite the lack of a matching "begin transaction;",
everything is working fine, but I don't want to find out later on that
I'm missing a bunch of the functions that are defined in this file. Can
someone suggest whether I should add a begin transaction, and if so,
where should it go?
Thanks for the help,
Mike
-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paul
Ramsey
Sent: June 3, 2003 11:47 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Running createlang and postgis.sql
At a minimum we appear to have an extraneous 'commit' (or a missing
'begin') in the sql file which needs to be paired up. The other warnings
are normal and can be ignored -- when postgresql creates new types there
is a brief period of chicken-and-egg, when types have been created and
their constructurs have not, which raises a warning.
P.
Robert W. Burgholzer wrote:
> Mike,
> I just had the same question today, thanks for posting it. It seems
that all
> is right with the data import and I have successfully added data, and
> retrieved it via avpgcon. So, I would say, no, you needn't be
concerned,
> however, I am not the expert, thus all I say is speculation.
>
> Perhaps this is a newer, more extensive error condition being reported
by
> postgresql, are you running postgresql 7.3.3?? (I am)
>
> Robert Burgholzer
>
>
>>===== Original Message From PostGIS Users Discussion
>
> <postgis-users at postgis.refractions.net> =====
>
>>Just a couple questions.when I run the command "createlang plpgsql
>>[DBNAME]" - I'm guessing that means the build that I got already
>>includes this language?
>>
>>
>>
>>Next, when I run "psql -d independencia -f postgis.sql", I get the
>>following notices:
>>
>>
>>
>>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
>>'spatial_ref_sys_pkey' for table 'spatial_ref_sys'
>>
>>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'gc_pk'
>>for table 'geometry_columns'
>>
>>NOTICE: ProcedureCreate: type box3d is not yet defined
>>
>>NOTICE: ProcedureCreate: type spheroid is not yet defined
>>
>>NOTICE: ProcedureCreate: type wkb is not yet defined
>>
>>NOTICE: ProcedureCreate: type chip is not yet defined
>>
>>NOTICE: ProcedureCreate: type geometry is not yet defined
>>
>>NOTICE: COMMIT: no transaction in progress
>>
>>
>>
>>Is this an issue I should be concerned about?
>>
>>
>>
>>Kind regards,
>>
>>Mike
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
A non-text attachment was scrubbed...
Name: postgis.sql
Type: application/octet-stream
Size: 31334 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20030604/5cbd3a38/attachment.obj>
More information about the postgis-users
mailing list