Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > pg_dumpall: pg_...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 15483 of 16112
Post > Topic >>

pg_dumpall: pg_conversion table not saved

by michael.enke@[EMAIL PROTECTED] (Michael Enke) May 7, 2008 at 03:58 PM

Hi list,
I updated pg_converion to set the condefault=false where I need it.
pg_dumpall does NOT write that table out and therefore it is not possible
to restore, this update get lost.
Anybody know if this is an error or has an explanation why it has to work
this way?

Background:
I have created my own conversion with CREATE DEFAULT CONVERSION ...
http://www.postgresql.org/docs/8.3/interactive/sql-createconversion.html
 > There should be only one default encoding in a schema for the encoding
pair

Why can not the "CREATE DEFAULT CONVERSION ..."
      a) return with an error if there is another default conversion
existing or
      b) silently set any other default to false
for the confor- and conto-encoding involved?

Regards,
Michael

-- 
Wincor Nixdorf International GmbH
Sitz der Gesellschaft: Paderborn
Registergericht Paderborn HRB 3507
Geschäftsführer: Eckard Heidloff (Vorsitzender), Stefan Auerbach, Dr.
Jürgen Wunram
Vorsitzender des Aufsichtsrats: Karl-Heinz Stiller
Steuernummer: 339/5884/0020 - Ust-ID Nr.: DE812927716 - WEEE-Reg.-Nr.
DE44477193

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail ist
nicht gestattet.

This e-mail may contain confidential information. If you are not the
intended recipient (or have received this e-mail in error) please notify
the sender immediately and destroy this e-mail. Any unauthorised copying,
disclosure or distribution of the material in this e-mail is strictly
forbidden.


-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 3 Posts in Topic:
pg_dumpall: pg_conversion table not saved
michael.enke@[EMAIL PROTE  2008-05-07 15:58:34 
Re: pg_dumpall: pg_conversion table not saved
tgl@[EMAIL PROTECTED] (T  2008-05-07 17:38:12 
Re: pg_dumpall: pg_conversion table not saved
kleptog@[EMAIL PROTECTED]  2008-05-07 23:42:21 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sun Jul 20 4:40:35 CDT 2008.