On 8/16/23 14:16, Rob Sargent wrote:
I have just had a quick look at rules and I am not sure how it can be done.
Rules still use the concept of NEW and OLD. If my original row has 'myfield'
set to 'me' then I don't think I can tell the difference between:
Update mytable set
> On Aug 16, 2023, at 1:35 PM, Adrian Klaver wrote:
>
> On 8/16/23 12:01, Rob Sargent wrote:
>> On 8/16/23 12:30, Guyren Howe wrote:
>>> For some reason, I was thinking the rule could see just the fields from the
>>> command, but you’re right; a rule won’t work. Sorry.
>>>
>>> Guyren G Howe
On 16/08/2023 21:24, Ron wrote:
Speakers of English as a second language are to be tolerated and
assisted, not mocked and insulted.
+1
I actually found it rather amusing. :-)
Ray.
On 8/16/23 12:27, Amn Ojee Uw wrote:
Sorry, did not mean it that way.
Thanks for the advice.
On 8/16/23
Speakers of English as a second language are to be tolerated and assisted,
not mocked and insulted.
On 8/16/23 12:27, Amn Ojee Uw wrote:
Sorry, did not mean it that way.
Thanks for the advice.
On 8/16/23 11:37 a.m., Ron wrote:
Friendly tip: whatever else you do, don't write "Hello children!"
On 8/16/23 12:01, Rob Sargent wrote:
On 8/16/23 12:30, Guyren Howe wrote:
For some reason, I was thinking the rule could see just the fields
from the command, but you’re right; a rule won’t work. Sorry.
Guyren G Howe
On Aug 15, 2023 at 23:22 -0700, Russell Rose | Passfield Data Systems
,
On 8/16/23 12:30, Guyren Howe wrote:
For some reason, I was thinking the rule could see just the fields
from the command, but you’re right; a rule won’t work. Sorry.
Guyren G Howe
On Aug 15, 2023 at 23:22 -0700, Russell Rose | Passfield Data Systems
, wrote:
I have just had a quick look at
For some reason, I was thinking the rule could see just the fields from the
command, but you’re right; a rule won’t work. Sorry.
Guyren G Howe
On Aug 15, 2023 at 23:22 -0700, Russell Rose | Passfield Data Systems
, wrote:
> I have just had a quick look at rules and I am not sure how it can be
Sorry, did not mean it that way.
Thanks for the advice.
On 8/16/23 11:37 a.m., Ron wrote:
Friendly tip: whatever else you do, don't write "Hello children!" in
English to adults. It's *highly insulting*.
On 8/16/23 05:10, Amn Ojee Uw wrote:
Hello children!
--
Born in Arizona, moved to
Yes!
Thank you Mateusz.
On 8/16/23 6:43 a.m., Mateusz Henicz wrote:
Hey,
You are using "WITH tablespace_option" wrong.
Try it like this:
postgres=# CREATE TABLESPACE jme_tablespace OWNER jamiil LOCATION
'/database' WITH
(seq_page_cost=1.0,random_page_cost=4.0,effective_io_concurrency=1);
Friendly tip: whatever else you do, don't write "Hello children!" in English
to adults. It's *highly insulting*.
On 8/16/23 05:10, Amn Ojee Uw wrote:
Hello children!
--
Born in Arizona, moved to Babylonia.
On 8/16/23 03:40, Andreas Joseph Krogh wrote:
På onsdag 16. august 2023 kl. 05:40:40, skrev Ron :
On 8/15/23 02:23, Jason Long wrote:
[snip]
> Does PostgreSQL have an option to increase speed?
Like a Turbo button?
It actually has that, but you'll have to sacrifice some safety.
Hey,
You are using "WITH tablespace_option" wrong.
Try it like this:
postgres=# CREATE TABLESPACE jme_tablespace OWNER jamiil LOCATION
'/database' WITH
(seq_page_cost=1.0,random_page_cost=4.0,effective_io_concurrency=1);
CREATE TABLESPACE
Cheers,
Mateusz
śr., 16 sie 2023 o 12:10 Amn Ojee Uw
Hello,
I have one query regarding client/server authentication using certificate
in postgres.
I am able to establish client server connection with OpenSSL certificate
creation.
We can create server and root certificates using OpenSSL and keep them in
data directory.
We need to update field in
Hello children!
I am learning how to create a tablespace, and AFAIK this are the steps
to follow.
First step is to create the directory where the database files will be
created, for that I am using the root directory '/database'. This
directory is be owned by the postgres group.
Example :
Thanks for the advice.
I just ordered it from Amazon.
On 8/12/23 6:59 p.m., Anthony DeBarros wrote:
Hi,
On Sat, Aug 12, 2023 at 6:23 PM Miles Elam
wrote:
> On 8/12/23 9:02 a.m., Amn Ojee Uw wrote:
>
> Is there a book to be recommended for PostgreSQL beginners?
I’m the author
På onsdag 16. august 2023 kl. 05:40:40, skrev Ron mailto:ronljohnso...@gmail.com>>:
On 8/15/23 02:23, Jason Long wrote:
[snip]
> Does PostgreSQL have an option to increase speed?
Like a Turbo button?
It actually has that, but you'll have to sacrifice some safety.
--
Andreas Joseph Krogh
I have just had a quick look at rules and I am not sure how it can be done.
Rules still use the concept of NEW and OLD. If my original row has 'myfield'
set to 'me' then I don't think I can tell the difference between:
Update mytable set afield='something'
and
Update mytable set
El mié, 16 ago 2023 6:54, Ron escribió:
> On 8/15/23 23:48, Olivier Gautherot wrote:
>
>
> El mié, 16 ago 2023 5:39, Ron escribió:
>
>> On 8/15/23 04:24, Olivier Gautherot wrote:
>>
>> [snip]
>>
>> Does the database have to be on a storage like EMC or QNAP?
>>>
>>
>> Faster storage can only
18 matches
Mail list logo