Skip to content

Query question, schemas #5

@apiszcz

Description

@apiszcz

Database table has 1 trip, which I copied to a new schema, it appears there is an insert requirement or trigger? Since the 'public' schema is referenced but the query specifies 's1'

car_id trip_id trip
1 1 [010100000000000000000000000000000000000000@2012-01-01 08:00:00+00, 010100000000000000000000400000000000000000@2012-01-01 08:10:00+00, 01010000000000000000000040666666666666FEBF@2012-01-01 08:15:00+00]

Query #1
select trip from s1.trips_test_001

Log message
2022-06-14T10:57:41 INFO Running Query: select trip from s1.trips_test_001
2022-06-14T10:57:41 INFO Query return types: tgeompoint

General log
2022-06-14T10:57:43 WARNING Feature type or srid for geom of "public"."move__tpoint_0_4ee6b0e8377344cc9c730e74772a096c" could not be determined or was not requested.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions