Hey,
I'm handling a very weird situation. I tried to check which sequences
belong to a specific table (table_A) with the following query :
WITH
sequences AS
(
SELECT oid,relname FROM pg_class WHERE relkind = 'S'
)
SELECT s.oid as seq_oid,d.objid as objid,d.refobjid
FROM pg_depend d,sequences s
whe
On Wed, 2019-09-25 at 15:39 +0300, Mariel Cherkassky wrote:
> select objid,refobjid::regclass from pg_depend where objid=16704;
> objid |refobjid
> ---+-
> 16704 | 2200
> 16704 | table_A
> 16704 | table_A
> 16704 | table_A
> 16704 | table_B
> (5 rows)
>
>
>
> There are many rows, anything specific u want to see ?
On Wed, 2019-09-25 at 22:20 +0300, Mariel Cherkassky wrote:
[problems with sequence dependencies]
> There are many rows, anything specific u want to see ?
Sorry, I didn't mean all of pg_depend, but your query
with all *columns* of pg_depend.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec
