Re: [HACKERS] alter user problem

2002-12-19 Thread Christopher Kings-Lynne
You need to go:   ALTER USER "EDU" WITH PASSWORD '';   Since you have used an uppercase name, you will always need to double quote it.   Chris -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of postgresqlSent: Friday, 20 December 2002 10:

[HACKERS] alter user problem

2002-12-19 Thread postgresql
Hi all I have install Postgresql 7.3 with user name EDU.then I enter the psql to change the password for EDU using "alter user EDU with password '''it returns " user EDU do not exist".I check the system table pg_user, and the user 'EDU' actually exists.But if I take the following S

Re: [HACKERS] What else needs to be done for 7.3.1?

2002-12-19 Thread Oliver Elphick
On Thu, 2002-12-19 at 18:40, Robert Treat wrote: > On Thu, 2002-12-19 at 12:58, Bruce Momjian wrote: > > OK, what additional things need to be done for 7.3.1? As far as I know, > > we have done everything. > > > > Do we want to coordinate with Lamar or Oliver about having packages > ready to coi

Re: [HACKERS] 7.3.1 documentation updates

2002-12-19 Thread Peter Eisentraut
Tom Lane writes: > If someone's willing to do the work of regenerating the doc tarballs, > I think it would be a real good idea to update them for minor releases. They are being updated, they have been for quite a while, and there's no one volunteering because it's done rather automatically. (Th

Re: [HACKERS] v7.3.1 tar ready ... please check it ...

2002-12-19 Thread Peter Eisentraut
Bruce Momjian writes: >Note: If you are upgrading an existing system and are going to >install the new files over the old ones, then you should have >backed up your data and shut down the old server by now, as >explained in the Section called If You

Re: [HACKERS] user defined settings (aka user defined guc variables)

2002-12-19 Thread Peter Eisentraut
Joe Conway writes: > I'm wondering whether it would be "a good thing" or "a bad thing" to have > unrecognized settings found in postgresql.conf be registered as user defined > settings? Certainly bad, since all error checking would go away. This is one of the main reasons why registering setting

Re: [HACKERS] 7.3.1 Changes

2002-12-19 Thread Bruce Momjian
We have not officially released 7.3.1 yet. It will be this weekend. Here is the list. --- Release Notes Release 7.3.1 Release date: 2002-12-18 This h

[HACKERS] 7.3.1 Changes

2002-12-19 Thread Greg Stark
Was there a list of changes in 7.3.1 posted? -- greg ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing l

Re: [HACKERS] v7.3.1 tar ready ... please check it ...

2002-12-19 Thread Bruce Momjian
Kevin Brown wrote: > Tom Lane wrote: > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > OK, I agree it should be bumped up, but the issue is whether to do that > > > in a minor release. It will increase shared memory by 36k. Is that > > > safe in a beta? Tom, Mr. FSM, can you comment? > > > >

Re: [HACKERS] What else needs to be done for 7.3.1?

2002-12-19 Thread Robert Treat
On Thu, 2002-12-19 at 12:58, Bruce Momjian wrote: > OK, what additional things need to be done for 7.3.1? As far as I know, > we have done everything. > Do we want to coordinate with Lamar or Oliver about having packages ready to coincide with the release announcement? Robert Treat --

Re: [HACKERS] v7.3.1 tar ready ... please check it ...

2002-12-19 Thread Kevin Brown
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > OK, I agree it should be bumped up, but the issue is whether to do that > > in a minor release. It will increase shared memory by 36k. Is that > > safe in a beta? Tom, Mr. FSM, can you comment? > > It seems a reasonably safe change

[HACKERS] What else needs to be done for 7.3.1?

2002-12-19 Thread Bruce Momjian
OK, what additional things need to be done for 7.3.1? As far as I know, we have done everything. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be y

Re: [HACKERS] [GENERAL] Table Timemachine!

2002-12-19 Thread Tom Lane
Lee Kindness <[EMAIL PROTECTED]> writes: > Tom Lane writes: >>> Lee Kindness <[EMAIL PROTECTED]> writes: I have a nagging feeling that somebody has at one point put together such a feature in a generic fashion... I thought there was a 'time machine' module in contrib! >>> contrib/sp

Re: [HACKERS] [GENERAL] Table Timemachine!

2002-12-19 Thread Lee Kindness
Tom Lane writes: > Lee Kindness <[EMAIL PROTECTED]> writes: > > I have a nagging feeling that somebody has at one point put together > > such a feature in a generic fashion... I thought there was a 'time > > machine' module in contrib! > contrib/spi/timetravel.* > I haven't ever tried it ...

Re: [HACKERS] v7.3.1 tar ready ... please check it ...

2002-12-19 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > OK, I agree it should be bumped up, but the issue is whether to do that > > in a minor release. It will increase shared memory by 36k. Is that > > safe in a beta? Tom, Mr. FSM, can you comment? > > It seems a reasonably safe change

Re: [HACKERS] v7.3.1 tar ready ... please check it ...

2002-12-19 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > OK, I agree it should be bumped up, but the issue is whether to do that > in a minor release. It will increase shared memory by 36k. Is that > safe in a beta? Tom, Mr. FSM, can you comment? It seems a reasonably safe change, but I too am concerned abo

Re: [HACKERS] please apply patch to CVS ( 7.3 and 7.4dev)

2002-12-19 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches I will try to apply it within the next 48 hours. --- Oleg Bartunov wrote: > Small fix in docum

Re: [HACKERS] v7.3.1 tar ready ... please check it ...

2002-12-19 Thread Bruce Momjian
scott.marlowe wrote: > On Thu, 19 Dec 2002, Philip Warner wrote: > > > At 10:49 PM 18/12/2002 -0500, Bruce Momjian wrote: > > >I don't think we can bump that up in a minor. > > > > Why not? It's a relatively serious problem with the default config. > > > > > > >Should we? > > > > Yes. > > I c

Re: [HACKERS] v7.3.1 tar ready ... please check it ...

2002-12-19 Thread scott.marlowe
On Thu, 19 Dec 2002, Philip Warner wrote: > At 10:49 PM 18/12/2002 -0500, Bruce Momjian wrote: > >I don't think we can bump that up in a minor. > > Why not? It's a relatively serious problem with the default config. > > > >Should we? > > Yes. I concur. The problems of a too-low fsm setting a

Re: [HACKERS] link to latest on ftp-site

2002-12-19 Thread Bruce Momjian
Uh, we are not sure if we have released 7.3.1 yet. :-0 There are some doc change that folks wanted, so we aren't announcing it yet. --- Tommi Maekitalo wrote: > Hi, > > the link to latest version points to the currently

Re: [HACKERS] [JDBC] Conversion between UNICODE and LATIN1 is not supported

2002-12-19 Thread Andreas Joseph Krogh
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 19 December 2002 16:09, you wrote: > Hello, > > Do you have other databases that work with UNICODE? You can check the > encoding of all your databases with 'psql -l'. You can check if you can > create any unicode databases with 'createdb -E

[HACKERS] please apply patch to CVS ( 7.3 and 7.4dev)

2002-12-19 Thread Oleg Bartunov
Small fix in documentation and some examples of usage. Please, apply to 7.3 and current CVS Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University

[HACKERS] link to latest on ftp-site

2002-12-19 Thread Tommi Maekitalo
Hi, the link to latest version points to the currently empty source/v7.3.1. Tommi -- Dr. Eckhardt + Partner GmbH http://www.epgmbh.de ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail