[pgadmin-support] bug report - PgAdmin III 1.12.1

[Michael_Gerstein]

bug report
PgAdmin III 1.12.1
Windows 7
Greenplum (4.0.3.0) - definitions for external tables do not show column 
types anymore

It is working properly in 1.10.3 

___

The information contained in this message may be privileged and conf idential 
and protected from disclosure. If you are not the original intended recipient, 
you are hereby notified that any review, retransmission, dissemination, or 
other use of, or taking of any action in reliance upon, this information is 
prohibited. If you have received this communication in error, please notify the 
sender immediately by replying to this message and delete it from your 
computer. Thank you for your cooperation. Troika Dialog, Russia. 
If you need assistance please contact our Contact Center  (+7495) 258 0500 or 
go to www.troika.ru/eng/Contacts/system.wbp  

Re: [pgadmin-support] bug report - PgAdmin III 1.12.1

[Dave Page]

On Thu, Nov 11, 2010 at 11:05 AM,   wrote:
> bug report
> PgAdmin III 1.12.1
> Windows 7
> Greenplum (4.0.3.0) - definitions for external tables do not show column
> types anymore
>
> It is working properly in 1.10.3

As far as I know, no-one has tested GP 4 with pgAdmin. Does this work with 3.x?


-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] bug report - PgAdmin III 1.12.1

[Michael_Gerstein]

Version 1.10.3 works with GP 4 without problems. I do not have GP 3.x 
installed anymore


Regards,
M. Gerstein

Data and Performance Architect
IT Department, Troika Dialog
Tel: (+7 495) 258-0501, ext. 2206



Dave Page  
11.11.2010 14:13

To
michael_gerst...@troika.ru
cc
pgadmin-support@postgresql.org
Subject
Re: [pgadmin-support] bug report - PgAdmin III 1.12.1






On Thu, Nov 11, 2010 at 11:05 AM,   wrote:
> bug report
> PgAdmin III 1.12.1
> Windows 7
> Greenplum (4.0.3.0) - definitions for external tables do not show column
> types anymore
>
> It is working properly in 1.10.3

As far as I know, no-one has tested GP 4 with pgAdmin. Does this work with 
3.x?


-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


___

The information contained in this message may be privileged and conf idential 
and protected from disclosure. If you are not the original intended recipient, 
you are hereby notified that any review, retransmission, dissemination, or 
other use of, or taking of any action in reliance upon, this information is 
prohibited. If you have received this communication in error, please notify the 
sender immediately by replying to this message and delete it from your 
computer. Thank you for your cooperation. Troika Dialog, Russia. 
If you need assistance please contact our Contact Center  (+7495) 258 0500 or 
go to www.troika.ru/eng/Contacts/system.wbp  

[pgadmin-support] copy

[Little, Douglas]

Is it possible to have a grid select/copy and paste to excel include the column 
headers?

We're on 1.12.1  win/xp


Doug Little

Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide
500 W. Madison, Suite 1000  Chicago IL 60661| Office 312.260.2588 | Fax 
312.894.5164 | Cell 847-997-5741
douglas.lit...@orbitz.com
 [cid:image001.jpg@01CB818A.BA1CCA30]   orbitz.com | 
ebookers.com | 
hotelclub.com | 
cheaptickets.com | 
ratestogo.com | 
asiahotels.com

<>

Re: [pgadmin-support] copy

[Elizondo Julio César]

Use PGADMIN to have a grid select and export to excel.


JCE

De: pgadmin-support-ow...@postgresql.org 
[mailto:pgadmin-support-ow...@postgresql.org] En nombre de Little, Douglas
Enviado el: jueves, 11 de noviembre de 2010 01:25 p.m.
Para: pgadmin-support@postgresql.org
Asunto: [pgadmin-support] copy

Is it possible to have a grid select/copy and paste to excel include the column 
headers?

We're on 1.12.1  win/xp


Doug Little

Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide
500 W. Madison, Suite 1000  Chicago IL 60661| Office 312.260.2588 | Fax 
312.894.5164 | Cell 847-997-5741
douglas.lit...@orbitz.com
 [cid:image001.jpg@01CB81A4.D4F33780]   orbitz.com | 
ebookers.com | 
hotelclub.com | 
cheaptickets.com | 
ratestogo.com | 
asiahotels.com



Este correo electrónico puede contener información confidencial y protegida 
legalmente bajo secreto profesional y/o financiero. La información esta 
dirigida solamente a la persona o entidad indicada como destinatario y su 
acceso por cualquier otra persona no esta autorizado.
Si ud. ha recibido este mensaje electrónico por error, por favor infórmeselo al 
remitente y bórrelo. Los conceptos y opiniones contenidos en este mail 
corresponden al autor del mensaje y no necesariamente coinciden con las de 
Distribuidora de Gas Cuyana S.A.

Muchas Gracias.
Distribuidora de Gas Cuyana S.A.
<>

[pgadmin-support] Bug: Little mistake in comment in inheriting table

[Vojtěch Látal]

Hi,
just a little thing: I wanted to try inheriting. So I made a table
"del" which inherits from table "vehicles".

Create script follows:
-- Table: del

-- DROP TABLE del;

CREATE TABLE del
(
-- Inherited from table del:  id integer NOT NULL DEFAULT
nextval('vehicle_id_seq'::regclass),
-- Inherited from table del:  vin character varying(20) NOT NULL,
-- Inherited from table del:  licence_plate character varying(12) NOT NULL,
 a boolean
)
INHERITS (vehicles)
WITH (
 OIDS=FALSE
);
ALTER TABLE del OWNER TO gary;


It seems it should be "-- Inherited from table vehicles:" instead of
current "-- Inherited from table del:".

Version: 1.12.1 from Community repo
OS: ArchLinux, kernel 2.6.35
PostgreSQL: 9.0.1

Steps to reproduce:
1) (create database,) create table, put some columns into.
2) create another table from contextual menu, select "New Table..."
3) "New Table..." dialog opens, put some table name in, open "Inherits" tab
4) select table you created in 1), click Add
5) select "Columns" tab, add some column
6) create table by clicking "OK"
7) select newly created table from step 6) and in SQL pane you'll see
what I've included.

Thanks guys for huge piece of good work. I really appreciate what you are doing.


Regards
Vojtěch Látal

-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] Dependents show up twice?

[Guillaume Lelarge]

Hi,

Le 11/11/2010 17:18, Seifert, Jan-Peter a écrit :
>  [...]
> server version is:
> PostgreSQL 8.3.12, compiled by Visual C++ build 1400
>  
> I have dumped the schema via pgAdmin III 1.8.4 + 8.3 server binaries
> because pgAdmin 1.12.1 + server 9.0 binaries hangs.
>  

OK, I don't reproduce this on my laptop with your schema. No matter
which release I use (1.13 and 1.12). Unfortunately, I don't see which
commit could have fixed it.

But I'm not sure this is an actual bug. They show up twice because they
really are in both databases. Did you check both databases?


-- 
Guillaume
 http://www.postgresql.fr
 http://dalibo.com

-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] Bug: Little mistake in comment in inheriting table

[Guillaume Lelarge]

Le 11/11/2010 19:53, Vojtěch Látal a écrit :
> Hi,
> just a little thing: I wanted to try inheriting. So I made a table
> "del" which inherits from table "vehicles".
> 
> Create script follows:
> -- Table: del
> 
> -- DROP TABLE del;
> 
> CREATE TABLE del
> (
> -- Inherited from table del:  id integer NOT NULL DEFAULT
> nextval('vehicle_id_seq'::regclass),
> -- Inherited from table del:  vin character varying(20) NOT NULL,
> -- Inherited from table del:  licence_plate character varying(12) NOT NULL,
>  a boolean
> )
> INHERITS (vehicles)
> WITH (
>  OIDS=FALSE
> );
> ALTER TABLE del OWNER TO gary;
> 
> 
> It seems it should be "-- Inherited from table vehicles:" instead of
> current "-- Inherited from table del:".
> 

You're right. I pushed a fix for this. It fixes your specific issue.
Unfortunately, there is still an issue for table heriting columns from
more than one table. I'll work on that ASAP.


-- 
Guillaume
 http://www.postgresql.fr
 http://dalibo.com

-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support