On Tue, 2024-07-09 at 07:05 +0100, Jaurès FOUTE KUETE wrote:
> [image showing a large "pg_wal" directory]
>
> We are facing this issue and want to know how can I do to clean this folder
> without problem.
>
> What can be the cause of that ?
> and How can I cle
it does not, but the odds the same user will run this command by this id
in two different sessions at the same time are very low.
this type of code exist for PO,SO, Invoices, to assign the next line item
# in many apps.
On Thu, Jan 16, 2020 at 10:40 AM Michael Nolan wrote:
>
>
> On Thu, Jan
On Thu, Jan 16, 2020 at 6:28 AM stan wrote:
> I am trying to create a function to automatically create a reference value
> when a record is inserted into a table. I want the reference value to
> consist of the user that is doing the insert, plus a couple of dates, plus
> a sequence number, where
Hi Stan
in you code sample there are "(" mis-matched, "MAX(" matches to "=
project_key)";
it should be
MAX(NULLIF(regexp_replace(report_no, '\D','','g'), '')::numeric)
I do exactly what you do, and you are correct sequences are not a good fit
I typically do something like this for
I am trying to create a function to automatically create a reference value
when a record is inserted into a table. I want the reference value to
consist of the user that is doing the insert, plus a couple of dates, plus
a sequence number, where the sequence number will increment every time a
given