laravel-postgresql-enhanced icon indicating copy to clipboard operation
laravel-postgresql-enhanced copied to clipboard

Table inheritance

Open henriquecm opened this issue 3 years ago • 2 comments

I got interested in Postgres after seeing the post in laravel-news.com, so I was researching differences compared to mysql and saw that you can create make a table inherit another in postgres.

It's possible to do that with this package or that option doesn't exist yet.

henriquecm avatar Sep 27 '21 13:09 henriquecm

Table inheritance is not implemented yet. What is your use case for it?

tpetry avatar Sep 27 '21 14:09 tpetry

I haven't started using postgres yet, I have some possible cases, but I don't know if they are 100% fit for it. There's one project that I'll starting modelling the db soon, and it's pretty complex so it might come in handy. Specially with things like custom fields.

henriquecm avatar Sep 28 '21 14:09 henriquecm

I am closing this issue as the PostgreSQL wiki advocates to never use table inheritance (Don't use table inheritance). There wasn't any feedback why it is needed in more than a year.

You can always use raw SQL statements to use table inheritance. I plan to only support safe functionality without any hidden problems.

tpetry avatar Jun 03 '23 08:06 tpetry