Recent questions tagged postgresql

0 votes

770 views

1 answer

This string: "CREATE USER %s PASSWORD %s", (user, pw) always gets expanded to: CREATE USER E'someuser' PASSWORD E' ... (user, pw)) conn.commit() See Question&Answers more detail:os...

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

0 votes

922 views

1 answer

postgresql - How do I change a Crystal Report's ODBC database connection at runtime?

I have a report made with Crystal Reports 2008 that I need to deploy a production system which means that ... database connection at runtime? See Question&Answers more detail:os...

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

0 votes

931 views

1 answer

postgresql - No function matches the given name and argument types

My function is: CREATE OR REPLACE FUNCTION FnUpdateSalegtab09 ( iacyrid Integer,iRepId Integer,iDrId Integer,ivrid Integer,imode ... ********* See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

postgresql - Error when pushing data to Heroku: time zone displacement out of range

I run the following command to push the contents of my local database to Heroku: heroku db:push --app my-app From ... on and/or how to fix it? See Question&Answers more detail:os...

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

0 votes

995 views

1 answer

postgresql - SQL Sub queries in check constraint

Can I make SQL sub queries in Check constraint ? I've a post table with columns id, owner I've another ... table action How is that possible ? See Question&Answers more detail:os...

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

0 votes

846 views

1 answer

postgresql - Using a variable period in an interval in Postgres

I have a relation that maintains monthly historical data. This data is added to the table on the last day of ... . How is this properly done? See Question&Answers more detail:os...

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

0 votes

874 views

1 answer

postgresql - Collect Recursive JSON Keys In Postgres

I have JSON documents stored in Postgres under the JSON data type (Postgres 9.3) and I need to recursively ... two together. Can anyone help? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

postgresql - Sorting array elements

I want to write a stored procedure that gets an array as input parameter and sort that array and return the sorted array. Kindly help. See Question&Answers more detail:os...

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

0 votes

797 views

1 answer

postgresql - Composite PRIMARY KEY enforces NOT NULL constraints on involved columns

This is one strange, unwanted behavior I encountered in Postgres: When I create a Postgres table with composite ... NULL constraints of course. See Question&Answers more detail:os...

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

0 votes

841 views

1 answer

postgresql - Maximum characters in labels (table names, columns etc)

Hope this question wasn't asked before. Does anyone know the character limit for domain names? For example if I ... names (columns, tables etc)? See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

postgresql - ERROR: unterminated quoted string at or near

While executing below shown trigger code using ANT I am getting the error org.postgresql.util.PSQLException: ERROR: ... sweeper(); END; See Question&Answers more detail:os...

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

0 votes

845 views

1 answer

postgresql - Django bulk_create with ignore rows that cause IntegrityError?

I am using bulk_create to loads thousands or rows into a postgresql DB. Unfortunately some of the rows are causing ... of the batch as possible? See Question&Answers more detail:os...

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

0 votes

781 views

1 answer

postgresql - Selecting rows ordered by some column and distinct on another

Related to - PostgreSQL DISTINCT ON with different ORDER BY I have table purchases (product_id, purchased_at, address_id) ... way to fix it? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

postgresql - How do I alter the date format in Postgres?

I'm getting the following error message ERROR: date/time field value out of range: "13/01/2010" HINT: Perhaps ... date in the format DD/MM/YYYY See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

postgresql - How do I get asynchronous / event-driven LISTEN/NOTIFY support in Java using a Postgres database?

From what I can tell, the JDBC drivers for LISTEN/NOTIFY in Java do NOT support true event-driven ... event-driven manner without polling? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - SQL Populate table with random data

I have a table with two fields: id(UUID) that is primary Key and description (var255) I want to insert random ... . PS: I am using PostgreSQL. See Question&Answers more detail:os...

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

0 votes

668 views

1 answer

postgresql - SELECT or INSERT a row in one command

I'm using PostgreSQL 9.0 and I have a table with just an artificial key (auto-incrementing sequence) and ... on other_key, if that helps. See Question&Answers more detail:os...

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

0 votes

854 views

1 answer

postgresql - Find dependent objects for a table or view

Background When dropping (or replacing) objects in PostgreSQL, if there are dependencies, the drop will fail (without ... by name and type? See Question&Answers more detail:os...

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

0 votes

917 views

1 answer

postgresql - SQL LIKE condition to check for integer?

I am using a set of SQL LIKE conditions to go through the alphabet and list all items beginning with the appropriate ... is on a Postgres DB. See Question&Answers more detail:os...

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

0 votes

828 views

1 answer

postgresql - eliminate duplicate array values in postgres

I have an array of type bigint, how can I remove the duplicate values in that array? Ex: array[1234, 5343, ... manual but it is not working. See Question&Answers more detail:os...

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

0 votes

866 views

1 answer

postgresql - Django: permission denied when trying to access database after restore (migration)

I have a django 1.4 app with a populated postgres 9.1 database in development server locally. After successful ... Am I missing something here? See Question&Answers more detail:os...

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

0 votes

787 views

1 answer

postgresql - Find Parent Recursively using Query

I am using postgresql. I have the table as like below parent_id child_id ---------------------- 101 102 103 104 ... --> 105 --> 104 --> 103) See Question&Answers more detail:os...

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

0 votes

754 views

1 answer

postgresql - Can I use return value of INSERT...RETURNING in another INSERT?

Is something like this possible? INSERT INTO Table2 (val) VALUES ((INSERT INTO Table1 (name) VALUES ('a_title' ... reference to the first table? See Question&Answers more detail:os...

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

0 votes

975 views

1 answer

postgresql duplicate key violates unique constraint

Hi i have a question i know this was posted many times but i didn't find an answer to my problem. The ... other thing that should be done ? See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

postgresql - Postgis installation: type "geometry" does not exist

I am trying to create table with Postgis. I do it by this page. But when I import postgis.sql file, I get a ... anybody know how can I fix it? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - Change type of varchar field to integer: "cannot be cast automatically to type integer"

I have a small table and a certain field contains the type "character varying". I'm trying to change it ... field contains only integer values. See Question&Answers more detail:os...

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

0 votes

724 views

1 answer

postgresql - Error when setting n_distinct using a plpgsql variable

I tried to use a function to set the n_distinct value for a table. The code is as follows: create ... any particular rule I overlooked? See Question&Answers more detail:os...

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

0 votes

857 views

1 answer

postgresql - function returns multiple columns as a single column instead of multiple columns

I am currently writing a function in postgresql 9.04 where I am attempting to use a variable which will be ... seperately? thank you in advance. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags