Re: [ADMIN] Crash

2001-03-14 Thread Tom Lane
"John W Cunningham" <[EMAIL PROTECTED]> writes: > I ran the test - can anyone tell me what these results mean and how I can > fix it? The diffs look like locale issues --- specifically, I'd say that your server is running in en_US or some other locale with ISO-like sorting rules for strings. I a

RE: [ADMIN] Crash

2001-03-14 Thread John W Cunningham
I ran the test - can anyone tell me what these results mean and how I can fix it? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tom Lane Sent: Wednesday, March 14, 2001 12:02 PM To: John W Cunningham Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] Crash "J

[ADMIN] funny permission

2001-03-14 Thread Metzidis, Anthony
why does this happen: grant select on table1 to user1; grant insert,update,select,delete on table2 to user1; insert into table2 select * from table1; error: table1: Permission Denied ? Do I need write permission on a table to do an insert into ...select... on it? --tony -

RE: [ADMIN] Crash

2001-03-14 Thread John W Cunningham
I can't even find the source file, I really need to see what these guys used when installing. -JOhn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tom Lane Sent: Wednesday, March 14, 2001 12:02 PM To: John W Cunningham Cc: [EMAIL PROTECTED] Subject: Re:

Re: [ADMIN] Crash

2001-03-14 Thread Tom Lane
"John W Cunningham" <[EMAIL PROTECTED]> writes: > How do I run the regression tests? See http://www.postgresql.org/users-lounge/docs/7.0/postgres/regress.htm regards, tom lane ---(end of broadcast)--- TIP 3: if posting/read

RE: [ADMIN] Crash

2001-03-14 Thread John W Cunningham
The server was installed by my ISP for me (when I install it's from a GreatBridge rpm). How do I run the regression tests? -John -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 9:59 AM To: John W Cunningham Cc: [EMAIL PROTECTED] Subject: Re:

Re: [ADMIN] Crash

2001-03-14 Thread Tom Lane
"John W Cunningham" <[EMAIL PROTECTED]> writes: > psql: ERROR: cannot find attribute 1 of relation pg_proc_oid_index This sounds like there's something pretty fundamentally broken. Did you build your executables yourself (if so, with what compiler and what configuration options) or grab an RPM

Re: [ADMIN] Authentication Problems

2001-03-14 Thread Peter Eisentraut
Graham Vickrage writes: > host all 127.0.0.1 255.255.255.0ident sameuser > host all 0.0.0.0 0.0.0.0 password > > I assumed that the above would solve my problem, which it only half manages. > The local client connections are worki

[ADMIN] Crash

2001-03-14 Thread John W Cunningham
Hello All, I'm pretty new to Postgres, but have managed to build a substantial site on it. I built the entire thing locally on some dev servers, and then put it online. The production DB server is a superb machine (twin PIII Ghz, 2 gigs RAM) so it should be able to handle anything my dev server

[ADMIN] Re: Authentication Problems

2001-03-14 Thread J.H.M. Dassen (Ray)
Graham Vickrage <[EMAIL PROTECTED]> wrote: >HOWEVER when I connect via an internet site Please define "connect via an internet site". Do you a) connect using a PostgreSQL client (e.g. "psql") on a remote host, or b) connect using HTTP to a server which executes CGI scripts that run on the serv

[ADMIN] Authentication Problems

2001-03-14 Thread Graham Vickrage
Hi all, I have a problem that may not be directly to do with postgres but I can't seem to figure it out. I have a linux redhat server with apache and postgres 7.0 runing on the same machine. I am trying to sort out authentication so that local clients can connect to the databases using 'ident sa