postgresql-9.2 Questions
25
Solved
Whenever I try to drop database I get the following error:
ERROR: database "pilot" is being accessed by other users
DETAIL: There is 1 other session using the database.
When I use:
SELEC...
Reflection asked 3/7, 2013 at 13:32
3
Solved
I have several large tables in Postgres 9.2 (millions of rows) where I need to generate a unique code based on the combination of two fields, 'source' (varchar) and 'id' (int). I can do this by gen...
Kazukokb asked 5/12, 2013 at 5:50
3
I am new in postgreSQL database , I recently found that postgreSQL support SQL Job by pgAgent. I am using windows XP operating system.
I searched lots about pgAgent on Google and trying to config...
Hypopituitarism asked 10/7, 2013 at 9:33
5
I have a variable 'x' which is varchar in staging table, but it is set to boolean in target table which has 'true' and 'false' values. How can I convert varchar to boolean in postgresql?
Intolerant asked 7/6, 2016 at 19:33
2
Solved
Let's say we're building a DB for storing analytics from web sites or mobile apps. Transactions aren't important (it's ok to drop things) and only slow things down, supporting as many concurrent ca...
Monospermous asked 21/1, 2013 at 20:29
2
Solved
If i have a column say column a of any given values, and i want another column column b to have a default value according to the value of column a
In another words:
if column a = 'peter' then colu...
Epinephrine asked 24/5, 2013 at 14:46
3
Solved
I am using PostgreSQL 9.2 on RedHat 6. I am looking for the database table and column which stores the location for a PostgreSQL tablespace. I thought it would be in PG_TABLESPACE, but
select * fro...
Voiced asked 5/2, 2016 at 10:32
7
I have a TEXT column containing valid JSON string.
CREATE TABLE users(settings TEXT);
INSERT INTO users VALUES ('{"language":"en","gender":"male"}');
INSERT INTO users VALUES ('{"language":"fr","...
Jubbulpore asked 18/4, 2013 at 4:14
4
I am trying to install the debugger for postgresql on Linux so I can use pgAdmin to debug my functions. I've set up my postgresql.conf file. However, I can't find pldbgapi.sql.
Postgresql is inst...
Iconoduly asked 30/8, 2013 at 14:9
2
Solved
I'm trying to work with current_setting().
I came up with this:
CREATE OR REPLACE FUNCTION process_audit() RETURNS TRIGGER AS $audit$
DECLARE
user_id integer;
BEGIN
BEGIN
user_id := current_...
Narbonne asked 30/7, 2013 at 20:19
2
Solved
In PostgreSql 9.2.4 I have two tables: user (id, login, password, name) and dealer (id, user_id).
And I want to insert into both tables returning id of created dealer.
Currently I'm doing it with...
Pavis asked 3/10, 2013 at 19:12
4
This should be SO simple. I want to retrieve the nextval of a sequence... it's not a default value... it's not a primary key... it's not a foreign key. In rare cases, I need a sequence number for a...
Fractocumulus asked 30/7, 2013 at 18:22
2
Solved
Postgres version :
PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit
We transfer from one server to another (with better cpu an ram) o...
Tempera asked 22/6, 2016 at 11:14
2
Below log message is available in postgres log file several thousand times. How to resolve.
missing chunk number 0 for toast value 815441 in pg_toast_2619.
pg_toast_2619 is the pg_statistic table...
Discernment asked 28/11, 2017 at 14:12
5
Solved
I'm trying to take a look at locks that are happening on
specific tables in my PostgreSQL database.
I see there's a table called pg_locks
select * from pg_locks;
Which seems to give me a bunch ...
Aquarium asked 9/5, 2016 at 7:39
2
I have a four node clustered Airflow environment that's been working fine for me for a few months now.
ec2-instances
Server 1: Webserver, Scheduler, Redis Queue, PostgreSQL Database
Server 2: W...
Volution asked 23/7, 2018 at 21:58
2
Solved
This has been asked multiple times here and here, but none of the answers are suitable in my case because I do not want to execute my update statement in a PL/PgSQL function and use GET DIAGNOSTICS...
Ilonailonka asked 30/11, 2012 at 15:14
10
Solved
I currently have a django app am developing on my PC with data in my db but when i try running this app on a test server i get the error below
DatabaseError: relation "django_site" does not exist...
Ripply asked 26/7, 2013 at 21:40
2
I have a problem that I'm working on. Below is a simplified query to show the problem:
WITH the_table AS (
SELECT a, b
FROM (VALUES('data1', 2), ('data3', 4), ('data5', 6)) x (a, b)
), my_data ...
Anabel asked 6/12, 2014 at 1:34
4
Solved
The following query is performed concurrently by two threads logged in with two different users:
WITH raw_stat AS (
SELECT
host(client_addr) as client_addr,
pid ,
usename
FROM
pg_stat_activi...
Fenn asked 15/10, 2013 at 13:19
4
Solved
I am trying to query a database table in postgresql, but every time I run the below query it gives me the INSUFFICIENT PRIVILEGE error. What possibly could be the reason for such permission denied ...
Clover asked 12/8, 2013 at 17:53
20
I just upgraded my MacMini Server from Lion Server to Mountain Lion using OS X Server. I am having the same problem with PostgreSQL that I did last year when I first installed Lion Server.
When I t...
Percipient asked 13/12, 2012 at 21:25
2
Solved
I want build new postgreSQL database by:
CREATE DATABASE newdb
WITH OWNER = postgres
ENCODING = 'UTF8'
TABLESPACE = pg_default
LC_COLLATE = 'zh_CN.UTF-8'
CONNECTION LIMIT = -1;
and the error...
Successive asked 18/9, 2013 at 11:16
2
Solved
Does anyone know what is the limit on the size of JSON data type in PostgreSQL 9.2?
Araby asked 28/9, 2012 at 2:37
4
Solved
Sorry if this is a dumb question but do i need to reindex my table every time i insert rows, or does the new row get indexed when added?
Discarnate asked 7/7, 2013 at 5:10
© 2022 - 2024 — McMap. All rights reserved.