[postgis-users] postgis_restore.pl error

[Willy-Bas Loos]

I think i figured it out

Except for the error, i also get these notices:
No larg, CREATE OPERATOR FAMILY btree_geometry_ops USING btree;
ALTER OPERATOR FAMILY public.btree_geometry_ops USING btree OWNER TO wbloos;

line 192 orf teh perl code is :
my $sigHR = "OPERATOR " . $name .' ('.$larg.', '.$rarg.')';

And $larg has not been initialized.

Normaly, there doesn't seem to be a ALTER OPERATOR FAMILY ... OWNER TO line
in the dump, but because i created the postgis definitions under my own
user, there was.
The script doesn't seem to cope with that. It skips OPERATOR CLASS, but not
OPERATOR FAMILY. Perl has to recognize the objects in the dump by text
string comparison, that's what goes wrong here.

It's only that one line "ALTER OPERATOR FAMILY public.btree_geometry_ops
USING btree OWNER TO wbloos;", the error is just printed 4 times.
I checked with this command to find the source of the error:
pg_restore -L <dumpfile>.lst dumpfile|sed -n '<line nr>'p

So i conclude that it's nothing to worry about.
Hope that helps any other users that encounter this, maybe the script can
be enhanced to cope with it.

Cheers,

WBL





On Tue, Jul 23, 2013 at 6:26 PM, Willy-Bas Loos <willybas at gmail.com> wrote:

> Hi,
>
> postgis_restore.pl gives me the error (4 times in 1 restore):
> Use of uninitialized value $larg in concatenation (.) or string at ./
> postgis_restore.pl line 192, <INPUT> line 16432.
>
> This is on version POSTGIS="2.0.1 r9979" GEOS="3.3.3-CAPI-1.7.4"
> PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.9.2, released 2012/10/08"
> LIBXML="2.7.8" RASTER
> It must be something new in my database or some illness of the dump i
> made, because it didn't happen when i restored it last may, and i just
> reproduced it on that same machine.
>
> Can anyone tell me what the error means?
>
> Thanks,
>
> WBL
> --
> "Quality comes from focus and clarity of purpose" -- Mark Shuttleworth
>



-- 
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130724/4c201fc2/attachment.html>