Quick Links

pgsql-sql since 2017-11-15 00:00

Discussion for users on SQL related matters.

Search the Archives

Browse Archives

Prev | Next

Nov. 15, 2017

Thread	Author	Time
Re: Line number returned in Postgres Raise Exception sentence	Pavel Stehule	08:49

Nov. 20, 2017

Thread	Author	Time
Re: Line number returned in Postgres Raise Exception sentence	queralt	12:52
Migration to pglister - Before	Stephen Frost	14:33
Migration to PGLister - After	Stephen Frost	14:47
Re: [ADMIN] Migration to pglister - Before	Achilleas Mantzios	15:30
Re: [ADMIN] Migration to pglister - Before	Stephen Frost	15:34

Nov. 22, 2017

Thread	Author	Time
How to use COPY command with jsonb datatype ?	ROS Didier	12:04
Re: How to use COPY command with jsonb datatype ?	bricklen	14:21

Nov. 23, 2017

Thread	Author	Time
Re: How to use COPY command with jsonb datatype ?	Hector Vass	09:05
psql -c "\copy table to test.csv with CSV" - french character is wrong	Emi	16:42
Re: psql -c "\copy table to test.csv with CSV" - french character is wrong	Pierre Chevalier Géologue	18:24
Re: psql -c "\copy table to test.csv with CSV" - french character is wrong	Emi	18:57

Nov. 24, 2017

Thread	Author	Time
Re: psql -c "\copy table to test.csv with CSV" - french character is wrong	David G. Johnston	06:28
Re: psql -c "\copy table to test.csv with CSV" - french character is wrong	Emi	14:47

Nov. 25, 2017

Thread	Author	Time
Roles and security	nikhil raj	20:03
Re: Roles and security	John R Pierce	23:15

Nov. 26, 2017

Thread	Author	Time
Re: Roles and security	Laurenz Albe	15:18

Nov. 28, 2017

Thread	Author	Time
Not counting duplicates of declared pratition in OVER()-clause	Andreas Joseph Krogh	17:54
Sv: Not counting duplicates of declared pratition in OVER()-clause	Andreas Joseph Krogh	18:03

Dec. 7, 2017

Thread	Author	Time
Timestamp alculation identical to Microsoft Excel results	Ertan Küçükoğlu	09:59
Re: Timestamp alculation identical to Microsoft Excel results 📎	Samed YILDIRIM	10:15
Re: Timestamp alculation identical to Microsoft Excel results	Luuk	17:27

Dec. 10, 2017

Thread	Author	Time
window function ?	Olivier Leprêtre	18:33
Re: window function ?	Andreas Kretschmer	18:48

Dec. 11, 2017

Thread	Author	Time
Windowing ?	Olivier Leprêtre	17:09
Re: Windowing ?	Andreas Kretschmer	17:15
Re: Windowing ?	Andreas Kretschmer	18:46

Dec. 12, 2017

Thread	Author	Time
FILTER clause for non-aggregate window functions	Андрей Жиденков	07:54
Re: FILTER clause for non-aggregate window functions	Tom Lane	15:35
Re: FILTER clause for non-aggregate window functions	Андрей Жиденков	16:53

Dec. 18, 2017

Thread	Author	Time
XML Parsing in Postgresql	Abdul Hameedk	13:50
Re: XML Parsing in Postgresql	Lutz Horn	14:02
Re: XML Parsing in Postgresql	Pavel Stehule	14:26

Dec. 19, 2017

Thread	Author	Time
SQL conformity regarding SQLSTATE	Jürgen Purtz	14:14
Re: SQL conformity regarding SQLSTATE	Tom Lane	15:30

Dec. 20, 2017

Thread	Author	Time
Re: SQL conformity regarding SQLSTATE	Jürgen Purtz	10:08
Re: SQL conformity regarding SQLSTATE	Simon Riggs	12:02

Dec. 21, 2017

Thread	Author	Time
Re: SQL conformity regarding SQLSTATE	Tom Lane	01:28
Re: SQL conformity regarding SQLSTATE 📎	Jürgen Purtz	10:44
Re: SQL conformity regarding SQLSTATE	Tom Lane	16:50

Dec. 22, 2017

Thread	Author	Time
Re: SQL conformity regarding SQLSTATE 📎	Jürgen Purtz	17:15

Dec. 25, 2017

Thread	Author	Time
High CPU usage in postgres servers	nikhil raj	18:28
Fwd: High CPU usage in postgres servers	nikhil raj	18:32
Re: High CPU usage in postgres servers	Melvin Davidson	23:12

