[SQL] What does PostgreSQL do when time goes backward?

How does PostgreSQL react to time being stepped at bootup? My Chrony NTP package might cause it to do so on rare occasions when the hardware clock is way off. This would only happen during bootup. -- John Hasler jhas...@newsguy.com Elmwood, WI USA -- Sent via pgsql-sql mailing list (pgsql

Re: [SQL] What does PostgreSQL do when time goes backward?

. Is it a VM or is there something going on that would stop or suspend your system? There is certainly something wrong there. -- John Hasler jhas...@newsguy.com Elmwood, WI USA -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http

Re: [SQL] Grass Root Protectionism

, is a positive sum game. It is US people who are benefitting more from the relationship, not non-US people. All are benefitting. The notion that someone is winning and therefor someone else must be losing is the OP's false thesis. -- John Hasler j...@dhh.gt.org Elmwood, WI USA -- Sent via

Re: [SQL] Grass Root Protectionism

D'Arcy J.M. Cain writes: Hey buddy, I know what I, a non-American, have done for this project. What have you done? I expect that this guy would tell you that all Free Software is evil and takes food out of the mouths of his children. -- John Hasler j...@dhh.gt.org Elmwood, WI USA -- Sent

Re: [SQL] Copyright and Paper walls

, in which case they have no grounds for action. There is nothing wrong with discussing Oracle's features or even deliberately duplicating them. -- John Hasler [EMAIL PROTECTED] Elmwood, WI USA -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http

Re: [SQL] accounting schema

Look at LedgerSMB at www.ledgersmb.org. It uses Postgresql. -- John Hasler [EMAIL PROTECTED] Elmwood, WI USA ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [SQL] UTF8 encoding and non-text data types

Joe writes: The Arabic language is written right-to-left, except ... when it comes to numbers. Perhaps they read their numbers right to left but use a little-endian notation. -- John Hasler [EMAIL PROTECTED] Elmwood, WI USA ---(end of broadcast

Re: [SQL] Need help with 'unique parents' constraint

Greg Sabino Mullane writes: Not just old-fashioned, [having only one mother is] the biological law! I see you aren't up on current research. -- John Hasler [EMAIL PROTECTED] Elmwood, WI USA ---(end of broadcast)--- TIP 4: Have you searched our

Re: [SQL] [GENERAL] CURRENT_TIMESTAMP

would expect to get from now(), but it's too late for that. -- John Hasler [EMAIL PROTECTED] Dancing Horse Hill Elmwood, Wisconsin ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command

Re: [SQL] [GENERAL] CURRENT_TIMESTAMP

Bruce Momjian writes: My point is that our current behavior may not be the most intuitive, and that most people may prefer a change. I would prefer a change. -- John Hasler [EMAIL PROTECTED] Dancing Horse Hill Elmwood, Wisconsin ---(end of broadcast

Re: [SQL] GUID in postgres

Josh writes: I'm sure you could make your own GUID, whatever one is. Globally Unique IDentifier, probably. Just hash a 128 bit random number with the current date. -- John Hasler [EMAIL PROTECTED] Dancing Horse Hill Elmwood, Wisconsin ---(end of broadcast

Re: [SQL] Is function atomic?

I wrote: Do you have any idea when [nested transactions] will [be added]? Richard Huxton writes: Check the todo list in the developers' area on the website - that'll show what's planned for 7.2 It's listed there: that's why I asked. Is everything on that list planned for 7.2? -- John

Re: [SQL] Is function atomic?

Richard Huxton writes: All functions take place within a transaction, but since PG doesn't support nested transactions yet you can't roll back the effects of a nested function. Do you have any idea when it will? -- John Hasler [EMAIL PROTECTED] (John Hasler) Dancing Horse Hill Elmwood, WI

[SQL] Nested Transactions

Can anyone give me an estimate of when we might expect to see nested transactions implemented? -- John Hasler [EMAIL PROTECTED] (John Hasler) Dancing Horse Hill Elmwood, WI ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [SQL] function to format floats as money?

Ross writes: But seriously, numeric(10,2) (or whatever precision and scale is correct for your application) is the standard answer. Floats are fine for money as long as you only add and subtract and don't deal in amounts that won't fit in the mantissa. -- John Hasler [EMAIL PROTECTED] (John

Re: [SQL] function to format floats as money?

, not to what might or might not meet with the approval of some officialdom or other. The two seldom bear any discernible relationship. -- John Hasler [EMAIL PROTECTED] (John Hasler) Dancing Horse Hill Elmwood, WI ---(end of broadcast)--- TIP 1

Re: [SQL] postgres

of that. They never notice where the article came from. -- John Hasler [EMAIL PROTECTED] Dancing Horse Hill Elmwood, Wisconsin

Re: [SQL] nested transactions

Bernie Huang writes: Just out of curiousity, does Postgres support nested transactions? I'd like to know too, and not just out of curiousity. I have a use for that. -- John Hasler [EMAIL PROTECTED] (John Hasler) Dancing Horse Hill Elmwood, WI