Solaris FAQ

Does anyone know if there is an operator class that supports the money data
type?
When I issue a command like :
create index "table1_price_idx" on "table" using btree ("price"
"money_ops");
or
create index "table1_price_idx" on "table" using btree ("price"
"float8_ops");
I get errors like :
ERROR: DefineIndex: opclass "money_ops" not found
and
ERROR: DefineIndex: opclass "float8_ops" does not accept datatype "money"
respectively.
I looked everywhere for documentation about this, and asked this question
elsewhere, but nobody knew anything.
Thanks in advance.
Rich Ryan

"Rich Ryan" <rich@usedcars.com> writes:

Does anyone know if there is an operator class that supports the money data
type?

There is not.

Type money is on its way out anyway, at least in its current
incarnation, because it's (a) nonstandard, (b) doesn't support
a reasonable number of digits, and (c) isn't internationalizable.
While (a) is not a fatal objection, (b) and (c) mean the type is
pretty badly crippled.

I doubt that anyone will want to do any work on money in its present
form. Sooner or later it ought to be reimplemented as an I/O skin
on type "numeric" ... hopefully with decent locale support. In the
meantime, efforts like adding index support seem like throwing good
work after bad.

I suggest using type numeric for now.

regards, tom lane

Bruce Momjian writes:

I have removed the new --export-dynamic item from the Solaris FAQ.
Looks like 7.1 has it fixed already.

Not that I could tell.

--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/

I see in makefiles/Makefile.solaris:

%.so: %.o
$(LD) -G -Bdynamic -o $@ $<
^^^^^^^^^

Is that OK?

Bruce Momjian writes:

I have removed the new --export-dynamic item from the Solaris FAQ.
Looks like 7.1 has it fixed already.

Not that I could tell.

--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Oh, OK.

Bruce Momjian writes:

I see in makefiles/Makefile.solaris:

%.so: %.o
$(LD) -G -Bdynamic -o $@ $<
^^^^^^^^^

Is that OK?

This is unrelated. The issue at hand is that the postgres/postmaster
executable must export its symbols so that the dynamically loaded modules
(e.g., PL handlers) can refer back to them. Normally this is done using
-Wl,-E when linking the postmaster executable. However, the Solaris
linker does not have this option, I believe it does it by default. So we
have to first find out what linker is being used and then write something
like

if {GNU ld}
export_dynamic := -Wl,-E
endif

Bruce Momjian writes:

I have removed the new --export-dynamic item from the Solaris FAQ.
Looks like 7.1 has it fixed already.

Not that I could tell.

--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/

--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Bruce Momjian writes:

I see in makefiles/Makefile.solaris:

%.so: %.o
$(LD) -G -Bdynamic -o $@ $<
^^^^^^^^^

Is that OK?

This is unrelated. The issue at hand is that the postgres/postmaster
executable must export its symbols so that the dynamically loaded modules
(e.g., PL handlers) can refer back to them. Normally this is done using
-Wl,-E when linking the postmaster executable. However, the Solaris
linker does not have this option, I believe it does it by default. So we
have to first find out what linker is being used and then write something
like

if {GNU ld}
export_dynamic := -Wl,-E
endif

Bruce Momjian writes:

I have removed the new --export-dynamic item from the Solaris FAQ.
Looks like 7.1 has it fixed already.

Not that I could tell.

--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/

--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/