n/blogs/pgblog/2017.html#June_2_2017
>
> --
> Bruce Momjian http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + As you are, so once was I. As I am, so you will be. +
> + Ancient Roman grave inscription +
-
connected to the original database which is not good.
True and I've always thought of it as a possible misfeature of psql that
it scans .psqlrc only once.
> Cheers,
> Steve
>
> On Fri, May 6, 2016 at 11:42 AM, Jerry Sievers wrote:
>
> Peter Eisentraut writes:
>
good questions. I don't really like the proposed answers,
> because that could cause confusion in practical use.
>
> --
> Peter Eisentraut http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Jerry Sievers
Postgr
gical_output.so
/usr/include
/usr/include/postgresql
/usr/include/postgresql/pglogical_output
/usr/include/postgresql/pglogical_output/compat.h
^^
/usr/include/postgresql/pglogical_output/hooks.h
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consult..
ated
> by the superuser when it gets created in the log (which again is subject
> to auditing, alerts, etc.)
>
> Ultimately I would also like to see a general hook available which would
> fire for all changes to GUC settings, but I think this one is still very
> useful as
Jerry Sievers writes:
> Hackers;
>
> I spotted this after doing some owner reassignments and then dropping
> the old roles.
>
> It looks like using either reassign or alter type owner to, the pg_class
> entry stays with old rolID.
>
> Then if we drop that old
--
266324 | 10
(1 row)
COMMIT
pg_dump: WARNING: owner of table "foo" appears to be invalid
psql:q:39: NOTICE: drop cascades to type foo
DROP SCHEMA
$ $
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consult...@
that grew up with Facebook, watches Japanese seizure
> robot anime, and has the attention span of a gnat.
> I'm not that user., "Tyler Riddle"
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consult...@comcast.net
p: 312.241.7800
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
client_min_messages
-
notice
(1 row)
create extension pgq_node;
CREATE EXTENSION
show client_min_messages;
client_min_messages
-
notice
(1 row)
psql (9.3.5, server 9.3.4)
You are now connected to database "postgres" as user "jsievers".
drop database f
es = 'more_libs,%'
At conclusion of file processing, stripping off an unnecessary delimiter
at beginning or end of string would be a nice asthetic feature and/or
might be required depending on whether an empty list value is legal.
Thanks
> --
> Álvaro Herrera
ed_preload_libraries += auto_explain
Would do the trick.
I've never heard this mentioned before so presume not many have
contemplated this.
Comments?
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consult...@comcast.net
p: 312.241.7800
--
Sent via pgsql-hackers mailing list (pgsql-h
is if it's not risky.
Comments?
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consult...@comcast.net
p: 312.241.7800
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
some merit, but the weak
> spot there is how do you define the search order? Or are you planning
> to just cross your fingers and hope it doesn't matter too much?
>
> regards, tom lane
>
--
Jerry Sievers
e: jerry.siev...@comcast.net
p: 312.241.7
Alvaro Herrera writes:
> Bruce Momjian wrote:
>
>> On Thu, Feb 13, 2014 at 08:24:27PM -0600, Jerry Sievers wrote:
>> > Greetings Hackers.
>> >
>> > I'm aware of how a pg_hba.conf file can refer to other files for
>> > including @lists of use
discussed.
Has been proposed, discussed and voted down? Or never mentioned?
Thx
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consult...@comcast.net
p: 312.241.7800
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your sub
nual catalog updates to change a varchar(N) to text and
whoopsie! That may be one explanation.
> Bruce Momjian http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + It's impossible for everything to be true. +
>
>
> --
_
>
> [cid]
>
> Jim Buttafuoco
> j...@contacttelecom.com
> 603-647-7170 ext. - Office
> 603-490-3409 - Cell
> jimbuttafuoco - Skype
>
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consult...@comcast.
Andrew Dunstan writes:
> On 07/25/2011 10:31 PM, Jerry Sievers wrote:
>> Hackers;
>>
>> I just noticed that somewhere between 8.2 and 8.4, an exception is
>> raised trying to alter table ONLY some_partition_parent ADD CHECK
>> (foo).
>>
>
>
> 8.4
compelling example of why it might be useful to allow
check constraints added to only a partition parent.
Comments?
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consult...@comcast.net
p: 305.321.1144
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org
rod master.
One in real-time mode and the others lagged.
Thanks all!
--
Jerry Sievers
Postgres DBA/Development Consulting
e: gsiever...@comcast.net
p: 305.321.1144
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
t; EnterpriseDB http://www.enterprisedb.com
>
>
>
> ---(end of broadcast)---
> TIP 1: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to [EMAIL PROTECTED] so that your
>
21 matches
Mail list logo
