pgsql-sql since 2019-07-21 00:00

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next

July 21, 2019

Thread Author Time
How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 00:58
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Ron 01:25
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 01:31
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Ron 01:48
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 02:00
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Ron 02:07
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 02:20
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? David G. Johnston 02:48
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Holger Jakobs 07:28
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 13:53
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Ron 14:12
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 14:24
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? David G. Johnston 14:54
Fw: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 14:56
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 15:00
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? David G. Johnston 15:06
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 15:10
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Ron 15:13
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 15:23
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Ron 15:37
Fw: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 15:44
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Avin Kavish 16:10
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 16:26
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Karen Goh 16:30
Re: How do I alter an existing column and add a foreign key which is a Primary key to a table? Scott Ribe 17:30

July 22, 2019

Thread Author Time
How do I alter an existing column and add a foreign key which is a Primary key to a table? David G. Johnston 03:14
Interesting security context issue Erik Brandsberg 20:58

July 23, 2019

Thread Author Time
Implicit typecast behavior Rick Vincent 11:22
AW: Implicit typecast behavior Sonnenberg-Carstens, Stefan 11:29
Re: Implicit typecast behavior Thomas Kellerer 11:46
Re: Implicit typecast behavior Tom Lane 14:31
RE: Implicit typecast behavior Rick Vincent 15:01

July 30, 2019

Thread Author Time
install sample database error Cao, Xiaowei 23:27

July 31, 2019

Thread Author Time
Re: install sample database error Thomas Kellerer 06:16
RE: install sample database error Cao, Xiaowei 16:28
Re: install sample database error Rob Sargent 16:30

Aug. 3, 2019

Thread Author Time
[ECPG] - Help on Dynamic Query using SQLDA with Cursors Rajesh Parameswaran 01:03

Aug. 13, 2019

Thread Author Time
UPDATE command with FROM clause JORGE MALDONADO 18:37
Re: UPDATE command with FROM clause Rob Sargent 21:45
Re: UPDATE command with FROM clause David G. Johnston 22:47

Aug. 19, 2019

Thread Author Time
PLJAVA build failure on postgres docker image Rick Vincent 15:04

Aug. 20, 2019

Thread Author Time
RE: PLJAVA build failure on postgres docker image Rick Vincent 08:38

Aug. 23, 2019

Thread Author Time
Ordering of arrays Mike Martin 10:12
Ordering of arrays Mike Martin 10:14
Re: Ordering of arrays Pavel Stehule 11:53

Aug. 29, 2019

Thread Author Time
libpq: How are result sets fetch behind the scene? Sebastien FLAESCH 16:32
Re: libpq: How are result sets fetched behind the scene? Sebastien FLAESCH 16:39

Aug. 30, 2019

Thread Author Time
Re: libpq: How are result sets fetched behind the scene? Sebastien FLAESCH 13:40
Re: libpq: How are result sets fetched behind the scene? Sebastien FLAESCH 13:55

Sept. 5, 2019

Thread Author Time
Question about WHERE CASE Mike Martin 11:04
Re: Question about WHERE CASE Martin Stöcker 11:42
Re: Question about WHERE CASE Tom Lane 13:46

Sept. 6, 2019

Thread Author Time
A complex SQL query jj08 12:31
Re: A complex SQL query Jānis Pūris 12:56
RE:Re: A complex SQL query jj08 14:35

Sept. 7, 2019

Thread Author Time
How do I enabled Windows 10 to be able to run PSQL etc Karen Goh 12:26
Re: libpq: How are result sets fetched behind the scene? 📎 Christian Barthel 12:43
Re: How do I enabled Windows 10 to be able to run PSQL etc Rob Sargent 14:07
Re: How do I enabled Windows 10 to be able to run PSQL etc Karen Goh 15:04
Re: How do I enabled Windows 10 to be able to run PSQL etc Rob Sargent 15:49
RE:RE:Re: A complex SQL query jj08 18:23
Re: RE:Re: A complex SQL query Victor Yegorov 21:33

Sept. 8, 2019