Dec. 26, 2017

Thread	Author	Time
Re: High CPU usage in postgres servers	Michael Paquier	00:19
Oacle to Postgres migration	Azimuddin Mohammed	00:28
Oracle to postgres migration	Azimuddin Mohammed	00:30
Re: Oacle to Postgres migration	PropAAS DBA	01:41
Re: Oracle to postgres migration	John Scalia	01:51
Re: Oracle to postgres migration	Vasilis Ventirozos	09:36
Re: Oracle to postgres migration	Timo Myyrä	12:32
Re: Oracle to postgres migration	Timo Myyrä	13:14

Dec. 29, 2017

Thread	Author	Time
Re: Oacle to Postgres migration	Francis Santiago	21:48

Jan. 4, 2018

Thread	Author	Time
More optimized SQL	Ertan Küçükoğlu	11:59
Sv: More optimized SQL	Andreas Joseph Krogh	13:27

Jan. 13, 2018

Thread	Author	Time
Alternative SQL	Ertan Küçükoğlu	22:26

Jan. 18, 2018

Thread	Author	Time
Ajuda - insert into select com variavel	Danilo	01:15
Re: Ajuda - insert into select com variavel	Iuri Sampaio	17:01
Re: Ajuda - insert into select com variavel	Danilo Bruneli	17:16
Re: Ajuda - insert into select com variavel	Iuri Sampaio	17:24

Jan. 25, 2018

Thread	Author	Time
nth_value and row_number in a partition	Olivier Leprêtre	18:30
Re: nth_value and row_number in a partition	David G. Johnston	18:43
RE: nth_value and row_number in a partition	Olivier Leprêtre	19:49
Re: nth_value and row_number in a partition	David G. Johnston	19:57
Re: nth_value and row_number in a partition	Martin Stöcker	20:12
RE: nth_value and row_number in a partition	Olivier Leprêtre	20:52

Jan. 26, 2018

Thread	Author	Time
Re: nth_value and row_number in a partition	MS (direkt)	07:31
RE: nth_value and row_number in a partition	Olivier Leprêtre	16:56
Re: nth_value and row_number in a partition	Martin Stöcker	17:04

Feb. 2, 2018

Thread	Author	Time
search inside partitions	Olivier Leprêtre	09:00
help defining a stored procedure that returns a record or an array using SELECT INTO	Luca Ferrari	09:21
Re: help defining a stored procedure that returns a record or an array using SELECT INTO	Pavel Stehule	09:42
Re: search inside partitions	Torsten Grust	11:01
Re: search inside partitions	Torsten Grust	11:20
RE: search inside partitions	Olivier Leprêtre	13:44

Feb. 9, 2018

Thread	Author	Time
functions allowed in CHECK constraints	Achilleas Mantzios	08:37
functions allowed in CHECK constraints	Achilleas Mantzios	09:04
Re: functions allowed in CHECK constraints	Achilleas Mantzios	11:23
Re: functions allowed in CHECK constraints	David G. Johnston	13:58
Re: functions allowed in CHECK constraints	David G. Johnston	14:06
Re: functions allowed in CHECK constraints	Tom Lane	14:32

Feb. 12, 2018

Thread	Author	Time
Conditional update	Lahari Sengupta	12:05
Re: Conditional update	Stuart	14:33

Feb. 13, 2018

Thread	Author	Time
pg_walldump and PITR. PostgreSQL 10.1	ROS Didier	12:58

Feb. 19, 2018

Thread	Author	Time
barman 1.3.3 - barman list-backup ne montre pas tous les backup disponibles	ROS Didier	15:35
Re: barman 1.3.3 - barman list-backup ne montre pas tous les backup disponibles	Anthony Nowocien	16:16
RE: barman 1.3.3 - barman list-backup ne montre pas tous les backup disponibles	ROS Didier	16:22

Feb. 22, 2018

Thread	Author	Time
Discrepancy in query output	Lahari Sengupta	13:20
Re: Discrepancy in query output	Lahari Sengupta	13:56
Re: Discrepancy in query output	David G. Johnston	15:54
Re: Discrepancy in query output	Lahari Sengupta	16:05

Feb. 27, 2018

Thread	Author	Time
update tables with instead of trigger after update of view	garret	17:59

March 1, 2018

Thread	Author	Time
Monthly budgets	Gary Stainburn	08:42
Re: Monthly budgets	Gary Stainburn	09:42
How to best migrate this nested join ?	Gary M	21:16
Re: How to best migrate this nested join ?	David G. Johnston	21:31

March 2, 2018

Thread	Author	Time
Re: How to best migrate this nested join ?	Gary M	00:15

March 8, 2018

Thread	Author	Time
Query question	Stanton Schmidt	18:58
Re: Query question	Martin Stöcker	19:07
Re: Query question	Stanton Schmidt	19:17
Re: Query question	Jeff Fletcher	19:20
Re: Query question	David G. Johnston	19:28
Re: Query question	Thomas Kellerer	19:48
Re: Query question	Stanton Schmidt	20:17

March 10, 2018

Thread	Author	Time
Trouble with single trigger using UUID as key, should I use two triggers?	Jason Aleski	02:15

March 16, 2018

Thread	Author	Time
does the notification of postgres appear in transaction completed order	abctevez	13:42
Re: does the notification of postgres appear in transaction completed order	Tom Lane	14:57

March 29, 2018

Thread	Author	Time
when transaction is committed in postgres	abctevez	06:46
Re: when transaction is committed in postgres 📎	Samed YILDIRIM	11:29

April 1, 2018

Thread	Author	Time
select unnest(), unnest()	Jasmin Dizdarevic	19:38
Re: select unnest(), unnest()	Tom Lane	19:49
Re: select unnest(), unnest()	Jasmin Dizdarevic	20:25

April 17, 2018

Thread	Author	Time
Postgres 9.6 - ltree extension - (re)build a tree on a table	Luca	10:11

April 18, 2018

Thread	Author	Time
Re: Postgres 9.6 - ltree extension - (re)build a tree on a table	Steve Midgley	00:19
Re: Postgres 9.6 - ltree extension - (re)build a tree on a table	David G. Johnston	00:30
summary view design / performance	Gary Stainburn	09:20
Re: summary view design / performance	Achilleas Mantzios	12:45

April 25, 2018

Thread	Author	Time
error in function, works when typed	Gary Stainburn	09:06
Re: error in function, works when typed 📎	Samed YILDIRIM	09:32
Re: error in function, works when typed	Gary Stainburn	09:56

April 27, 2018

Thread	Author	Time
psql method (initcap and also keep Roman number capitalized)	Emi	14:39

April 30, 2018

Thread	Author	Time
Re: psql method (initcap and also keep Roman number capitalized)	Martin Stöcker	11:22

May 6, 2018

Thread	Author	Time
Access to table only through functions	Alvin D?az	22:51

May 7, 2018

Thread	Author	Time
Re: Access to table only through functions	Gerardo Herzig	01:14
Re: Access to table only through functions	Alvin D?az	01:56

June 13, 2018

Thread	Author	Time
Window ?	Olivier Leprêtre	14:33
Re: Window ?	Gerardo Herzig	14:51
Re: Window ?	David G. Johnston	14:54
RE: Window ?	Olivier Leprêtre	15:14
Re: Window ?	Gerardo Herzig	15:22

July 3, 2018

Thread	Author	Time
Problem inserting binary data in bytea column of UTF-8 database	Brice André	04:28

July 5, 2018

Thread	Author	Time
Re: Problem inserting binary data in bytea column of UTF-8 database	Alexey Bashtanov	13:48
Re: Problem inserting binary data in bytea column of UTF-8 database	David G. Johnston	14:04

July 7, 2018

Thread	Author	Time
Re: Problem inserting binary data in bytea column of UTF-8 database	Brice André	06:42

July 26, 2018

Thread	Author	Time
Vacumdb Command Problem	komala pelleti	10:38
Re: Vacumdb Command Problem	hubert depesz lubaczewski	11:41
test mail	Emiliano Amilcarelli	20:18
Fwd: test mail	Emiliano Amilcarelli	20:25
Re: Fwd: test mail	Alvaro Herrera	20:29

July 27, 2018

Thread	Author	Time
Regarding calling shell script from postgres function	komala pelleti	06:12
Re: Regarding calling shell script from postgres function	Andreas Kretschmer	06:51
Regarding vacuumdb	komala pelleti	09:41
Re: Regarding vacuumdb	Andreas Kretschmer	11:38

Aug. 2, 2018

Thread	Author	Time
List user who have access to schema	Suresh Raja	17:49
Re: List user who have access to schema	Tom Lane	17:58
Re: List user who have access to schema	Suresh Raja	18:23
Re: List user who have access to schema	David G. Johnston	18:42
Re: List user who have access to schema	Adrian Klaver	18:47

Aug. 3, 2018

Thread	Author	Time
Re: List user who have access to schema	pinker	14:26

Aug. 6, 2018

Thread	Author	Time
read explain (analyse, buffers) output in Postgres 10.4 with parallel on	Huan Ruan	03:24
Re: read explain (analyse, buffers) output in Postgres 10.4 with parallel on	Jonathan S. Katz	03:33
Re: read explain (analyse, buffers) output in Postgres 10.4 with parallel on	Huan Ruan	06:15

Aug. 28, 2018

Thread	Author	Time
pgadmin not displaying data from postgresql_fdw	Olivier Leprêtre	15:37

Aug. 29, 2018

Thread	Author	Time
redundant constraint_schema	Olivier Leprêtre	13:48
Stored Procedure to Delete Rows and Return Count	Dave Bolt	21:46
Re: Stored Procedure to Delete Rows and Return Count	Jonathan S. Katz	21:50
Re: Stored Procedure to Delete Rows and Return Count	Jonathan S. Katz	21:56
Re: Stored Procedure to Delete Rows and Return Count	David G. Johnston	21:56
RE: Stored Procedure to Delete Rows and Return Count	Dave Bolt	22:26

Sept. 4, 2018

Thread	Author	Time
XMLTABLE question 📎	David Day	10:05
Re: XMLTABLE question	Pavel Stehule	15:05

Sept. 5, 2018

Thread	Author	Time
RE: XMLTABLE question	David Day	08:56
Re: XMLTABLE question	Pavel Stehule	09:41

Sept. 10, 2018

Thread	Author	Time
md5 and trust and pg_hba.conf	Rossi, Maria	14:45
Re: md5 and trust and pg_hba.conf	Sameer Kumar	14:55
Re: md5 and trust and pg_hba.conf	Fabio Pardi	15:17
RE: md5 and trust and pg_hba.conf	Rossi, Maria	15:22
Re: md5 and trust and pg_hba.conf	Sameer Kumar	15:35
RE: md5 and trust and pg_hba.conf	David Raymond	15:41
RE: md5 and trust and pg_hba.conf	Rossi, Maria	19:47
RE: md5 and trust and pg_hba.conf	David Raymond	20:39

Sept. 14, 2018

Thread	Author	Time
create policy/using expression	Voillequin, Jean-Marc	09:22

Sept. 21, 2018

Thread	Author	Time
select where not in () fails	Gary Stainburn	15:08
Re: select where not in () fails	Pavel Stehule	15:11
Re: select where not in () fails	Gary Stainburn	15:20
Re: select where not in () fails	Pavel Stehule	16:14

Sept. 22, 2018

Thread	Author	Time
Re: select where not in () fails	Andrew Gierth	18:13

Oct. 6, 2018

Thread	Author	Time
Why the index is not used ?	ROS Didier	09:57
Re: Why the index is not used ?	Pavel Stehule	10:13
Re: Why the index is not used ?	Vladimir Ryabtsev	16:51

Oct. 7, 2018

Thread	Author	Time
Re: Why the index is not used ?	Paul McGarry	02:20
RE: Why the index is not used ?	ROS Didier	13:13
RE: Why the index is not used ?	ROS Didier	13:20
Re: Why the index is not used ?	Francisco Olarte	15:58
RE: Why the index is not used ?	ROS Didier	18:32
RE: Why the index is not used ?	Kumar, Virendra	18:41
Re: Why the index is not used ?	Vladimir Ryabtsev	18:48
Re: Why the index is not used ?	Vladimir Ryabtsev	19:32
Re: Why the index is not used ?	Tomas Vondra	20:07
Re: Why the index is not used ?	Paul McGarry	22:10

Oct. 8, 2018

Thread	Author	Time
RE: Why the index is not used ?	ROS Didier	06:29
RE: Why the index is not used ?	ROS Didier	08:32
Re: Why the index is not used ?	Jean-Paul Argudo	08:44
RE: Why the index is not used ?	ROS Didier	11:47
RE: Why the index is not used ?	ROS Didier	12:02
RE: Why the index is not used ?	ROS Didier	12:07
RE: Why the index is not used ?	Phil Endecott	13:14
RE: Why the index is not used ?	ROS Didier	14:10
RE: Why the index is not used ?	ROS Didier	14:29
RE: Why the index is not used ?	ROS Didier	15:32

Browse Archives

Prev | Next