I do understand better now and indeed the current limitation has no
workaround that I can come up with. I was hoping maybe subblocks would
work but its pretty clear cut that to catch an error at the commit command
you must catch it within a block and the commit error will be raised first.
On Fri,
> t...@sss.pgh.pa.us wrote:
>
>> b...@yugabyte.com wrote:
>>
>> I want to demonstrate how to meet this requirement:
>>
>> «
>> Encapsulate each business function in a user-defined subprogram that hides
>> all the implementation details like table names and the SQL statements that
>> manipulate
On Friday, May 6, 2022, Shaozhong SHI wrote:
> A json object is like this - {3}.
>
> How to get the value -3 out of this json object {3}
>
>
That isn’t valid json so your question doesn’t make sense.
Just treat it as a text type and use one or more of the documented text
functions to manipulate
Bryn Llewellyn writes:
> I want to demonstrate how to meet this requirement:
> «
> Encapsulate each business function in a user-defined subprogram that hides
> all the implementation details like table names and the SQL statements that
> manipulate their contents so the they cannot be seen usin
> david.g.johns...@gmail.com wrote:
>
>> b...@yugabyte.com wrote:
>>
>> Is there simply no way that inserts into table "t" in my example can be
>> encapsulated in PL/pgSQL so that the error from the failing trigger can be
>> handled rather there than escaping, raw, to the client?
>
> Any poten
Hello!
I've some questions around Backup & Restore.
1: Is it necessary to perform a VACUUM and REINDEXING operation after
restoring the dump from Postgres 9.6 to Postgres 13? The dump size could be
1/2 TB to 1 TB.
2: Also, are there any other operations that are recommended to perform
after pg_r
A json object is like this - {3}.
How to get the value -3 out of this json object {3}
David
On Friday, May 6, 2022, Rama Krishnan wrote:
> Thanks a lot. Which means normal primary key and foreign key relationship
> right can u pls send me any reference link
>
Like what? Read the documentation for those commands and features.
David J.
Thanks a lot. Which means normal primary key and foreign key relationship
right can u pls send me any reference link
On Sat, 7 May, 2022, 06:21 David G. Johnston,
wrote:
>
>
> On Friday, May 6, 2022, Rama Krishnan wrote:
>
>> Hi ,
>>
>> Can you pls tell us how to do a vertical partition in pos
On Friday, May 6, 2022, Rama Krishnan wrote:
> Hi ,
>
> Can you pls tell us how to do a vertical partition in postgresql
>
Manually. “Create table” with the columns you want in each. You FK column
will also be your PK column on the non-primary table.
David J.
Hi ,
Can you pls tell us how to do a vertical partition in postgresql
Thanks
RamaKrishnan
On Fri, May 6, 2022 at 4:40 PM Bryn Llewellyn wrote:
>
> Is there simply no way that inserts into table "t" in my example can be
> encapsulated in PL/pgSQL so that the error from the failing trigger can be
> handled rather there than escaping, raw, to the client?
>
>
Any potential solution to thi
The PG doc section 43.8. Transaction Management:
https://www.postgresql.org/docs/current/plpgsql-transactions.html
says "A transaction cannot be ended inside a block with exception handlers."
It's easy to demonstrate the restriction by adding this just before the final
"end;" in the simple examp
> Does https://patroni.readthedocs.io/en/latest/replication_modes.html
help?
Thanks. I have found the same meanwhile. The effects I experienced were
caused by the fact that Patroni configures async replication by default.
After changing it to sync everything worked as expected
Jerry:
On Fri, 6 May 2022 at 03:04, Jerry Sievers wrote:
> Has anyone run into This?
> Psycopg3 fails to resolve timezone localtime on MacOS (Catalina).
>
> It falls back to UTC regardless of whether running with/without the
> tzdata package which I did try.
>
> There is a /etc/localtime symlink
15 matches
Mail list logo