Thread Author Time
RE:Re: RE:Re: A complex SQL query jj08 02:09
Re: RE:Re: RE:Re: A complex SQL query v_kalees 03:20
Re: How do I enabled Windows 10 to be able to run PSQL etc 📎 Karen Goh 04:11
RE:Re: RE:Re: RE:Re: A complex SQL query jj08 16:12
Re: libpq: How are result sets fetched behind the scene? Tom Lane 19:35

Sept. 9, 2019

Thread Author Time
Re: How do I enabled Windows 10 to be able to run PSQL etc Rob Sargent 02:30
Re: How do I enabled Windows 10 to be able to run PSQL etc 📎 Karen Goh 05:06
Re: How do I enabled Windows 10 to be able to run PSQL etc Steve Midgley 15:07
Re: How do I enabled Windows 10 to be able to run PSQL etc Rob Sargent 15:45

Sept. 10, 2019

Thread Author Time
Re: libpq: How are result sets fetched behind the scene? Sebastien FLAESCH 09:11

Sept. 11, 2019

Thread Author Time
Find and replace Campbell, Lance 20:24
Re: Find and replace Rob Sargent 20:27
Re: Find and replace Campbell, Lance 20:31
Re: Find and replace Tom Lane 20:49

Sept. 12, 2019

Thread Author Time
Re: How do I enabled Windows 10 to be able to run PSQL etc Karen Goh 10:50
Re: How do I enabled Windows 10 to be able to run PSQL etc Steve Midgley 12:07
Looking for technical references on how to set up PostGIS/PostgreSQL for serving MapInfo Desktop application users Shaozhong SHI 12:09
Re: How do I enabled Windows 10 to be able to run PSQL etc Karen Goh 12:17
Re: How do I enabled Windows 10 to be able to run PSQL etc Steve Midgley 12:22
Re: Looking for technical references on how to set up PostGIS/PostgreSQL for serving MapInfo Desktop application users Iuri Sampaio 23:17

Sept. 18, 2019

Thread Author Time
Unexpected behaviour since Windows 1903 Update Koorsen, Andre 11:39

Sept. 19, 2019

Thread Author Time
any alternative to pg-safeupdate for windows 10? john snow 03:47
Re: any alternative to pg-safeupdate for windows 10? john snow 04:00
Re: any alternative to pg-safeupdate for windows 10? Steve Midgley 08:16

Sept. 20, 2019

Thread Author Time
German "umlaut insensitive" query Jakob.Witczak 08:36
Re: German "umlaut insensitive" query Jonathan S. Katz 12:17
Dialog box, passing parameter fails [email protected] 22:20

Sept. 23, 2019

Thread Author Time
Re: Dialog box, passing parameter fails Steve Midgley 00:24
AW: German "umlaut insensitive" query Jakob.Witczak 05:57
RE: Dialog box, passing parameter fails Voillequin, Jean-Marc 06:53

Sept. 24, 2019

Thread Author Time
Re: AW: German "umlaut insensitive" query Peter Eisentraut 07:05
AW: AW: German "umlaut insensitive" query Jakob.Witczak 08:38
RE: AW: German "umlaut insensitive" query Voillequin, Jean-Marc 10:10

Sept. 25, 2019

Thread Author Time
How do I get rid of version 10 Postgresql completely ? Karen Goh 15:03
Fw: How do I get rid of version 10 Postgresql completely ? Karen Goh 15:52
Re: Fw: How do I get rid of version 10 Postgresql completely ? Rob Sargent 16:05

Sept. 26, 2019

Thread Author Time
No enough disk space to launch server [email protected] 20:06

Sept. 27, 2019

Thread Author Time
Transactions in one table JORGE MALDONADO 16:21
Re: Transactions in one table Olivier Gautherot 16:26
Re: Transactions in one table David G. Johnston 16:27
Re: Transactions in one table Rob Sargent 16:41

Oct. 4, 2019

Thread Author Time
Automatically updating a new information column in PostgreSQL Pepe TD Vo 13:26
RE: Automatically updating a new information column in PostgreSQL Voillequin, Jean-Marc 13:49
Re: Automatically updating a new information column in PostgreSQL Tom Lane 13:50
Re: Automatically updating a new information column in PostgreSQL Pepe TD Vo 15:53

Oct. 8, 2019

