Unable to migrate table using point datatype in postgres ?

Did you try point instead?

$table->point('point_table');

@sinnbeck Yeah, It is giving same resopnse.

   Illuminate\Database\QueryException  : SQLSTATE[42704]: Undefined object: 7 ERROR:  type "geography" does not exist at character 92 (SQL: create table "clients_users_locations" ("id" bigserial primary key not null, "point_table" geography(point, 4326) not null, "created_by" bigint not null, "created_at" timestamp(0) with time zone not null))

  at /opt/lampp/htdocs/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664
    660|         // If an exception occurs when attempting to run a query, we'll format the error
    661|         // message to include the bindings with SQL, which will make this exception a
    662|         // lot more helpful to the developer instead of just the database's errors.
    663|         catch (Exception $e) {
  > 664|             throw new QueryException(
    665|                 $query, $this->prepareBindings($bindings), $e
    666|             );
    667|         }
    668| 

  Exception trace:

  1   Doctrine\DBAL\Driver\PDOException::("SQLSTATE[42704]: Undefined object: 7 ERROR:  type "geography" does not exist at character 92")
      /opt/lampp/htdocs/project/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:129

  2   PDOException::("SQLSTATE[42704]: Undefined object: 7 ERROR:  type "geography" does not exist at character 92")
      /opt/lampp/htdocs/project/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:127

@sinnbeck To use Spatial Datatypes in laravel, do we need to do something else ?

Are you sure you have postgis enabled on your postgres db ?

https://postgis.net/install/

@sinnbeck yeah, I am able to create tables using point datatype in postgres manually.

So if you copy paste this query to your db manager it works?

create table "clients_users_locations" ("id" bigserial primary key not null, "point_table" geography(point, 4326) not null, "created_by" bigint not null, "created_at" timestamp(0) with time zone not null)

No, It's not. Using GUI editor, I am able to add point column.

@sinnbeck When I run SELECT name FROM pg_available_extensions; It shown me all the enabled extension.

Postgis was already there. Still, I created again using CREATE EXTENSION postgis; and migration started working. This migration is creating geography datatype field, not point datatype .

Did you use this?

$table->point('point_table');

yeah, I used the same.

I go through your link - https://postgis.net/install . While hitting below queries.

 	CREATE EXTENSION postgis_raster;
 	CREATE EXTENSION postgis_sfcgal;

I got below errors -

ERROR:  Extension "postgis_raster" is not supported by Amazon RDS
DETAIL:  Installing the extension "postgis_raster" failed, because it is not on the list of extensions supported by Amazon RDS.
HINT:  Amazon RDS allows users with rds_superuser role to install supported extensions. See: SHOW rds.extensions;
SQL state: 22023

ERROR:  Extension "postgis_sfcgal" is not supported by Amazon RDS
DETAIL:  Installing the extension "postgis_raster" failed, because it is not on the list of extensions supported by Amazon RDS.
HINT:  Amazon RDS allows users with rds_superuser role to install supported extensions. See: SHOW rds.extensions;
SQL state: 22023

Are these both(postgis_sfcgal,postgis_raster) are also required for using postgres spatial database datatype ?

I read through the source and it seems that unless isGeometry is set to something, it will use geography

https://github.com/laravel/framework/blob/8.x/src/Illuminate/Database/Schema/Grammars/PostgresGrammar.php#L905

I cannot find any way of setting that parameter :(

@sinnbeck You checked at Larvel 8.0 files. Checkout in Laravel 5.8.

Here it is - https://github.com/laravel/framework/blob/5.8/src/Illuminate/Database/Schema/Grammars/PostgresGrammar.php#L905

Is there any other way, where we could define custom datatype while making migration ?

Oh seems 5.8 only supports geography :( I think would would need to do a raw migration instead (\DB::statement())

@sinnbeck Nope, point datatype is there in docs as well as code.

Check - https://github.com/laravel/framework/blob/5.8/src/Illuminate/Database/Schema/Grammars/PostgresGrammar.php#L800

Yes but as I understand it creates this query

create table "clients_users_locations" ("id" bigserial primary key not null, "point_table" geography(point, 4326) not null, "created_by" bigint not null, "created_at" timestamp(0) with time zone not null)

and you want

create table "clients_users_locations" ("id" bigserial primary key not null, "point_table" geometry(point) not null, "created_by" bigint not null, "created_at" timestamp(0) with time zone not null)

Or am I mistaken ? (Sorry but I have never used postgis before, so I am not sure)

Okay, Will it be better to upgrade laravel 5.8 to laravel 8.0 ? Is laravel 8.0 stable ?

I assume. But sadly I dont have a setup to test it currently. Perhaps make a test project first? You can try out 7 first. It has the same code as 8 regarding postgres point generation :)

@sinnbeck Using raw query will only be a good solution.

For anyone, who need the approach to write the perfect code for raw query in this case, I have put my code below. We will be making custom PostgresGrammar class with our overrided method definition. While using it in migration, we simply need to register out Grammer Class here.

Here is the CustomPostgresGrammar -

	<?php
		namespace App\Grammer;

		use Illuminate\Database\Schema\Grammars\PostgresGrammar;
		use Illuminate\Support\Fluent;

		/**
 		* Extended version of PostgresGrammar with
 		* support of 'point' data type in Postgres.
 		*/
		class ExtendedPostgresGrammar extends PostgresGrammar
		{

    		/**
     		* Create the column definition for a spatial Point type.
     		*
     		* @param  \Illuminate\Support\Fluent  $column
     		* @return string
     		*/
    		protected function typePoint(Fluent $column)
    		{
        	return "$column->type";
    		}

	}

Here is the migration file code -

    public function up() {
        // register new grammar class
        DB::connection()->setSchemaGrammar(new ExtendedPostgresGrammar());
        $schema = DB::connection()->getSchemaBuilder();
        $schema->create('locations', function (Blueprint $table) {
            $table->bigInteger('id');
            $table->point('points'); 
            $table->datetimetz('created_at');
         });
     }

You need to install postgis and postgis_topology extensions. https://i.imgur.com/T1GRmnw.png