Ruby on Rails | Screencasts | Download | Documentation | Weblog | Community | Source

Ticket #2872 (closed enhancement: fixed)

Opened 3 years ago

Last modified 2 years ago

PostgreSQL money datatype is unsupported

Reported by: mike@mike-burns.com Assigned to: Jeremy Kemper <rails@bitsweat.net>
Priority: low Milestone: 1.2
Component: ActiveRecord Version: 0.14.3
Severity: normal Keywords: postgresql money
Cc:

Description

The PostgreSQL adaptor tries to insert money as a float instead of a string, producing the error: ERROR: column "p" is of type money but expression is of type numeric

Change History

11/15/05 03:25:27 changed by bitsweat

  • keywords changed from postgresql, money, datatype to postgresql money.
  • owner changed from David to Jeremy Kemper <rails@bitsweat.net>.
  • summary changed from PostgreSQL money datatype is incorrect to PostgreSQL money datatype is unsupported.
  • type changed from defect to enhancement.
  • milestone set to 1.1.

The money type is not yet supported.

11/15/05 05:44:15 changed by CSN

From PG's docs:

"Note: The money type is deprecated. Use numeric or decimal instead, in combination with the to_char function."

11/15/05 07:11:34 changed by bitsweat

  • priority changed from normal to low.
  • milestone changed from 1.1 to 1.x.

Thanks for the pointer CSN; lowering priority accordingly.

11/26/06 05:46:15 changed by bitsweat

  • status changed from new to closed.
  • resolution set to fixed.
  • milestone changed from 1.x to 1.2.

Numeric/decimal are now supported.