Re: pg_get_serial_sequence not working for manually set seq

2025-04-21 Thread Tom Lane
Marcelo Fernandes writes: > I've been testing the pg_get_serial_sequence function and noticed that I can > only get reliable results when using a SERIAL or IDENTITY column. > However, shouldn't it work for manually set sequences too? pg_get_serial_sequence looks for pg_depend entries that make se

pg_get_serial_sequence not working for manually set seq

2025-04-21 Thread Marcelo Fernandes
Hi folks, I've been testing the pg_get_serial_sequence function and noticed that I can only get reliable results when using a SERIAL or IDENTITY column. However, shouldn't it work for manually set sequences too? In the docs[0] we have that this function: > Returns the name of the sequence assoc