Thread Author Time
parser that could handle "FROM... SELECT..." as well as "SELECT... FROM..." Marius Andreiana 06:12
Re: parser that could handle "FROM... SELECT..." as well as "SELECT... FROM..." Pavel Stehule 06:32
Re: parser that could handle "FROM... SELECT..." as well as "SELECT... FROM..." Marius Andreiana 07:14
Re: parser that could handle "FROM... SELECT..." as well as "SELECT... FROM..." Pavel Stehule 07:25
Re: parser that could handle "FROM... SELECT..." as well as "SELECT... FROM..." Tom Lane 14:29
Qusetion re regexexp_split_to_array and last occurence Mike Martin 15:48
Question re regexexp_split_to_array and last oc Mike Martin 15:51
Re: Qusetion re regexexp_split_to_array and last occurence David G. Johnston 19:26

Oct. 9, 2019

Thread Author Time
pg_dump compatibility level / use create view instead of create table/rule Alex Williams 01:01
Re: pg_dump compatibility level / use create view instead of create table/rule Alex Williams 01:11
Re: pg_dump compatibility level / use create view instead of create table/rule Tom Lane 05:01
Set FILLFACTOR for primary key Ed Behn 16:36
Re: Set FILLFACTOR for primary key Peter Geoghegan 17:16
Re: pg_dump compatibility level / use create view instead of create table/rule Alex Williams 21:32
Re: pg_dump compatibility level / use create view instead of create table/rule Alex Williams 21:34
Re: pg_dump compatibility level / use create view instead of create table/rule Alex Williams 21:39
Re: pg_dump compatibility level / use create view instead of create table/rule Tom Lane 22:46

Oct. 10, 2019

Thread Author Time
Re: pg_dump compatibility level / use create view instead of create table/rule 📎 Alex Williams 00:24
Re: pg_dump compatibility level / use create view instead of create table/rule Tom Lane 15:20

Oct. 11, 2019

Thread Author Time
Modeling graph data in Postgres? Steve Midgley 09:20

Oct. 16, 2019

Thread Author Time
Save Session? Mike Martin 11:30
Should I add a Index Key in this case ? Karen Goh 11:36
Re: Save Session? William Ivanski 11:36
Re: Should I add a Index Key in this case ? Steve Midgley 15:26
Re: Should I add a Index Key in this case ? Karen Goh 15:47
Re: Should I add a Index Key in this case ? Rob Sargent 16:05

Oct. 17, 2019

Thread Author Time
Re: Save Session? Arni Kromić 07:31
Fwd: Save Session? Arni Kromić 07:33
RE: Save Session? Dave Bolt 10:13

Oct. 21, 2019

Thread Author Time
pgpool-II 4.0 switching over standby to master issue Om Prakash Jaiswal 09:11

Oct. 26, 2019

Thread Author Time
Re: pg_dump compatibility level / use create view instead of create table/rule Tom Lane 19:03
Re: pg_dump compatibility level / use create view instead of create table/rule Andres Freund 20:56
Re: pg_dump compatibility level / use create view instead of create table/rule Tom Lane 21:18

Nov. 7, 2019

Thread Author Time
Using transactions in all CRUD operations JORGE MALDONADO 00:42
Re: Using transactions in all CRUD operations Rene Romero Benavides 00:53
Returned row count doesn't match lines in output file Tchouante, Merlin 17:57
Re: Returned row count doesn't match lines in output file Tom Lane 18:06
Re: Returned row count doesn't match lines in output file Rob Sargent 18:06
Re: Returned row count doesn't match lines in output file Steve Midgley 18:06
RE: Returned row count doesn't match lines in output file Tchouante, Merlin 18:29

Nov. 8, 2019

Thread Author Time
Help with outer joins Tchouante, Merlin 16:55

Nov. 11, 2019

Thread Author Time
RE: Help with outer joins Tchouante, Merlin 15:21
type for storing emails? stan 17:59
Re: type for storing emails? Dmitry Igrishin 18:19
Re: type for storing emails? Rene Romero Benavides 18:29

Nov. 12, 2019

Thread Author Time
Re: type for storing emails? Martin Edlman 07:37
FW: Re: type for storing emails? stan 15:07
Sv: FW: Re: type for storing emails? Andreas Joseph Krogh 15:21
Re: FW: Re: type for storing emails? Steve Midgley 15:50
Re: FW: Re: type for storing emails? Andreas Joseph Krogh 16:44
install problem with extensions stan 17:09
Re: install problem with extensions legrand legrand 21:50

Nov. 13, 2019

Thread Author Time
Re: install problem with extensions stan 18:09
Re: install problem with extensions legrand legrand 18:11

Nov. 14, 2019

Thread Author Time
Re: Postgresql RDS DB Latency Chossing Hash join Plan github kran 17:21
PostGreSQL Replication and question on maintenance github kran 17:23

Nov. 15, 2019

Thread Author Time
Fwd: PostGreSQL Replication and question on maintenance github kran 05:26
Re: PostGreSQL Replication and question on maintenance Pavel Stehule 05:41
Re: PostGreSQL Replication and question on maintenance github kran 15:10

Nov. 16, 2019

Thread Author Time
Re: PostGreSQL Replication and question on maintenance github kran 13:36
Re: PostGreSQL Replication and question on maintenance Jeff Janes 17:13

Nov. 20, 2019

Thread Author Time
Re: PostGreSQL Replication and question on maintenance Soto Cuevas Manuel Alejandro 12:12
Re: PostGreSQL Replication and question on maintenance Pavel Stehule 12:15

Nov. 25, 2019

Thread Author Time
How to use Array in Array of Json Monalee Bhandge 12:02
Re: How to use Array in Array of Json Steve Midgley 16:13
RE: How to use Array in Array of Json 2.andriychuk 16:14

Nov. 26, 2019

Thread Author Time
Re: How to use Array in Array of Json Monalee Bhandge 05:38

Nov. 27, 2019

Thread Author Time
Re: PostGreSQL Replication and question on maintenance github kran 01:22
How to use Array in Array of Json Monalee Bhandge 12:11

Dec. 1, 2019

Thread Author Time
Solving my query needs with Rank and may be CrossTab Iaam Onkara 22:54
Re: Solving my query needs with Rank and may be CrossTab Rob Sargent 23:28
Re: Solving my query needs with Rank and may be CrossTab Iaam Onkara 23:38

Dec. 2, 2019

Thread Author Time
Re: Solving my query needs with Rank and may be CrossTab Rob Sargent 04:58
Re: Solving my query needs with Rank and may be CrossTab Iaam Onkara 06:09
Re: Solving my query needs with Rank and may be CrossTab Rob Sargent 13:42
Re: Solving my query needs with Rank and may be CrossTab Iaam Onkara 16:55
Re: Solving my query needs with Rank and may be CrossTab Rob Sargent 21:14

Dec. 20, 2019

Thread Author Time
problem with read-only user ROS Didier 13:01
Re: problem with read-only user Tom Lane 14:04

Dec. 27, 2019

Thread Author Time
RE: problem with read-only user ROS Didier 08:56

Dec. 31, 2019

Thread Author Time
Whether to use "IN" clause Mark Williams 10:15

Jan. 3, 2020

Thread Author Time
For each statement trigger and update table Mike Martin 23:09
Re: For each statement trigger and update table Rene Romero Benavides 23:39
Re: For each statement trigger and update table Mike Martin 23:55

Jan. 4, 2020

Thread Author Time
Re: For each statement trigger and update table Rene Romero Benavides 00:06
Re: For each statement trigger and update table Rene Romero Benavides 00:26
Re: For each statement trigger and update table Mike Martin 00:32
Re: For each statement trigger and update table Mike Martin 03:45

Jan. 5, 2020

Thread Author Time
Re: For each statement trigger and update table Rene Romero Benavides 01:49
Re: For each statement trigger and update table Mike Martin 16:10
Re: For each statement trigger and update table Rene Romero Benavides 19:42

Jan. 6, 2020

Thread Author Time
Re: For each statement trigger and update table Erik Brandsberg 13:53

Jan. 25, 2020

Thread Author Time
SQL schema and query optimisation for fast cross-table query execution Brice André 08:49

Browse Archives

Prev | Next