Hello guys
I need an advice.
For new tables on PostgreSql:
Does it better create via SQL or create a DBF file, then run upsize to import it ?
In case that I create via SQL, what kind of fields/index do I need
to get the advantages of PGDBE ?
Thanks in advance
Best Regards
Osvaldo Ramirez
Create new table
Moderator: Moderatoren
- dtmackenzie
- Rekursionen-Architekt
- Beiträge: 265
- Registriert: Do, 22. Nov 2007 9:02
- Wohnort: Leipzig
- Hat sich bedankt: 66 Mal
- Danksagung erhalten: 22 Mal
- Kontaktdaten:
Re: Create new table
Hello Osvaldo,
you already have an upsized database and want to add a new table, right?
I'll also need to do this in the near future, probably from program code with the DbCreate() function.
Directly in SQL is not a good idea, also because the Alaska system tables may also need to be updated, and we shouldn't mess with these.
Upsize is problematical because it creates a complete new database; I don't know of any way to get it to add a new table to an existing database.
Correct me if I'm wrong, everyone...
P.S. Adding new fields to an existing table seems to work OK via SQL as long as there is no full-text search column on the table.
you already have an upsized database and want to add a new table, right?
I'll also need to do this in the near future, probably from program code with the DbCreate() function.
Directly in SQL is not a good idea, also because the Alaska system tables may also need to be updated, and we shouldn't mess with these.
Upsize is problematical because it creates a complete new database; I don't know of any way to get it to add a new table to an existing database.
Correct me if I'm wrong, everyone...
P.S. Adding new fields to an existing table seems to work OK via SQL as long as there is no full-text search column on the table.
Viele Grüße,
David
David
- Tom
- Der Entwickler von "Deep Thought"
- Beiträge: 9388
- Registriert: Do, 22. Sep 2005 23:11
- Wohnort: Berlin
- Hat sich bedankt: 104 Mal
- Danksagung erhalten: 362 Mal
- Kontaktdaten:
Re: Create new table
Just use DbCreate() via the PGDBE. Works excellent. All triggers, constraints etc. are created automatically. Use OrdCreate() or INDEX ON to create the indexes.
Herzlich,
Tom
Tom
Re: Create new table
Thanks guys
and yes,it is for new tables,
So dbcreate(), index on ... , work on pgdbe, I didnt know.
Thanks a lot
Osvaldo Ramirez
and yes,it is for new tables,
So dbcreate(), index on ... , work on pgdbe, I didnt know.
Thanks a lot
Osvaldo Ramirez
Grüße
Osvaldo Ramirez
Osvaldo Ramirez
- Frank Grossheinrich
- Rekursionen-Architekt
- Beiträge: 147
- Registriert: Fr, 31. Mär 2017 15:06
- Wohnort: Eschborn
- Hat sich bedankt: 5 Mal
- Danksagung erhalten: 82 Mal
- Kontaktdaten:
Re: Create new table
Osvaldo,
PGDBE is exactly for this purpose: use your "old" ISAM code (ISAM includes all DB navigation, all DB opening and closing functions, all DB and index creation, ... SKIP, dbGotop(), ... everything) with a SQL backend. Without changing your code/business logic. That is the whole idea.
Regards
Frank
PGDBE is exactly for this purpose: use your "old" ISAM code (ISAM includes all DB navigation, all DB opening and closing functions, all DB and index creation, ... SKIP, dbGotop(), ... everything) with a SQL backend. Without changing your code/business logic. That is the whole idea.
Regards
Frank
We love Xbase++, and you?
- Tom
- Der Entwickler von "Deep Thought"
- Beiträge: 9388
- Registriert: Do, 22. Sep 2005 23:11
- Wohnort: Berlin
- Hat sich bedankt: 104 Mal
- Danksagung erhalten: 362 Mal
- Kontaktdaten:
Re: Create new table
As long as you don't use filters.Without changing your code/business logic.
To be honest: There are several code changes needed, but only a percent of what would be needed to migrate the application to native SQL. Which can be planned/done afterwards.
There are still some few issues with this, but Alaska is working on it, and besides this it's an excellent thing.
Herzlich,
Tom
Tom