Running migrate:fresh fails when using TimescaleDB hypertables

[nhedger]

Laravel Version

11.31

PHP Version

8.4

Database Driver & Version

PostgresQL 17 / TimescaleDB

Description

When an application uses TimescaleDB hypertables, running the migrate:fresh command results in a failure.

Internal error: 7 ERROR: cannot drop a hypertable along with other objects

It seems that TimescaleDB does not support dropping hypertables while dropping another hypertable or a standard PostgreSQL table.

I believe this issue could be fixed by running a single drop in a loop over the list of tables in the following code.

framework/src/Illuminate/Database/Schema/PostgresBuilder.php

Lines 96 to 120 in b9df1f7

	public function dropAllTables()
	{
	$tables = [];
	$excludedTables = $this->connection->getConfig('dont_drop') ?? ['spatial_ref_sys'];
	$schemas = $this->getSchemas();
	foreach ($this->getTables() as $table) {
	$qualifiedName = $table['schema'].'.'.$table['name'];
	if (in_array($table['schema'], $schemas) &&
	empty(array_intersect([$table['name'], $qualifiedName], $excludedTables))) {
	$tables[] = $qualifiedName;
	}
	}
	if (empty($tables)) {
	return;
	}
	$this->connection->statement(
	$this->grammar->compileDropAllTables($tables)
	);
	}

I'm willing to submit a PR if you're open to a fix using this approach

No hard feelings otherwise, I have a workaround in place.

Steps To Reproduce

The following repo contains instructions to reproduce: https://github.com/nhedger/hypertable-drop

[nhedger]

Was this issue converted to a discussion by mistake @crynobone?

Is the issue missing some information that you would need to reproduce?