U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » Huge error of Postgresql! Double fields by transmission to the program lose a fractional part!

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Return to the default flat view

Create a new topic

Submit Reply

Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! [message #47540 is a reply to message #47539]

Thu, 26 January 2017 02:04

sergeynikitin is currently offline

sergeynikitin
Messages: 748
Registered: January 2008
Location: Moscow, Russia

Contributor

sergeynikitin@jabber.ru

I change postgresql setting to ( /etc/postgresql/9.5/main/postgresql.conf )
en_US:

# These settings are initialized by initdb, but they can be changed.
#lc_messages = 'ru_RU.UTF-8'			# locale for system error message
					# strings
#lc_monetary = 'ru_RU.UTF-8'			# locale for monetary formatting
#lc_numeric = 'ru_RU.UTF-8'			# locale for number formatting
#lc_time = 'ru_RU.UTF-8'				# locale for time formatting


lc_messages = 'en_US.UTF-8'			# locale for system error message
					# strings
lc_monetary = 'en_US.UTF-8'			# locale for monetary formatting
lc_numeric = 'en_US.UTF-8'			# locale for number formatting
lc_time = 'en_US.UTF-8'				# locale for time formatting

Result is zero!

26.01.2017 03:59:52 ===start analysis===
26.01.2017 03:59:52 s = 40
26.01.2017 03:59:52 da = 40
26.01.2017 03:59:52 dS = 40
26.01.2017 03:59:52 test_format_and_lang_settings = 40,000000
26.01.2017 03:59:52 ====end analysis====
26.01.2017 03:59:52  
26.01.2017 03:59:52 ===start analysis===
26.01.2017 03:59:52 s = 269.96336996337
26.01.2017 03:59:52 da = 269
26.01.2017 03:59:52 dS = 269.96336996337
26.01.2017 03:59:52 test_format_and_lang_settings = 269,963370
26.01.2017 03:59:52 ====end analysis====
26.01.2017 03:59:52  
26.01.2017 03:59:52 ===start analysis===
26.01.2017 03:59:52 s = 59.95115995116
26.01.2017 03:59:52 da = 59
26.01.2017 03:59:52 dS = 59.95115995116
26.01.2017 03:59:52 test_format_and_lang_settings = 59,951160
26.01.2017 03:59:52 ====end analysis====

SergeyNikitin<U++>( linux, wine )
{
under( Ubuntu || Debian || Raspbian );
}

Report message to a moderator

Send a private message to this user

[Message index]

		Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Mon, 23 January 2017 02:28
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: unodgs on Mon, 23 January 2017 07:34
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Mon, 23 January 2017 08:38
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: Klugier on Mon, 23 January 2017 09:38
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Mon, 23 January 2017 09:46
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: mirek on Wed, 25 January 2017 11:30
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Wed, 25 January 2017 18:18
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Wed, 25 January 2017 18:35
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Wed, 25 January 2017 18:37
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: Klugier on Wed, 25 January 2017 18:42
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Wed, 25 January 2017 18:54
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: mirek on Wed, 25 January 2017 19:02
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Wed, 25 January 2017 19:31
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: mirek on Wed, 25 January 2017 19:49
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Wed, 25 January 2017 20:31
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: mirek on Wed, 25 January 2017 20:40
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Thu, 26 January 2017 01:00
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Thu, 26 January 2017 01:25
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Thu, 26 January 2017 01:33
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Thu, 26 January 2017 01:43
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Thu, 26 January 2017 01:45
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Thu, 26 January 2017 01:57
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Thu, 26 January 2017 02:04
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Thu, 26 January 2017 02:23
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: mirek on Thu, 26 January 2017 14:10
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: mirek on Thu, 26 January 2017 15:01
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Thu, 26 January 2017 15:25
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: mirek on Thu, 26 January 2017 09:09
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: Klugier on Wed, 25 January 2017 19:03

Previous Topic:	I propose to Add Postgresql to topic header
Next Topic:	How can .sch express a many-to-many relationship ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Sat May 11 14:05:58 CEST 2024

Total time taken to generate the page: 0.02262 seconds