p me understand this strange behavior?
Thank you,
Eudald
El mié., 15 jul. 2020 a las 18:37, Eudald Valcàrcel Lacasa
() escribió:
>
> Hello Tom,
> I've noticed something that may be a factor on this problem.
>
> In the automated script, 5 or 6 seconds before this query happens,
Hello Tom,
I've noticed something that may be a factor on this problem.
In the automated script, 5 or 6 seconds before this query happens, the
foreign table is created.
If I create the foreign table manually and skip its creation in the
automated script, and then I run the automated script,
the qu
Hello Tom,
Thanks for your answer! I didn't know about this plugin and configured
postgresql with it.
After running the query both manually and with the script, I've the
following logs:
MANUALLY:
2020-07-15 00:56:08.735 CEST [20457] cefron@kontriki LOG: statement:
UPDATE import_temp_2 AS tmp SET
Hello!
I'm running a docker container that executes a php script running a
sequence of queries.
One of the queries gets stuck (takes more than 2 hours in execution,
active in pg_stat_activity).
The query is executed with a JOIN between a FOREIGN TABLE and a local table.
Executing this query from t
You're right Rob.
Thanks, it worked!
Eudald
El jue., 7 may. 2020 a las 21:16, Rob Sargent ()
escribió:
>
>
> > On May 7, 2020, at 1:03 PM, Eudald Valcàrcel Lacasa <
> eudald.valcar...@gmail.com> wrote:
> >
> > I know the -T command, but I'm trying
an Klaver ()
escribió:
> On 5/7/20 9:53 AM, Eudald Valcàrcel Lacasa wrote:
> > Hello!
> > I've been looking at the documentation and there seems to be no keyword
> > for negation purposes.
> >
> > Am I missing something? Or it's like this?
>
> http
Hello!
I've been looking at the documentation and there seems to be no keyword for
negation purposes.
Am I missing something? Or it's like this?
I'm trying to use pg_dump to create a database skeleton and I have tables
like program_0, program_1, etc. And I'd like to dump all the tables but
client
