Thread: Solaris FAQ
I have removed the new --export-dynamic item from the Solaris FAQ. Looks like 7.1 has it fixed already. -- 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, Pennsylvania19026
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, Pennsylvania19026
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/
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,
Pennsylvania19026