Re: [HACKERS] WITH SYSID dropped

2006-11-06 Thread Dr. Ernst Molitor
es and regards, Ernst On Sunday, November 5th, 2006, 14:52 Stefan Kaltenbrunner wrote > Dr. Ernst Molitor wrote: > > Dear PostgreSQL gurus, > > > > > > The procedure still works, but due to the dropping of "WITH SYSID", > > moving the data to a new PostgreS

[HACKERS] WITH SYSID dropped

2006-11-05 Thread Dr. Ernst Molitor
Dear PostgreSQL gurus, having read through the thread on the topic cited above, I still think the change - however well-founded it may be - carries a problem: That of an upgrade on installations that relied on the statement. Currently, I'm preparing to switch a PostgreSQL-8.0.3-installation to

[HACKERS] function to return pg_user.usesysid

2003-02-07 Thread Dr. Ernst Molitor
Dear PostgreSQL developers, as far as I know, there is no function available to directly access the user id (pg_(shadow|user).usesysid) of the current database user, while the user's name is easily available (function current_user). For a couple of databases I'm using or designing, it is neces