python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - postgresql-12

How to add a new column on NOT NULL constraint

I have a table with 2 columns requested with NOT NULL constraint as shown below Col1 Col2 Val1 Val2 Val3 Val4 I am trying to add a new column called 'Col3' ALTER TABLE table ADD COLUMN C...
test-img

드봉드봉

sql

database

postgresql

rdbms

postgresql-12

Votes: 0

Answers: 1

Latest Answer

If the new row is supposed to be NOT NULL, add a DEFAULT clause to the column definition: ALTER TABLE tab ADD COLUMN Col3 INTEGER NOT null DEFAULT 0; Alternatively, omit the NOT NULL, fill the new co...
test-img

Laurenz Albe

SQL Query parent-child in same table

I'm facing a problem trying to build a query. What im trying to do is to select all that dont have parent or have parent but only the latest created (the parent itself are not included in the selectio...
test-img

Syahrulez Anuar

sql

postgresql

postgresql-12

Votes: 0

Answers: 1

Latest Answer

Try this: SELECT a.* FROM myTable a INNER JOIN ( SELECT parent_id, MAX(date_created) date_created FROM myTable GROUP BY parent_id ) b ON a.parent_id = b.parent_id AND a.date_crea...
test-img

Nayanish Damania

How to merge a start, undefined number of midpoints, and an endpoint together?

My goal is to merge together a start point that will always exist, any existing midpoints from a different table(could be from 0-100), and an end point that will always exist. The tables are formatted...
test-img

Jarrett Rector

postgresql

postgis

postgresql-12

Votes: 0

Answers: 1

Latest Answer

Try to use this: ST_MakeLine(ARRAY(SELECT geom FROM mid_point)) And ST_AddPoint() to add start and end points.
test-img

mikkapy

How to configure pgpool with repmgr to make node information sync?

I am trying to configure pgpool with postgresql and repmgr. But after configuring that I found it is not working as expected. When I switchover standby to primary using repmgr it is working expected b...
test-img

Sheikh Wasiu Al Hasib

postgresql

load-balancing

database-administration

postgresql-12

pgpool

Votes: 0

Answers: 1

Latest Answer

If you are making repmgr handle automatic failover, you need to add another step in follow_command parameter in repmgr.conf file as follow: follow_command='/usr/bin/repmgr standby follow -f /etc/repmg...
test-img

Taha Adel

Posts

Questions

Blogs

Jobs