Re: [ADMIN] [DBmirror Issue] recordchange() dies in packageData unless there is a PRIMARY KEY on DELETE and UPDATEs.

2002-09-24 Thread Mark McEahern
[Rajesh Kumar Mallah] > Hi can you help me with applying the patch > i dunno much abt patch > > # patch -p0 < patch > patch: malformed patch at line 7: PRIMARY); It looks like a context patch. patch --help should tell you how to apply a context patch. It will also tell you the basic syntax

Re: [ADMIN] time stamp

2002-06-20 Thread Mark McEahern
To be fair, you really ought to ask this question: Suppose user A sets up a conference call with users B, C, and D, who each live in: A: Tokyo B: Denver C: San Diego D: New York The meeting is to occur at 1:00 PM tokyo time. (Never mind for now whether that make

Re: [ADMIN] pg_shadow

2002-06-06 Thread Mark McEahern
[Kasper] > Do i have to create the pg_shadow table myself or how do i do, > the password auth is not worjing. > > and i think i need HELP... It would help if you were a little more specific: 1. What exactly are you doing? 2. What exactly do you mean by "is not working"? Have you modified pg_h

Re: [ADMIN] Forgot admin pw on initialization/install RH 7.3/PGSQL7.2

2002-05-23 Thread Mark McEahern
[Jeff Kowalczyk] > I made a dumb mistake, and forgot to write down the autogenerated > administrator password when I first started the Postgres database on > RedHat 7.3. I'm having a hard time finding information on how to do this > online, and it's a tricky term to search the archives for, as wel

Re: [ADMIN] configure datatype name > 31?

2002-05-06 Thread Mark McEahern
Sorry, this is a duplicate sent before I subscribed to the group--it was stalled, so I resent after subscribing. This question has been answered. Thanks, // mark > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Mark McEahern > Sent:

[ADMIN] configure datatype name > 31?

2002-05-06 Thread Mark McEahern
Hi, the name datatype, which is used at least here: pg_database.datname pg_shadow.usename is a 31 character field. That seems awfully low. For instance, what if I'm silly enough to want to make a database named: customer_GUID where GUID is something like: 0ff

[ADMIN] configure datatype name > 31?

2002-05-03 Thread Mark McEahern
Is there a way to configure PostgreSQL to make the name field larger? The name datatype, which is used for these two columns in these system tables: pg_database.datname pg_shadow.usename is a 31 character field. That seems awfully low. For instance, what if I'm silly enough to