On 9/8/24 13:04, Achilleas Mantzios wrote:
Hi
for remote DDL execution (such as CREATE TABLE) is dblink my only option?
You will need to define in what context you are considering options.
For instance you can do remote DDL operations by passing a command or
script via psql.
thanks
Hi
for remote DDL execution (such as CREATE TABLE) is dblink my only option?
thanks
On 9/8/24 10:45, Peter J. Holzer wrote:
On 2024-09-06 01:44:00 +0530, Lok P wrote:
We are having a requirement to create approx 50 billion rows in a partition
table(~1 billion rows per partition, 200+gb size daily partitions) for a
performance test. We are currently using ' insert into
select..
On 2024-09-06 01:44:00 +0530, Lok P wrote:
> We are having a requirement to create approx 50 billion rows in a partition
> table(~1 billion rows per partition, 200+gb size daily partitions) for a
> performance test. We are currently using ' insert into table_partition>
> select.. From or ;' metho
On Sun, 2024-09-08 at 16:02 +0200, Istvan Soos wrote:
> On Sun, Sep 8, 2024 at 3:41 PM Laurenz Albe wrote:
> > You must be doing something wrong then, because it works:
>
> And you are right, I was doing something wrong:
>
> [...]
>
> I'm sorry for the noise.
No problem; I'm glad you could fin
On Sun, Sep 8, 2024 at 3:41 PM Laurenz Albe wrote:
> You must be doing something wrong then, because it works:
And you are right, I was doing something wrong:
The combination of the change and the library internals triggered a
SET statement_timeout TO 3000; before the ROLLBACK was sent, and the
On Sun, 2024-09-08 at 15:01 +0200, Istvan Soos wrote:
> On Sun, Sep 8, 2024 at 1:19 PM Laurenz Albe wrote:
> > ROLLBACK and COMMIT are working: they end the transaction.
>
> I have this reproduction test, and ROLLBACK does fail:
> https://github.com/isoos/postgresql-dart/pull/363/files#diff-4547e
On Sun, Sep 8, 2024 at 1:19 PM Laurenz Albe wrote:
> ROLLBACK and COMMIT are working: they end the transaction.
I have this reproduction test, and ROLLBACK does fail:
https://github.com/isoos/postgresql-dart/pull/363/files#diff-4547e49b04ec8280fb8f4f1ebf695b77f9a2d9a4ac9bcfd685bcd570a46baa80R122
On Sun, 2024-09-08 at 12:56 +0200, Istvan Soos wrote:
> I'm one of the developers of the Dart-language Postgresql client
> package. I am working on adding a feature that may set the
> statement_timeout value before a session or a query as the client
> requests it, however, I'm stuck with the follow
I'm one of the developers of the Dart-language Postgresql client
package. I am working on adding a feature that may set the
statement_timeout value before a session or a query as the client
requests it, however, I'm stuck with the following error:
setup:
CREATE TABLE t (id INT PRIMARY KEY);
INSERT
10 matches
Mail list logo
