Groups
Sign in
Groups
comp.databases.postgresql
Conversations
About
Send feedback
Help
info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Learn more
comp.databases.postgresql
Contact owners and managers
1–30 of 823
Mark all as read
Report group
0 selected
Thomas Morgan
,
John-Paul Stewart
2
Jan 29
TO_CHAR Issue or Designed feature
On 2024-01-29 17:22, Thomas Morgan wrote: > When I issue following > > SELECT to_char(now(),
unread,
TO_CHAR Issue or Designed feature
On 2024-01-29 17:22, Thomas Morgan wrote: > When I issue following > > SELECT to_char(now(),
Jan 29
Robert Welz
, …
paedru fernando
4
8/23/22
ORDER BY in UNION in postgres 7.3.9
On Tuesday, August 5, 2008 at 4:18:48 PM UTC+5:30, Robert Welz wrote: > Laurenz Albe <inv...@
unread,
ORDER BY in UNION in postgres 7.3.9
On Tuesday, August 5, 2008 at 4:18:48 PM UTC+5:30, Robert Welz wrote: > Laurenz Albe <inv...@
8/23/22
Rich Ford
, …
George Neuner
4
5/6/22
Update 500 Million row table
On Wed, 4 May 2022 15:25:51 -0700 (PDT), Andy Wallace <arwal...@gmail.com> wrote: >I'
unread,
Update 500 Million row table
On Wed, 4 May 2022 15:25:51 -0700 (PDT), Andy Wallace <arwal...@gmail.com> wrote: >I'
5/6/22
Rich Ford
,
George Neuner
2
3/11/22
Get explain plan while query running
On Thu, 10 Mar 2022 08:31:23 -0800 (PST), Rich Ford <richf...@gmail.com> wrote: >Is there
unread,
Get explain plan while query running
On Thu, 10 Mar 2022 08:31:23 -0800 (PST), Rich Ford <richf...@gmail.com> wrote: >Is there
3/11/22
Bach Nguyet Tien
,
George Neuner
5
6/30/21
database upgrade on the different binary
On Tue, 29 Jun 2021 16:21:23 -0700 (PDT), Bach Nguyet Tien <mayt...@gmail.com> wrote: >On
unread,
database upgrade on the different binary
On Tue, 29 Jun 2021 16:21:23 -0700 (PDT), Bach Nguyet Tien <mayt...@gmail.com> wrote: >On
6/30/21
shariqtariq
, …
George Neuner
4
1/21/21
Postgresql database behaving unpredictably
On Thu, 21 Jan 2021 04:15:03 +0000 (UTC), Mladen Gogala <mgo...@yahoo.com> wrote: >On Fri,
unread,
Postgresql database behaving unpredictably
On Thu, 21 Jan 2021 04:15:03 +0000 (UTC), Mladen Gogala <mgo...@yahoo.com> wrote: >On Fri,
1/21/21
Alexander Mills
,
Christian Barthel
2
12/26/20
how to use NOTIFY to publish previous and new record
Alexander Mills <alexande...@gmail.com> writes: > Can anyone describe how I might be
unread,
how to use NOTIFY to publish previous and new record
Alexander Mills <alexande...@gmail.com> writes: > Can anyone describe how I might be
12/26/20
kill...@coronavirus.com
,
Edixon Idrogo
2
11/2/20
coronavirus COVID-19
El sábado, 18 de abril de 2020 a las 12:10:58 UTC-4, kill...@coronavirus.com escribió: >
unread,
coronavirus COVID-19
El sábado, 18 de abril de 2020 a las 12:10:58 UTC-4, kill...@coronavirus.com escribió: >
11/2/20
xyz9...@gmail.com
3/28/20
Fight the coronavirus 100% and save LOTS of CASH -- Combattez le coronavirus 100% et économisez BEAUCOUP d'ARGENT
Protect yourself and your loved ones ! KILL the coronavirus right now ! And save LOTS OF CASH New
unread,
Fight the coronavirus 100% and save LOTS of CASH -- Combattez le coronavirus 100% et économisez BEAUCOUP d'ARGENT
Protect yourself and your loved ones ! KILL the coronavirus right now ! And save LOTS OF CASH New
3/28/20
chat...@gmail.com
3/28/20
Postgres geometry type operation error in CrudRepository custom sql query
I have two WGS 84 points p1(lonul, latul) the up left point and p2(lonbr, latbr) the bottom right
unread,
Postgres geometry type operation error in CrudRepository custom sql query
I have two WGS 84 points p1(lonul, latul) the up left point and p2(lonbr, latbr) the bottom right
3/28/20
Bill Gunshannon
, …
Christian Barthel
10
2/22/20
Table with a variable number of elements in a column
alexande...@gmail.com writes: > I have a similar question/answer on StackExchange: >
unread,
Table with a variable number of elements in a column
alexande...@gmail.com writes: > I have a similar question/answer on StackExchange: >
2/22/20
lbo...@gmail.com
,
robamm...@gmail.com
3
12/30/19
building a tree with recursive and export that as json
1 important thing when decoding: if you used to save arrays, then you should use function json_decode
unread,
building a tree with recursive and export that as json
1 important thing when decoding: if you used to save arrays, then you should use function json_decode
12/30/19
Luuk
,
robamm...@gmail.com
9
12/29/19
calculating pi [Re: php and big data and predictive modelling...]
On Sunday, December 29, 2019 at 11:15:01 AM UTC+2, Luuk wrote: > On 28-12-2019 18:40, robamman2019
unread,
calculating pi [Re: php and big data and predictive modelling...]
On Sunday, December 29, 2019 at 11:15:01 AM UTC+2, Luuk wrote: > On 28-12-2019 18:40, robamman2019
12/29/19
Pankaj Jangid
,
Christian Barthel
3
10/4/19
Nice article on PostgreSQL 12 Generated Columns
Christian Barthel <b...@online.de> writes: > Pankaj Jangid <pankaj...@gmail.com>
unread,
Nice article on PostgreSQL 12 Generated Columns
Christian Barthel <b...@online.de> writes: > Pankaj Jangid <pankaj...@gmail.com>
10/4/19
Pankaj Jangid
, …
Mladen Gogala
6
9/22/19
Application architecture for multi-site manufacturing
Mladen Gogala <gogala...@gmail.com> writes: > You should be aware of the CAP theorem
unread,
Application architecture for multi-site manufacturing
Mladen Gogala <gogala...@gmail.com> writes: > You should be aware of the CAP theorem
9/22/19
jim....@branr.com
,
Matthew Woodcraft
3
8/7/19
psql.exe after new installation
In article <23107516-8be5-4c83...@googlegroups.com>, <jim....@branr.com>
unread,
psql.exe after new installation
In article <23107516-8be5-4c83...@googlegroups.com>, <jim....@branr.com>
8/7/19
inve...@gmail.com
,
Laurenz Albe
4
3/20/19
PostgreSQL 10.3 leaving "exiting" (defunct) processes on AIX platform
On Wed, 20 Mar 2019 10:53:07 -0700, inverasln wrote: > The question now is to how to get that to
unread,
PostgreSQL 10.3 leaving "exiting" (defunct) processes on AIX platform
On Wed, 20 Mar 2019 10:53:07 -0700, inverasln wrote: > The question now is to how to get that to
3/20/19
Mladen Gogala
, …
Laurenz Albe
5
3/20/19
Partition pruning in pg11
On Wed, 20 Mar 2019 05:27:52 +0000, Laurenz Albe wrote: > On Wed, 20 Mar 2019 02:07:44 +0000,
unread,
Partition pruning in pg11
On Wed, 20 Mar 2019 05:27:52 +0000, Laurenz Albe wrote: > On Wed, 20 Mar 2019 02:07:44 +0000,
3/20/19
Unto Sten
, …
Laurenz Albe
5
10/26/18
plpgsql function SQL injection vulnerability?
George Neuner <gneu...@comcast.net> wrote: > This particular use is safe: the 're'
unread,
plpgsql function SQL injection vulnerability?
George Neuner <gneu...@comcast.net> wrote: > This particular use is safe: the 're'
10/26/18
lbo...@gmail.com
,
Robert Klemme
2
10/6/18
issue with UPDATE
On 05.10.2018 18:44, lbo...@gmail.com wrote: > I'm stuck with an UPDATE, probably I'm
unread,
issue with UPDATE
On 05.10.2018 18:44, lbo...@gmail.com wrote: > I'm stuck with an UPDATE, probably I'm
10/6/18
Alf Normann Klausen
,
Laurenz Albe
3
10/2/18
archiver problem
mandag 1. oktober 2018 18.19.52 UTC+2 skrev Laurenz Albe følgende: > > You must have removed
unread,
archiver problem
mandag 1. oktober 2018 18.19.52 UTC+2 skrev Laurenz Albe følgende: > > You must have removed
10/2/18
Sachin Singh
, …
Dimitri Fontaine
6
8/2/18
How to support more than 1200 client connections
Sachin Singh <nots...@gmail.com> writes: > With session pool_mode out of memory error
unread,
How to support more than 1200 client connections
Sachin Singh <nots...@gmail.com> writes: > With session pool_mode out of memory error
8/2/18
ajat.pr...@gmail.com
,
Laurenz Albe
3
5/25/18
Query regarding psql command
Thank you Laurenz for the help 🙂
unread,
Query regarding psql command
Thank you Laurenz for the help 🙂
5/25/18
bjorn.d...@gmail.com
, …
Matthew Woodcraft
4
5/23/18
create user mapping for user_in_postgredb server my_remote_ms_server options (username 'domain\myuser', password 'keepsecret');
any example you can share how the postgre-sql-file should look like that is called by shell script?
unread,
create user mapping for user_in_postgredb server my_remote_ms_server options (username 'domain\myuser', password 'keepsecret');
any example you can share how the postgre-sql-file should look like that is called by shell script?
5/23/18
inve...@gmail.com
,
Laurenz Albe
2
5/4/18
How to see values passed to a query
On Wed, 02 May 2018 13:19:01 -0700, inverasln wrote: > Postgres 9.6.1 > > I have an insert
unread,
How to see values passed to a query
On Wed, 02 May 2018 13:19:01 -0700, inverasln wrote: > Postgres 9.6.1 > > I have an insert
5/4/18
luca.b...@gmail.com
,
Dimitri Fontaine
2
5/1/18
lateral query with dynamic column value
luca.b...@gmail.com writes: > I need an help with lateral subqueries: > > is it possible
unread,
lateral query with dynamic column value
luca.b...@gmail.com writes: > I need an help with lateral subqueries: > > is it possible
5/1/18
lordl...@gmail.com
,
Dimitri Fontaine
3
4/19/18
Postgres 9.6 - ltree extension - (re)build a tree on a table
Il giorno martedì 17 aprile 2018 23:31:01 UTC+2, Dimitri Fontaine ha scritto: > lordluke80@gmail.
unread,
Postgres 9.6 - ltree extension - (re)build a tree on a table
Il giorno martedì 17 aprile 2018 23:31:01 UTC+2, Dimitri Fontaine ha scritto: > lordluke80@gmail.
4/19/18
Majid Lotfi
,
Robert Klemme
2
4/9/18
all types returned in result are strings
On 09.04.2018 19:11, Majid Lotfi wrote: > Hi, I am using postgres from ruby using pg gem, I did a
unread,
all types returned in result are strings
On 09.04.2018 19:11, Majid Lotfi wrote: > Hi, I am using postgres from ruby using pg gem, I did a
4/9/18
forough m
,
Laurenz Albe
12
3/10/18
Update Json column
On Thursday, March 8, 2018 at 3:06:23 PM UTC+3:30, Laurenz Albe wrote: > On Wed, 07 Mar 2018 00:09
unread,
Update Json column
On Thursday, March 8, 2018 at 3:06:23 PM UTC+3:30, Laurenz Albe wrote: > On Wed, 07 Mar 2018 00:09
3/10/18
Peter Percival
,
Laurenz Albe
3
2/5/18
Password?
Peter Percival wrote: >> When I installed PostgreSQL it asked me to supply a password, which I
unread,
Password?
Peter Percival wrote: >> When I installed PostgreSQL it asked me to supply a password, which I
2/5/18