agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedinvalid reference to FROM-clause entry for table
2024-10-03 22:14 UTC Sam Stearns <sam.stearns@dat.com>
` Re: invalid reference to FROM-clause entry for table
2024-10-03 22:21 UTC Tom Lane <tgl@sss.pgh.pa.us>
` RE: invalid reference to FROM-clause entry for table
2024-10-04 13:27 UTC Adw Spe <h.3stnc4kdbem6q_8p@outlook.com>
` Re: invalid reference to FROM-clause entry for table
2024-10-04 15:12 UTC Sam Stearns <sam.stearns@dat.com>
` Re: invalid reference to FROM-clause entry for table
2024-10-05 02:35 UTC David G. Johnston <david.g.johnston@gmail.com>
[5+ messages in thread]
PostgreSQL implicitly double-quoting identifier name with umlaut
2024-09-13 23:06 UTC Michael Downey <mdowney@esri.com>
` Re: PostgreSQL implicitly double-quoting identifier name with umlaut
2024-09-13 23:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
` RE: PostgreSQL implicitly double-quoting identifier name with umlaut
2024-09-13 23:33 UTC Michael Downey <mdowney@esri.com>
[3+ messages in thread]
Powerfailure caused a reduction in INSERT performance of version 12 database.
2024-08-19 14:33 UTC Frank Komsic <komsicf@shoeicanada.com>
` Re: Powerfailure caused a reduction in INSERT performance of version 12 database.
2024-08-19 14:49 UTC Steve Midgley <science@misuse.org>
` Re: Powerfailure caused a reduction in INSERT performance of version 12 database.
2024-08-19 16:07 UTC Frank Komsic <komsicf@shoeicanada.com>
` Re: Powerfailure caused a reduction in INSERT performance of version 12 database.
2024-08-19 16:27 UTC Frank Komsic <komsicf@shoeicanada.com>
` Re: Powerfailure caused a reduction in INSERT performance of version 12 database.
2024-08-19 16:31 UTC Frank Komsic <komsicf@shoeicanada.com>
` Re: Powerfailure caused a reduction in INSERT performance of version 12 database.
2024-08-19 16:37 UTC Steve Midgley <science@misuse.org>
` Re: Powerfailure caused a reduction in INSERT performance of version 12 database.
2024-08-19 17:16 UTC Frank Komsic <komsicf@shoeicanada.com>
` Re: Powerfailure caused a reduction in INSERT performance of version 12 database.
2024-09-03 22:14 UTC Frank Komsic <komsicf@shoeicanada.com>
[8+ messages in thread]
ORDER BY elements in ARRAY
2024-08-27 11:22 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: ORDER BY elements in ARRAY
2024-08-27 11:44 UTC Guillaume Lelarge <guillaume@lelarge.info>
` Re: ORDER BY elements in ARRAY
2024-08-27 12:39 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: ORDER BY elements in ARRAY
2024-08-27 14:59 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: ORDER BY elements in ARRAY
2024-08-27 16:03 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: ORDER BY elements in ARRAY
2024-08-27 16:27 UTC Andreas Joseph Krogh <andreas@visena.com>
[6+ messages in thread]
object mapping for json/jsonb columns
2024-08-27 12:28 UTC Jan Bernitt <jaanbernitt@gmail.com>
` Re: object mapping for json/jsonb columns
2024-08-27 15:34 UTC Steve Midgley <science@misuse.org>
` Re: object mapping for json/jsonb columns
2024-08-27 16:05 UTC Jan Bernitt <jaanbernitt@gmail.com>
` object mapping for json/jsonb columns
2024-08-27 16:17 UTC David G. Johnston <david.g.johnston@gmail.com>
[4+ messages in thread]
Using replication to upgrade db from 12 to 16
2024-07-20 17:01 UTC Frank Komsic <komsicf@shoeicanada.com>
` Re: Using replication to upgrade db from 12 to 16
2024-07-20 17:45 UTC Kashif Zeeshan <kashi.zeeshan@gmail.com>
` Re: Using replication to upgrade db from 12 to 16
2024-07-20 17:59 UTC Frank Komsic <komsicf@shoeicanada.com>
` Re: Using replication to upgrade db from 12 to 16
2024-07-20 18:09 UTC Kashif Zeeshan <kashi.zeeshan@gmail.com>
` Re: Using replication to upgrade db from 12 to 16
2024-07-22 17:00 UTC Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
[5+ messages in thread]
SQL statements error in pgsql 16 but not in pgsql 12
2024-07-15 22:57 UTC Frank Komsic <komsicf@shoeicanada.com>
` Re: SQL statements error in pgsql 16 but not in pgsql 12
2024-07-15 23:23 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: SQL statements error in pgsql 16 but not in pgsql 12
2024-07-16 14:56 UTC Bharani SV-forum <esteembsv-forum@yahoo.com>
` Re: SQL statements error in pgsql 16 but not in pgsql 12
2024-07-16 15:00 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: SQL statements error in pgsql 16 but not in pgsql 12
2024-07-16 18:01 UTC Frank Komsic <komsicf@shoeicanada.com>
` Re: SQL statements error in pgsql 16 but not in pgsql 12
2024-07-18 14:50 UTC Bharani SV-forum <esteembsv-forum@yahoo.com>
` Re: SQL statements error in pgsql 16 but not in pgsql 12
2024-07-18 14:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
[7+ messages in thread]
Trick to create alias/mirror table
2024-07-08 11:27 UTC intmail01 <intmail01@gmail.com>
` Re: Trick to create alias/mirror table
2024-07-08 11:55 UTC Kashif Zeeshan <kashi.zeeshan@gmail.com>
` Re: Trick to create alias/mirror table
2024-07-08 12:09 UTC shammat@gmx.net
` Re: Trick to create alias/mirror table
2024-07-08 12:17 UTC Achilleas Mantzios - cloud <a.mantzios@cloud.gatewaynet.com>
` Re: Trick to create alias/mirror table
2024-07-08 13:04 UTC intmail01 <intmail01@gmail.com>
` Re: Trick to create alias/mirror table
2024-07-08 13:11 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Trick to create alias/mirror table
2024-07-08 13:29 UTC shammat@gmx.net
` Re: Trick to create alias/mirror table
2024-07-08 13:44 UTC shammat@gmx.net
[8+ messages in thread]
struggling with GRANT while upgrading from 13 to 16
2024-06-25 17:04 UTC Axel Rau <Axel.Rau@Chaos1.DE>
` Re: struggling with GRANT while upgrading from 13 to 16
2024-06-25 17:28 UTC Steve Midgley <science@misuse.org>
` Re: struggling with GRANT while upgrading from 13 to 16
2024-06-25 17:38 UTC Axel Rau <Axel.Rau@Chaos1.DE>
` Re: struggling with GRANT while upgrading from 13 to 16
2024-06-25 18:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: struggling with GRANT while upgrading from 13 to 16
2024-06-26 11:01 UTC Axel Rau <Axel.Rau@Chaos1.DE>
` Re: struggling with GRANT while upgrading from 13 to 16
2024-06-26 11:08 UTC Axel Rau <Axel.Rau@Chaos1.DE>
` [RESOLVED] Re: struggling with GRANT while upgrading from 13 to 16
2024-06-26 13:38 UTC Axel Rau <Axel.Rau@Chaos1.DE>
[7+ messages in thread]
Postgres fine tuning
2024-05-31 05:42 UTC Kanimozhi Manoharan <kanithilak@gmail.com>
` Re: Postgres fine tuning
2024-06-03 05:26 UTC Kanimozhi Manoharan <kanithilak@gmail.com>
[2+ messages in thread]
Pgadmin 4 cannot add or modify line in a view
2024-05-30 14:26 UTC intmail01 <intmail01@gmail.com>
` Re: Pgadmin 4 cannot add or modify line in a view
2024-05-30 14:52 UTC Usman Khan <umk555@gmail.com>
` Re: Pgadmin 4 cannot add or modify line in a view
2024-05-30 18:01 UTC intmail01 <intmail01@gmail.com>
` Re: Pgadmin 4 cannot add or modify line in a view
2024-05-30 19:07 UTC Usman Khan <umk555@gmail.com>
` Re: Pgadmin 4 cannot add or modify line in a view
2024-05-30 21:40 UTC Steve Midgley <science@misuse.org>
` Re: Pgadmin 4 cannot add or modify line in a view
2024-05-31 02:05 UTC Amitabh Kant <amitabhkant@gmail.com>
` Re: Pgadmin 4 cannot add or modify line in a view
2024-05-31 06:21 UTC Muhammad Ikram <mmikram@gmail.com>
` Re: Pgadmin 4 cannot add or modify line in a view
2024-05-31 15:33 UTC intmail01 <intmail01@gmail.com>
[8+ messages in thread]
Small table selection extremely slow!
2024-05-14 11:11 UTC Bo Guo <bo.guo@gisticinc.com>
` Re: Small table selection extremely slow!
2024-05-14 11:16 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Small table selection extremely slow!
2024-05-14 11:26 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Small table selection extremely slow!
2024-05-14 11:50 UTC Bo Guo <bo.guo@gisticinc.com>
` Re: Small table selection extremely slow!
2024-05-14 12:10 UTC Shane Borden <sborden76@gmail.com>
` Re: Small table selection extremely slow!
2024-05-14 12:15 UTC Bo Guo <bo.guo@gisticinc.com>
` Re: Small table selection extremely slow!
2024-05-14 13:36 UTC Bo Guo <bo.guo@gisticinc.com>
[7+ messages in thread]
How to pass arguments in postgres to sql scripts.
2024-04-27 13:03 UTC kunwar singh <krishsingh.111@gmail.com>
` Re: How to pass arguments in postgres to sql scripts.
2024-04-27 13:13 UTC Samed YILDIRIM <samed@reddoc.net>
` Re: How to pass arguments in postgres to sql scripts.
2024-05-03 16:43 UTC Feike Steenbergen <feikesteenbergen@gmail.com>
[3+ messages in thread]
One parent record with 3 possible child records
2024-05-01 23:08 UTC JORGE MALDONADO <jorgemal1960@gmail.com>
` Re: One parent record with 3 possible child records
2024-05-01 23:24 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: One parent record with 3 possible child records
2024-05-02 13:33 UTC Sanjay Minni <sanjay@crestadvice.com>
` Re: One parent record with 3 possible child records
2024-05-02 13:37 UTC Rob Sargent <robjsargent@gmail.com>
` Re: One parent record with 3 possible child records
2024-05-02 14:02 UTC David G. Johnston <david.g.johnston@gmail.com>
` One parent record with 3 possible child records
2024-05-02 14:37 UTC Wetmore, Matthew (CTR) <Matthew.Wetmore@evernorth.com>
` Re: One parent record with 3 possible child records
2024-05-02 15:12 UTC Sanjay Minni <sanjay.minni@gmail.com>
` Re: One parent record with 3 possible child records
2024-05-02 18:28 UTC Rob Sargent <robjsargent@gmail.com>
` Re: One parent record with 3 possible child records
2024-05-02 22:47 UTC Nic Mitchell <nm728@cam.ac.uk>
[9+ messages in thread]
Trigger
2000-07-14 14:11 UTC Carolyn Lu Wong <carolyn@kss.net.au>
` Re: Trigger
2000-07-14 15:49 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Trigger
2000-09-06 10:24 UTC Mike Baroukh <mbaroukh@i-panema.fr>
` Re: Trigger
2000-09-06 12:18 UTC Chris Ryan <chris@greatbridge.com>
` Re: Trigger
2000-09-06 12:40 UTC Chris Ryan <chris@greatbridge.com>
` Trigger
2000-09-06 20:27 UTC Craig May <craig.may@s2.enthdimension.com.au>
` Re: Trigger
2003-04-10 16:07 UTC A.Bhuvaneswaran <bhuvansql@myrealbox.com>
` Re: Trigger
2003-04-10 16:12 UTC Franco Bruno Borghesi <franco@akyasociados.com.ar>
` Re: Trigger
2003-04-10 17:54 UTC Richard Huxton <dev@archonet.com>
` Trigger
2005-02-16 13:44 UTC Eugen Gass <gass@intend.de>
` Re: Trigger
2005-02-16 20:53 UTC Pavel Rabel <pavel@sajt.cz>
` Re: Trigger
2005-02-16 23:47 UTC Michael Fuhr <mike@fuhr.org>
` Re: [SQL] Trigger
2005-02-17 09:29 UTC Eugen Gass <gass@intend.de>
` Trigger
2024-04-10 14:58 UTC Stefan Sturm <mailling@anrath.info>
[14+ messages in thread]
Function can not use the 'NEW' variable as a direct parameter inside trigger function?
2024-04-05 17:17 UTC intmail01 <intmail01@gmail.com>
` Re: Function can not use the 'NEW' variable as a direct parameter inside trigger function?
2024-04-05 19:21 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Help with error date_trunc() function.
2024-04-05 16:23 UTC Miguel Angel Prada <mprada@hoplasoftware.com>
` Re: Help with error date_trunc() function.
2024-04-05 16:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
help with a particular multi-table query
2024-04-01 22:03 UTC James Cloos <cloos@jhcloos.com>
` Re: help with a particular multi-table query
2024-04-01 23:13 UTC Steve Midgley <science@misuse.org>
` Re: help with a particular multi-table query
2024-04-04 10:18 UTC Samed YILDIRIM <samed@reddoc.net>
[3+ messages in thread]
postgres is slow on windows
2024-04-02 09:19 UTC Nazneen Mulani <naz18mulani@gmail.com>
` Re: postgres is slow on windows
2024-04-02 10:37 UTC Jayadevan M <maymala.jayadevan@gmail.com>
` Re: postgres is slow on windows
2024-04-04 09:17 UTC Samed YILDIRIM <samed@reddoc.net>
[3+ messages in thread]
xml build a list of all elements
2024-03-26 21:04 UTC ft <ml@ft-c.de>
` Re: xml build a list of all elements
2024-03-26 22:27 UTC Steve Midgley <science@misuse.org>
[2+ messages in thread]
Get error when calling function that returns a table
2024-03-25 15:43 UTC Russell Rose | Passfield Data Systems <russellrose@passfield.co.uk>
` Re: Get error when calling function that returns a table
2024-03-25 16:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
decode/encode backslash to base64
2024-03-24 21:29 UTC ft <ftimmer@ft-c.de>
` decode/encode backslash to base64
2024-03-24 21:31 UTC ft <ml@ft-c.de>
` Re: decode/encode backslash to base64
2024-03-25 13:48 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
UPDATE with AND clarification
2024-03-22 11:36 UTC Jamie Thompson <jthompson.neuk@gmail.com>
` Re: UPDATE with AND clarification
2024-03-22 13:35 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: UPDATE with AND clarification
2024-03-22 19:51 UTC Jamie Thompson <jthompson.neuk@gmail.com>
[3+ messages in thread]
Cursor with hold for select takes too long
2024-03-22 16:50 UTC Bindra Bambharoliya <bindra.bambharoliya@gmail.com>
` Re: Cursor with hold for select takes too long
2024-03-22 17:39 UTC Erik Brandsberg <erik@heimdalldata.com>
` Re: Cursor with hold for select takes too long
2024-03-22 17:47 UTC Bindra Bambharoliya <bindra.bambharoliya@gmail.com>
` Re: Cursor with hold for select takes too long
2024-03-22 17:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
How to choose table in SELECT clause without schema qualifier or 'set local'
2024-03-22 07:11 UTC intmail01 <intmail01@gmail.com>
` Re: How to choose table in SELECT clause without schema qualifier or 'set local'
2024-03-22 13:28 UTC David G. Johnston <david.g.johnston@gmail.com>
[2+ messages in thread]
[next (older)]
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox