Re: [HACKERS] CVS repository invalid revision

2008-02-17 Thread Christian Robottom Reis
On Sat, Feb 16, 2008 at 08:28:42PM +0100, Peter Eisentraut wrote: > Christian Robottom Reis wrote: > > I'm running a conversion of PostgreSQL's CVS repository, but I'm > > stuck on a revision that cscvs fails to parse. > > I can't quite answer that particular question, but there are already so

Re: [HACKERS] Replacing time_t fields in pg_control and elsewhere

2008-02-17 Thread Zdenek Kotala
Tom Lane napsal(a): pg_time_t: only one-second resolution. Also, since this is typedef'd as int64, the field-width problem comes right back to haunt us on machines where INT64_IS_BROKEN. On the other hand, it's not clear that there are any such machines anymore, and furthermore such a machin

Re: [HACKERS] NetBSD/dtime_t

2008-02-17 Thread Michael Meskes
On Sat, Feb 16, 2008 at 09:15:24AM -0500, Tom Lane wrote: > Does it have to be a typedef, rather than a #define? > I'm thinking that you could forcibly include sys/types.h > and then it would be safe to #define dtime_t the way you want. I just committed a patch that does more or less what you sugg

Re: [HACKERS] Doubt in IndexScanDescData

2008-02-17 Thread Gregory Stark
One thing you might be missing is that indexes are relations too. They're a bit different than heap relations (ie "tables") but they share enough structure that it's worth using the same datatypes to represent both. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me

Re: [HACKERS] Doubt in IndexScanDescData

2008-02-17 Thread Hans-Juergen Schoenig
take a look at that ... http://www.postgresql.org/docs/8.3/static/indexam.html this might clear up the problem. here is an example making clear what happens: select phone_number from phonebook where name = 'xy'; index is asked to find the right place in the heap to retrieve the data. t

Re: [HACKERS] Doubt in IndexScanDescData

2008-02-17 Thread Suresh
Hans-Juergen Schoenig <[EMAIL PROTECTED]> wrote: On Feb 17, 2008, at 4:33 PM, Suresh wrote: [ "include/access/relscan.h" ] In IndexScanDescData, whats the purpose of having two Relation variables. typedef struct IndexScanDescData { RelationheapRelation; /* heap relation des

Re: [HACKERS] Doubt in IndexScanDescData

2008-02-17 Thread Hans-Juergen Schoenig
On Feb 17, 2008, at 4:33 PM, Suresh wrote: [ "include/access/relscan.h" ] In IndexScanDescData, whats the purpose of having two Relation variables. typedef struct IndexScanDescData { RelationheapRelation; /* heap relation descriptor, or NULL */ Relation

[HACKERS] Doubt in IndexScanDescData

2008-02-17 Thread Suresh
[ "include/access/relscan.h" ] In IndexScanDescData, whats the purpose of having two Relation variables. typedef struct IndexScanDescData { RelationheapRelation; /* heap relation descriptor, or NULL */ RelationindexRelation; /* index relation descriptor */ ...

Re: [HACKERS] Show INHERIT in \du

2008-02-17 Thread Brendan Jurd
I've done up a patch per Tom's idea of combining the binary role attributes into a single column. Each attribute which differs from the default is listed on a separate line, like so: List of roles Role name | Attributes | Member of -++-