Dan Langille wrote: > This was originally posted under PostgreSQL createdb changes > > Bruno Friedmann wrote: > >> Hi Dan >> >> Can you check for constency with the other databases (Mysql/Sqlite) how are >> spell the table,columns and their order in declaration. >> I know we don't care about sensitive case under postgresql, but it would >> make easier to migrate from one db to another >> (dump stupid sql) or csv file ( but actually you need to know the order to >> re-import them) >> >> I've done many transformation for a job like this one month ago. (was on my >> todo list ... ) >> Perharps we need to have some sort of reflexion, as I've not checked if >> bacula save catalog job use full insert or not. > > I think you are asking me to make the PostgreSQL names case-sensitive. > I would rather not do that. Here is why: > > test=# create table "Pool" (col1 text); > CREATE TABLE > test=# select * from pool; > ERROR: relation "pool" does not exist > test=# select * from Pool; > ERROR: relation "pool" does not exist > test=# select * from "Pool"; > col1 > ------ > (0 rows) > > test=# > > That is, you MUST use double quotes. > > As for the ordering of the columns, I agree, the column orders should be > the same. > > Do you have notes from the transformations you did?
In my short look, I found only one instance of columns out of order. The PostgreSQL Job table has priorjobid defined at the end of the CREATE TABLE. It should be right after filesetid. Recommendation: move it. Prognosis: This would only affect users if they were doing something very specifi. Otherwise, it should not. In the JobMedia table, MySQL has a Stripe column which is not present in either PostgreSQL or SQLite. Recommdation: delete it from the table definition. I do not see it referenced in the code. No need to drop it. We could issue a note saying users could drop if they wish. ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Bacula-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-devel
