Re: [libreoffice-users] Cannot add primary key after saving without primary key.

I used the Libreoffice wizard to create the database. It's a local
file. It's an offline laptop and I don't have MySQL or PostgresSQL
running so maybe it's SQLite?  What's the process to check the
backend?

Thanks for your time.


On Sun, Oct 21, 2012 at 5:45 PM, Tom Davies <tomdavies04@yahoo.co.uk> wrote:
> Hi :)
> Which back-end are you using to store the data?  MySql/MariaDb, Postgresql,
> Sqlite?
> Regards from
> Tom :)
>
>
> ________________________________
> From: David Smith <sidicas2@gmail.com>
> To: users@global.libreoffice.org
> Sent: Sunday, 21 October 2012, 10:40
> Subject: [libreoffice-users] Cannot add primary key after saving without
> primary key.
>
> Software: Libreoffice base
> Version: 3.5.4.2 (Debian Wheezy)
> Subject: Cannot add primary key after saving without primary key.
>
> I've got a problem.  I'm trying to test some different table designs.
> Whenever I create a table without a primary key, I find that I cannot
> go back and add a primary key later.  When I first save the table,
> Libreoffice asks me if I want to create a primary key now.  I choose
> "no" because I'm experimenting with some different table designs and
> didn't want to commit to anything just yet.
> 1. Create table without primary key.
> 2. Save table.
> 3. Libreoffice asks if I want to create a primary key now.
> 4. I choose no.
> 5. I later then open the table and set the primary key.
> 6. I save the table.
> 7.  I open the table again and the primary key that I chose was not saved!
>
> I've never had this kind of problem with a database before. Is this a
> bug or a missing feature?
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted