[postgis-tickets] [PostGIS] #2359: raster2pgsql - large collection of examples of different bugs in -l (overviews)

[PostGIS]

#2359: raster2pgsql - large collection of examples of different bugs in -l
(overviews)
---------------------+------------------------------------------------------
  Reporter:  gbell   |       Owner:  dustymugs             
      Type:  defect  |      Status:  reopened              
  Priority:  medium  |   Milestone:  PostGIS 2.0.4         
 Component:  raster  |     Version:  2.0.x                 
Resolution:          |    Keywords:  raster2pgsql overviews
---------------------+------------------------------------------------------

Comment(by dustymugs):

 Actually, the SQL is correct. That is due to the use of a COPY statement.
 If you were to use INSERT statements (no -Y flag), the output looks like
 the following...

 {{{
 BEGIN
 psql:bogota.sql:2: NOTICE:  CREATE TABLE will create implicit sequence
 "bogota_rid_seq1" for serial column "bogota.rid"
 psql:bogota.sql:2: ERROR:  relation "bogota" already exists
 psql:bogota.sql:3: ERROR:  current transaction is aborted, commands
 ignored until end of transaction block
 psql:bogota.sql:4: ERROR:  current transaction is aborted, commands
 ignored until end of transaction block
 psql:bogota.sql:5: ERROR:  current transaction is aborted, commands
 ignored until end of transaction block
 psql:bogota.sql:6: ERROR:  current transaction is aborted, commands
 ignored until end of transaction block
 ...
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2359#comment:7>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.