Hello,
Need inputs on below:
We are working on a setting up a new highly transactional (tps 100k) OLTP
system for payments using blockchain and postgresql 9.6 as DB on Rhel 7.6.
Postgres version is 9.6 and not latest because of specs of blockchain
component.
There is a requirement for data compr
po 5. 8. 2019 v 7:55 odesílatel Thomas Kellerer napsal:
> Igal @ Lucee.org schrieb am 05.08.2019 um 00:52:
> > I have the following statement in a trigger:
> >
> > new.email = lower(new.email);
> >
> > When I try to update a record without setting the email column however,
> I get an error:
>
Igal @ Lucee.org schrieb am 05.08.2019 um 00:52:
> I have the following statement in a trigger:
>
> new.email = lower(new.email);
>
> When I try to update a record without setting the email column however, I get
> an error:
>
> SQL Error [42703]: ERROR: record "new" has no field "email"
>
On 8/4/19 3:52 PM, Igal @ Lucee.org wrote:
I have the following statement in a trigger:
new.email = lower(new.email);
When I try to update a record without setting the email column however,
Do you mean:
1) There is no actual email column?
2) There is an email column but no value for i
I have the following statement in a trigger:
new.email = lower(new.email);
When I try to update a record without setting the email column however,
I get an error:
SQL Error [42703]: ERROR: record "new" has no field "email"
Where: SQL statement "SELECT lower(new.email)"
PL/pgSQL function
Alban, thank you for your reply. Your suggestion makes sense, and I will be
talking to our engineers about it. Currently we need to understand:
a) How do we break A -> B replication such that both can become
independent primaries
b) How do we reassign C from B->C replication to A->C r
