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, Pennsylvania 19026

Wed, 18 Oct 2000 23:19:23 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
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


Wed, 18 Oct 2000 21:54:17 -0700
"Rich Ryan" <rich@usedcars.com>
Index Ops supporting money type
"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

Thu, 19 Oct 2000 01:40:54 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Index Ops supporting money type 
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/


Thu, 19 Oct 2000 16:48:35 +0200 (CEST)
Peter Eisentraut <peter_e@gmx.net>
Re: Solaris FAQ
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

Thu, 19 Oct 2000 11:56:05 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Solaris FAQ
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

Thu, 19 Oct 2000 12:12:21 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Solaris FAQ
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/


Thu, 19 Oct 2000 18:14:26 +0200 (CEST)
Peter Eisentraut <peter_e@gmx.net>
Re: Solaris FAQ