Hello,
On Mon, Oct 7, 2019 at 6:43 PM Nikolay Shaplov wrote:
> В письме от понедельник, 7 октября 2019 г. 14:57:14 MSK пользователь Michael
> Paquier написал:
> > On Sun, Oct 06, 2019 at 03:47:46PM +0300, Nikolay Shaplov wrote:
> > > The idea of this patch is following: If you read the code, part
On Fri, 4 Oct 2019 at 13:18, Tom Lane wrote:
> Natarajan R writes:
> > Me: Thanks Tomas, But this is for that particular database only, I want
> > to get the *list of database Id's* on which my extension is installed
> > during *PG_INIT* itself...
>
> You can't. In the first place, that inform
Hi, Konstantin
I'm very sorry for the late response and thank you for your feedback.
(I re-sent this email because my email address changed and couldn't deliver to
hackers.)
>From: Konstantin Knizhnik [mailto:k.knizh...@postgrespro.ru]
>
>Takeshi-san,
>
>I am sorry for late response - I just wa
Hi Ashutosh,
On Mon, Oct 7, 2019 at 1:39 PM Ashutosh Sharma wrote:
> I think we could have first deleted all the dependency of child object
> on parent and then deleted the child itself using performDeletion().
So, there are two objects to consider in this case -- column and an
index that depend
On 2019-10-07 08:52, Michael Paquier wrote:
> On Fri, Oct 04, 2019 at 04:35:59PM +0200, Peter Eisentraut wrote:
>> As of d9dd406fe281d22d5238d3c26a7182543c711e74, we require MSVC 2013,
>> which means _MSC_VER >= 1800. This means that conditionals about
>> older versions of _MSC_VER can be removed
Hi, Alvaro
>
>The last patch we got here (a prototype) was almost a year ago. There was
>substantial discussion about it, but no new version of the patch has been
>posted. Are
>we getting a proper patch soon, or did we give up on the approach entirely?
I'm sorry for the late response. I starte
Moon-san, kuroda.keisuke-san
On Thu, Aug 29, 2019 at 8:20 AM, Moon, Insung wrote:
> =# CREATE INDEX foo_idx ON foo USING gin (i jsonb_ops);
> =# SELECT * FROM gin_metapage_info(get_raw_page('foo_idx', 0)) WITH
> (fastupdate=off);
This is not important thing but some mistakes are here.
=# CREATE
Apologies for not helping much here; I'm on vacation for a couple of
weeks.
On 2019-Oct-08, Amit Langote wrote:
> I couldn't imagine how that trick could be implemented for this case. :(
Can't we pass around an ObjectAddresses pointer to which each recursion
level adds the object(s) it wants to
On Tue, Oct 8, 2019 at 6:15 PM Alvaro Herrera wrote:
> Apologies for not helping much here; I'm on vacation for a couple of
> weeks.
No worries, please take your time.
> On 2019-Oct-08, Amit Langote wrote:
>
> > I couldn't imagine how that trick could be implemented for this case. :(
>
> Can't w
On Mon, 7 Oct 2019 at 18:02, Bruce Momjian wrote:
> Well, do to encryption properly, there is the requirement of the nonce.
> If you ever rewrite a bit, you technically have to have a new nonce.
> For WAL, since it is append-only, you can use the WAL file name. For
> heap/index files, we change
On Tue, 8 Oct 2019 at 19:46, Joe Nelson wrote:
>
> David Rowley wrote:
> > The translation string here must be consistent over all platforms. I
> > think this will cause issues if the translation string uses %ld and
> > the platform requires %lld?
>
> A very good and subtle point. I'll change it t
On Sat, Oct 5, 2019 at 3:10 AM Andres Freund wrote:
>
> On 2019-10-04 17:08:29 -0400, Tom Lane wrote:
> > Andres Freund writes:
> > > On 2019-10-04 16:31:29 -0400, Bruce Momjian wrote:
> > >> Yeah, it is certainly weird that you have to assign the first array
> > >> element to get the rest to be
Ants Aasma wrote:
> On Mon, 7 Oct 2019 at 18:02, Bruce Momjian wrote:
>
>> Well, do to encryption properly, there is the requirement of the nonce.
>> If you ever rewrite a bit, you technically have to have a new nonce.
>> For WAL, since it is append-only, you can use the WAL file name. Fo
В письме от понедельник, 7 октября 2019 г. 18:55:20 MSK пользователь Dent John
написал:
> I like the new approach. And I agree with the ambition — to split out the
> representation from StdRdOptions.
Thanks.
> However, with that change, in the AM’s *options() function, it looks as if
> you coul
В письме от понедельник, 7 октября 2019 г. 12:59:27 MSK пользователь Robert
Haas написал:
> > This thread is a follow up to the thread
> > https://www.postgresql.org/message-id/2620882.s52SJui4ql@x200m where I've
> > been trying to remove StdRdOptions structure and replace it with unique
> > stru
В письме от вторник, 8 октября 2019 г. 16:00:49 MSK пользователь Amit Langote
написал:
> > > > The idea of this patch is following: If you read the code, partitioned
> > > > tables do not have any options (you will not find
> > > > RELOPT_KIND_PARTITIONED
> > > > in boolRelOpts, intRelOpts, realR
Hi everyone,
like the others before me we (the university of Münster) are happy to
see this feature as well. Thank you this.
When I applied the patch two weeks ago I run into the issue that initdb
did not recognize the new parameters (collation-provider and icu-locale)
but I guess it was caused b
Robert Haas wrote:
> On Mon, Oct 7, 2019 at 3:01 PM Antonin Houska wrote:
> > However the design doesn't seem to be stable enough at the
> > moment for coding to make sense.
>
> Well, I think the question is whether working further on your patch
> could produce some things that everyone would a
On Tue, Oct 8, 2019 at 2:12 PM Amit Langote wrote:
>
> Hi Ashutosh,
>
> On Mon, Oct 7, 2019 at 1:39 PM Ashutosh Sharma wrote:
> > I think we could have first deleted all the dependency of child object
> > on parent and then deleted the child itself using performDeletion().
>
> So, there are two o
Hi,
some days ago I ran into a problem with the to_date() function. I
originally described it on StackExchange:
https://dba.stackexchange.com/questions/250111/unexpected-behaviour-for-to-date-with-week-number-and-week-day
The problem:
If you want to parse a date string with year, week and day
Greetings,
* Robert Haas (robertmh...@gmail.com) wrote:
> On Mon, Oct 7, 2019 at 9:14 AM Fujii Masao wrote:
> > Agreed, too. Do you have any idea to implement that? I've not found out
> > "smart" way to do that yet.
> >
> > One idea is, as Michael suggested, to use SetConfigOption() for all the
>
Greetings,
* Anastasia Lubennikova (a.lubennik...@postgrespro.ru) wrote:
> Cool. It seems that everyone agrees on this patch.
Thanks for working on this, I took a quick look over it and I do have
some concerns.
> I attached the updated version. Now it prints a better error message
> and generate
Amit Kapila writes:
> On Wed, Oct 2, 2019 at 2:57 PM vignesh C wrote:
>> I noticed that some of the header files inclusion is not ordered as
>> per the usual standard that is followed.
>> The attached patch contains the fix for the order in which the header
>> files are included.
>> Let me know y
On Tue, Oct 8, 2019 at 10:58 PM Stephen Frost wrote:
>
> Greetings,
>
> * Robert Haas (robertmh...@gmail.com) wrote:
> > On Mon, Oct 7, 2019 at 9:14 AM Fujii Masao wrote:
> > > Agreed, too. Do you have any idea to implement that? I've not found out
> > > "smart" way to do that yet.
> > >
> > > On
Hi,
I apologize for the mistake.
For the mailing list correspondence I created this mail account. But I
forgot to change the sender name. So, the "postgres" name appeared as
sender name in the mailing list. I changed it.
Kind regards,
Mark/S-Man42
Hi,
some days ago I ran into a problem wi
On Fri, 12 Jul 2019 at 01:27, Robert Haas wrote:
>
> We have steadfastly refused to provide protocol-level tools for things
> like "please change my user ID, and don't let anyone change it again
> via SQL," and that's a huge problem for things like connection poolers
> which can't parse all the S
On Thu, 11 Jul 2019 at 04:34, Tom Lane wrote:
> Robert Haas writes:
> > On Wed, Jul 10, 2019 at 9:59 AM Dave Cramer wrote:
> >> I'm still a bit conflicted about what to do with search_path as I do
> believe this is potentially a security issue.
> >> It may be that we always want to report that
Greetings,
* Fujii Masao (masao.fu...@gmail.com) wrote:
> On Tue, Oct 8, 2019 at 10:58 PM Stephen Frost wrote:
> > Having these options end up set but then hacking all of the other code
> > that looks at them to check if we're actually in recovery or not would
> > end up being both confusing to u
I want to read pg_database from pg_init...
Is using heap_open() is possible? or else any other way is there ?
On Tue, Oct 08, 2019 at 10:03:03PM +0530, Natarajan R wrote:
I want to read pg_database from pg_init...
Is using heap_open() is possible? or else any other way is there ?
This is way too vague question - I have no idea what you mean by
pg_init, for example. And it's probably a good idea to exp
Tomas Vondra wrote:
> On Tue, Oct 08, 2019 at 10:03:03PM +0530, Natarajan R wrote:
> >I want to read pg_database from pg_init...
> >
> >Is using heap_open() is possible? or else any other way is there ?
>
> This is way too vague question - I have no idea what you mean by
> pg_init, for example.
On Mon, Oct 7, 2019 at 9:52 PM Bruce Momjian wrote:
>
> On Mon, Oct 7, 2019 at 09:14:38AM +0200, Anders Åstrand wrote:
> > Hello
> >
> > Attached is a patch for adding uri as an encoding option for
> > encode/decode. It uses what's called "percent-encoding" in rfc3986
> > (https://tools.ietf.org/
Greetings,
* Magnus Hagander (mag...@hagander.net) wrote:
> Unless we are *absolutely* certain, I bet someone will be able to find a
> side-channel that somehow leaks some data or data-about-data, if we don't
> encrypt everything. If nothing else, you can get use patterns out of it,
> and you can
Greetings,
* Martín Marqués (mar...@2ndquadrant.com) wrote:
> pg_last_wal_receive_lsn()
> pg_last_wal_replay_lsn()
> pg_last_xact_replay_timestamp()
>
> Under normal circumstances we would expect to receive NULLs from all
> three functions on a primary node, and code comments back up my thoughts.
On Mon, Oct 7, 2019 at 11:38 PM Isaac Morland wrote:
>
> On Mon, 7 Oct 2019 at 03:15, Anders Åstrand wrote:
>>
>> Hello
>>
>> Attached is a patch for adding uri as an encoding option for
>> encode/decode. It uses what's called "percent-encoding" in rfc3986
>> (https://tools.ietf.org/html/rfc3986#
Greetings,
* Tom Lane (t...@sss.pgh.pa.us) wrote:
> Andrew Gierth writes:
> > "Tom" == Tom Lane writes:
> > Tom> Perhaps we could change the back branches so that they interpret
> > Tom> "-f -" as "write to stdout", but without enforcing that you use
> > Tom> that syntax.
>
> > We should def
Hi,
On 2019-10-07 12:14:52 -0400, Robert Haas wrote:
> > - if (portal->status == PORTAL_READY)
> > - MarkPortalFailed(portal);
> >
> > Why it is safe to remove this check? It has been explained in commit
> > 7981c342 why we need that check. I don't see any explanation in email
> > or patch which
On Tue, Oct 8, 2019 at 7:52 AM Antonin Houska wrote:
> * Temporary files (buffile.c): we derive the IV from PID of the process that
> created the file + segment number + block within the segment. This
> information does not change if you need to write the same block again. If
> new IV should
Hi,
> IMV, and not unlike other similar cases I've talked about on another
> thread, these should be cleared when the system is promoted as they're
> otherwise confusing and nonsensical.
Keep in mind that this also happens when the server crashes and has to
perform crash recovery. In that case th
Christoph Berg writes:
> Re: Tom Lane 2018-09-28
>> Remove pqsignal() from libpq's official exports list.
> This is starting to hurt in several places:
> 04 11:41 mha@xindi:~$ psql
> 04 11:41 /usr/lib/postgresql/9.2/bin/psql: symbol lookup error:
>/usr/lib/postgresql/9.2/bi
Hello.
On Tue, Oct 8, 2019 at 8:52 PM Antonin Houska wrote:
>
> Robert Haas wrote:
>
> > On Mon, Oct 7, 2019 at 3:01 PM Antonin Houska wrote:
> > > However the design doesn't seem to be stable enough at the
> > > moment for coding to make sense.
> >
> > Well, I think the question is whether wor
On Sat, Oct 5, 2019 at 4:36 PM Dilip Kumar wrote:
>
> Few more comments
>
>
> 1.
> +static int
> +compute_parallel_workers(Relation onerel, int nrequested, int nindexes)
> +{
> + int parallel_workers;
> + bool leaderparticipates = true;
>
> Seems like this function is
On Fri, Oct 4, 2019 at 8:55 PM vignesh C wrote:
>
> On Fri, Oct 4, 2019 at 4:18 PM Amit Kapila wrote:
> >
> > On Wed, Oct 2, 2019 at 7:29 PM Masahiko Sawada
> > wrote:
> >>
> >> On Sat, Sep 21, 2019 at 9:31 PM Amit Kapila
> >> wrote:
> >> >
> One comment:
Thank you for reviewing this patch.
On Mon, Oct 7, 2019 at 01:47:57PM -0400, Bruce Momjian wrote:
> On Fri, Oct 4, 2019 at 11:55:21PM -0400, Tom Lane wrote:
> > Bruce Momjian writes:
> > > On Fri, Oct 4, 2019 at 05:40:08PM -0500, Justin Pryzby wrote:
> > >> I would argue to include in 12.1, since 12 is what most everyone will
>
Hi all,
ALTER SYSTEM currently does not raise error upon invalid entry. Take for
example:
alter system set superuser_reserved_connections = 10;
> ALTER SYSTEM
alter system set max_connections = 5;
> ALTER SYSTEM
The database will now fail to restart without manual intervention by way of
editin
On Tue, Oct 8, 2019 at 2:45 PM Amit Kapila wrote:
>
> On Tue, Oct 8, 2019 at 1:48 AM Peter Geoghegan wrote:
> >
> > On Mon, Oct 7, 2019 at 12:28 PM Robert Haas wrote:
> > > I would say that sucks, because it makes it harder to set
> > > maintenance_work_mem correctly. Not sure how hard it would
"Jordan Deitch" writes:
> ALTER SYSTEM currently does not raise error upon invalid entry.
You mean on invalid combinations of entries.
Take for example:
> alter system set superuser_reserved_connections = 10;
> ALTER SYSTEM
> alter system set max_connections = 5;
> ALTER SYSTEM
> The database
Dear hackers.
First, I don't know which email thread should written a reply,
therefore using the first email thread.
Sorry about the inconvenience...
Sawada-san and I have previously researched the PostgreSQL database
cluster file that contains user data.
The result has been updated to the WIKI p
Moon, Insung wrote:
> Hello.
>
> On Tue, Oct 8, 2019 at 8:52 PM Antonin Houska wrote:
> >
> > Robert Haas wrote:
> >
> > > On Mon, Oct 7, 2019 at 3:01 PM Antonin Houska wrote:
> > > > However the design doesn't seem to be stable enough at the
> > > > moment for coding to make sense.
> > >
> >
Hi, Konstantin
>>From: Konstantin Knizhnik [mailto:k.knizh...@postgrespro.ru]
>>I do not completely understand from your description when are are going
>>to evict entry from local cache?
>>Just once transaction is committed? I think it will be more efficient
>>to also specify memory threshold for
On Tue, Oct 8, 2019 at 8:19 PM Tom Lane wrote:
>
> Amit Kapila writes:
> > On Wed, Oct 2, 2019 at 2:57 PM vignesh C wrote:
> >> I noticed that some of the header files inclusion is not ordered as
> >> per the usual standard that is followed.
> >> The attached patch contains the fix for the order
On Wed, Oct 9, 2019 at 1:02 AM Stephen Frost wrote:
>
> Greetings,
>
> * Fujii Masao (masao.fu...@gmail.com) wrote:
> > On Tue, Oct 8, 2019 at 10:58 PM Stephen Frost wrote:
> > > Having these options end up set but then hacking all of the other code
> > > that looks at them to check if we're actu
Dear Antonin Houska.
Thank you for your attention to thie matter.
On Wed, Oct 9, 2019 at 2:42 PM Antonin Houska wrote:
>
> Moon, Insung wrote:
>
> > Hello.
> >
> > On Tue, Oct 8, 2019 at 8:52 PM Antonin Houska wrote:
> > >
> > > Robert Haas wrote:
> > >
> > > > On Mon, Oct 7, 2019 at 3:01 PM A
Hi all,
After the set of issues discussed here, it seems to me that it would
be a good thing to have some safeguards against incorrect flags when
opening a fd which would be used for fsync():
https://www.postgresql.org/message-id/16039-196fc97cc05e1...@postgresql.org
Attached is a patch aimed at
On Mon, Oct 07, 2019 at 03:06:35PM -0400, Tom Lane wrote:
> Noah Misch writes:
> > [ fetch-add-gcc-xlc-unify-v2.patch ]
>
> This still fails on Apple's compilers. The first failure I get is
>
> ccache gcc -std=gnu99 -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -We
Moon, Insung wrote:
> On Wed, Oct 9, 2019 at 2:42 PM Antonin Houska wrote:
> >
> > Moon, Insung wrote:
> >
> > > I also tried to generate IV using PID (32bit) + tempCounter (64bit) at
> > > first, but in the worst-case PID and tempCounter are used in the same
> > > values.
> > > Therefore, the
56 matches
Mail list logo
