Re: [ADMIN] Joining tables in two different databases?

El jue, 09-08-2007 a las 15:08 -0400, Chris Hoover escribió: > On 8/8/07, Michael Goldner <[EMAIL PROTECTED]> wrote: > Is it possible to access tables in two different databases, > running on the > same server, from within psql? > yes it is, with dblink. follow ne

Re: [ADMIN] Mass updates on a large table

On 8/10/07, Mark Steben <[EMAIL PROTECTED]> wrote: > > > > > Hi Scott, thanks for the response. > 4.The business reason for the update: we are replacing within a > query a > COALESCE function that gave us the most recent date between 3 dates. We > Are instead doing the COALESCE as part of

Re: [ADMIN] Mass updates on a large table

"Mark Steben" <[EMAIL PROTECTED]> writes: > I am attempting an update on two new date field columns on a 17 million row > table. Every row gets updated. > The update statement is a simple one: > UPDATE EMAILRCPTS SET ID = ID > And the update of the new date fields themselves occurs as the resul

Re: [ADMIN] Mass updates on a large table

On 8/10/07, Mark Steben <[EMAIL PROTECTED]> wrote: > > Good afternoon, > > I am attempting an update on two new date field columns on a 17 million row > table. Every row gets updated. > > The update statement is a simple one: > > UPDATE EMAILRCPTS SET ID = ID > > And the update of the new date

Re: [ADMIN] Easy way to change table schema?

On 8/10/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote: > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Chris Hoover wrote: > > I have accidentally created some tables in the wrong schema. Since my > > testers have begun to use them and put data in them, I was hoping for an > > easy way to

[ADMIN] Mass updates on a large table

Good afternoon, I am attempting an update on two new date field columns on a 17 million row table. Every row gets updated. The update statement is a simple one: UPDATE EMAILRCPTS SET ID = ID And the update of the new date fields themselves occurs as the result of a before trigger. The u

Re: [ADMIN] exclude logs of one database from log

=?iso-8859-2?Q?Witold_Go=B3=B1b?= <[EMAIL PROTECTED]> writes: > Is there posibility to exclude logs of one database from log file ? > How can I do that ? You could probably get the effect you want by using ALTER DATABASE SET to create a database-local setting of log_min_messages that is higher tha

Re: [ADMIN] Easy way to change table schema?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Chris Hoover wrote: > I have accidentally created some tables in the wrong schema. Since my > testers have begun to use them and put data in them, I was hoping for an > easy way to move the existing tables. > > Is there a way to move tables between s

[ADMIN] Easy way to change table schema?

I have accidentally created some tables in the wrong schema. Since my testers have begun to use them and put data in them, I was hoping for an easy way to move the existing tables. Is there a way to move tables between schema's w/o having to drop and recreate? Thanks, Chris

Re: [ADMIN] Postgres and PAM config issues

Marcin Porwit napisal 2007-08-10 03:26: positionwhile[pg]% more /etc/pam.d/postgresql #%PAM-1.0 auth required pam_stack.so service=system-auth The system is a CentOS 4.4 box, and I'm running PostgreSQL 8.0.6. However, when I try to get psql to do password authenti

[ADMIN] exclude logs of one database from log

Hello, Is there posibility to exclude logs of one database from log file ? How can I do that ? Regards Witek ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining c