Tags: sasajib/postgres-meta
Tags
Merge pull request supabase#162 from supabase/feat/pg-meta-cache feat(server): cache pg-meta connections
Merge pull request supabase#500 from supabase/fix/typegen-set-returni… …ng-function fix(typegen): set returning function
fix: Skip over dropped attributes when enumerating types (supabase#492) * Skip over dropped attributes when enumerating types `pg_attribute` may contain records for attributes that were dropped but Postgres kept them around and instead of deleting them, renamed them to `........pg.dropped.#........` and set their `attisdropped` to `true`. This ends up generating these dropped attributes as `unknown` fields in the TypeScript types. In this commit I updated the `types` query to not return these. Maybe it would be preferrable to instead keep these but skip them only when generating the TypeScript types? * use `not` --------- Co-authored-by: Bobbie Soedirgo <bobbie@soedirgo.dev>
fix: logic when returning default roles (supabase#490) * Bug fix returning default roles * refactor: replace DEFAULT_ROLES w/ prefix test * test: includeDefaultRoles --------- Co-authored-by: Bobbie Soedirgo <bobbie@soedirgo.dev>
fix: make virtual columns nullable (supabase#480) psteinroe contributed a change which adds schema functions which take only the table name as columns on the tables when generating TypeScript types. This commit extends that to treat function return types as nullable. The function used in `oo-init.sql` could be changed like so: ```sql create function public.blurb(public.todos) returns text as $$ select null; $$ language sql stable; ``` It would still compile and be a valid function despite the unchanged return type, which means any function must be treated as potentially returning `null` in the types. I have also updated instructions for building and testing the TypeScript type generation.
fix: return field name with composite type unknown (supabase#483) * fixed return unknown to name typed unknown * chore: fix formatting Co-authored-by: Qiao Han <qiao@supabase.io>
Merge pull request supabase#475 from supabase/feat/optional-columns feat(tables, views, foreign-tables): make `columns` optional
PreviousNext