postgrest-js

postgrest-js copied to clipboard

No way to retrieve column list for an empty table

4

# Bug report - [X] I confirm this is a bug with Supabase, not with my own application. - [X] I confirm I have searched the [Docs](https://docs.supabase.com), GitHub [Discussions](https://github.com/supabase/supabase/discussions), and...

zachblume

# Bug report - [X] I confirm this is a bug with Supabase, not with my own application. - [X] I confirm I have searched the [Docs](https://docs.supabase.com), GitHub [Discussions](https://github.com/supabase/supabase/discussions), and...

mansueli

## What kind of change does this PR introduce? This adds support for importing postgrest-js as an ESM module in node. ## What is the current behavior? Currently, postgrest-js can...

tomprince

Cannot import postgres-js as an ESM module in node.

2

# Bug report ## Describe the bug A clear and concise description of what the bug is. ## To Reproduce 1. Create a new package and install postgres-js: ``` mkdir...

tomprince

Exclude generated columns from the insert type

5

# Bug report ## Describe the bug Postgres allows the creation of generated columns: https://www.postgresql.org/docs/current/ddl-generated-columns.html. Inserting a value into such a column throws an error: https://www.tutorialsteacher.com/postgresql/generated-always. Supabase includes these columns...

yannxaver

daterange column input is modified before writing to db

3

# Bug report ## Describe the bug When writing to a `daterange` column with a range like `"[2022-12-28, 2022-12-28]"` the column is modified to look like `"[2022-12-28,2022-12-29)"`. There are _two_...

kyeotic

# Bug report ## Describe the bug When doing a foreign table query, for some reason the type is `T | T[] | null`. ## To Reproduce With the following...

probablykasper

Upserts do not seem to work on partial index on postgres

5

### Discussed in https://github.com/supabase/supabase/discussions/12565 Originally posted by **beacoding** February 20, 2023 Looks like we cannot specify an `onConflict` and `where` together when we set a partial index on our postgres...

steve-chavez

Previously, if you wrote a query like this: ```typescript // presumes a table foos that has a JSONB `data` column const { data, error } = await client.from('foos').select('id').order('data->>count', { ascending:...

mqp

Incorrect handling of union types in `PostgrestResponseSuccess<T>` type

1

# Bug report ## Describe the bug `await supabase.from(tableName).select("*")` returns a type `PostgrestResponse`, which could be of type `PostgrestResponseSuccess`. Currently `PostgrestResponseSuccess` is defined as: ```ts interface PostgrestResponseSuccess extends PostgrestResponseBase {...

leohku