Inverse of pg_get_serial_sequence? - Mailing list pgsql-hackers

From Andres Freund
Subject Inverse of pg_get_serial_sequence?
Date
Msg-id 20140829172637.GG10109@awork2.anarazel.de
Whole thread Raw
Responses Re: Inverse of pg_get_serial_sequence?
Re: Inverse of pg_get_serial_sequence?
List pgsql-hackers
Hi,

We have pg_get_serial_sequence() mapping (relation, colum) to the
sequence. What I'm missing right now is the inverse. I.e. given a
sequence tell me the owner.
describe.c has a query for that, and it's not too hard to write, but it
still seems 'unfriendly' not to provide it.

Does anybody dislike adding a function for that?


I can't really think of a good name (not that pg_get_serial_sequence is
well named). pg_get_serial_sequence_owner(serial regclass, OUT rel
regclass, OUT colname name) maybe?

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: On partitioning
Next
From: Tom Lane
Date:
Subject: Re: On partitioning