Re: [GENERAL] Build in function to verify email addresses

- Original Message - From: "Nick Dro" To: pgsql-general@postgresql.org Sent: Thursday, November 16, 2017 2:56:42 AM Subject: [GENERAL] Build in function to verify email addresses I beleieve that every information system has the needs to send emails.

Re: [GENERAL] Shared Constants in PLPGSQL

- Original Message - > From: "Tim Uckun" > To: "pgsql-general" > Sent: Tuesday, August 1, 2017 5:56:02 AM > Subject: [GENERAL] Shared Constants in PLPGSQL > > What's the best way to deal with global constants in PLPGSQL. Currently I > am

Re: [GENERAL] Limiting DB access by role after initial connection?

- Original Message - > From: "Ken Tanzer" > To: "PG-General Mailing List" > Sent: Friday, June 9, 2017 1:37:34 AM > Subject: [GENERAL] Limiting DB access by role after initial connection? > > ...I'm working with an organization with

Re: [GENERAL] Why does this hot standy archive_command work

ct: Re: [GENERAL] Why does this hot standy archive_command work > > Steve Atkins <st...@blighty.com> writes: > > >> On Jan 20, 2017, at 7:03 PM, bto...@computer.org <bto...@broadstripe.net> > >> wrote: > >> > >> While learning a bit about basic h

[GENERAL] Why does this hot standy archive_command work

While learning a bit about basic hot standby configuration, I was reviewing an article that used these parameters wal_level = 'hot_standby' archive_mode = on archive_command = 'cd .' max_wal_senders = 1 hot_standby = on How or why that particular archive_command actually works (... and it does

Re: [GENERAL] efficiently migrating 'old' data from one table to another

- Original Message - > From: "Jonathan Vanasco" > To: "pgsql-general general" > Sent: Thursday, January 12, 2017 3:06:14 PM > Subject: [GENERAL] efficiently migrating 'old' data from one table to another > > I'm just wondering if

Re: [GENERAL] LYDB: Feasible to use PG roles instead of application-level security?

- Original Message - > From: "Alban Hertroys" > To: "Guyren Howe" > Cc: "pgsql-general" > Sent: Friday, December 30, 2016 6:23:27 AM > Subject: Re: [GENERAL] LYDB: Feasible to use PG roles instead of >

Re: [GENERAL] Generating sample data

- Original Message - > From: "Rich Shepard" > To: pgsql-general@postgresql.org > Sent: Tuesday, December 27, 2016 7:23:46 PM > Subject: Re: [GENERAL] Generating sample data > > On Tue, 27 Dec 2016, Adrian Klaver wrote: > > > As it happens there is a Python

Re: [GENERAL] About the MONEY type

- Original Message - > From: "Merlin Moncure" > To: "Raymond O'Donnell" > Cc: "Thomas Kellerer" , "PostgreSQL General" > > Sent: Wednesday, November 30, 2016 11:41:39 AM > Subject: Re: [GENERAL] About

Re: [GENERAL] select function alias

- Original Message - > From: "Howard News" > Sent: Wednesday, November 30, 2016 9:03:28 AM > Subject: Re: [GENERAL] select function alias > On 30/11/2016 13:42, Timoteo Blanco wrote: > > I've a series of timestamp columns I'd like to alias in select

Re: [GENERAL] Invoice Table Design

- Original Message - > From: "rob" > To: pgsql-general@postgresql.org > Sent: Tuesday, November 29, 2016 3:45:21 AM > Subject: Re: [GENERAL] Invoice Table Design > > Hi Rich, > > thanks for the response -- going from Mongo to Postgres does require the > kind of

Re: [GENERAL] dumping table contents in a sensible order

- Original Message - > From: "Chris Withers" > Sent: Tuesday, November 15, 2016 5:56:11 PM > > I have a database that I want to dump three tables from, for use in > development. They form a subset of the data, so I was dumping like this: > > pg_dump thedatabase

Re: [GENERAL] What is the best thing to do with PUBLIC schema in Postgresql database

- Original Message - > From: "Patricia Hu" > Sent: Friday, November 4, 2016 9:58:10 AM > > Since it could potentially be a security loop hole. So far the action taken > to address it falls into these two categories: > > drop the PUBLIC schema altogether. ...