| CARVIEW |
Select Language
HTTP/2 200
date: Wed, 23 Jul 2025 12:22:26 GMT
content-type: text/html; charset=utf-8
cf-ray: 963b24ad1b0d25e0-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=88b2bc14-9df5-4f2a-903c-1cd532575c61; expires=Thu, 23 Jul 2026 12:22:26 GMT; domain=.stackexchange.com; path=/; secure; httponly
strict-transport-security: max-age=31536000; includeSubDomains
vary: Accept-Encoding
content-security-policy: upgrade-insecure-requests; frame-ancestors 'self' https://stackexchange.com
x-frame-options: SAMEORIGIN
x-request-guid: f7fb4437-5e1f-4e05-8ec9-48ba2705236f
x-worker-origin-response-time: 536000000
x-dns-prefetch-control: off
set-cookie: prov=88b2bc14-9df5-4f2a-903c-1cd532575c61; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=75JjbhD6Y8kfbSXEw5ExMsZ2PJW7fmCQvvd5dHg43QI-1753273346-1.0.1.1-djmsthHFtFhFd3NMDI6BwyXuqJSSQvW.wKMgnYwz.Fwy8gJ35v9T_Y7Onku_Z_mu9gkc9DVpBLv51THdoeNJW73vgreb_xvh._4DQ6Ag5Zo; path=/; expires=Wed, 23-Jul-25 12:52:26 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=6SMyYBO3_K3uQN6Z_7kWgDY5RJZEzmV2l4m7pwHP7R0-1753273346649-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'postgresql-9.3' Questions - Database Administrators Stack Exchange
Skip to main content
Stack Exchange Network
Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about TeamsQuestions tagged [postgresql-9.3]
PostgreSQL version 9.3
580 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
51
views
Multiple but not all executions of the same Postgres SELECT query are getting locked endlessly
I am using Postgresql version 9.2.18 on Centos Version CentOS Linux release 7.3.1611 (Core)
In postgres there is a select query on a single table which is getting executed multiple times per minute.
...
1
vote
1
answer
415
views
Postgres timezone issue when using postgres_fdw
I have a view stored on a foreign Postgres server (v 9.3) which pulls all of the data that was posted for the day.
I have foreign tables (using postgres_fdw) stored on my local Postgres servers (...
0
votes
1
answer
20
views
ERROR: column "FLAT" does not exit. Line 1. SELECT UPPER(FLAT). Kindly fix the trigger
CREATE OR REPLACE FUNCTION trigger_fct_tri_sv_tab_temp()
RETURNS trigger
AS
$BODY$
BEGIN
n.FLAT := UPPER(n.FLAT);
RETURN NEW;
end
$BODY$
LANGUAGE plpgsql
SECURITY DEFINER;
CREATE TRIGGER ...
2
votes
3
answers
1k
views
calculate and return the ratings using sql
I have a table like this
What I am trying to achieve is weighted rating. For e.g., in this table we have five star as 3, four star as 1, three star as 1, two star as 1 and one star as 0. So the ...
0
votes
1
answer
918
views
PostgreSQL 9.6.17 COALESCE function error
I'm trying a SQL query with the function COALESCE in PostgreSQL 9.6.17, but it produces an error:
invalid syntax for type double precision: ""
Example query:
SELECT COALESCE(date_part('...
0
votes
1
answer
1k
views
Unable to create view with temp table
Hi I am working on one project and want to create a view. I am using temp table in my query. can any one let me know how we can create such view ?
Following is my query, I tried using WITH..AS , but ...
2
votes
1
answer
377
views
Postgres table size is not growing after adding row
I couldn't see any growth in table size when I added a row in the relevant table. I see the same memory space even after adding 5 rows. Could anyone please help me and explain what I'm doing wrong?
0
votes
1
answer
449
views
Query fails sometimes on casting error
I have a query that can run on the same data set, and sometimes it fails and sometimes it succeeds
The query is generated by hive metadata service, and I can't modify it.
This is a simplified version ...
2
votes
1
answer
9k
views
Could not fork new process for connection: Could not allocate memory
I need help to understand the cause of this error and how to fix it.
I have a server running PostgreSQL 9.3. The cluster has around 1.000 databases. I use pgBouncer for pooling connections, and I set ...
9
votes
2
answers
10k
views
How to estimate the size of a PostgreSQL DB to be dumped through pg_dump
Similar to this question about MySQL --
I need to find out the size of a dump file prior dumping but for a PostgreSQL Database. I could not find any reference to this in the documentation
0
votes
1
answer
152
views
Extract week number from character varying column where dates are in float values as well as in datetimestamp as well
I have a table in which the closure_date which is represented as a character varying column. Some of the dates are saved as "43684.5708564815" and also as "2019-05-24 18:51:17". Now I need to extract ...
3
votes
2
answers
33k
views
How to do a restore of a large postgresql database?
I'm working on restoring a backup from on-premise postgresql to another postgresql database hosted in AWS (rds-aurora postgresql, serverless). The data size is 170gb of compressed data.
I earlier ...
0
votes
0
answers
360
views
Single-tenant to multi-tenant: restore old database to schema in new database
I have a Django app which uses Postgres as a database w/ the django-tenants package providing multitenant functionality. This is a migration from what was originally a single tenant database with just ...
-1
votes
1
answer
404
views
PostgreSQL Password Authentication Error...but cannot find account
I'm getting the following error within the PostgreSQL log file. When an external service is calling the DB for map routing, the following error appears. However, within “Login/Group Roles”,...
1
vote
2
answers
6k
views
How can I have an aggregate function in the WHERE clause?
Using PostgreSQL 9.3.24
Issue
Just simple operation, but I don't know how to do that best simplest way.
How can I display results only when sum of available_counts for same product_id is 0 and ...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
postgresql × 494
performance × 56
index × 28
query-performance × 23
replication × 22
json × 17
optimization × 17
ubuntu × 15
pg-dump × 14
plpgsql × 14
postgresql-9.2 × 14
amazon-rds × 13
backup × 12
postgis × 12
postgresql-9.4 × 12
database-design × 11
pgadmin × 10
update × 10
locking × 9
permissions × 9
psql × 9
upgrade × 9
array × 8
index-tuning × 8
more related tags
Hot Network Questions
- Etymology of the word skulduggery?
- How to 'scale' a square list?
- Praesul meorum tattoo
- In QGIS installed via OSGeo4W on Windows 11, what is the path to the command history file for the Python console?
- Calculating the wall thickness in a hollow rotating cylinder space habitat
- Did Webster's Dictionary define Fascism by its relationship to corporations until 1987?
- Can you identify this shell case from Flanders?
- grep behaviour is different when run using bash -c '...'
- Why is this endgame winning for Black?
- In this video why are the astronauts wearing only their flight suits during dragon training while in others they are in their full starman suits?
- How much power does the Fed chair have over interest rates?
- What was the source of the image of pelican in Catholic churches?
- Prevent equation label from shifting down
- What does this "lightbulb-ish" symbol mean in figure 1 of the Diffie Hellmann paper?
- rEAAlly good for you
- Is a Rakshasa Immune to True Strike?
- Can I still get the pacifist ending if I use the fight option in a boss fight, but miss every time?
- Is it legal for businesses to give financial incentives for leaving positive reviews on review sites (e.g., Google Maps, Yelp, Facebook, Amazon)?
- What is the consistency strength of Russell & Whitehead's ‘Principia Mathematica’?
- Will a restless MCU survive long enough?
- How does Rav Kotler assign final letters in 5 cases in Vayikra-Bamidbar?
- Axioms of quantum mechanics - intuitive explanation
- Book/book series including siblings (possibly twins; boy and girl) fighting various creatures from the 2010's
- Business technical issues lead to unsuccessful payment being considered successful. Do I have any duty to notify?