pgsql-sql since 2015-06-01 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

June 1, 2015

Thread Author Time
Re: PG and Temporal Steve Midgley 17:25
Re: PG and Temporal Ravi Krishna 18:02

June 2, 2015

Thread Author Time
Re: PG and Temporal Skylar Thompson 13:36

June 4, 2015

Thread Author Time
remove tablespace for primary key (*not* by drop/recreate constraint) Emi Lu 16:41
Re: remove tablespace for primary key (*not* by drop/recreate constraint) David G. Johnston 17:44
Re: remove tablespace for primary key (*not* by drop/recreate constraint) 📎 Emi Lu 18:35
Re: remove tablespace for primary key (*not* by drop/recreate constraint) Adrian Klaver 18:50
Re: remove tablespace for primary key (*not* by drop/recreate constraint) David G. Johnston 18:51

June 5, 2015

Thread Author Time
Re: remove tablespace for primary key (*not* by drop/recreate constraint) 📎 Emi Lu 13:33
Re: remove tablespace for primary key (*not* by drop/recreate constraint) Igor Neyman 13:47
Re: remove tablespace for primary key (*not* by drop/recreate constraint) Igor Neyman 13:52
Re: remove tablespace for primary key (*not* by drop/recreate constraint) David G. Johnston 13:59
Re: remove tablespace for primary key (*not* by drop/recreate constraint) 📎 Emi Lu 14:00
Re: remove tablespace for primary key (*not* by drop/recreate constraint) Igor Neyman 14:25

June 10, 2015

Thread Author Time
Renumber Primary Keys and Update the same as Foreign Keys Jon Forsyth 23:05
Re: Renumber Primary Keys and Update the same as Foreign Keys Adrian Klaver 23:51

June 11, 2015

Thread Author Time
Re: Renumber Primary Keys and Update the same as Foreign Keys Jon Forsyth 20:02
Re: Renumber Primary Keys and Update the same as Foreign Keys Adrian Klaver 20:24

June 12, 2015

Thread Author Time
Null principal provided for method... Andreas Joseph Krogh 13:42
Re: Null principal provided for method... Andreas Joseph Krogh 13:47

June 16, 2015

Thread Author Time
self join issue Ed Rouse 20:41

June 17, 2015

Thread Author Time
Re: self join issue David G. Johnston 15:18
EnterpriseDB: PostgreSql 9.4 Where is the Language Pack Installer? Stephen Tahmosh 15:19
Re: EnterpriseDB: PostgreSql 9.4 Where is the Language Pack Installer? Stephen Tahmosh 15:34

June 18, 2015

Thread Author Time
3 foreign keys in 1 table for 3 1-to-many relations? gvim 00:51
Re: 3 foreign keys in 1 table for 3 1-to-many relations? David G. Johnston 01:30
Re: self join issue Marc Mamin 19:45

June 22, 2015

Thread Author Time
Re: extracting PII data and transforming it across table. Suresh Raja 21:09
Run analyze on schema Suresh Raja 21:10
Re: Run analyze on schema Jerry Sievers 23:53

June 24, 2015

Thread Author Time
Re: [GENERAL] Run analyze on schema Suresh Raja 03:34

June 29, 2015

Thread Author Time
Disable Trigger for session only gmb 07:43
Re: Disable Trigger for session only Adrian Klaver 13:06
Re: Disable Trigger for session only gmb 14:13
Re: Disable Trigger for session only Adrian Klaver 14:26
Re: Disable Trigger for session only Greg Sabino Mullane 20:34
Re: Disable Trigger for session only Adrian Klaver 20:43

June 30, 2015

Thread Author Time
Re: Disable Trigger for session only gmb 07:17
Re: Disable Trigger for session only gmb 08:31

July 1, 2015

