- Notifications
You must be signed in to change notification settings - Fork5
Commit38fb906
committed
> Joe Conway <mail@joeconway.com> writes:
>>ISTM that "source" is worth knowing.>> Hm, possibly. Any other opinions?This version has the seven fields I proposed, including "source". Here'san example that shows why I think it's valuable:regression=# \xExpanded display is on.regression=# select * from pg_settings where name = 'enable_seqscan';-[ RECORD 1 ]-----------name | enable_seqscansetting | oncontext | uservartype | boolsource | defaultmin_val |max_val |regression=# update pg_settings set setting = 'off' where name ='enable_seqscan';-[ RECORD 1 ]---set_config | offregression=# select * from pg_settings where name = 'enable_seqscan';-[ RECORD 1 ]-----------name | enable_seqscansetting | offcontext | uservartype | boolsource | sessionmin_val |max_val |regression=# alter user postgres set enable_seqscan to 'off';ALTER USER(log out and then back in again)regression=# \xExpanded display is on.regression=# select * from pg_settings where name = 'enable_seqscan';-[ RECORD 1 ]-----------name | enable_seqscansetting | offcontext | uservartype | boolsource | usermin_val |max_val |In the first case, enable_seqscan is set to its default value. Aftersetting it to off, it is obvious that the value has been changed for thesession only. In the third case, you can see that the value has been setspecifically for the user.Joe Conway1 parenta265b7f commit38fb906
File tree
8 files changed
+204
-55
lines changed- doc/src/sgml
- src
- backend/utils/misc
- bin/initdb
- include/utils
- test/regress
- expected
- sql
8 files changed
+204
-55
lines changedLines changed: 34 additions & 3 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
1 | 1 |
| |
2 |
| - | |
| 2 | + | |
3 | 3 |
| |
4 | 4 |
| |
5 | 5 |
| |
| |||
571 | 571 |
| |
572 | 572 |
| |
573 | 573 |
| |
574 |
| - | |
| 574 | + | |
575 | 575 |
| |
576 | 576 |
| |
577 | 577 |
| |
578 | 578 |
| |
579 | 579 |
| |
580 |
| - | |
| 580 | + | |
581 | 581 |
| |
| 582 | + | |
| 583 | + | |
| 584 | + | |
| 585 | + | |
| 586 | + | |
| 587 | + | |
| 588 | + | |
| 589 | + | |
| 590 | + | |
| 591 | + | |
| 592 | + | |
| 593 | + | |
| 594 | + | |
| 595 | + | |
| 596 | + | |
| 597 | + | |
| 598 | + | |
| 599 | + | |
| 600 | + | |
| 601 | + | |
| 602 | + | |
| 603 | + | |
| 604 | + | |
| 605 | + | |
| 606 | + | |
| 607 | + | |
| 608 | + | |
| 609 | + | |
| 610 | + | |
| 611 | + | |
| 612 | + | |
582 | 613 |
| |
583 | 614 |
| |
584 | 615 |
| |
|
Lines changed: 147 additions & 32 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
10 | 10 |
| |
11 | 11 |
| |
12 | 12 |
| |
13 |
| - | |
| 13 | + | |
14 | 14 |
| |
15 | 15 |
| |
16 | 16 |
| |
| |||
155 | 155 |
| |
156 | 156 |
| |
157 | 157 |
| |
| 158 | + | |
| 159 | + | |
| 160 | + | |
| 161 | + | |
| 162 | + | |
| 163 | + | |
| 164 | + | |
| 165 | + | |
| 166 | + | |
| 167 | + | |
| 168 | + | |
| 169 | + | |
| 170 | + | |
| 171 | + | |
| 172 | + | |
| 173 | + | |
| 174 | + | |
| 175 | + | |
| 176 | + | |
| 177 | + | |
| 178 | + | |
| 179 | + | |
| 180 | + | |
| 181 | + | |
| 182 | + | |
| 183 | + | |
| 184 | + | |
| 185 | + | |
| 186 | + | |
| 187 | + | |
| 188 | + | |
| 189 | + | |
| 190 | + | |
| 191 | + | |
| 192 | + | |
| 193 | + | |
| 194 | + | |
| 195 | + | |
| 196 | + | |
| 197 | + | |
| 198 | + | |
158 | 199 |
| |
159 | 200 |
| |
160 | 201 |
| |
| |||
3323 | 3364 |
| |
3324 | 3365 |
| |
3325 | 3366 |
| |
3326 |
| - | |
3327 |
| - | |
| 3367 | + | |
| 3368 | + | |
3328 | 3369 |
| |
3329 |
| - | |
| 3370 | + | |
| 3371 | + | |
3330 | 3372 |
| |
3331 | 3373 |
| |
3332 | 3374 |
| |
3333 | 3375 |
| |
3334 | 3376 |
| |
3335 | 3377 |
| |
3336 |
| - | |
3337 |
| - | |
3338 |
| - | |
3339 | 3378 |
| |
3340 | 3379 |
| |
3341 | 3380 |
| |
3342 |
| - | |
| 3381 | + | |
| 3382 | + | |
| 3383 | + | |
| 3384 | + | |
| 3385 | + | |
| 3386 | + | |
| 3387 | + | |
| 3388 | + | |
| 3389 | + | |
| 3390 | + | |
| 3391 | + | |
| 3392 | + | |
| 3393 | + | |
| 3394 | + | |
| 3395 | + | |
| 3396 | + | |
| 3397 | + | |
| 3398 | + | |
| 3399 | + | |
| 3400 | + | |
| 3401 | + | |
| 3402 | + | |
| 3403 | + | |
| 3404 | + | |
| 3405 | + | |
| 3406 | + | |
| 3407 | + | |
| 3408 | + | |
| 3409 | + | |
| 3410 | + | |
| 3411 | + | |
| 3412 | + | |
| 3413 | + | |
| 3414 | + | |
| 3415 | + | |
| 3416 | + | |
| 3417 | + | |
| 3418 | + | |
| 3419 | + | |
| 3420 | + | |
| 3421 | + | |
| 3422 | + | |
| 3423 | + | |
| 3424 | + | |
| 3425 | + | |
| 3426 | + | |
| 3427 | + | |
| 3428 | + | |
| 3429 | + | |
| 3430 | + | |
| 3431 | + | |
| 3432 | + | |
| 3433 | + | |
| 3434 | + | |
| 3435 | + | |
| 3436 | + | |
| 3437 | + | |
| 3438 | + | |
| 3439 | + | |
| 3440 | + | |
| 3441 | + | |
| 3442 | + | |
| 3443 | + | |
| 3444 | + | |
| 3445 | + | |
| 3446 | + | |
| 3447 | + | |
| 3448 | + | |
| 3449 | + | |
| 3450 | + | |
| 3451 | + | |
| 3452 | + | |
| 3453 | + | |
| 3454 | + | |
| 3455 | + | |
| 3456 | + | |
| 3457 | + | |
| 3458 | + | |
| 3459 | + | |
| 3460 | + | |
| 3461 | + | |
| 3462 | + | |
3343 | 3463 |
| |
3344 | 3464 |
| |
3345 | 3465 |
| |
| |||
3379 | 3499 |
| |
3380 | 3500 |
| |
3381 | 3501 |
| |
| 3502 | + | |
| 3503 | + | |
3382 | 3504 |
| |
3383 | 3505 |
| |
3384 | 3506 |
| |
| |||
3402 | 3524 |
| |
3403 | 3525 |
| |
3404 | 3526 |
| |
3405 |
| - | |
3406 |
| - | |
| 3527 | + | |
| 3528 | + | |
| 3529 | + | |
| 3530 | + | |
| 3531 | + | |
3407 | 3532 |
| |
3408 | 3533 |
| |
3409 | 3534 |
| |
3410 | 3535 |
| |
| 3536 | + | |
| 3537 | + | |
| 3538 | + | |
| 3539 | + | |
| 3540 | + | |
| 3541 | + | |
| 3542 | + | |
| 3543 | + | |
| 3544 | + | |
| 3545 | + | |
3411 | 3546 |
| |
3412 | 3547 |
| |
3413 | 3548 |
| |
| |||
3438 | 3573 |
| |
3439 | 3574 |
| |
3440 | 3575 |
| |
3441 |
| - | |
3442 |
| - | |
3443 |
| - | |
| 3576 | + | |
3444 | 3577 |
| |
3445 | 3578 |
| |
3446 | 3579 |
| |
| |||
3450 | 3583 |
| |
3451 | 3584 |
| |
3452 | 3585 |
| |
3453 |
| - | |
3454 |
| - | |
3455 |
| - | |
| 3586 | + | |
3456 | 3587 |
| |
3457 | 3588 |
| |
3458 |
| - | |
3459 |
| - | |
3460 |
| - | |
3461 |
| - | |
3462 | 3589 |
| |
3463 | 3590 |
| |
3464 | 3591 |
| |
| |||
3468 | 3595 |
| |
3469 | 3596 |
| |
3470 | 3597 |
| |
3471 |
| - | |
3472 |
| - | |
3473 |
| - | |
3474 |
| - | |
3475 |
| - | |
3476 |
| - | |
3477 |
| - | |
3478 |
| - | |
3479 | 3598 |
| |
3480 | 3599 |
| |
3481 | 3600 |
| |
3482 | 3601 |
| |
3483 | 3602 |
| |
3484 | 3603 |
| |
3485 |
| - | |
3486 |
| - | |
3487 |
| - | |
3488 |
| - | |
3489 | 3604 |
| |
3490 | 3605 |
| |
3491 | 3606 |
| |
|
Lines changed: 4 additions & 2 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
27 | 27 |
| |
28 | 28 |
| |
29 | 29 |
| |
30 |
| - | |
| 30 | + | |
31 | 31 |
| |
32 | 32 |
| |
33 | 33 |
| |
| |||
1000 | 1000 |
| |
1001 | 1001 |
| |
1002 | 1002 |
| |
1003 |
| - | |
| 1003 | + | |
| 1004 | + | |
| 1005 | + | |
1004 | 1006 |
| |
1005 | 1007 |
| |
1006 | 1008 |
| |
|
Lines changed: 11 additions & 10 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
7 | 7 |
| |
8 | 8 |
| |
9 | 9 |
| |
10 |
| - | |
| 10 | + | |
11 | 11 |
| |
12 | 12 |
| |
13 | 13 |
| |
| |||
55 | 55 |
| |
56 | 56 |
| |
57 | 57 |
| |
58 |
| - | |
59 |
| - | |
60 |
| - | |
61 |
| - | |
62 |
| - | |
63 |
| - | |
64 |
| - | |
| 58 | + | |
| 59 | + | |
| 60 | + | |
| 61 | + | |
| 62 | + | |
| 63 | + | |
| 64 | + | |
65 | 65 |
| |
66 | 66 |
| |
67 | 67 |
| |
| |||
73 | 73 |
| |
74 | 74 |
| |
75 | 75 |
| |
| 76 | + | |
| 77 | + | |
76 | 78 |
| |
77 | 79 |
| |
78 | 80 |
| |
| |||
92 | 94 |
| |
93 | 95 |
| |
94 | 96 |
| |
95 |
| - | |
96 | 97 |
| |
97 | 98 |
| |
98 | 99 |
| |
| |||
132 | 133 |
| |
133 | 134 |
| |
134 | 135 |
| |
135 |
| - | |
| 136 | + | |
136 | 137 |
| |
137 | 138 |
| |
138 | 139 |
| |
|
0 commit comments
Comments
(0)