Mariel Cherkassky writes:
> seq_oid | classid | objid | objsubid | refclassid | refobjid | refobjsubid
> | deptype
> -+-+---+--++--+-+-
>17188 |1259 | 17188 |0 | 1259 |17190 | 1
> | a
>1656
Hey,
This is the full output with all the columns :
WITH
sequences AS
(
SELECT oid,relname FROM pg_class WHERE relkind = 'S'
)
SELECT s.oid as seq_oid,d.*
FROM pg_depend d,sequences s
where
s.oid = d.objid
and d.deptype = 'a' and d.refobjid::regclass::text='table_A';
seq_oid | classid | objid |
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
>
> There are many rows, anything specific u want to see ?
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)
>
>
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