Thread Author Time
[C#] File Upload to PostgreSQL drunken 08:10
Re: [C#] File Upload to PostgreSQL David G. Johnston 12:17

July 2, 2015

Thread Author Time
PGSQL-Performance mailing list John Sherwood 10:52

July 3, 2015

Thread Author Time
Re: Help with 'contestant' query Greg Sabino Mullane 19:36

July 7, 2015

Thread Author Time
Backups failing despite many settings that should prevent it John Sherwood 13:35
Re: Backups failing despite many settings that should prevent it Tom Lane 14:28

July 8, 2015

Thread Author Time
Oracle to PostgreSQL Migration - Need Information Tim Clotworthy 16:30
Re: Oracle to PostgreSQL Migration - Need Information [email protected] 18:21
encrypt psql password in unix script Suresh Raja 18:34
Re: encrypt psql password in unix script John R Pierce 18:46
Re: encrypt psql password in unix script Steve Midgley 19:01
Re: encrypt psql password in unix script Vick Khera 19:06
Re: [SQL] encrypt psql password in unix script Xavier Stevens 19:08
Re: [SQL] encrypt psql password in unix script John R Pierce 19:20

July 9, 2015

Thread Author Time
decode double slash octal 06:29
Octal to UTF-8 09:21
Re: Octal to UTF-8 Vinayak 09:35
Strange DOMAIN behavior Alex Ignatov 10:03
Strange DOMAIN behavior David G. Johnston 12:49
Re: Strange DOMAIN behavior Alex Ignatov 14:10
Re: Strange DOMAIN behavior David G. Johnston 14:23
Re: Strange DOMAIN behavior Alex Ignatov 16:42
Re: Strange DOMAIN behavior David G. Johnston 16:50
Re: Strange DOMAIN behavior Alex Ignatov 17:28
How to insert a carriage return and line field between fields in a query JORGE MALDONADO 23:10
Re: How to insert a carriage return and line field between fields in a query David G. Johnston 23:18

July 15, 2015

Thread Author Time
User defined exceptions Alex Ignatov 14:10
Re: User defined exceptions David G. Johnston 14:22
Re: User defined exceptions Pavel Stehule 15:54

July 17, 2015

Thread Author Time
Re: User defined exceptions Alexey Bashtanov 07:34
Re: User defined exceptions Alexey Bashtanov 07:36
Re: User defined exceptions Alex Ignatov 15:31

Aug. 2, 2015

Thread Author Time
Getting the list of foreign keys (for deleting data from the database) Mario Splivalo 15:04
Re: Getting the list of foreign keys (for deleting data from the database) Thomas Kellerer 15:20
Re: Getting the list of foreign keys (for deleting data from the database) Adrian Klaver 15:25
Re: Getting the list of foreign keys (for deleting data from the database) Mario Splivalo 15:44
Re: Re: Getting the list of foreign keys (for deleting data from the database) Mario Splivalo 15:48

Aug. 5, 2015

Thread Author Time
Stored Procedure to return resultset from multiple delete statements. Jason Aleski 03:54
Re: Stored Procedure to return resultset from multiple delete statements. David G. Johnston 05:21

Aug. 6, 2015

Thread Author Time
Sales report by month and item category Richard RK. Klingler 16:16
IP address, subnet query behaves wrong for /32 Richard RK. Klingler 16:47
Re: IP address, subnet query behaves wrong for /32 David G. Johnston 17:01
Re: IP address, subnet query behaves wrong for /32 Adrian Klaver 17:02
Re: IP address, subnet query behaves wrong for /32 David G. Johnston 17:07
Re: IP address, subnet query behaves wrong for /32 Tom Lane 19:10
Re: IP address, subnet query behaves wrong for /32 Richard RK. Klingler 19:35
Re: IP address, subnet query behaves wrong for /32 [email protected] 19:45
Re: IP address, subnet query behaves wrong for /32 Adrian Klaver 19:53
Re: Sales report by month and item category Steve Midgley 21:36

Aug. 17, 2015

Thread Author Time
ERROR: cache lookup failed for type Stuart 00:58
Re: ERROR: cache lookup failed for type Adrian Klaver 01:17
Re: ERROR: cache lookup failed for type Tom Lane 03:16
Re: ERROR: cache lookup failed for type Stuart 03:52
Re: ERROR: cache lookup failed for type Stuart 03:56
Re: ERROR: cache lookup failed for type Adrian Klaver 04:08
Re: ERROR: cache lookup failed for type Stuart 04:46
Re: ERROR: cache lookup failed for type Adrian Klaver 14:11
Re: ERROR: cache lookup failed for type Stuart 14:13
Re: IP address, subnet query behaves wrong for /32 Peter Eisentraut 14:30

Aug. 23, 2015

Thread Author Time
WHERE ... NOT NULL ... OR ... (SELECT...) Mario Splivalo 21:01

Aug. 24, 2015

Thread Author Time
Re: WHERE ... NOT NULL ... OR ... (SELECT...) Dickson S. Guedes 11:34
Re: WHERE ... NOT NULL ... OR ... (SELECT...) Mario Splivalo 12:13

Aug. 25, 2015

Thread Author Time
Reassign permissions Amreen Khan 19:20
Re: Reassign permissions Rene Romero Benavides 20:46

Sept. 11, 2015

Thread Author Time
Showing a cumlative total by month David Nelson 14:46
Re: Showing a cumlative total by month David G. Johnston 15:15
Re: Showing a cumlative total by month David Nelson 15:47
Re: Showing a cumlative total by month David Nelson 15:53
Re: Showing a cumlative total by month David Nelson 18:15

Sept. 15, 2015

Thread Author Time
View not using index gmb 11:56
Re: View not using index Brice André 13:18
Re: View not using index Igor Neyman 13:29

Sept. 16, 2015

Thread Author Time
Re: View not using index gmb 04:45

Sept. 20, 2015

Thread Author Time
Recursive merging of overlapping arrays in a column dave 11:12
Re: Recursive merging of overlapping arrays in a column Rob Sargent 14:00
Re: Recursive merging of overlapping arrays in a column dave 15:57
Re: Recursive merging of overlapping arrays in a column David G. Johnston 17:43
Re: Recursive merging of overlapping arrays in a column dave 19:40

Sept. 21, 2015

Thread Author Time
Re: Recursive merging of overlapping arrays in a column hari.fuchs 09:45
Re: Recursive merging of overlapping arrays in a column dave 12:19

Sept. 22, 2015

Thread Author Time
problem with regexp_matches in nested funcion Isaac Marco Blancas 09:00
problem with regexp_matches in nested funcion David G. Johnston 12:36
Re: problem with regexp_matches in nested funcion Isaac Marco Blancas 15:11

Nov. 6, 2015

Thread Author Time
query option in COPY postgres masyaf 20:22
Re: query option in COPY postgres David G. Johnston 22:02
Re: query option in COPY postgres Adrian Klaver 22:40
Re: query option in COPY postgres masyaf 22:54

Nov. 9, 2015

Thread Author Time
Re: query option in COPY postgres Adrian Klaver 17:13

Nov. 12, 2015

Thread Author Time
Exception Handling in Postgis function ranjitsaurav 07:35

Nov. 15, 2015

Thread Author Time
Re: How would I get rid of trailing blank line? david.paulo 02:17

Nov. 16, 2015

Thread Author Time
Need more info on PL/pgSQL compile listing Michael Moore 23:29

Nov. 17, 2015

Thread Author Time
Re: Need more info on PL/pgSQL compile listing Tom Lane 00:02
Re: Need more info on PL/pgSQL compile listing Michael Moore 00:36

Nov. 19, 2015

Thread Author Time
plpgsql: how to use a composite type varray 卢迪 08:09
Re: plpgsql: how to use a composite type varray Alexander Shereshevsky 09:21
Re: plpgsql: how to use a composite type varray 卢迪 10:23
Re: plpgsql: how to use a composite type varray Alexander Shereshevsky 11:24
Re: plpgsql: how to use a composite type varray 卢迪 11:48
Re: plpgsql: how to use a composite type varray Tom Lane 15:10

Nov. 23, 2015

Thread Author Time
Select values by interval Markus Wolters 16:37
Re: Select values by interval David G. Johnston 16:49
Re: Select values by interval Andreas Kretschmer 17:22
Re: Select values by interval David G. Johnston 17:25
Re: Select values by interval Andreas Kretschmer 17:31
ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 19:38
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 20:13
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 20:23
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 20:36
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 20:39

Nov. 24, 2015

Thread Author Time
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 17:27
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Tom Lane 22:02
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Alvaro Herrera 22:10
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 22:13
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Tom Lane 22:24
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 22:27
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 22:42

Nov. 29, 2015

Thread Author Time
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 20:23

Dec. 2, 2015

Thread Author Time
unique constraint definition within create table Andreas Kretschmer 06:36
Re: unique constraint definition within create table Tom Lane 14:46
Re: unique constraint definition within create table Adrian Klaver 14:59
Re: unique constraint definition within create table David G. Johnston 18:42
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 19:41
Oracle PL/SQL to pg/PSQL conversion documentation. Michael Moore 20:44
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 20:46
Re: Oracle PL/SQL to pg/PSQL conversion documentation. Adrian Klaver 20:47
Re: Oracle PL/SQL to pg/PSQL conversion documentation. Michael Moore 21:02
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 21:06
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 21:15
Re: Oracle PL/SQL to pg/PSQL conversion documentation. Pavel Stehule 21:24
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 21:44
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 21:49
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 21:56
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 22:02
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 22:36
Re: Oracle PL/SQL to pg/PSQL conversion documentation. Michael Moore 22:38
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 22:42
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 23:08
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 23:24
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 23:34
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 23:42
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 23:56

Dec. 3, 2015

Thread Author Time
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 00:14
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 00:34
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 00:39
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 00:51
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 01:21
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 01:46
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 05:03
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 13:00
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 15:33
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 16:33
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 16:48
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 18:29
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 19:26
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 19:38
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 20:11
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 20:55
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 21:08
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 21:15
Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Adrian Klaver 21:19
Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map Sribeiro 21:27

Browse Archives

Prev | Next