Quick Links

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

Discussion for users on SQL related matters.

Search the Archives

Browse Archives

Prev | Next

Oct. 11, 2017

Thread	Author	Time
Re: ERROR: invalid byte sequence for encoding "UTF8": 0xe9 0x6d 0x61	Feike Steenbergen	06:20
Re: ERROR: invalid byte sequence for encoding "UTF8": 0xe9 0x6d 0x61 - fixed	ROS Didier	07:49

Oct. 14, 2017

Thread	Author	Time
Only insert into tables trough functions	Alvin Díaz	13:36

Oct. 16, 2017

Thread	Author	Time
How to index encrypted colums ?	ROS Didier	13:38
Re: Only insert into tables trough functions	Klaus Kaisersberger	15:31
Re: How to index encrypted colums ?	Klaus Kaisersberger	15:47

Oct. 17, 2017

Thread	Author	Time
Re: How to index encrypted colums ?	ROS Didier	07:49
Re: How to get the list of tables with encrypted columns	ROS Didier	07:54
Re: How to index encrypted colums ?	Steve Midgley	14:14
Re: How to index encrypted colums ?	ROS Didier	15:17
Re: How to index encrypted colums ?	Guillaume Lelarge	15:37
Re: How to index encrypted colums ?	Klaus Kaisersberger	16:26
Re: How to index encrypted colums ?	Steve Midgley	16:46
Re: How to index encrypted colums ?	Klaus Kaisersberger	18:33
Re: How to index encrypted colums ?	Klaus Kaisersberger	18:54
Re: How to index encrypted colums ?	Klaus Kaisersberger	19:18
Re: How to get the list of tables with encrypted columns	Klaus Kaisersberger	20:46
Re: How to get the list of tables with encrypted columns	Klaus Kaisersberger	20:49

Oct. 24, 2017

Thread	Author	Time
Unable to use INSERT ... RETURNING with column from other table	Andreas Joseph Krogh	22:04
Re: Unable to use INSERT ... RETURNING with column from other table	Peter Geoghegan	22:06
Re: Unable to use INSERT ... RETURNING with column from other table	Andreas Joseph Krogh	22:49

Oct. 25, 2017

Thread	Author	Time
Re: Unable to use INSERT ... RETURNING with column from other table	Andreas Joseph Krogh	00:21
Re: Unable to use INSERT ... RETURNING with column from other table	David G. Johnston	01:56
Re: Unable to use INSERT ... RETURNING with column from other table	Peter Geoghegan	02:45
Re: Unable to use INSERT ... RETURNING with column from other table	Tom Lane	03:04
Re: Unable to use INSERT ... RETURNING with column from other table	Andreas Joseph Krogh	21:15
Re: Unable to use INSERT ... RETURNING with column from other table	Andreas Joseph Krogh	21:34

Nov. 1, 2017

Thread	Author	Time
join tables by nearest timestamp	Brice André	05:53
Re: join tables by nearest timestamp	Achilleas Mantzios	08:06
Re: join tables by nearest timestamp	Achilleas Mantzios	08:11
Re: join tables by nearest timestamp	Brice André	08:47
Re: join tables by nearest timestamp	Brice André	13:12

Nov. 2, 2017

Thread	Author	Time
Re: join tables by nearest timestamp	Achilleas Mantzios	07:43
Re: join tables by nearest timestamp	Brice André	09:31
Re: join tables by nearest timestamp	Achilleas Mantzios	14:49

Nov. 8, 2017

Thread	Author	Time
Problems with PARTITION BY with count() in window-func	Andreas Joseph Krogh	10:17
Re: Problems with PARTITION BY with count() in window-func	Andreas Joseph Krogh	13:50
Re: Problems with PARTITION BY with count() in window-func	MS (direkt)	14:51

Nov. 13, 2017

Thread	Author	Time
md5 checksum of a previous row	Iaam Onkara	06:15
Re: md5 checksum of a previous row	Achilleas Mantzios	07:25
Re: md5 checksum of a previous row	Iaam Onkara	07:30
Re: md5 checksum of a previous row	MS (direkt)	07:31
Re: md5 checksum of a previous row	Iaam Onkara	07:39
Re: md5 checksum of a previous row	MS (direkt)	07:42
Re: md5 checksum of a previous row	Iaam Onkara	07:47
Re: md5 checksum of a previous row	Thomas Kellerer	07:49
Re: md5 checksum of a previous row	Iaam Onkara	07:56
Re: md5 checksum of a previous row	Achilleas Mantzios	07:57
Re: md5 checksum of a previous row	Achilleas Mantzios	08:01
Re: md5 checksum of a previous row	Iaam Onkara	08:01
Re: md5 checksum of a previous row	Achilleas Mantzios	08:13
Re: md5 checksum of a previous row	Iaam Onkara	14:11
Re: md5 checksum of a previous row	Achilleas Mantzios	14:36

Nov. 14, 2017

Thread	Author	Time
Line number returned in Postgres Raise Exception sentence	queralt	10:17

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

Browse Archives

Prev | Next