Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Hackers > Re: statement t...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 4 of 8 Topic 9300 of 10389
Post > Topic >>

Re: statement timeout vs dump/restore

by Andreas.Zeugswetter@[EMAIL PROTECTED] ("Zeugswetter Andreas OSB s May 5, 2008 at 12:38 PM

> > Do we want the following:
>=20
> > 1. pg_dump issues "set statement_timeout =3D 0;" to the=20
> database prior to=20
> > taking its copy of data (yes/no/default-but-switchable)
> > 2. pg_dump/pg_restore issue "set statement_timeout =3D 0;" in=20
> text mode=20
> > output (yes/no/default-but-switchable)
> > 3. pg_restore issues "set statement_timeout =3D 0;" to the=20
> database in=20
> > restore mode (yes/no/default-but-switchable)
>=20
> I think "yes" for all three.  There was some handwaving about someone
> maybe not wanting it, but an utter lack of convincing use-cases; so
> I see no point in going to the effort of providing a switch.
>=20
> Note that 2 and 3 are actually the same thing (if you think they are
> not, then you are putting the behavior in the wrong place).

I thought a proper fix for 3 would not depend on 2 ?

Andreas

--=20
Sent via pgsql-hackers mailing list (pgsql-hackers@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
 




 8 Posts in Topic:
statement timeout vs dump/restore
andrew@[EMAIL PROTECTED]   2008-05-03 09:50:30 
Re: statement timeout vs dump/restore
tgl@[EMAIL PROTECTED] (T  2008-05-03 13:01:36 
Re: statement timeout vs dump/restore
jd@[EMAIL PROTECTED] (&q  2008-05-03 10:31:01 
Re: statement timeout vs dump/restore
Andreas.Zeugswetter@[EMAI  2008-05-05 12:38:54 
Re: statement timeout vs dump/restore
andrew@[EMAIL PROTECTED]   2008-05-05 09:01:25 
Re: statement timeout vs dump/restore
xzilla@[EMAIL PROTECTED]   2008-05-06 16:51:13 
Re: statement timeout vs dump/restore
tgl@[EMAIL PROTECTED] (T  2008-05-06 17:33:13 
Re: statement timeout vs dump/restore
andrew@[EMAIL PROTECTED]   2008-05-06 17:56:53 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Oct 11 19:13:37 CDT 2008.