Re: [SQL] Re: [SQL] Relator io da composiçao de FKs e PKs

2009-03-19 Thread Alvaro Herrera
Oliveiros Cristina wrote: > Escreve a tua dúvida em inglês, por favor, isto é uma lista de mailing em > ingles. Isn't there a portuguese mailing list? Should one be created? -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt,

[SQL] Re: [SQL] Relatorio da composiçao de FKs e PKs

2009-03-19 Thread Oliveiros Cristina
Escreve a tua dúvida em inglês, por favor, isto é uma lista de mailing em ingles. He wants to do a report with the composition of each foreign key and primary key, not just their names. He wants to know where postgres keeps that in catalog. Best, Oliveiros - Original Message - From

[SQL] Relatorio da composiçao de FKs e PKs

2009-03-19 Thread paulo matadr
Bom tarde mais um vez , minha intensao era fazer um relatorio da composicao de cada fk e pk( nao apenas seu nome),alguem sabe onde o postgres guarda isso no catalogo. Abraço a todos. Veja quais são os assuntos do momento no Yahoo! +Buscados http://br.maisbuscados.yahoo.com

Re: [SQL] alter column from varchar(32) to varchar(255) without view re-creation

2009-03-19 Thread Emi Lu
PostgreSQL 8.0.15. Is there a way that I can easily alter column type from varchar(32) to varchar(255) but do not have to worry about views dependent on it? You should test it carefully and it is considered a bad practice - I'll probably get sued for recommending this :-), but you may try: SEL

Re: [SQL] alter table on a large db

2009-03-19 Thread Scott Marlowe
On Thu, Mar 19, 2009 at 1:57 AM, Zdravko Balorda wrote: > > Hi, > > I need to make some ALTER TABLEs. It takes about 30min to copy > this quite large databse, bat several ours to run a bunch of ALTER > TABLE statements. > Is there any way to make it faster? I wonder what could possibly alter table

Re: [SQL] alter table on a large db

2009-03-19 Thread Achilleas Mantzios
Στις Thursday 19 March 2009 09:57:11 ο/η Zdravko Balorda έγραψε: > > Hi, > > I need to make some ALTER TABLEs. It takes about 30min to copy > this quite large databse, bat several ours to run a bunch of ALTER > TABLE statements. > Is there any way to make it faster? I wonder what could possibly a

[SQL] alter table on a large db

2009-03-19 Thread Zdravko Balorda
Hi, I need to make some ALTER TABLEs. It takes about 30min to copy this quite large databse, bat several ours to run a bunch of ALTER TABLE statements. Is there any way to make it faster? I wonder what could possibly alter table be doing all this time. Regards, Zdravko. -- Sent via pgsql-sq