Thread: Solaris FAQ

Solaris FAQ

From
Bruce Momjian
Date:
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
 


Index Ops supporting money type

From
"Rich Ryan"
Date:
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



Re: Index Ops supporting money type

From
Tom Lane
Date:
"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


Re: Solaris FAQ

From
Peter Eisentraut
Date:
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/



Re: Solaris FAQ

From
Bruce Momjian
Date:
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
 


Re: Solaris FAQ

From
Peter Eisentraut
Date:
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/



Re: Solaris FAQ

From
Bruce Momjian
Date:
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