Skip to content
#

PostgreSQL

postgresql logo

PostgreSQL is a database management system that is object-relational. PostgreSQL originated from the Ingres project at the University of California, Berkeley.

Here are 23,323 public repositories matching this topic...

supabase
dbeaver
KOLANICH
KOLANICH commented Jan 11, 2019

Sometimes it is needed to store compressed data in the DB. Unfortunately not all the DBs have built-in compression and FUSE compressed FSes are not available for every OS. So it may make sense to store compressed binary blobs in the DB.

Unfortunately when one sees them in DBeaver he sees them compressed, but often they are needed uncompressed. So it'd be nice to have a feature to decompress the

prisma
binary64
binary64 commented Aug 2, 2021

Bug description

On windows, I run prisma format and note the unusual file ending. The lines are all LF, but the very last line is CRLF.

This causes issue on my Linux CI where it formats it ending in LF's only, causing a diff to occur and the build to fail.

How to reproduce

  1. On windows do prisma format
  2. Open in HxD or similar
  3. See attached:

![image](https://user-images.g

directus
cube.js
leogodin217
leogodin217 commented Sep 17, 2021

Describe the bug
Using a time dimension on a runningTotal measure on Snowflake mixes quoted and unquoted columns in the query. This fails the query, because Snowflake has specific rules about quoted columns. Specifically:

  • All unquoted column names are treated as upper case
  • Quoted column names are case sensitive.

So "date_from" <> date_from

To Reproduce
Steps to reproduce

questdb
puzpuzpuz
puzpuzpuz commented Dec 16, 2021

Describe the bug

ATM the following query

select * from t where abyte = null;

executes just fine and returns rows with abyte column equal to zero. The same happens for short columns.

Byte and short column types don't support nulls (important note: geobyte and geoshort types support nulls), so we need to do something with this behavior. We could either report an error for

Created by Michael Stonebraker

Released July 8, 1996

Repository
postgres/postgres
Website
www.postgresql.org
Wikipedia
Wikipedia