Re: [libreoffice-users] Help with failing AutoValue increment in LO Base table

Different databases have different ways of implementing Auto-Increment
or Serial numbers.

I expect this to be related to the database you're using (Mariadb), a
Base compatibility issue but not really a bug.

I have no experience with Mariadb, but expect you can resolve your
problem by running the appropriate SQL command(s) to set the ID column
to your db-specific auto-increment type.  In PostgreSQL, for example,
you'd need to create a Sequence then set the default value of the ID
column to that sequence.

PostgreSQL example code:
CREATE SEQUENCE mytable_id_seq INCREMENT 1 START 1 CACHE 1;
ALTER TABLE mytable ALTER COLUMN ID SET DEFAULT
nextval('mytable_id_seq'::regclass);

Joe

On 7/17/24 07:20, Harvey Nimmo wrote:
> I wonder if anyone else sees this issue with LOBase. It would be good
> to know, if it might be an issue to be addressed to the OpenSUSE forum.

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy