Thread: LC_COLLATE - initdb

Hi!

I would like know if it's possible to configure a specific data base with
LC_COLLATE=pt_BR, LC_CTYPE=pt_BR... using initdb.

Thank's

Tiago

This will probably be a quick question for some of you with more
experience than I.  When you define a trigger to occur before or after
an event, does this mean that the trigger is spawned as part of the
current event transaction, or is it completed as a seperate transaction
after the event is processed?  In advance, thanks for the help!

Kris

sszabo@bigpanda.com

On Wed, 28 May 2003, Kris Kiger wrote:

> This will probably be a quick question for some of you with more
> experience than I.  When you define a trigger to occur before or after
> an event, does this mean that the trigger is spawned as part of the
> current event transaction, or is it completed as a seperate transaction
> after the event is processed?  In advance, thanks for the help!

It's part of the same transaction.  If I'm remembering the details right,
the before triggers happen right before the event, currently non-deferred
after triggers happen at the end of the statement that caused the event
(although this may change in the future) and deferred after triggers (for
deferred foreign keys) happen at the end of the transaction during the
commit.

Hello All,

The /var/lib/pgsql/data/base directory has the databases listed in  numeric
form.
Earlier it used to be proper names.

How can the numbers be resolved to names?

This actually can also help M/s. Anagha Joshi to find out relevant database
size and
possibly take backup in tarred form.

regards,
Rakesh Pawar.

On Thu, 2003-05-29 at 00:06, rakesh wrote:
> Hello All,
>
> The /var/lib/pgsql/data/base directory has the databases listed in  numeric
> form.
> Earlier it used to be proper names.
>
> How can the numbers be resolved to names?
>

The easiest way is to do select oid,* from pg_database, where the
numbers will correspond to the oid.

> This actually can also help M/s. Anagha Joshi to find out relevant database
> size and
> possibly take backup in tarred form.
>

guess i'd have to look at the specifics, but if she created her tar ball
on a live database then theres a good chance it wont work.


btw - just want to make a request to people to please not "hijack" other
peoples threads when posting to the list. This can happen if you hit
"reply to" on a message you don't intend to reply to, instead of create
a new email and addressing it properly. It messes up threading of
peoples requests for threaded email clients, newsgroup followers, and in
the archives, and it tends to reduce the chances of both the hijacker
and hijackee of getting a response.

Robert Treat

On Thu, May 29, 2003 at 09:36:55AM +0530, rakesh wrote:
> How can the numbers be resolved to names?

contrib/oid2name

A
--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110