Re: Error Message - Mailing list pgadmin-support

From Dave Page
Subject Re: Error Message
Date
Msg-id 03AF4E498C591348A42FC93DEA9661B844AF32@mail.vale-housing.co.uk
Whole thread Raw
In response to Error Message  ("Marcio Pugina" <mpugina@ucoast.com>)
List pgadmin-support
Hmm, works OK here. Can I have the debug log please?
 
Regards, Dave.
-----Original Message-----
From: Marcia Bussolaro [mailto:marcia@lojafacil.com.br]
Sent: 28 May 2003 18:53
To: Dave Page
Subject: RE: [pgadmin-support] Error Message

Hi Dave,

        The query is:
CREATE TABLE teste (
  codigo int2 NOT NULL,
  nome varchar(500),
  endereco varchar(500),
  tutu numeric(15, 2),
 
CONSTRAINT teste_pkey PRIMARY KEY (codigo)
) WITH OIDS;

        I click in "View Data", "Add" and I insert 2 records:
Code            Nome            Endereco        Tutu
1                                               10.2
2                                               10.25

        When I tried to insert record with code 3, appeared the error. Then, I tried to insert record with code 4 and then appear the error below.

[]'s
Marcia

At 16:19 28/05/2003 +0100, you wrote:

Hi,

> Description:  ERROR:  pg_atoi: error in "4
> 3": can't parse "
> 3"
> Number:               -2147467259
> Routine:              pgAdmin II:frmSQLOutput.cmdSave_Click
>
> ************************************************************
>
> Insert your comment:
> 1) In the table doesn't exist code 3 or 4, only code 1 and 2.
> Code is a
> field that is a primary_key;

What was the SQL query in the dialogue? If cyou can reproduce it, please
send a full debug log of the error occuring (log settings are under
tools -> Options.

> 2) In the message box, if I click "Exit", the pgAdmin close
> !!! I tought
> that the message box would go to close :-)))

'Continue' makes it go away and carry on, 'Exit' exits the application.

Regards, Dave.

pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Error Message
Next
From: "Frankie Lam"
Date:
Subject: Error Message