I find that the RECURSIVE can be used only once in a CTE.
I have the following use-case where there is a hierarchy of store_groups,
and then there are stores associated with a store_group. Requirement is to
ensure that a store can be used only once in a store group hierarchy.
Following definitions
> "Jitendra" == Jitendra Loyal writes:
Jitendra> I find that the RECURSIVE can be used only once in a CTE.
RECURSIVE can be specified only once, but it applies to all CTEs at that
level. That is to say, RECURSIVE qualifies the preceding WITH, _not_ the
following CTE.
Note that just specify
On Fri, 22 Feb 2019 13:23:11 +0530
Jitendra Loyal wrote:
> I find that the RECURSIVE can be used only once in a CTE.
>
> I have the following use-case where there is a hierarchy of
> store_groups, and then there are stores associated with a
> store_group. Requirement is to ensure that a store ca
Thanks Andrew
I will try this and revert; I was specifying RECURSIVE for the second CTE
as well.
Regards,
Jitendra
Hi all.
Taking advantage of the topic I would like to know the recommendations
about how to update to a newer Postgres version having all that amount of
data.
Anyone one could share your experience about?
Thanks in advance.
Regards,
Samuel
Thanks Got it
Regards,
Jitendra
On Fri 22 Feb, 2019, 4:03 PM mariusz On Fri, 22 Feb 2019 13:23:11 +0530
> Jitendra Loyal wrote:
>
> > I find that the RECURSIVE can be used only once in a CTE.
> >
> > I have the following use-case where there is a hierarchy of
> > store_groups, and then ther
Just adding that my case it's not a Amazon RDS, it's common server, if I
can say like that...
On Fri, Feb 22, 2019 at 5:48 AM Samuel Teixeira Santos
wrote:
> Just adding that my case it's not a Amazon RDS, it's common server, if I
> can say like that...
>
Aplologies I missed the point to mention that this is a question to
PostgreSQL community. We are currently using PostgreSQL. ( Aurora
Hi Everyone,
I have a partitioned by period table scenario here where I need to
execute a query with a function in where clause.
I'm not sure if this is the best approach to do that, but when I use the
functions, it scans all the tables instead only the desired one. If I put
the parameter hard
I've set up 2 instances of PostgreSQL 11. On instance A, I created a table
with 2 local partitions and 2 partitions on instance B using foreign data
wrappers, following https://pgdash.io/blog/postgres-11-sharding.html.
Inserting rows into this table works as expected, with rows ending up in
the app
On 2/22/19 4:46 AM, github kran wrote:
On Fri, Feb 22, 2019 at 5:48 AM Samuel Teixeira Santos
mailto:arcano...@gmail.com>> wrote:
Just adding that my case it's not a Amazon RDS, it's common server,
if I can say like that...
Aplologies I missed the point to mention that this is a que
Hi pgsql-general,
I know that the requirement for replication is that a user be allowed to
connect to the "replication" database. My question is how to configure the
streaming replication client to use a particular authentication method. I
haven't been able to find examples of streaming repli
On Fri, Feb 22, 2019 at 2:03 AM Tom Lane wrote:
> Bruce Momjian writes:
> > On Thu, Feb 21, 2019 at 09:31:32PM -0500, Stephen Frost wrote:
> >> * Bruce Momjian (br...@momjian.us) wrote:
> >>> There was too much concern that users would accidentally start the old
> >>> server at some later point,
I started trying to debug backup with minimal WALs for achieve consistency, it
is from 'server 2'
and it only needs 20 WAL files.
It error was:
ERROR: xlog flush request 44B/7E5DAB28 is not satisfied --- flushed only to
44B/7305B560
CONTEXT: writing block 0 of relation base/16506/16891_vm
===
forgot to cc pgsql-general list
De : legrand legrand
Envoyé : vendredi 22 février 2019 20:26
À : Bruce Momjian
Objet : RE: pg_stat_statements doesn't track commit from pl/pgsql blocks
Hello Bruce,
thank you for taking time to answer.
yes, I was expecting someth
Hi Melvin,
Unfortunately I was not able to use it because I was not able to access
pg_authid in RDS.
Thanks.
Tiff
On Thu, Feb 21, 2019 at 6:09 PM Melvin Davidson
wrote:
> Tiffany, have you tried the clone_schema function? It seems to me it does
> exactly what you need, no dumping or restoring.
On Tue, Feb 19, 2019 at 5:31 PM Thomas Munro wrote:
> On Tue, Feb 19, 2019 at 5:16 PM James Sewell
> wrote:
> >> Here's a starter patch that shows one of the approaches discussed. It
> >> gets WSL users to a better place than they were before, by suppressing
> >> further warnings after the firs
Greetings,
* Zachary Hanson-Hart (zac...@temple.edu) wrote:
>I know that the requirement for replication is that a user be allowed to
> connect to the "replication" database. My question is how to configure the
> streaming replication client to use a particular authentication method. I
> hav
18 matches
Mail list logo
