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 <tomdavie...@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 <sidic...@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+h...@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+h...@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