Re: Suggested way of associating PG user metadata with record - Mailing list pgsql-general

From Peter Geoghegan
Subject Re: Suggested way of associating PG user metadata with record
Date
Msg-id db471ace0905200539p41ec037bj8dd78b6405f5045d@mail.gmail.com
Whole thread Raw
In response to Re: Suggested way of associating PG user metadata with record  (David <wizzardx@gmail.com>)
List pgsql-general
David,

> A text column should be perfectly fine, and is the simplest
> implementation. But it does have a few possible issues that you need
> to keep in mind (besides things like users being removed). For
> instance, if PostgreSQL users are renamed (eg: ALTER USER name RENAME
> TO newname), then your text column becomes incorrect.

Yes, that had occurred to me. I think I'll go ahead and take the
obvious approach. On the whole, it seems very easy to implement and
maintain to me, and the alternative approach doesn't buy me any very
appreciable advantage.

Thanks,
Peter Geoghegan

pgsql-general by date:

Previous
From: Robert Gravsjö
Date:
Subject: Table partitioning
Next
From: Raymond O'Donnell
Date:
Subject: Re: [Windows] Feedback on PG?