foo> - Search results in mailing lists
Mailing lists >> pgsql-admin >> Thread
2025-04-29 05:06:21 | Re: Adding New Column with default value. (Ron Johnson)
foo ADD COLUMN bar BIGINT NOT NULL DEFAULT 0; UPDATE foo SET bar = 0 WHERE
Mailing lists >> pgsql-admin >> Thread
2025-02-18 21:24:26 | Feature Request: multithreaded reindexdb --concurrently of a single table (Ron Johnson)
foo INFO: index "public.foo_pkey" was reindexed INFO: index "public.i_foo_2" was reindexed INFO: index
Mailing lists >> pgsql-admin >> Thread
2024-08-30 03:14:28 | Re: Alternate Datafile Location (Ron Johnson)
foo;" handles all that for you. If you *really* want your user databases spread all over
Mailing lists >> pgsql-admin >> Thread >> Search in thread (2)
2024-08-27 13:04:01 | Re: Password Change Mandatory during First Login (Muhammad Waqas)
foo LOGIN PASSWORD 'foo' VALID UNTIL '2021-11-22'; but password authentication in pg_hba.conf
Mailing lists >> pgsql-admin >> Thread
2024-06-29 22:34:52 | Re: Strange "permission denied" errors on pg_restore (Ron Johnson)
foo") are owned by the service account fis_tap. postgres=# select oid postgres=# from pg_roles
Mailing lists >> pgsql-admin >> Thread >> Search in thread (2)
2024-06-18 22:02:13 | RE: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER (Vitale, Anthony, Sony Music)
foo to be bar. \set ECHO all \set ON_ERROR_STOP on DO $proc$ declare
Mailing lists >> pgsql-admin >> Thread
2024-06-13 12:52:18 | Get PG primary version without substring manipulation? (Ron Johnson)
foo.example.com pg_config --version PostgreSQL 9.6.24 $ ssh foo.example.com psql --version psql
Mailing lists >> pgsql-admin >> Thread >> Search in thread (2)
2024-06-07 03:40:23 | Re: How to find the view modified date and time and user name (M Sarwar)
foo last Thursday at 14:30. Let's check the log file to see what
Mailing lists >> pgsql-admin >> Thread
2024-02-08 10:37:45 | Re: Need help to implement Primary Key. (Thomas Kellerer)
foo add id bigint generated always as identity not null; Once that has finished (which
Mailing lists >> pgsql-admin >> Thread
2024-01-23 16:30:37 | Re: pg_dumpall and owner of the extension (Tom Lane)
owner; CREATE EXTENSION foo; RESET ROLE; but that would fail for you. regards, tom lane
Mailing lists >> pgsql-admin >> Thread
2023-12-18 19:28:05 | Re: pg_ctl only allows 12 parameters? (Tom Lane)
foo -o "whatever" pg_ctl: too many command-line arguments (first is "foo") Try "pg_ctl --help
Mailing lists >> pgsql-admin >> Thread
2023-11-16 16:32:26 | Index file is growing when I drop a table. Why? (Ron Johnson)
foo=# select * from pg_class where oid = 41533; -[ RECORD 1 ]-------+---------- oid | 41533 relname | i_bar_su1 relnamespace
Mailing lists >> pgsql-admin >> Thread
2023-08-08 22:47:27 | ignore_system_indexes=on no help for missing/corrupt pg_class_oid_index? (Jerry Sievers)
foo did the expected for us $sometime before. I believe that index 2662::regclass is probably
Mailing lists >> pgsql-admin >> Thread
2023-06-22 20:54:54 | Re: GENERATE AS (Ron)
foo=# begin; BEGIN foo=*# insert into bar (f1, f2) values (3, 'jj'); INSERT 0 1 foo=*# insert
Mailing lists >> pgsql-admin >> Thread >> Search in thread (3)
2023-05-19 16:47:46 | RE: Vacuum Tuning Question (Murthy Nunna)
foo.freez::int, age(datfrozenxid) AS txns, datname FROM pg_database d JOIN (SELECT setting