Re: [HACKERS] Getting table name/tuple from OID
huaxin zhang napisał(a): Hi all, I am interested in the answer as well -- how to get a table name (or an operator name) from an OID.the parser must know how to do this, but the segment of code is hard to locate. CREATE OR REPLACE FUNCTION gettablename(__oid oid) RETURNS varchar AS $BODY$ SELECT (_sna.nspname || '.' || _tna.relname) AS tableQualifiedName FROM pg_class _tna, pg_namespace _sna WHERE _tna.oid = $1 AND _sna.oid = _tna.relnamespace; $BODY$ LANGUAGE 'sql' IMMUTABLE; ALTER FUNCTION gettablename(__oid oid) OWNER TO root; ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [HACKERS] [pgsql-advocacy] Not 7.5, but 8.0 ?
Uytkownik Shachar Shemesh napisa: Dave Page wrote: Right, but not having the luxury of time travel (wasn't that removed in Postgres95? ;-) ) we can only go by what the majority think. We won't know if it's actually right unless we try it. We could run a survey saying 'would you use PostgreSQL on win32', but the chances are that the vast majority of potential win32 users would not visit the site to answer that until it became widely know that we do support win32, by which time of course it's all a bit moot. Unless of course, you have other stats that prove that win32 support is uninteresting to most people and potential users? Regards, Dave. I'm sorry if I'm being alow here - is there any problem with running a production server on cygwin's postgresql? Is the cygwin port of lesser quality, or otherwise inferior? Performance, performance, perfomance... and perfomance... it is (almost) always worse perfomance when we emulate something... and using Cygwin we are emulating U*nix... ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] [pgsql-advocacy] Not 7.5, but 8.0 ?
Uz.ytkownik Andrew Dunstan napisa?: Claudio Natoli wrote: As for release numbering, ISTM that is not fundamentally very important. At my former company we had code names for branches and decided release names/numbers near release time in accordance with marketing requirements. Let's not get hung up on nominalism. A release number is just a tag and we can call it whatever seems good at the time. Maybe it's a good time to think about PostgreSQL's marketing strategy identity. Maybe this great DBMS should be changed in all areas - not only in technical related fields ? ML ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] [pgsql-advocacy] Not 7.5, but 8.0 ?
Uz.ytkownik Jean-Michel POURE napisa?: For me, this makes 60% of the market at least. A 1% to 60% is not a small difference, it is a real gap. Don't forget that success isn't always connected with technical things (very good example is MySQL :-)) - PostgreSQL needs a good marketing, clear strategy and identity. But for sure Win32 port will be a huge step. There are other databases which have Win32 native version and aren't so popular (like Firebird...)... So my proposition to PostgreSQL's team is to think also about SMI - Strategy Marketing Identity... ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
