RE: [GENERAL] Roll Back dont roll back counters

2001-08-16 Thread Carlos Felipe Zirbes
You still can tell the order even if you have holes in the key... Carlos Felipe Zirbes DBServer Assessoria em Sistemas de Informação E-mail: [EMAIL PROTECTED] Fone: (51) 3342-8055 Fax: (51) 3342-4838 -Original Message- From: Roderick A. Anderson [mailto:[EMAIL PROTECTED]] Sent: quinta

RE: [GENERAL] Can't find destroydb

2001-05-23 Thread Carlos Felipe Zirbes
And I have 7.0 installed and yesterday I couldn't find COPY. I had to use the \copy command in psql instead. I've installed postgres from the source. Any ideas why COPY isn't there, in the bin directory? Ah, "man copy" works fine. TIA, Carlos Felipe Zirbes DBServer

RE: [GENERAL] Data access permission?

2001-03-31 Thread Carlos Felipe Zirbes
access to rows (if that were possible). Carlos Felipe Zirbes DBServer Assessoria em Sistemas de Informação E-mail: [EMAIL PROTECTED] Fone: (51) 342-8055 / (51) 378-9056 Fax: (51) 342-4838 -Original Message- From: Manuel Sugawara [mailto:[EMAIL PROTECTED]] Sent: sexta-feira, 30 de março de

[GENERAL] Foreign Key constraint and Alter Table command

2000-12-12 Thread Carlos Felipe Zirbes
Hi.   I am using postgres 7.0.can't_remember_the_rest and I am not able to add a FK via alter table command. When I try to do it I get an "Feature not implemented" error message. This is what I've been trying to do:   alter table foo add constraint foo_fk foreign key (a) references foo_2  

[GENERAL] PostGres and ERwin

2000-08-14 Thread Carlos Felipe Zirbes
Hi.   Has anyone ever used erwin to connect to postgres? I have been trying to use erwin 3.5.2 sp2 to connect to pgsql via the latest odbc driver available and can't get erwin do create PK and FK constraint correctly. What odbc version should I use? 2.0 or 3.0?   Any help or report about th

[GENERAL] bulk copy in postgresql

2000-03-22 Thread Carlos Felipe Zirbes
Title: bulk copy in postgresql Hi. Can someone please tell me if there is a tool in postgres similar to BCP? I need to populate some tables using data from some text files and don't know how to do it. Thanks in advance, Carlos Felipe Zirbes