Create user is failing under 6.5

Started by Michael Davisalmost 27 years ago3 messages
#1Michael Davis
michael.davis@prevuenet.com

CREATE USER sarah;
ERROR: Bad abstime external representation ''

The back end will fail with the next sql call:

CREATE USER sarah;
NOTICE: (transaction aborted): all queries ignored until end of transaction
block
*ABORT STATE*

Am I missing something?

Thanks, Michael

#2Peter Mount
petermount@it.maidstone.gov.uk
In reply to: Michael Davis (#1)
RE: [HACKERS] Create user is failing under 6.5

I have seen this before. I've simply got round it by adding the valid
until date.

Peter

--
Peter T Mount, IT Section
petermount@it.maidstone.gov.uk
Anything I write here are my own views, and cannot be taken as the
official words of Maidstone Borough Council

-----Original Message-----
From: Michael Davis [mailto:michael.davis@prevuenet.com]
Sent: Tuesday, March 30, 1999 6:04 AM
To: hackers@postgreSQL.org
Subject: [HACKERS] Create user is failing under 6.5

CREATE USER sarah;
ERROR: Bad abstime external representation ''

The back end will fail with the next sql call:

CREATE USER sarah;
NOTICE: (transaction aborted): all queries ignored until end of
transaction
block
*ABORT STATE*

Am I missing something?

Thanks, Michael

#3James Thompson
jamest@math.ksu.edu
In reply to: Peter Mount (#2)
RE: [HACKERS] Create user is failing under 6.5

I hit it too. You can create the user with the createuser utility in a
shell. Might still explain some backend crashes for me though.

On Tue, 30 Mar 1999, Peter Mount wrote:

I have seen this before. I've simply got round it by adding the valid
until date.

Peter

->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<
James Thompson 138 Cardwell Hall Manhattan, Ks 66506 785-532-0561
Kansas State University Department of Mathematics
->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<