Search found 1015 matches

by Tom
Wed Apr 13, 2022 12:07 am
Forum: PostGreSQL
Topic: Unlocking logs when a POSTGRESQL client disconnects abnormally
Replies: 10
Views: 1603

Re: Unlocking logs when a POSTGRESQL client disconnects abnormally

Hi, Diego. Because I went to the link you gave me, and Alaska explains that she has no solution for that problem. The problem is a part of the "Defect Tracking System" and became a "Problem Report": https://www.alaska-software.com/support/kbase-old.cxp There is no solution yet , since they just star...
by Tom
Tue Apr 12, 2022 12:31 am
Forum: PostGreSQL
Topic: How to create a temporary dbf file by copying the structure of a POSTGRESQL table
Replies: 4
Views: 565

Re: How to create a temporary dbf file by copying the structure of a POSTGRESQL table

Hi, Diego. Almost every database command knows the VIA clause. This allows you to use a DBE for operations that is not the default DBE: USE mytable // uses the default DBE COPY TO mytable2 VIA DBFNTX // creates a physical DBF at the path set by your app When using functions like DbCreate(), DbExport...
by Tom
Mon Apr 11, 2022 5:54 am
Forum: PostGreSQL
Topic: Unlocking logs when a POSTGRESQL client disconnects abnormally
Replies: 10
Views: 1603

Re: Unlocking logs when a POSTGRESQL client disconnects abnormally

Code: Select all

UPDATE public.<mytablename> SET __lock_owner = 0
in pgAdmin or from your app (maybe in service routines, after DbPack) will solve temporarly.
by Tom
Mon Apr 11, 2022 5:37 am
Forum: PostGreSQL
Topic: Unlocking logs when a POSTGRESQL client disconnects abnormally
Replies: 10
Views: 1603

Re: Unlocking logs when a POSTGRESQL client disconnects abnormally

You're right, Diego. If the app is killed, the lock stays. As k-insis mentioned, there is a table row "__lock_owner" in every table, which is 0 (zero) if a record is not locked. If it contains an integer value, the record is (and stays) locked. This value is not removed if an app doesn't close and q...
by Tom
Sat Apr 09, 2022 2:36 am
Forum: eXpress++ Support
Topic: How to view or modify the tables of a database in POSTGRESQL
Replies: 12
Views: 1606

Re: How to view or modify the tables of a database in POSTGRESQL

Hi, Diego. You have to establish a connection to the PG server and set the PGDBE and/or the session as the default session or DBE (or use the VIA clause) if you want to create index files there. This is what you do if you want to use the PGDBE in your app. It's not necessary for upsizing, but right ...
by Tom
Tue Apr 05, 2022 1:38 am
Forum: eXpress++ Support
Topic: How to view or modify the tables of a database in POSTGRESQL
Replies: 12
Views: 1606

Re: How to view or modify the tables of a database in POSTGRESQL

Hi, Diego. You can add a password for pgAdmin and a password for the server and one for the databases. You can create roles and manage access rights. Look at the PostGreSQL docs for this: https://www.postgresql.org/docs/14/index.html The FOR statement is not supported by DbfUpsize, but by INDEX ON a...
by Tom
Tue Apr 05, 2022 12:37 am
Forum: eXpress++ Support
Topic: How to view or modify the tables of a database in POSTGRESQL
Replies: 12
Views: 1606

Re: How to view or modify the tables of a database in POSTGRESQL

Hi, Diego. This updates the CUSTA index within POSTGRESQL? Yes, it does. The PGDBE allows to use tables like with DBF-based DBEs. Take care about: - Pathes in filenames (don't use them with the PGDBE) - FErase/DELETE FILE/ERASE FILE - they don't work (use DROP TABLE instead), remove "Ferase(<cIndexN...
by Tom
Mon Apr 04, 2022 12:22 am
Forum: eXpress++ Support
Topic: How to view or modify the tables of a database in POSTGRESQL
Replies: 12
Views: 1606

Re: How to view or modify the tables of a database in POSTGRESQL

Addition: If you want to look at the upsized tables, install and open pgAdmin. Connect to the server, look for your database (it should be "MDIDEMO"). Find "Schemas", click on this, you should see "Public". Schemas are kind of folders in a PostGres database. By default, DbfUpsize creates all tables ...
by Tom
Mon Apr 04, 2022 12:16 am
Forum: eXpress++ Support
Topic: How to view or modify the tables of a database in POSTGRESQL
Replies: 12
Views: 1606

Re: How to view or modify the tables of a database in POSTGRESQL

If you use the PGDBE with upsized ISAM tables, you can use all mechanisms known from other DBEs, like DbCreate(), OrdCreate(), DbExport() and others. This works similar to file based DBEs. It's the idea of PGDBE to use the same code, functions, methods and procedures. To be honest, DELETE FILE or ER...