Skip to content

Instantly share code, notes, and snippets.

@joseluistorres
Last active August 29, 2015 14:01
Show Gist options
  • Save joseluistorres/675f0524ef718e1ba53b to your computer and use it in GitHub Desktop.
Save joseluistorres/675f0524ef718e1ba53b to your computer and use it in GitHub Desktop.
public.geometry(MultiLineString,3857) does not exist
-- If you have an error running a query with geometry in Postgresql
CREATE TABLE "some_random_table" (
"id" int4 NOT NULL,
"map_coords" "public"."geometry(MultiLineString,3857)",
"col3" int4 NOT NULL,
"col4_id" int4 NOT NULL,
CONSTRAINT "some_random_tablee_pkey" PRIMARY KEY ("id")
);
-- like this:
-- ERROR: type "public.geometry(MultiLineString,3857)" does not exist
-- LINE 5: "map_coords" "public"."geometry(MultiLineString,3857...
-- ^
-- And you know that it does exist, just take the double quote away from that line to and voilá:
CREATE TABLE "some_random_table" (
"id" int4 NOT NULL,
map_coords public.geometry(MultiLineString,3857),
"col3" int4 NOT NULL,
"col4_id" int4 NOT NULL,
CONSTRAINT "some_random_tablee_pkey" PRIMARY KEY ("id")
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment