Re: [pgadmin-support] Error Message

[Dave Page]

Title: Message

Hmm, works OK here. Can I have the debug log please?

 

Regards, Dave.

-----Original Message-----
From: Marcia Bussolaro [mailto:[EMAIL PROTECTED]
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.