operator class for GiST-index required (PostgreSQL)

[bleedchf]

CREATE TABLE public.payers_subscriptions (
    id integer NOT NULL,
    client_internet inet
);

CREATE INDEX payers_subscriptions_client_internet_idx ON public.payers_subscriptions USING gist (client_internet inet_ops);

---

php artisan migrate:generate --ignore=users,cache,jobs,cache_locks,failed_jobs,job_batches,password_reset_tokens,sessions

Using connection: pgsql

Generating migrations for: payers_subscriptions

Do you want to log these migrations in the migrations table? (yes/no) [yes]:

Next Batch Number is: 2. We recommend using Batch Number 0 so that it becomes the "first" migration. [Default: 0] [0]:

Setting up Tables and Index migrations.
Created: /.../.../.../database/migrations/2025_07_09_013525_create_payers_subscriptions_table.php

Setting up Views migrations.

Setting up Stored Procedures migrations.

Setting up Foreign Key migrations.

Finished!

---

php artisan migrate:refresh

INFO Rolling back migrations.

0001_01_01_000002_create_jobs_table ................................................................................................. 63.96ms DONE
0001_01_01_000001_create_cache_table ................................................................................................ 16.58ms DONE
0001_01_01_000000_create_users_table ................................................................................................ 26.77ms DONE
2025_07_09_013525_create_payers_subscriptions_table ................................................................................. 11.78ms DONE

INFO Running migrations.

0001_01_01_000000_create_users_table ................................................................................................. 7.91ms DONE
0001_01_01_000001_create_cache_table ................................................................................................. 5.27ms DONE
0001_01_01_000002_create_jobs_table .................................................................................................. 6.88ms DONE
2025_07_09_013525_create_payers_subscriptions_table .................................................................................. 9.52ms FAIL

Illuminate\Database\QueryException

SQLSTATE[42704]: Undefined object: 7 ERROR: data type inet has no default operator class for access method "gist"
HINT: You must specify an operator class for the index or define a default operator class for the data type. (Connection: pgsql, SQL: create index "payers_subscriptions_client_internet_idx" on "payers_subscriptions" using gist ("client_internet"))

at vendor/laravel/framework/src/Illuminate/Database/Connection.php:822
818▕ $this->getName(), $query, $this->prepareBindings($bindings), $e
819▕ );
820▕ }
821▕
➜ 822▕ throw new QueryException(
823▕ $this->getName(), $query, $this->prepareBindings($bindings), $e
824▕ );
825▕ }
826▕ }
+9 vendor frames

10 database/migrations/2025_07_09_013525_create_payers_subscriptions_table.php:14
Illuminate\Support\Facades\Facade::__callStatic("create")
+38 vendor frames

49 artisan:16
Illuminate\Foundation\Application::handleCommand(Object(Symfony\Component\Console\Input\ArgvInput))

[bleedchf]

php artisan about

Environment ......................................................................................................................................
Application Name .................................................................................................................... [...]
Laravel Version .......................................................................................................................... 12.20.0
PHP Version ................................................................................................................................ 8.4.8
Composer Version ........................................................................................................................... 2.8.9
Environment ................................................................................................................................ local
Debug Mode ............................................................................................................................... ENABLED
URL ............................................................................................................................. [...]
Maintenance Mode ............................................................................................................................. OFF
Timezone ..................................................................................................................................... UTC
Locale ........................................................................................................................................ en

Cache ............................................................................................................................................
Config ................................................................................................................................ NOT CACHED
Events ................................................................................................................................ NOT CACHED
Routes ................................................................................................................................ NOT CACHED
Views ..................................................................................................................................... CACHED

Drivers ..........................................................................................................................................
Broadcasting ................................................................................................................................. log
Cache ................................................................................................................................... database
Database ................................................................................................................................... pgsql
Logs .............................................................................................................................. stack / single
Mail ........................................................................................................................................ smtp
Queue ................................................................................................................................... database
Session ................................................................................................................................. database

