[GENERAL] ALTER TABLE and vacuum

Do I need to vacuum after an alter table command? Does it matter if there is a default or if we accept NULLs for the new field? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Identify ldap connections in logfiles

Is there a way to identify ldap connections to pgsql 9.3 from log files? Thanks, Rick -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] overwrite column data select - Postgres 9.2

I was hopping that in a SELECT I could replace the data from the email column to something else... maybe email = name_first + name_last? Is that possible? I can't overwrite the data into that column... that has to be done by the select (if possible) SELECT , , ..., name_first || ' ' ||

Re: [GENERAL] Unable to connect to Postgresql

On 4/10/2017 2:23 PM, John Iliffe wrote: On Monday 10 April 2017 11:53:35 Daniel Verite wrote: John Iliffe wrote: Given that you set two directories: /tmp and /var/pgsql, I would think you can let the other apps use /tmp as before and have only Apache use /var/pgsql ? Yes, I will

Re: [GENERAL] PostgreSQL with PowerBuilder, and Identity keys (serials)

On 8/5/2017 6:06 PM, Dan Cooperstock at Software4Nonprofits wrote: (I wish Postgres had a web-based community board, rather than just this mailing list with no history available!) I will post it to Appeon as an actual bug if I get stuck. Have you looked here?