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 7:47 PM Robert Haas <robertmhaas@gmail.com> wrote:
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.

Thanks Robert, that worked. Here is the output:

(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


--
Sandeep Thakkar


В списке 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