Storage ..........................................................................................................................................
public/storage ........................................................................................................................ NOT LINKED

---

php artisan db:show

PostgreSQL .................................................................................................................................. 17.5
Connection ................................................................................................................................. pgsql
Database ........................................................................................................................ [...]
Host ................................................................................................................................... 127.0.0.1
Port ........................................................................................................................................ 5432
Username ........................................................................................................................ [...]
URL ..............................................................................................................................................
Open Connections ............................................................................................................................... 8
Tables ......................................................................................................................................... 9
Total Size ............................................................................................................................. 192.00 KB

Schema / Table .............................................................................................................................. Size
public / cache .......................................................................................................................... 16.00 KB
public / cache_locks .................................................................................................................... 16.00 KB
public / failed_jobs .................................................................................................................... 24.00 KB
public / job_batches .................................................................................................................... 16.00 KB
public / jobs ........................................................................................................................... 24.00 KB
public / migrations ..................................................................................................................... 24.00 KB
public / password_reset_tokens .......................................................................................................... 16.00 KB
public / sessions ....................................................................................................................... 32.00 KB
public / users ..........................................................................................................................

[bleedchf]

composer require kitloong/laravel-migrations-generator

./composer.json has been updated
Running composer update kitloong/laravel-migrations-generator
Loading composer repositories with package information
Updating dependencies
Lock file operations: 1 install, 0 updates, 0 removals

• Locking kitloong/laravel-migrations-generator (v7.1.2)
  Writing lock file
  Installing dependencies from lock file (including require-dev)
  Package operations: 1 install, 0 updates, 0 removals
• Downloading kitloong/laravel-migrations-generator (v7.1.2)
• Installing kitloong/laravel-migrations-generator (v7.1.2): Extracting archive
  Generating optimized autoload files

Illuminate\Foundation\ComposerScripts::postAutoloadDump
@php artisan package:discover --ansi

INFO Discovering packages.

kitloong/laravel-migrations-generator ....................................................................................................... DONE
laravel/pail ................................................................................................................................ DONE
laravel/sail ................................................................................................................................ DONE
laravel/tinker .............................................................................................................................. DONE
nesbot/carbon ............................................................................................................................... DONE
nunomaduro/collision ........................................................................................................................ DONE
nunomaduro/termwind ......................................................................................................................... DONE

80 packages you are using are looking for funding.
Use the composer fund command to find out more!

@php artisan vendor:publish --tag=laravel-assets --ansi --force

INFO No publishable resources for tag [laravel-assets].

No security vulnerability advisories found.
Using version ^7.1 for kitloong/laravel-migrations-generator

[bleedchf]

The creation of a GiST-Index requires a class operator as described in https://www.postgresql.org/docs/16/gist-builtin-opclasses.html

It must be either one of:

• box_ops
  

• circle_ops
  

• inet_ops
  

• multirange_ops
  

• point_ops
  

• poly_ops
  

• range_ops
  

• tsquery_ops
  

• tsvector_ops
  

Currently, the generator ignores the operator class, thus causing it to fail on a migration. A fix of this issue would be highly appreciated since GiST-Indices are not uncommon in PostgreSQL.

Thank you very much for your attention and consideration.

[bleedchf]

laravel/framework#56261 This issue has been fixed upstream by adding an additional argument to the method

$table->spatialIndex(['field'], 'index_name', 'new_optional_argument_operator_class');

Is it possible to update the migration generator in such a way that it adds that last argument if necessary? Thank you very much for your attention and consideration.

[bleedchf]

The new laravel version is live and working.

A manual change from

$table->spatialIndex(['client_internet'], 'payers_subscriptions_client_internet_idx');

to

$table->spatialIndex(['client_internet'], 'payers_subscriptions_client_internet_idx', 'inet_ops');

works perfectly.

Can the generator be modified in such a way that the last argument is added automatically if necessary? It is the last change that stands in the way for full PostgreSQL support in laravel and it would be highly highly appreciated by the entire PostgreSQL community.

Thank you very much in advance.