Tom Lane wrote:
>"Marc Sherman" <msherman@projectile.ca> writes:
>> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
>>> Sounds like you have no pg_shadow entry for the postgres user.
>
>> No, that's not it:
...
>> This is strange, though -- the problem types have typowner set
>> to 103 in pg_type, which is clearly invalid. 103 happens to be
>> the Linux user ID (in passwd) for the postgres user. Strange.
>
>> I suspect this may be a problem with the Debian install scripts;
>> Debian is forcing postgres' user id to be 31 in the db, since it
>> used to use a reserved user id for postgres in the os.
Yes: this is a hangover from the old system which I can remove, since there
is no longer any point in it.
>Either that or a bug in initdb: it *should* substitute the same ID into
>postgres' pg_shadow entry as it does into the owner columns of the
>template1 system catalogs. Maybe it's getting confused. Oliver,
>any thoughts?
I can't see any bug in the initdb script. It looks straightforward.
Did the user perhaps delete and recreate the postgres user at some stage?
Then the hard-coded sysid in the installation would orphan user-created
functions when the database was upgraded.
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"But where shall wisdom be found? And where is the
place of understanding? It cannot be gotten for gold,
neither shall silver be weighed for the price thereof.
Whence then cometh wisdom? and where is the place of
understanding? ...Behold the fear of the Lord, that is
wisdom; and to depart from evil is understanding."
Job 12,15,20,28