[osmosis-dev] NOTIVE: table "actions" does not exist, skipping

[Sebastiaan Couwenberg]

On 05/28/2017 03:01 PM, Pander wrote:
> I am following instructions from
> https://wiki.openstreetmap.org/wiki/Osmosis/PostGIS_Setup to run a
> database with an export of a country from Geofabrik.
> 
> When I run
> 
>     sudo -u postgres psql -d gis -f
> /usr/share/doc/osmosis/examples/pgsnapshot_schema_0.6.sql
> 
> I get this message
> 
>     psql:/usr/share/doc/osmosis/examples/pgsnapshot_schema_0.6.sql:4:
> NOTICE:  table "actions" does not exist, skipping
> 
> Is this a bug which I should report in trac?

No, it's just a notice that the "DROP TABLE IF EXISTS actions;" query
did not delete the table because it doesn't exist.

> Also the page offers the command
> 
>     sudo -u postgres psql -d gis -f
> /usr/share/doc/osmosis/examples/pgsnapshot_schema_0.6_linestring.sql
> 
> when I want longstring support, but there is no information on which I
> should base my decision. Where can I find more information or what is
> recommended for my goal here?

It all depends on what you want to do with the database. Applying the
_action, _bbox & _linestring SQL scripts in addition to the basic schema
gives you more tables and geometry columns for spatial queries which you
then don't need to construct yourself.

Have a look at the comments on the top of those files for their purpose.
If you don't need that, you can skip applying those scripts.

Kind Regards,

Bas

-- 
 GPG Key ID: 4096R/6750F10AE88D4AF1
Fingerprint: 8182 DE41 7056 408D 6146  50D1 6750 F10A E88D 4AF1