Re: Default Values

2002-01-30 Thread Dave Page
> -Original Message- > From: George T. Gibson [mailto:[EMAIL PROTECTED]] > Sent: 30 January 2002 21:54 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] Default Values > > > Having some trouble with default values. > > My table already exists. I want to update default values so

Re: Consistent page fault in pgadmin2 1.2.0

2002-01-30 Thread Dave Page
> -Original Message- > From: Thomas Sandford [mailto:[EMAIL PROTECTED]] > Sent: 30 January 2002 17:15 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] Consistent page fault in pgadmin2 1.2.0 > > > I can get a consistent crash in pgadmin2 v1.2.0 by setting > "View System Objects"

Default Values

2002-01-30 Thread George T. Gibson
Having some trouble with default values. My table already exists. I want to update default values so I go to the table properties box and enter the new value for date - CURRENT_DATE. Clicked OK and in the Log view I get: 1/30/2002 4:42:43 PM - SQL (jbsdata): ALTER TABLE "note" ALTER COLU

Re: attribute 'datlastsysoid' not found

2002-01-30 Thread Leonardo Junquera
I think this is related to the same problem I was having before. I'm running the wrong installation of postgres. I have installed 7.1.1 in /usr/local/ and i see that /etc/rc.d/init.d/postgresql is looking in the /var/lib/pgsql to start postgres. I'll have to go through the file and point it

Consistent page fault in pgadmin2 1.2.0

2002-01-30 Thread Thomas Sandford
I can get a consistent crash in pgadmin2 v1.2.0 by setting "View System Objects" on and trying to view the data in the pg_index table. Whilst this may well come into the category of "I hurts when I do this" - "Don't do it then", I thought I'd report it... Running under Windows 98. The associate

Re: attribute 'datlastsysoid' not found

2002-01-30 Thread Dave Page
> -Original Message- > From: Leonardo Junquera [mailto:[EMAIL PROTECTED]] > Sent: 30 January 2002 16:34 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] attribute 'datlastsysoid' not found > > > Dave, thanks. That seemed to work now I'm getting: > > An error has occured in pgAdm

attribute 'datlastsysoid' not found

2002-01-30 Thread Leonardo Junquera
Dave, thanks. That seemed to work now I'm getting: An error has occured in pgAdmin II: frmConnect.cmdConnect_Click: Number: -2147467259 Description: Error while executing the query; ERROR: attribute 'datlastsysoid' not found Any suggestions.

Re: connection problems due to authentication

2002-01-30 Thread Dave Page
> -Original Message- > From: Leonardo Junquera [mailto:[EMAIL PROTECTED]] > Sent: 30 January 2002 15:30 > To: [EMAIL PROTECTED] > Subject: Re: [pgadmin-support] connection problems due to > authentication > > > Sorry. > > host sbm 192.168.0.2 255.255.255.255 password leoj T

Re: connection problems due to authentication

2002-01-30 Thread Leonardo Junquera
Sorry. host sbm 192.168.0.2 255.255.255.255 password leoj -- Original Message -- From: Dave Page <[EMAIL PROTECTED]> Date: Wed, 30 Jan 2002 15:30:54 - > > >> -Original Message- >> From: Leonardo Junquera [mailto:[EMAIL PROTECTED]] >>

Re: connection problems due to authentication

2002-01-30 Thread Dave Page
> -Original Message- > From: Leonardo Junquera [mailto:[EMAIL PROTECTED]] > Sent: 30 January 2002 14:12 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] connection problems due to authentication > > > Now I am getting this error: > > An error has occured in pgAdmin II: frmConnect

connection problems due to authentication

2002-01-30 Thread Leonardo Junquera
Now I am getting this error: An error has occured in pgAdmin II: frmConnect.cmdConnect_Click: Number: -2147217843 Description: Password authentication failed for user 'leoj' I am a user in the database and have set the password to the one I am using when trying to connect. I looked in the