Re: [firebird-support] SEC$DESCRIPTION, how to change it?

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 2020-01-07 19:49, hamacker sirhamac...@gmail.com [firebird-support] 
wrote:
> There is a SEC$DESCRIPTION field on security users table, but
> CREATE/ALTER USER command  does not any parameter to change it, is it
> correct?

Since Firebird 3, you can use:

COMMENT ON USER  IS ''

This doesn't seem to have been documented in the release notes.

Mark

[firebird-support] SEC$DESCRIPTION, how to change it?

[hamacker sirhamac...@gmail.com [firebird-support]]

There is a SEC$DESCRIPTION field on security users table, but CREATE/ALTER
USER command  does not any parameter to change it, is it correct?

RE: [firebird-support] Database/Table Corruption

[Hugo Eyng hugoe...@msn.com [firebird-support]]

Hi Mark.

I decided to "pump" all tables, except the one that was inconsistent,  from the 
old to a new database.
After this, I extracted all records I could from the incosistent table and 
inserted into the new database.

Possibly I lost some records from this table, I realy don´t know, because 
"select count(id) from mytable" results in the same " ERROR:internal Firebird 
consistency check (decompression overran buffer (179), file: sqz.cpp line: 239)"

Atenciosamente,

+ + Hugo Eyng + +


De: firebird-support@yahoogroups.com  em nome 
de Mark Rotteveel m...@lawinegevaar.nl [firebird-support] 

Enviado: quarta-feira, 1 de janeiro de 2020 08:25
Para: firebird-support@yahoogroups.com 
Assunto: Re: [firebird-support] Database/Table Corruption



On 31/12/2019 18:27, Hugo Eyng hugoe...@msn.com [firebird-support] wrote:
> Gfix didn´t work even using it as you  explained.

Please be more specific than "didn't work". What happened, did you get
an error, did gfix find nothing wrong? What was the gfix output?

Mark
--
Mark Rotteveel