Recent questions tagged postgresql

0 votes

796 views

1 answer

postgresql - How to handle an optional value returned by a query using the postgres crate?

I'm trying to get a value for a query, but this value can be NULL and I don't know how to handle it ... convert a NULL into a chrono::NaiveDate. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - How to suppress INFO messages when running psql scripts

I'm seeing INFO messages when I run my tests and I thought that I had gotten rid of them by setting the ... to turn off the INFO messages? See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

postgresql - How to use EXECUTE FORMAT ... USING in postgres function

CREATE OR REPLACE FUNCTION dummytest_insert_trigger() RETURNS trigger AS $BODY$ DECLARE v_partition_name VARCHAR(32); BEGIN ... get the error. See Question&Answers more detail:os...

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

0 votes

754 views

1 answer

postgresql - Why can PL/pgSQL functions have side effect, while SQL functions can't?

PostgreSQL document says: The entire body of a SQL function is parsed before any of it is executed. While a ... the commands in their bodies? See Question&Answers more detail:os...

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

0 votes

862 views

1 answer

postgresql - Gaps between primary key id in sql table

I have a table which is: CREATE SEQUENCE id_seq; CREATE TABLE public."UserInfo" ( id bigint NOT NULL DEFAULT nextval(' ... 1,2,3.. sequential.. See Question&Answers more detail:os...

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

0 votes

843 views

1 answer

postgresql - How do I move my existing rails app onto heroku? (sqlite to postgres)

I have an existing Ruby on Rails app that already has data loaded into it. I used the default SQLite database setup, ... . How do I do that? See Question&Answers more detail:os...

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

0 votes

986 views

1 answer

postgresql - PSQL Command Line Arguments in DO script

I've got a script NewSchemaSafe.sql that creates a new schema based on the project directory; it's called from ... can be used more directly. See Question&Answers more detail:os...

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

0 votes

903 views

1 answer

postgresql - PL/pgSQL: General Way to Update N Columns in Trigger?

I am attempting create a function that will take a general table and convert N columns to upper case. I haven't had any ... 3); >> A, 3 etc. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - Can not insert German characters in Postgres

I am using UTF8 as encoding for my Postgres 8.4.11 database: CREATE DATABASE test WITH OWNER = postgres ENCODING ... puTTY to connect. Any idea? See Question&Answers more detail:os...

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

0 votes

842 views

1 answer

postgresql - Questions about Postgres track_commit_timestamp (pg_xact_commit_timestamp)

I'm working on a design for a concurrency-safe incremental aggregate rollup system,and track_commit_timestamp ( ... in this plan? See Question&Answers more detail:os...

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

0 votes

939 views

1 answer

postgresql - EXECUTE...USING statement in PL/pgSQL doesn't work with record type?

I'm trying to write a function in PL/PgSQL that have to work with a table it receives as a parameter. I ... what's wrong with the above code? See Question&Answers more detail:os...

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

0 votes

946 views

1 answer

postgresql - Use variable set by psql meta-command inside of DO block

Here's what I would like to do: set values foo,bar,baz DO $$ DECLARE value TEXT; values TEXT[] := ... END LOOP; END $$ LANGUAGE plpgsql; See Question&Answers more detail:os...

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

0 votes

776 views

1 answer

postgresql - Window functions and more "local" aggregation

Suppose I have this table: select * from window_test; k | v ---+--- a | 1 a | 2 b | 3 a | 4 Ultimately ... of k=a in this sample (ordered by v). See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

postgresql - Access Docker postgres container from another container

I am trying to make a portable solution to having my application container connect to a postgres container. By ... non-Docker compose solution. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - the trait `diesel::Expression` is not implemented for `bigdecimal::BigDecimal`

I am trying to create a struct that I can use in diesel for insertion. Specifically I am making the struct ... as I could not find samples. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - Exporting a AWS Postgres RDS Table to AWS S3

I wanted to use AWS Data Pipeline to pipe data from a Postgres RDS to AWS S3. Does anybody know how ... Any other suggestions will also work. See Question&Answers more detail:os...

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

0 votes

915 views

1 answer

postgresql - How can I prevent Postgres from inlining a subquery?

Here's a slow query on Postgres 9.1.6, even though the maximum count is 2, with both rows already identified by ... and with a GiST index on it. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - Declaring the tuple structure of a record in PL/pgSQL

I can't find anything in the PostgreSQL documentation that shows how to declare a record, or row, while declaring ... END; $$ LANGUAGE plpgsql; See Question&Answers more detail:os...

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

0 votes

849 views

1 answer

postgresql - Rails reports can't find a column that is there

I am currently trying to do a complicated WHERE search on a table using Rails, the trouble is I get the ... had any experience with this? See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

postgresql - Heroku Postgres: "psql: FATAL: no pg_hba.conf entry for host"

There are a number of Heroku CLI Postgres commands that all return the same error. For example: $ heroku pg:bloat ... and how could I fix it? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

postgresql - How to escape question mark (?) character with Spring JpaRepository

Postgres defines additional jsonb Operators such as ?|. However, using Spring JpaRepository query builder, ... your responses guys! See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - Match a phrase ending in a prefix with full text search

I'm looking for a way to emulate something like SELECT * FROM table WHERE attr LIKE '%text%' using a tsvector in ... to_tsquery('zend fram:*'); See Question&Answers more detail:os...

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

0 votes

901 views

1 answer

postgresql - Build postgres docker container with initial schema

I'm looking to build dockerfiles that represent company databases that already exist. Similarly, I'd like create a ... compose to do this. See Question&Answers more detail:os...

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

0 votes

914 views

1 answer

postgresql port confusion 5433 or 5432?

I have installed postgresql on OSX. When I run psql, I get $ psql psql: could not connect to server: No such ... in the right place by default? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

postgresql - datagrip Cannot apply changes This table is read only. Cell editor changes cannot be applied

So simply the problem occurs when I want to edit selected rows and then apply it. I'm sure it worked some ... , reseting also didn't help. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

postgresql - Failed to find conversion function from unknown to text

In one of my select statements I've got the following error: ERROR: failed to find conversion function from unknown to ... 9.2.4 (SQL Fiddle) See Question&Answers more detail:os...

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

0 votes

811 views

1 answer

Background Users can type in a name and the system should match the text, even if the either the user ... index-refuses-to-build-td5108810.html See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

postgresql - Spring Docker container cannot access Postgres Docker container

The Dockerfile of my spring-boot app: FROM openjdk:8-jdk-alpine VOLUME /tmp COPY target/media-0.0.1- ... system is ready to accept connections See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags