On Mar 11, 2009, at 1:21 PM, John Wang wrote:
I have a table, for example, Product. It's index is Product_index.
If I use \copy to load data into the table:
\copy Product from data.txt
Will the index, Product_index, also be updated with the new data
during "copy"?
Yes, and indexes are upda
Postgres works fine in solaris zones. We've been using solaris with
postgresql running in zones for about a year.
Is there a more specific concern you have?
-Jovan
Hi,
Anybody has an experience in running postgres database server from a
solaris zone? Do you see any problems with such a set
CFLAGS="-R/opt/usr/local/amd64/lib -xmodel=medium -
xtarget=generic64 -fast
-xarch=amd64"
What does "-fast" do? If it involves any reinterpretation of IEEE
float
arithmetic accuracy requirements, drop it.
The -fast option using sun studio cc expands to include the flag -
fsimple=2 whi
1. a - old notation
2. a
3. e & d
4. b & c
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
As Zdenek mentioned, in Solaris 10 postgresql is run as a service, so
any attempts at stopping it manually will be detected and it will
automatically be started again.
The syntax was a bit off though (because the service may not
necessarily be called postgresql:version_82, and you need svcadm
inst