SEO

________________________________

From: pgadmin-support-owner@postgresql.org
[mailtogadmin-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"


This should be fine in the latest snapshot:
http://developer.pgadmin.org/snapshots/win32/

Regards, Dave.

I tryed the version of
http://developer.pgadmin.org/snapsho...0921-Win32.zip but
nothing better appears.

I am still with problem to insert via pgAdmin.

Still waitting for any other suggestion ?


Regards
Ezequias

2006/9/27, Dave Page <dpage@vale-housing.co.uk>:
>
>
>
> ------------------------------
> *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"
>
>
> This should be fine in the latest snapshot:
> http://developer.pgadmin.org/snapshots/win32/
>
> Regards, Dave.
>



--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
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/snapsho...0921-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



---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

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


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

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';


2006/10/2, Hiroshi Saito <z-saito@guitar.ocn.ne.jp>:
>
> 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
>
>


--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
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



---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings