Create new table

Hier dreht es sich um den PostGre Server

Moderator: Moderatoren

Antworten
jobbisoft
Rookie
Rookie
Beiträge: 15
Registriert: Mi, 12. Jan 2022 20:13
Kontaktdaten:

Create new table

Beitrag von jobbisoft »

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
Grüße
Osvaldo Ramirez
Benutzeravatar
dtmackenzie
Rekursionen-Architekt
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

Beitrag von dtmackenzie »

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... :wink:

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
Benutzeravatar
Tom
Der Entwickler von "Deep Thought"
Der Entwickler von "Deep Thought"
Beiträge: 9345
Registriert: Do, 22. Sep 2005 23:11
Wohnort: Berlin
Hat sich bedankt: 100 Mal
Danksagung erhalten: 359 Mal
Kontaktdaten:

Re: Create new table

Beitrag von Tom »

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
jobbisoft
Rookie
Rookie
Beiträge: 15
Registriert: Mi, 12. Jan 2022 20:13
Kontaktdaten:

Re: Create new table

Beitrag von jobbisoft »

Thanks guys
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
Benutzeravatar
Frank Grossheinrich
Rekursionen-Architekt
Rekursionen-Architekt
Beiträge: 142
Registriert: Fr, 31. Mär 2017 15:06
Wohnort: Eschborn
Hat sich bedankt: 5 Mal
Danksagung erhalten: 81 Mal
Kontaktdaten:

Re: Create new table

Beitrag von Frank Grossheinrich »

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
We love Xbase++, and you?
Benutzeravatar
Tom
Der Entwickler von "Deep Thought"
Der Entwickler von "Deep Thought"
Beiträge: 9345
Registriert: Do, 22. Sep 2005 23:11
Wohnort: Berlin
Hat sich bedankt: 100 Mal
Danksagung erhalten: 359 Mal
Kontaktdaten:

Re: Create new table

Beitrag von Tom »

Without changing your code/business logic.
As long as you don't use filters. 8)

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. =D>
Herzlich,
Tom
Antworten