Thread: Bug report on insert with pgadmin

Hi list,

I am trying to insert a new row with the 'pgadmin 1.6 beta 1' and I got the following error:

My procedure was rignt click on the table and choose "vew data > View all rows"


See my attach file.

Could someone help me ?

Sincerely

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
                                  Atenciosamente (Sincerely)
                        Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/

---

From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Ezequias Rodrigues da Rocha
Sent: 27 September 2006 14:16
To: pgAdmin Support
Subject: [pgadmin-support] Bug report on insert with pgadmin

Hi list,

I am trying to insert a new row with the 'pgadmin 1.6 beta 1' and I got the following error:

My procedure was rignt click on the table and choose "vew data > View all rows"
 

I tryed the version of http://developer.pgadmin.org/snapshots/win32/pgadmin3-20060921-Win32.zip but nothing better appears.

I am still with problem to insert via pgAdmin.

Still waitting for any other suggestion ?


Regards
Ezequias




--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
                                  Atenciosamente (Sincerely)
                        Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/

Hi.

----- Original Message ----- 
From: Ezequias Rodrigues da Rocha

> I tryed the version of http://developer.pgadmin.org/snapshots/win32/pgadmin3-20060921-Win32.zip but nothing better 
> appears.
>
> I am still with problem to insert via pgAdmin.
>
> Still waitting for any other suggestion ?

Although I do not understand the circumstances in question, what table definition is it?
I expect that a key cannot be specified. Probably, What kind message does it display?

Regards,
Hiroshi Saito 

The error message is this one




--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
                                  Atenciosamente (Sincerely)
                        Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/

Hi.

From: Ezequias Rodrigues da Rocha 

> The error message is this one.

Umm, Something is strange....
Please tell about a table definition and an input character that I can reproduce it.

Regards,
Hiroshi Saito

The table definition is right below:

id bigint NOT NULL,
  codigo integer,
  quando timestamp without time zone,
  inicio_venda timestamp without time zone,
  final_venda timestamp without time zone,
  inicio_entrada timestamp without time zone,
  final_entrada timestamp without time zone,
  estado integer,
  descricao character varying(255),
  bilhete_sequencia bigint,
  evento_id bigint,
  local_id bigint,
  mapa_id bigint,
  CONSTRAINT sessao_pkey PRIMARY KEY (id),
  CONSTRAINT fkca0297e012b92bfc FOREIGN KEY (local_id)
      REFERENCES base."local" (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT fkca0297e02ed86538 FOREIGN KEY (mapa_id)
      REFERENCES base.mapa (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT fkca0297e0829aabb8 FOREIGN KEY (evento_id)
      REFERENCES base.evento (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITHOUT OIDS;
ALTER TABLE base.sessao OWNER TO root;
COMMENT ON TABLE base.sessao IS 'Sessões dos Eventos';





--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
                                  Atenciosamente (Sincerely)
                        Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/

Hi Ezequias.

My experiment is this. 
The definition of a table is changed a little.
http://www.winpg.jp/~saito/pgAdmin/pgAdmin3_test1.png
http://www.winpg.jp/~saito/pgAdmin/pgAdmin3_test2.png
http://www.winpg.jp/~saito/pgAdmin/pgAdmin3_test3.png
http://www.winpg.jp/~saito/pgAdmin/pgAdmin3_test4.png

Although I may be having missed something, it is completed normally....
My pgAdmin3 1.6 Beta1 (Sep 27 2006,rev)

Regards,
Hiroshi Saito

----- Original Message ----- 
From: Ezequias Rodrigues da Rocha 

---

From: Ezequias Rodrigues da Rocha [mailto:ezequias.rocha@gmail.com]
Sent: 03 October 2006 12:14
To: Hiroshi Saito
Cc: Dave Page; pgAdmin Support
Subject: Re: [pgadmin-support] Bug report on insert with pgadmin

Hiroshi,

Thank you for your information. I noticed you are using a newer version than me. Where did you get this version ?

Here is an attached image of my version Sept 12.
 

Thank you Dave, I installed in that time and notthing occurs, now it is working. Maybe something on instalation in that time.

I remember I was uninstalling at the same time I install the new version or leave both installed.

Now is OK thank you both. I think I will give a break to putty.

Now I think a popup menu to delete a selected row is very important now.

My best Regards
Ezequias



--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
                                  Atenciosamente (Sincerely)
                        Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/

Hi Ezequias.

From: "Ezequias Rodrigues da Rocha"
(snip)
> Now I think a popup menu to delete a selected row is very important now.

Does this realize your hope?:-)
http://inet.winpg.jp/~saito/pgAdmin/pgAdmin3_EditGrid_popup.png
(Sorry it is japanese)
There is not whose objection, and either I will apply it.

Regards,
Hiroshi Saito

> -----Original Message-----
> From: Hiroshi Saito [mailto:z-saito@guitar.ocn.ne.jp]
> Sent: 05 October 2006 05:14
> To: Dave Page; Ezequias Rodrigues da Rocha
> Cc: pgadmin-hackers@postgresql.org; pgAdmin Support
> Subject: Re: [pgadmin-support] Bug report on insert with pgadmin
>
> Hi Ezequias.
>
> From: "Ezequias Rodrigues da Rocha"
> (snip)
> > Now I think a popup menu to delete a selected row is very
> important now.
>
> Does this realize your hope?:-)
> http://inet.winpg.jp/~saito/pgAdmin/pgAdmin3_EditGrid_popup.png
> (Sorry it is japanese)
> There is not whose objection, and either I will apply it.

I object.

1) It's a new feature and we are well past feature freeze.

2) If we are going to add a context menu in the future we should think
about it and create one with all the appropriate row-related operations
(such as copy for example) in one go.

Regards, Dave.

Hi.

> > Does this realize your hope?:-)
> > http://inet.winpg.jp/~saito/pgAdmin/pgAdmin3_EditGrid_popup.png
> > (Sorry it is japanese)
> > There is not whose objection, and either I will apply it.
>
> I object.
>
> 1) It's a new feature and we are well past feature freeze.

Ahh, yes...

> 2) If we are going to add a context menu in the future we should think
> about it and create one with all the appropriate row-related operations
> (such as copy for example) in one go.

Um, It is to have the function of insert/copy/cut/paste/deletion.
Certainly, they did not provide with the key operation now.
It might be TODO though it is regrettable.... hopefully it.

Regards,
Hiroshi Saito

I expected this Japanese Kanji means Delete :)

Who implemented it you ? Why not integrate it to pgAdmin ?

Regards
Ezequias




--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
                                  Atenciosamente (Sincerely)
                        Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/