PostgreSQL
PostgreSQL is a database management system that is object-relational. PostgreSQL originated from the Ingres project at the University of California, Berkeley.
Here are 10,006 public repositories matching this topic...
When adding a new data store database in Metabase it tries to connect first with SSL (if the driver supports SSL), and then without, in that order. If either connection succeeds, the database details are accepted as valid. Yes, you can add driver specific JDBC options to use SSL, but there is no good feed
Issue type:
[ ] question
[ ] bug report
[ ] feature request
[x] documentation issue
Database system/driver:
[ ] cordova
[ ] mongodb
[ ] mssql
[ ] mysql / mariadb
[ ] oracle
[x] postgres
[ ] cockroachdb
[ ] sqlite
[ ] sqljs
[ ] react-native
[ ] expo
TypeORM version:
[x] latest
[ ] @next
[ ] 0.x.x (or put your version here)
@madAndroid was kind enough to provide instructions on how to configure Redash with Auth0/SAML on the forum: https://discuss.redash.io/t/auth0-integration/586/5.
We should port this over to the Knowledge Base (either as a section in the Authentication Options page or a dedicated one).
-
Updated
Feb 5, 2020
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
Environment
Knex version: 0.20.3
Database + version: psql (PostgreSQL) 12.1
OS: macOS 10.14.6
Bug
The expirationChecker property on the connection object is not being called to recreate the connection object with new credentials for the database, even though the timeout was reached.
The first time that a request is being made, it works fine but after the timeout, it won't all
-
Updated
Feb 6, 2020 - Java
pgcli depends on humanize which is https://github.com/jmoiron/humanize.
The current version has a slightly odd behavior of rounding down unexpectedly:
In [11]: humanize.naturaltime(datetime.timedelta(seconds=120))
Out[11]: '2 minutes ago'
In [12]: humanize.naturaltime(datetime.timedelta(seconds=119.9))
-
Updated
Feb 6, 2020 - JavaScript
Relevant system information:
- OS: Ubuntu 18.0 and , Windows 10 x64
- PostgreSQL version 10, 11.6
- TimescaleDB 1.3 - 1-5
- Installation method: apt / msi
Describe the bug
When backing up and restoring the a Timescale database from one server to another where the destination server does not have the same table spaces as the source server the primary keys and indexes on the base
Following this guide on the node-postgres.com site:
https://node-postgres.com/guides/project-structure
I have setup my project structure to reflect the suggested guide.
Despite this, when I try to make a call to the db.query function as the guide shows, I get the error:
Unhandled Rejection (TypeError): net.Socket is not a constructor
I am calling the function from an `a
Hey Cube.Js team!
I get the following yarn warnings when installing dependencies. Can these be fixed? Thank you.
warning @cubejs-backend/server-core > @cubejs-backend/schema-compiler > joi@14.3.1: This module has moved and is now available at @hapi/joi. Please update your dependencies as this version is no longer maintained an may contain bugs and security issues.
warning @cubejs-backe
-
Updated
Feb 6, 2020
- Related Issues: #IssueNumber if necessary
Introduction
Your front page example references a non-existent Posts variable
Issue Description
The front page has this code:
const User = bookshelf.model('User', {
tableName: 'users',
posts() {
return this.hasMany(Posts)
}
})
This line specifically:
return this.hasMany(Posts)
In the documentation (https://github.com/coscms/xorm/blob/master/docs/QuickStart.md > Section 1: Create ORM Engine > 1.Logs)
I saw that there was/is an engine.ShowError = true. However the ShowError is not an attribute / method anymore. Also I don't find it anywhere in the code.
Did this dissapear? If so, why? And could you bring it back?
Other than that, really enjoying the library. Bi
As it's easier to see from images here are images of NewsBlur and InoReader. In a nutshell, the Inoreader shows the correct number of unread stories, but NewsBlur does not.
Both Feed Reader are marked unread yesterday at the same time.
NewsBlur:
See the yellow stories, that are somehow prefiltered (marked as read).
 -> In<Self, T::InExpression>Queries using this method will not be placed in the prepared statement cache
But [comments](https://github.com/diesel
-
Updated
Feb 6, 2020 - Java
-
Updated
Feb 6, 2020 - Python
1、我最近在使用Enterprisedb 10.4,然后参照下面的文章:https://www.enterprisedb.com/docs/en/10.0/Ora_Reference_Guide_v10/Database_Compatibility_for_Oracle_Developers_Reference_Guide.1.035.html
在pg admin里面输入了下面这些代码
CREATE DATABASE LINK chicago
CONNECT TO sue IDENTIFIED BY 'mypassword'
USING oci '//127.0.0.1/acctg';
但是却报了下面这个错,很疑惑,语法都是按照文档上来的,为什么会有这个问题呢
ERROR: syntax error at or near "TO"
SQL state: 4
What went wrong?
I'm getting deprecation warnings with openSSL encryption.
[2019/09/05 08:38:52][info] Using Encryptor::OpenSSL to encrypt the archive.
[2019/09/05 08:40:22][warn] Pipeline STDERR Messages:
[2019/09/05 08:40:22][warn] (Note: may be interleaved if multiple commands returned error messages)
[2019/09/05 08:40:22][warn]
[2019/09/05 08:40:22][warn] *** WARNING : depre
Citus_indent setup
The steps described in our README does not work for me: https://github.com/citusdata/citus/blob/master/CONTRIBUTING.md#following-our-coding-conventions
The main problem is that after cloning the tools repo we need to run make install from top level instead of uncrustify because many of the variables are defined at the top level.
-
Updated
Feb 6, 2020 - Python
Created by Michael Stonebraker
Released July 8, 1996
- Repository
- postgres/postgres
- Website
- www.postgresql.org
- Wikipedia
- Wikipedia
Issue Description
Is your feature request related to a problem? Please describe.
When doing some migrations, I would like to delete a column created in a previous migration.
However, this is not possible with the current code for some scenarios.
An example :
migration v3