Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data
От | Sandeep Thakkar |
---|---|
Тема | Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data |
Дата | |
Msg-id | CANFyU96pdjUgGEopmU6KhaU782ff7HF4gvJ1RBqsbXiUWYQvMg@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data (Robert Haas <robertmhaas@gmail.com>) |
Ответы |
Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data
(Noah Misch <noah@leadboat.com>)
|
Список | pgsql-bugs |
On Mon, Nov 1, 2021 at 9:33 AM Sandeep Thakkar
<sandeep.thakkar@enterprisedb.com> wrote:
> (gdb) p tupdesc1->attrs[1]
> No symbol "tupdesc1" in current context.
> (gdb) p tupdesc1->attrs[2]
> No symbol "tupdesc1" in current context.
> (gdb) p tupdesc2->attrs[0]
> No symbol "tupdesc2" in current context.
> (gdb) p tupdesc2->attrs[1]
> No symbol "tupdesc2" in current context.
> (gdb)
I think you need to select stack frame 1 before running these
commands. I believe just running "frame 1" before you run these print
commands should do the trick.
(gdb) frame 1
#1 0x40000000003fdc00:0 in equalTupleDescs (tupdesc1=0x60000000001f65e0,
tupdesc2=0x60000000001fba08)
(gdb) p tupdesc1->attrs[0]
$1 = {attrelid = 27272, attname = {
data = "initial", '\000' <repeats 56 times>}, atttypid = 23,
attstattarget = -1, attlen = 4, attnum = 1, attndims = 0, attcacheoff = 0,
atttypmod = -1, attbyval = true, attalign = 105 'i', attstorage = 112 'p',
attcompression = 0 '\000', attnotnull = false, atthasdef = false,
atthasmissing = false, attidentity = 0 '\000', attgenerated = 0 '\000',
attisdropped = false, attislocal = true, attinhcount = 0, attcollation = 0}
(gdb) p tupdesc1->attrs[1]
$2 = {attrelid = 27272, attname = {data = "a", '\000' <repeats 62 times>},
atttypid = 23, attstattarget = -1, attlen = 4, attnum = 2, attndims = 0,
attcacheoff = -1, atttypmod = -1, attbyval = true, attalign = 105 'i',
attstorage = 112 'p', attcompression = 0 '\000', attnotnull = false,
atthasdef = true, atthasmissing = true, attidentity = 0 '\000',
attgenerated = 0 '\000', attisdropped = false, attislocal = true,
attinhcount = 0, attcollation = 0}
(gdb) p tupdesc1->attrs[2]
$3 = {attrelid = 27272, attname = {data = "b", '\000' <repeats 62 times>},
atttypid = 19, attstattarget = -1, attlen = 64, attnum = 3, attndims = 0,
attcacheoff = -1, atttypmod = -1, attbyval = false, attalign = 99 'c',
attstorage = 112 'p', attcompression = 0 '\000', attnotnull = false,
atthasdef = false, atthasmissing = false, attidentity = 0 '\000',
attgenerated = 0 '\000', attisdropped = false, attislocal = true,
attinhcount = 0, attcollation = 950}
(gdb) p tupdesc2->attrs[0]
$4 = {attrelid = 27272, attname = {
data = "initial", '\000' <repeats 56 times>}, atttypid = 23,
attstattarget = -1, attlen = 4, attnum = 1, attndims = 0, attcacheoff = 0,
atttypmod = -1, attbyval = true, attalign = 105 'i', attstorage = 112 'p',
attcompression = 0 '\000', attnotnull = false, atthasdef = false,
atthasmissing = false, attidentity = 0 '\000', attgenerated = 0 '\000',
attisdropped = false, attislocal = true, attinhcount = 0, attcollation = 0}
(gdb) p tupdesc2->attrs[1]
$5 = {attrelid = 27272, attname = {data = "a", '\000' <repeats 62 times>},
atttypid = 23, attstattarget = -1, attlen = 4, attnum = 2, attndims = 0,
attcacheoff = -1, atttypmod = -1, attbyval = true, attalign = 105 'i',
attstorage = 112 'p', attcompression = 0 '\000', attnotnull = false,
atthasdef = true, atthasmissing = true, attidentity = 0 '\000',
attgenerated = 0 '\000', attisdropped = false, attislocal = true,
attinhcount = 0, attcollation = 0}
(gdb) p tupdesc2->attrs[2]
$6 = {attrelid = 27272, attname = {data = "b", '\000' <repeats 62 times>},
atttypid = 19, attstattarget = -1, attlen = 64, attnum = 3, attndims = 0,
attcacheoff = -1, atttypmod = -1, attbyval = false, attalign = 99 'c',
attstorage = 112 'p', attcompression = 0 '\000', attnotnull = false,
atthasdef = false, atthasmissing = false, attidentity = 0 '\000',
attgenerated = 0 '\000', attisdropped = false, attislocal = true,
attinhcount = 0, attcollation = 950}
(gdb)
--
Robert Haas
EDB: http://www.enterprisedb.com
В списке pgsql-bugs по дате отправления:
Предыдущее
От: Tom LaneДата:
Сообщение: Re: BUG #17261: FK ON UPDATE CASCADE can break referential integrity with columns of different types
Следующее
От: "David G. Johnston"Дата:
Сообщение: Re: BUG #17261: FK ON UPDATE CASCADE can break referential integrity with columns of different types