Re: [BUGS] 8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio
Zdenek Kotala wrote: > > Main problem is -fast switch. It modifies behavior of floating point > operation (it is reason why It is not good option for postgres) and > use another floating point libraries and some function are inlined. It > is reason why pow test passed with -fast switch without -lm switch. > > Detail description of -fast you can found on > http://docs.sun.com/source/819-3688/cc_ops.app.html > I noticed that the Sun FAQ now has changed from hinting that -fast might be very beneficial to recomend staying away from it. Using -fast is an old habit, has been building with it for years. I've seen that the testsuite breaks (in date/time) with only -fast, but it seems the only option one has to disable to normalize floating point enough is -fns. I hope passing the testsuite really means that fp math behaves correctly. If I'm wrong about that, I'll have to change our build routine. Beeing lazy, it is a good bit easier to go with -fast and turn of the problematic optimization with: -fast -fns=no than expanding the -fast macro and having to add all parameters: -dalign -nofstore -fsimple=2 -fsingle -xalias_level=basic -native -xdepend -xlibmil -xlibmopt -xO5 -xregs=frameptr I do understand the recomendation to avoid -fast, the tweaking is both compiler version and hardware architecture dependant. Doing a make check is always advisable. regards, Andreas ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
[BUGS] BUG #2758: missing quotes in SQL sentence
The following bug has been logged online: Bug reference: 2758 Logged by: scoanda Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Windows XP sp2 Description:missing quotes in SQL sentence Details: I set the transaction isolation level for an user with ALTER ROLE SET default_transaction_isolation='read committed'; In pgAdmin I get the sentence without quotes: ALTER ROLE SET default_transaction_isolation=read committed; This doesn't work if I copy/paste to SQL Query window. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [BUGS] BUG #2758: missing quotes in SQL sentence
That's a pgadmin bug; please report it to them. On Tue, Nov 14, 2006 at 03:42:53PM +, scoanda wrote: > > The following bug has been logged online: > > Bug reference: 2758 > Logged by: scoanda > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.4 > Operating system: Windows XP sp2 > Description:missing quotes in SQL sentence > Details: > > I set the transaction isolation level for an user with > ALTER ROLE SET default_transaction_isolation='read committed'; > > In pgAdmin I get the sentence without quotes: > ALTER ROLE SET default_transaction_isolation=read committed; > > This doesn't work if I copy/paste to SQL Query window. > > ---(end of broadcast)--- > TIP 1: if posting/reading through Usenet, please send an appropriate >subscribe-nomail command to [EMAIL PROTECTED] so that your >message can get through to the mailing list cleanly > -- Jim Nasby[EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [BUGS] BUG #2758: missing quotes in SQL sentence
No, it's the intended behaviour. pgAdmin doesn't have any idea how you want to quote SET values, so it leaves it to you to add them. Regards, Dave > --- Original Message --- > From: "Jim C. Nasby" <[EMAIL PROTECTED]> > To: scoanda <[EMAIL PROTECTED]> > Sent: 14/11/06, 19:15:59 > Subject: Re: [BUGS] BUG #2758: missing quotes in SQL sentence > > That's a pgadmin bug; please report it to them. > > On Tue, Nov 14, 2006 at 03:42:53PM +, scoanda wrote: > > > > The following bug has been logged online: > > > > Bug reference: 2758 > > Logged by: scoanda > > Email address: [EMAIL PROTECTED] > > PostgreSQL version: 8.1.4 > > Operating system: Windows XP sp2 > > Description:missing quotes in SQL sentence > > Details: > > > > I set the transaction isolation level for an user with > > ALTER ROLE SET default_transaction_isolation='read committed'; > > > > In pgAdmin I get the sentence without quotes: > > ALTER ROLE SET default_transaction_isolation=read committed; > > > > This doesn't work if I copy/paste to SQL Query window. > > > > ---(end of broadcast)--- > > TIP 1: if posting/reading through Usenet, please send an appropriate > >subscribe-nomail command to [EMAIL PROTECTED] so that your > >message can get through to the mailing list cleanly > > > > -- > Jim Nasby[EMAIL PROTECTED] > EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) > > ---(end of broadcast)--- > TIP 5: don't forget to increase your free space map settings > ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re: [BUGS] BUG #2758: missing quotes in SQL sentence
Dave Page wrote: > No, it's the intended behaviour. pgAdmin doesn't have any idea how > you want to quote SET values, so it leaves it to you to add them. Just quote them all. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
