Comments (2)
Just ran into this as well. This happens for non-unque indexes, too
defmodule Blog.Resources.Page do
use Ash.Resource,
data_layer: AshPostgres.DataLayer
postgres do
table("pages")
repo(Blog.Repo)
custom_indexes do
- index [:published], unique: false
- index [:published, :published_at], unique: false
+ index [:is_published], unique: false
+ index [:is_published, :published_at], unique: false
end
end
attributes do
uuid_primary_key :id
- attribute :published, :boolean do
+ attribute :is_published, :boolean do
default false
end
attribute :published_at, :naive_datetime do
allow_nil? true
end
end
end
This change generates the following:
defmodule Blog.Repo.Migrations.TablePageRenamePublishedToIsPublished do
use Ecto.Migration
def up do
drop_if_exists index(:pages, ["published", "published_at"],
name: "pages_published_published_at_index"
)
drop_if_exists index(:pages, ["published"], name: "pages_published_index")
create index(:pages, ["is_published", "published_at"])
create index(:pages, ["is_published"])
rename table(:pages), :published, to: :is_published
end
def down do
rename table(:pages), :is_published, to: :published
drop_if_exists index(:pages, ["is_published"], name: "pages_is_published_index")
drop_if_exists index(:pages, ["is_published", "published_at"],
name: "pages_is_published_published_at_index"
)
create index(:pages, ["published"])
create index(:pages, ["published", "published_at"])
end
end
Note that down
is correct. I guess it's a matter of ordering in the up
generator. Should be drop index
, rename column
, create index
.
from ash_postgres.
+1 this also occurs when removing a field and a related index
from ash_postgres.
Related Issues (20)
- Possibly use raw SQL to convert to jsonb (maybe not always) HOT 9
- varchar size info for a column that already exists is missing from migration
- Ash.Error.UnknownError raised when passing a non-UUID value to a query on a UUID field
- Adding a new relationship with multitenancy at the same time generates invalid_foreign_key HOT 1
- Updating the latest Ash causes some queries to break HOT 2
- Generated migrations should be formatted correctly HOT 1
- Using an AshPostgres resource with a Timescale Hypertable.
- Api.exists? raise an error when multiple result found HOT 2
- Allow layering of Repos HOT 2
- `exists` aggregation ignores `filter` option HOT 3
- First aggregate loses datetime precision HOT 3
- Issue having multiple has_one relationships in a calculation HOT 11
- Calc to agg from calc to agg in separate resource errors HOT 11
- Error building reference HOT 2
- Empty string in relationship converted to nil before save HOT 1
- polymorphic_on_delete option needs refining and potentially moving HOT 1
- polymorphic_on_delete option results in never-ending migration cycle HOT 2
- Relationships are able to cross tenants with attribute strategy HOT 1
- tables with same name and different schemas breaks migration generator logic HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from ash_postgres.