Re: [ADMIN] error from postgresql 8.4.0 after a dump/restore from 8.3.5

Kenneth Marshall wrote: I just thought of something, would running an older release of pgadmin cause this error? I have just restored a DB from 8.3.5 to 8.4.0 and I just received the error: ERROR: column "reltriggers" does not exist at character 41 STATEMENT: SELECT relhasindex, relkind,

Re: [ADMIN] error from postgresql 8.4.0 after a dump/restore from 8.3.5

I just thought of something, would running an older release of pgadmin cause this error? Cheers, Ken On Wed, Aug 05, 2009 at 06:29:07PM -0500, Kenneth Marshall wrote: > Dear PostgreSQL admins. > > I have just restored a DB from 8.3.5 to 8.4.0 and I just > received the error: > > ERROR: column

[ADMIN] error from postgresql 8.4.0 after a dump/restore from 8.3.5

Dear PostgreSQL admins. I have just restored a DB from 8.3.5 to 8.4.0 and I just received the error: ERROR: column "reltriggers" does not exist at character 41 STATEMENT: SELECT relhasindex, relkind, relchecks, reltriggers, relhasrules, relhasoids , reltablespace FROM pg_catal

Re: [ADMIN] Where pg saves the next OID?

2009/8/5 Nelson Gonzaga : > Hi all, > Where postgresql saves the next OID to be used in any record? > I need to read it and use in a temporary field (unique) until the user put > the correct value, I don't want to use sequences because only a few records > it will be used. > Now I'm using the curre

[ADMIN] Where pg saves the next OID?

Hi all, Where postgresql saves the next OID to be used in any record? I need to read it and use in a temporary field (unique) until the user put the correct value, I don't want to use sequences because only a few records it will be used. Now I'm using the current_time function to do it. tks, Ne