Recent questions tagged PostgreSQL

0 votes

1.0k views

1 answer

I don't understand how to test my repositories. I want to be sure that I really saved object with all of ... because I need to test PostgreSQL. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

953 views

1 answer

postgresql - array_agg for Array Types

I'm trying to get array_agg to work with an array type in Postgresql and I'm having trouble figuring out ... to find another approach? Thanks! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.4k views

1 answer

postgresql - Django Migration Error: Column does not exist

Python 3, Django 1.8.5, Postgres I have a model Sites that has been working fine. I recently tried to add a ... . This is not an okay solution. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

postgresql - Postgres birthdays selection

I work with a Postgres database. This DB has a table with users, who have a birthdate (date field). Now I ... with the cases at 29-02 birthday? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

741 views

1 answer

postgresql - Should I specify both INDEX and UNIQUE INDEX?

On one of my PostgreSQL tables, I have a set of two fields that will be defined as being unique in the ... ON mytable (col1, col2); See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

847 views

1 answer

postgresql - Get records where json column key is null

I have table users with json column details. I want to fetch all user records where details["email"] is null or ... not exist: json -> boolean See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

975 views

1 answer

postgresql - Not able to connect to postgres using jdbc in pyspark shell

I am using standalone cluster on my local windows and trying to load data from one of our server using following ... not able to find solution. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

979 views

1 answer

postgresql - When do Postgres column or table names need quotes and when don't they?

Let's consider the following postgres query: SELECT * FROM "MY_TABLE" WHERE "bool_var"=FALSE AND "str_var"=' ... text column? Something else? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

999 views

1 answer

postgresql - Postgres default sort by id - worldship

I need to setup worldship to pull from one of our postgres databases. I need to have it so that the packages ... them with record 2 being first. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.3k views

1 answer

postgresql - Cannot INSERT: ERROR: array value must start with "{" or dimension information

journeypost=# INSERT INTO user_data.user_data (username,randomint) VALUES ('mahman',1); ERROR: array value must start ... KEY, btree (username) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

955 views

1 answer

postgresql - Optional argument in PL/pgSQL function

I am trying to write a PL/pgSQL function with optional arguments. It performs a query based on a filtered set of ... ids)); END $$ LANGUAGE SQL See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

postgresql - Select today's (since midnight) timestamps only

I have a server with PostgreSQL 8.4 which is being rebooted every night at 01:00 (don't ask) and ... doing string acrobatics with to_char()? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

691 views

1 answer

postgresql - Do I need a primary key for my table, which has a UNIQUE (composite 4-columns), one of which can be NULL?

I have the following table (PostgreSQL 8.3) which stores prices of some products. The prices are synchronised ... index already for my SELECTs? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

postgresql - How to get SQL text from Postgres event trigger

In a pgsql event trigger on tag ALTER TABLE, I wish to know which table is being altered. The pg variables ... ADD COLUMN col1 int text itself? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.5k views

1 answer

postgresql - How to create postgres extension inside the container?

I have to install hstore to my docker postgres Here is my ordinary command in the shell to execute my need ... the entire project for my team See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

909 views

1 answer

postgresql - Rails Migration Error w/ Postgres when pushing to Heroku

I'm trying to perform the following up migration to change the column "number" in the "tweet" model's ... much appreciated. Thanks everyone. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

997 views

1 answer

postgresql - Set value in dependency of Helm chart

I want to use the postgresql chart as a requirements for my Helm chart. My requirements.yaml file hence ... to the postgreSQL dependency? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

postgresql - Postgres table column name restrictions?

I did this in psql: CREATE TABLE IF NOT EXISTS apiss (skey TEXT, time INTEGER, user TEXT, ip TEXT); I get ... can have? (postgresql v9.1.3) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.7k views

1 answer

postgresql - How to fix "ERROR: column c.relhasoids does not exist" in Postgres?

I'm trying to CREATE TABLE command in Postgresql. After creating a table, if I punch in TABLE table name, ... would be appreciated! Thank you. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

747 views

1 answer

postgresql - Generating an Instagram- or Youtube-like unguessable string ID in ruby/ActiveRecord

Upon creating an instance of a given ActiveRecord model object, I need to generate a shortish (6-8 characters) unique ... up at a new record? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

786 views

1 answer

postgresql - Passing a record as function argument PL/pgSQL

First I am really new to pl/pgsql. Need it for a project. I am stuck with this (simplified) problem. My ... Thank you very much for your help. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.2k views

1 answer

postgresql - PG COPY error: invalid input syntax for integer

Running COPY results in ERROR: invalid input syntax for integer: "" error message for me. What am I missing? ... TABLE Trivia: PostgreSQL 9.2.4 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

961 views

1 answer

postgresql - plpgsql function returns table(..)

I'm trying to get this plpgsql function to work: CREATE OR REPLACE FUNCTION outofdate(actualdate varchar) RETURNS ... state: 42601 Character: 67 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

931 views

1 answer

postgresql - How to list tables affected by cascading delete

I'm trying to perform a cascading delete on 15+ tables but I'm not certain that all of the requisite ... affected by a cascading delete query? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

686 views

1 answer

postgresql - What is the order of records in a table with a composite primary key

In PostgreSQL, when a combination of multiple columns is specified as the PRIMARY KEY, how are the records ordered ... in case of PostgreSQL? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

988 views

1 answer

postgresql - How can I test if a column exists in a table using an SQL statement

Is there a simple alternative in PostgreSQL to this statement produced in Oracle? select table_name from ... my database table. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

postgresql - Storing json, jsonb, hstore, xml, enum, ipaddr, etc fails with "column "x" is of type json but expression is of type character varying"

When using PostgreSQL to store data in a field of a string-like validated type, like xml, json, jsonb, xml ... m looking for a general solution. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

741 views

1 answer

postgresql - How to provide an API client with 1,000,000 database results?

Following up from my previous question: Using "Cursors" for paging in PostgreSQL What is a good way to provide ... than any of these options? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags