[ADMIN] pg_dump issue across different versions (7.1.2 & 7.2).

hi, here i have 2 machines which have postgres 7.1.2 & 7.2 running, respectively. I did try pg_dump of database in machine (7.2) from the machine where i have 7.1.2 and it produced the message Archiver(db) version: 7.1 Aborting because of version mismatch. Use --ignore-version if you think it'

Re: [ADMIN] column name length

Felipe Nascimento wrote: > Is there a max length (number of characters) to column names?? > > I received the following: > identifier "petb_convidado_partida_participante" will be truncated to > "petb_convidado_partida_particip" > > Tks > Felipe > Yes -- it is 31 characters max by default. You

[ADMIN] column name length

Title: column name length Is there a max length (number of characters) to column names?? I received the following: identifier "petb_convidado_partida_participante" will be truncated to "petb_convidado_partida_particip" Tks Felipe

Re: [ADMIN] vacuum error

"Zhang, Anna" <[EMAIL PROTECTED]> writes: > ERROR: RelationBuildTriggers: 2 record(s) not found for rel domain. > I deleted triggers that referenced domain before vacuum, is this the cause? If you deleted them via "delete from pg_trigger" and not by DROP TRIGGER, then yes. You'll need to manual

Re: [ADMIN] vacuum error

On Fri, 8 Mar 2002, Zhang, Anna wrote: > Thanks Stephan! your suggestion works. I just wonder that if dropping > triggers caused such problem, this might be a postgres bug. Did you drop them or did you delete from pg_trigger? AFAIK this only happens with the latter (which isn't meant as normal

Re: [ADMIN] vacuum error

Thanks Stephan! your suggestion works. I just wonder that if dropping triggers caused such problem, this might be a postgres bug. Anna Zhang -Original Message- From: Stephan Szabo [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 1:02 PM To: Zhang, Anna Cc: '[EMAIL PROTECTED]' Subj

Re: [ADMIN] vacuum error

On Fri, 8 Mar 2002, Zhang, Anna wrote: > Hi, > I got an error when vacuum database, see below: > > $vacuumdb xdap > ERROR: RelationBuildTriggers: 2 record(s) not found for rel domain. > > I deleted triggers that referenced domain before vacuum, is this the cause? > How can I fix it? or It doesn'

[ADMIN] vacuum error

Hi, I got an error when vacuum database, see below: $vacuumdb xdap ERROR: RelationBuildTriggers: 2 record(s) not found for rel domain. I deleted triggers that referenced domain before vacuum, is this the cause? How can I fix it? or It doesn't bother, It's ok to ignore such error? Thanks in adva