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
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions