[ppa-help] [ phppgadmin-Bugs-2908984 ] problem with "upload an SQL script"

[SourceForge.net <no...@so...>]

Bugs item #2908984, was opened at 2009-12-04 19:44
Message generated for change (Comment added) made by ioguix
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=2908984&group_id=37132

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Emmanuel (estefanakis)
Assigned to: Nobody/Anonymous (nobody)
Summary: problem with "upload an SQL script"

Initial Comment:
dear all

when I upload the file http://www.dbnet.ece.ntua.gr/~stefanak/dhmoi.sql
I get the error message "geometry contains no closed rings"
and it stops.

on the other hand, when I copy and paste the content of the sql file into the 
sql script window it is executed and the table is created.

and comment on this would be greatly appreciated!

emmanuel.

----------------------------------------------------------------------

>Comment By: Guillaume `ioguix` de Rorthais (ioguix)
Date: 2010-08-25 18:36

Message:
Hello,

Did you find a way to fix this ?

I have a different error when executing your script on a PostgreSQL 8.4
server using our current PPA dev tree:

dhmoi_utf8.sql:11: ERROR: AddGeometryColumns() - invalid SRID
CONTEXT: SQL statement "SELECT AddGeometryColumn('', $1 , $2 , $3 , $4 ,
$5 , $6 )"
PL/pgSQL function "addgeometrycolumn" line 4 at SQL statement

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=2908984&group_id=37132