This question seems related to the other thread you started on April 18th?
> This is related but perhaps a little complicated than the previous one,
since this involves modifying the query that would be executed.
Several of us suggested you use a CTE to materialize your intermediate
values. Did
On Tue, Apr 23, 2019 at 2:56 PM Souvik Bhattacherjee
wrote:
> Hi,
>
> I need to use the return value of the function somefunction1() to modify a
> query and execute it.
>
> While it is easy to fetch the desired result using plpgsql functions(),
> however modifying and rewriting the query using th
Thanks, works fine!
-Souvik
On Mon, Apr 22, 2019 at 12:02 PM Tom Lane wrote:
> Souvik Bhattacherjee writes:
> > I was just wondering if it is possible to store the output of EXPLAIN
> into
> > a table.
>
> EXPLAIN won't do that directly, but you could make a plpgsql function
> along the lines
Thanks for your response Adrian, appreciate your time and effort.
I'd read the EOL statement regarding 9.3, but seeing the older 9.2 packages
were available figured they should be for 9.3 too.
The problem is that we automate the pg install with chef, so I will need to
try and vendor the cookbook un
Hi,
Is there a quick way to fetch the contents of a temp table from within
postgres server code?
The temp table has a single column and there is a single value in the
column. Thus, I'm using the temp table as a variable to store a string.
begin;
create temp table mytemp(metastr char(1024)) on co
On 22/04/2019 18:49, Tom Lane wrote:
"Ray O'Donnell" writes:
In general, then, is it not possible to use an expression thus? -
[...] ALTER COLUMN [...] RESTART WITH
No. In general, PG's utility commands (everything except SELECT/
INSERT/UPDATE/DELETE) don't do expression evaluation
On Tue, 23 Apr 2019, Peter Devoy wrote:
I think you may have serial already there (indicated by sequence in the the
default value).
Peter,
As serial is an alias for integer (the actual data type) using integer and
specifying it as the primary key works.
If you wish to change to identity col
Hi Rich
I think you may have serial already there (indicated by sequence in the the
default value). If you wish to change to identity columns this should be
useful: https://www.2ndquadrant.com/en/blog/postgresql-10-identity-columns/
Regards
Peter
>
> My question was about how you (think you are) setting log_error_verbosity,
> not what you're doing to produce the message. The decisions in elog.c
> about which fields to print in the server log do not depend on the latter.
>
Roger that.
> However... looking again at what elog.c does, I'm p
On 4/22/19 9:05 PM, Lewis Shobbrook wrote:
Thanks Adrian,
The symlinks have been created for all pgdg versions other than 9.3
It seems to have been an over site perhaps.
As stated in the announcement...
"Today, you still get the link to the pgdg-centos11-11-2 rpm."
Which is true in all instances
Hi there,
>From documentation
https://www.postgresql.org/docs/10/runtime-config-wal.html standby behavior
with setting synchronous_commit = remote_apply is not obvious. I think we
should explain this case.
Am I correct that master always sync COMMIT, except 'off' and regardless of
whether standb
11 matches
Mail list logo
