How do I recollect my password?
pgtypeslib/timestamp problem
Hello Guest		   
  • Login
• Register…
• Start blog		   • Who, Where, When
• What can I do?
• What to Read?		   • Polls
• Avatars
• Interests		   • Cities and Countries
• Random blog
• Users search		   • Search
• Games
• Tests
• QAIX		   • Сообщества
• Talxy Chat
• Horoscope
• Online		  
Зарегистрируйся!
QAIX > PostgreSQL database development > pgtypeslib/timestamp­ problem 27 March 2003 17:59:52
  Recent blog posts: 
Free iPod nano raffle for…
Aimersoft 2008 Christmas promotion: "Free iPod nano raffle for Chrismas" and "Buy 1 Get…

How to convert Rhapsody to…
Music purchased from Rhapsody is under DRM protection, which stops customers from playing the downloaded&helli­p;

PS3 firmware update adds full…
Eric Lempel, Sony's Director of PlayStation Network Operations, has posted on the official PlayStation 3…

Nintendo makes $6 profit on…
According to Macquarie Securities analyst David Gibson, Nintendo makes $6 USD operating profit on each…

Maintenance in winter
Skin for winter very easy to do, if does not supplement the moisture in time, like persimmons, flat and…

'Jasper' Xbox 360s finally…
'Jasper' Xbox 360s finally available According to a flooding of posts over at xbox-scene, it appears…

How to transfer Napster music…
Music purchased from Napster is under DRM protection, which stops customers from playing the downloaded&helli­p;

The song my brother taught me
Don't let your heart be hardened Don't let your love grow cold May it always stay so childlike May it…

My brother taught me this…
God grant me the serenity to accept the things I cannot change; courage to change the things I can;…

baz-baz-baz-baz pam-parabaram…
baz-baz-baz-baz pam-parabaram baz-baz-baz-baz pam-parabaram baz-baz-baz-baz pam-parabaram-baz ba-ra-ba…

  They have birthday today: 
xiongchong
henna diah
  Forums:   
    topic feeds

• QAIX  all topics, blogs and comments

• PHP web-programming

• Perl web-programming

• ASP web-programming

• Visual Basic Programming

• .Net Development

• C/C++ Programming

• Java Programming

• Javascript web-programming

• Apache HTTP Server

• Web-design

• Web-hosting, dedicated, colocation

• HTML web-programming

• XML development

• General Web-programming

• Content Management Systems

• ColdFusion

• Search Engine Optimization

• Hardware

• Software, Computer Help

• MySQL database development

• PostgreSQL database development

• MS Access database development

• Oracle database development

• MS SQL database development

• Informix database development

• Buy / Sell

• Open discussion

• Anonymous
  Discuss: 
plpgsql - Insert from a record…
Dear Postgresql experts, I'm writing a simple plpgsql function that selects a row from a table…

calling a pl/pgsql function…
Hello, i am tryin to pass an array like argument to a pl/pgsql function but i can not find the correct…

