Yes, that it surely one option but is there any grant that can be made on a
function so that it can only be called from within the same schema? Even
then it is a bit cumbersome
On Tue, Nov 20, 2018 at 9:12 AM Thomas Kellerer wrote:
> Nicklas Karlsson schrieb am 20.11.2018 um 07:32:
> > Are there
Hello!
I try write playbook for install postgresql.
When i want get link repo i go to https://www.postgresql.org/download/ and
choose OS version, PostgreSQL version - get link repo (for example -
https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-6-x86_64/pgdg-redhat11-11-2.noarch.rpm
)
Nicklas Karlsson schrieb am 20.11.2018 um 07:32:
> Are there any plans for including Oracle-style packages with
> namespace/visibility support at some point or is it just "use
> schemas"? I could even live without package-state but I find it
> frustrating with the namespace pollution when the appli
On Mon, 2018-11-19 at 17:46 -0800, Wyatt Alt wrote:
> I've been struggling to eliminate replication lag on a Postgres 9.6.6
> instance on Amazon RDS. I believe the lag is caused by early cleanup
> conflicts from vacuums on the master, because I can reliably resolve
> it by killing long-running quer
Hi,
(sorry if this has been asked before, "package" gives a lot of hits for
RPMs etc, I couldn't find much on this after 2005 in the lists)
Are there any plans for including Oracle-style packages with
namespace/visibility support at some point or is it just "use schemas"? I
could even live with
Not sure about the root cause but I can make these observations and raise
some questions:
1) 9.6.6 is five bug fix versions behind
2) 300GB is so big a table, wouldn't make sense to you to partition it ?
2a) or if it's partitioned, doesn't the time of creation or dropping of new
partitions match th
Sorry, I see now there was a similar question a few days ago:
https://www.postgresql.org/message-id/CAJw4d1WtzOdYzd8Nq2=ufk+z0jy0l_pfg9tvcwprmt3nczq...@mail.gmail.com
Two ideas proposed (aside from disconnects):
* Autovacuum is truncating a page on the master and taking an
AccessExclusiveLock on t
I've been struggling to eliminate replication lag on a Postgres 9.6.6
instance on Amazon RDS. I believe the lag is caused by early cleanup
conflicts from vacuums on the master, because I can reliably resolve it by
killing long-running queries on the standby. I most recently saw ten hours
of lag on
On Mon, Nov 19, 2018 at 4:36 PM Tom Lane wrote:
>
> Merlin Moncure writes:
> > On Mon, Nov 19, 2018 at 11:56 AM Tom Lane wrote:
> >> The search_path in the trigger probably doesn't include public.
> >> You could add a "SET search_path = whatever" clause to the trigger
> >> function definition to
Merlin Moncure writes:
> On Mon, Nov 19, 2018 at 11:56 AM Tom Lane wrote:
>> The search_path in the trigger probably doesn't include public.
>> You could add a "SET search_path = whatever" clause to the trigger
>> function definition to ensure it runs with a predictable path.
> Might be worth co
On Mon, Nov 19, 2018 at 11:56 AM Tom Lane wrote:
>
> "Day, David" writes:
> > Any suggestions as to why the int[] operations are not understood in the
> > trigger context.?
>
> The search_path in the trigger probably doesn't include public.
> You could add a "SET search_path = whatever" clause t
Tom
I was thinking something similar after finding that my test function recreated
in the problematic schema would execute correctly
As one user-role but not another and that they had different search_path
settings.
After adding public to search patch for that role all was good.
The error mess
Hi,
on a CentOS 7.5 machine with PostgreSQL 10.3 installed from the PGDG yum repo,
I have a strange error when trying to update to 10.6.
A simple "yum update" updated everything except postgresql10-server.x86_64!
That package gives (repeatedly) the error message:
Error unpacking rpm package po
Greetings,
* Magnus Hagander (mag...@hagander.net) wrote:
> On Mon, Nov 19, 2018 at 4:01 PM Stephen Frost wrote:
> > * Magnus Hagander (mag...@hagander.net) wrote:
> > > This has now been pushed, so both the schedule and the session list on
> > > pgconf.eu will now indicate which sessions have sl
"Day, David" writes:
> Any suggestions as to why the int[] operations are not understood in the
> trigger context.?
The search_path in the trigger probably doesn't include public.
You could add a "SET search_path = whatever" clause to the trigger
function definition to ensure it runs with a pred
On Mon, Nov 19, 2018 at 4:35 PM Stephen Frost wrote:
> Greetings,
>
> * Achilleas Mantzios (ach...@matrix.gatewaynet.com) wrote:
> > On 19/11/18 3:27 μ.μ., Stephen Frost wrote:
> > >* Charles Clavadetscher (clavadetsc...@swisspug.org) wrote:
> > >>
> https://wiki.postgresql.org/wiki/PostgreSQL_Co
On Mon, Nov 19, 2018 at 4:01 PM Stephen Frost wrote:
> Greetings,
>
> * Magnus Hagander (mag...@hagander.net) wrote:
> > This has now been pushed, so both the schedule and the session list on
> > pgconf.eu will now indicate which sessions have slides uploaded.
>
> That's better, but couldn't we m
I have installed the intarray extension installed in the public schema and am
attempting to use this in a plpgsql trigger function from another schema.
When the triggers executes this I get an exception to the effect
{
"hint": "No operator matches the given name and argument type(s). You
Greetings,
* Achilleas Mantzios (ach...@matrix.gatewaynet.com) wrote:
> On 19/11/18 3:27 μ.μ., Stephen Frost wrote:
> >* Charles Clavadetscher (clavadetsc...@swisspug.org) wrote:
> >>https://wiki.postgresql.org/wiki/PostgreSQL_Conference_Europe_Talks_2018
> >>
> >>As mentioned there, the slides ar
Greetings,
* Magnus Hagander (mag...@hagander.net) wrote:
> This has now been pushed, so both the schedule and the session list on
> pgconf.eu will now indicate which sessions have slides uploaded.
That's better, but couldn't we make that an actual link..?
Thanks!
Stephen
signature.asc
Descri
> -Original Message-
> From: Achilleas Mantzios
> Sent: Montag, 19. November 2018 15:43
> To: pgsql-general@lists.postgresql.org
> Subject: Re: pgconf eu 2018 slides entry missing from
> https://wiki.postgresql.org/wiki/PostgreSQL_Related_Slides_and_Presentatio
> ns
>
> On 19/11/18 3:27 μ
On 19/11/18 3:27 μ.μ., Stephen Frost wrote:
Greetings,
* Charles Clavadetscher (clavadetsc...@swisspug.org) wrote:
https://wiki.postgresql.org/wiki/PostgreSQL_Conference_Europe_Talks_2018
As mentioned there, the slides are linked, as long as they have been delivered
by the speakers, in the ta
On Mon, Nov 19, 2018 at 2:38 PM Magnus Hagander wrote:
> On Mon, Nov 19, 2018 at 2:27 PM Stephen Frost wrote:
>
>> Greetings,
>>
>> * Charles Clavadetscher (clavadetsc...@swisspug.org) wrote:
>> >
>> https://wiki.postgresql.org/wiki/PostgreSQL_Conference_Europe_Talks_2018
>> >
>> > As mentioned
On Mon, Nov 19, 2018 at 2:27 PM Stephen Frost wrote:
> Greetings,
>
> * Charles Clavadetscher (clavadetsc...@swisspug.org) wrote:
> > https://wiki.postgresql.org/wiki/PostgreSQL_Conference_Europe_Talks_2018
> >
> > As mentioned there, the slides are linked, as long as they have been
> delivered b
Greetings,
* Charles Clavadetscher (clavadetsc...@swisspug.org) wrote:
> https://wiki.postgresql.org/wiki/PostgreSQL_Conference_Europe_Talks_2018
>
> As mentioned there, the slides are linked, as long as they have been
> delivered by the speakers, in the talk descriptions in the schedule.
I'm n
25 matches
Mail list logo
