[GENERAL] Encoding Conversion

Hi, When I´m doing a conversion PostgreSQL returns SCAPES to me besides the desire caracter. Why ? Using Postgresql 8.2: SELECT CONVERT('Rejeição: Duplicidade de NF-e, com diferença na Chave de Acesso [35110100608804000178550010001009471840996034]','UTF8','LATIN1') Result: "Rejeição: Du

[GENERAL] Continue sequence

Hi, Which is the correct way to obtain a continue sequence without fail (hole/gap) for a composite-id ? Example: CREATE TABLE nf ( number INTERGER NOT NULL, serie VARCHAR(2) NOT NULL, CONSTRAINT pky_nf PRIMARY KEY (number,serie) ) number serie 1 A 2

[GENERAL] Backup ?

Hi. Is it possible to do a backup only with index ? Is it possible to do a backup only with users, login roles or group roles ? regards, Wilton Ruffato Wonrath [EMAIL PROTECTED] __ Fale com seus amigos de graça com o novo Yahoo! Messen

[GENERAL] Protect PL/PGSQL source

Hello, Does anyone knows if it´s possible to protect from users see a PL/PGSQL source ? I have a PL/PGSQL function and I want to make it invisible to users. Just a example, in Oracle there is a option like this: http://www.dbasupport.com/oracle/ora9i/wrap_utility.shtml Regards, Wil

[GENERAL] PSQL - Slow on Windows 2000 or Windows 2003

Hello, Does anyone knows why it´s so slow to return a backup in Windows 2000 or Windows 2003 for archives bigger than 80 MB ? I do the same thing using others windows versions or linux, and it´s far fast than this. What could it be ? I´m using PostgreSQL 8.1 or lower version. Regards,