PgDatabase, on heap…
I am having a problem constructing a PgDatabase object. If I create the object on the stack (as a var…

Backup and restore through JDBC
Hello List I am trying to develop, a API to carry through backup and restore through JDBC. I think that…
  Recent forum topics: 
why infix:<div>:(Int, Int…
HaloO, I realized from the typed literal thread that S03 now explicitly states that div on two Ints…

[rt.cpan.org #41329] VMS…
<URL: http://rt.cpan.org/­Ticket/Display.html?­id=41329 > Thanks, applied

how to write literals of some…
Hello, I'm wondering how to write anonymous value literals of some Perl 6 basic types, and I didn't…
  Recent forum comments:
RE: Defining classpath for…
Your WSExample.java file has to be placed under the WAS.HOME/bin folder. Since your java2Wsdl is…

RE: access denied
IUSR account doesn't have access to cmd.exe by default (assuming you are using anonymous…

RE: access denied
Hey guys, I'm totally out of my league here, I don't even know how I got stuck with this problem, it's…

RE: [patch@34995] vms.c - Memory…
On Wed, Dec 3, 2008 at 7:38 PM, John E. Malmberg <wb8tyw@qsl.net> wrote: Thanks, applied as…

RE: how to write literals of some…
HaloO, David Green wrote: And how about 'Num 1.0 === Complex(1,0) === Int 1'? Should all these be…

RE: how to write literals of some…
HaloO, David Green wrote: IIRC, === is defined to compare only values from the same type domain. For…

RE: Support for ensuring invariants…
* David Green <david.green@telus.­net> [2008-12-03 22:00]: Not with a closure trait and…

RE: Support for ensuring invariants…
* Mark J. Reed <markjreed@gmail.co­m> [2008-12-03 20:30]: Yes. Exactly. It’s not a…

RE: Files, Directories, Resources…
* Aristotle Pagaltzis (pagaltzis@gmx.de) [081204 14:38]: So, they start when - you have users pick…

RE: Support for ensuring invariants…
* mark.a.biggar@comca­st.net <mark.a.biggar@comc­ast.net> [2008-12-03 21:45]: I…
  Moderators:
 Administrator
 Protorioris

pgtypeslib/timestamp­ problem

Michael Meskes 27 March 2003 17:59:52
 I found it, well not really that is. It seems the problem is triggered
by some gcc optimization. I'm using gcc 3.2.3. If I specify -O2 it does
not work correctly, without optimization it does. Now the big question
is which optimization is causing trouble.

It certainly is not -ffast-math as I do include the corresponding error
message which is not triggered. Unfortunately I cannot install the
complete 7.4 CVS version right now to see if the timestamp code in the
backend compiles correctly.

So here's the question comojng out of this all, anyone out here with an
idea why the timestamp "Wed Jul 12 17:34:29 2000" becomes "Wed Jul 12
4649:34:26.000002 2000" when putting it into timestamp format and back
out. The function is almost identical to timestamp_in resp.
timestamp_out. If these two functions and their helpers are compield
without "-O2" the output is correct.

Michael

--
Michael Meskes
Email: Michael@Fam-Meskes.­De
ICQ: 179140304
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!


-------------------­--------(end of broadcast)---------­------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHer­e" to majordomo@postgresq­l.org)

Add comment
Tom Lane 27 March 2003 17:07:48 [ permanent link ]
 Michael Meskes <meskes@postgresql.­org> writes:> So here's the question comojng out of this all, anyone out here with an> idea why the timestamp "Wed Jul 12 17:34:29 2000" becomes "Wed Jul 12> 4649:34:26.000002 2000" when putting it into timestamp format and back> out. The function is almost identical to timestamp_in resp.> timestamp_out. If these two functions and their helpers are compield> without "-O2" the output is correct.

FWIW, I get the correct answer in CVS tip on Red Hat Linux 8.0, which
is using gcc 3.2 (and -O2, per defaults in our makefiles):

regression=# set DateStyle TO postgres;
SET
regression=# select 'Wed Jul 12 17:34:29 2000'::timestamp;
timestamp
-------------------­-------
Wed Jul 12 17:34:29 2000
(1 row)

regards, tom lane


-------------------­--------(end of broadcast)---------­------------------
TIP 6: Have you searched our list archives?

http://archives.pos­tgresql.org

Add comment
Michael Meskes 27 March 2003 17:43:58 [ permanent link ]
 On Thu, Mar 27, 2003 at 09:07:48AM -0500, Tom Lane wrote:> FWIW, I get the correct answer in CVS tip on Red Hat Linux 8.0, which> is using gcc 3.2 (and -O2, per defaults in our makefiles):

Thanks Tom. I just wonder what's different in my makefile. It just does:

include $(top_builddir)/src­/Makefile.global
override CPPFLAGS := -O1 -g -I$(top_srcdir)/src­/interfaces/ecpg/inc­lude
-I$(top_srcdir)/src­/include/utils $(CPPFLAGS)

with "-O1" just inserted of course.

Tom, I take it you have released gcc 3.2 right? It seems my ione is
based on a CVS prerelease:

gcc -v
Reading specs from /usr/lib/gcc-lib/i3­86-linux/3.2.3/specs­
Configured with: ../src/configure -v
--enable-languages=­c,c++,java,f77,proto­,pascal,objc,ada --prefix=/usr
--mandir=/usr/share­/man --infodir=/usr/shar­e/info
--with-gxx-include-­dir=/usr/include/c++­/3.2 --enable-shared
--with-system-zlib --enable-nls --without-included-­gettext
--enable-__cxa_atex­it --enable-clocale=gn­u --enable-java-gc=bo­ehm
--enable-objc-gc i386-linux
Thread model: posix
gcc version 3.2.3 20030316 (Debian prerelease)

Michael
--
Michael Meskes
Email: Michael@Fam-Meskes.­De
ICQ: 179140304
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!


-------------------­--------(end of broadcast)---------­------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresq­l.org so that your
message can get through to the mailing list cleanly

Add comment
Tom Lane 27 March 2003 17:59:52 [ permanent link ]
 Michael Meskes <meskes@postgresql.­org> writes:> Tom, I take it you have released gcc 3.2 right? It seems my ione is> based on a CVS prerelease:

It's whatever came with RH 8.0 ...

$ gcc -v
Reading specs from /usr/lib/gcc-lib/i3­86-redhat-linux/3.2/­specs
Configured with: ../configure --prefix=/usr --mandir=/usr/share­/man --infodir=/usr/shar­e/info --enable-shared --enable-threads=po­six --disable-checking --host=i386-redhat-­linux --with-system-zlib --enable-__cxa_atex­it
Thread model: posix
gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7)

regards, tom lane


-------------------­--------(end of broadcast)---------­------------------
TIP 4: Don't 'kill -9' the postmaster

Add comment
 

Add new comment

As:
Login:  Password:  
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.

QAIX > PostgreSQL database development > pgtypeslib/timestamp­ problem 27 March 2003 17:59:52
see also:
Help with PERLCC
How to send files as Attachements to…
Dinesh Kumar/NCE/AMADEUS is out of the…
пройди тесты:
see also:
JBOSS Error
Please somebody help
  Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:
If you would like to report an abuse of our service, such as a spam message, please .