github-starred/pgadmin3
2
0
Fork 0
mirror of https://github.com/levinsv/pgadmin3.git synced 2026-05-15 14:15:49 -06:00
Code Issues 6 Projects Packages Wiki Activity Actions

[GH-ISSUE #47] Two issues on pgadmin for windows build #43

New issue
Closed
opened 2026-05-05 03:32:51 -06:00 by gitea-mirror · 3 comments
gitea-mirror commented 2026-05-05 03:32:51 -06:00
Owner
Copy link

Originally created by @maxargy on GitHub (Oct 8, 2024).
Original GitHub issue: https://github.com/levinsv/pgadmin3/issues/47

  1. Error After a DB restore, but restore works fine
    image

  2. A lot of errors in view data (top 100 rows) on a table containing ts_vector data
    image
    image
    ... and many others

Thank you Massimiliano

Originally created by @maxargy on GitHub (Oct 8, 2024). Original GitHub issue: https://github.com/levinsv/pgadmin3/issues/47 1. Error After a DB restore, but restore works fine ![image](https://github.com/user-attachments/assets/f29f2b81-fe74-4ff2-8093-5c3fc746ab82) 2. A lot of errors in view data (top 100 rows) on a table containing ts_vector data ![image](https://github.com/user-attachments/assets/18b613ff-394e-4126-b908-437998f9b06e) ![image](https://github.com/user-attachments/assets/563ab6a4-c3a1-4745-8e55-b97568d43e68) ... and many others Thank you Massimiliano
gitea-mirror commented 2026-05-05 03:32:55 -06:00
Author
Owner
Copy link

@levinsv commented on GitHub (Oct 8, 2024):

  1. I have never used database recovery via pgadmin3. And I don't know how to reproduce it.
  2. Required:
    DBMS version.
    Create table test ...
    insert into test ...

I need at least some data to reproduce the problem.

<!-- gh-comment-id:2399068752 --> @levinsv commented on GitHub (Oct 8, 2024): 1. I have never used database recovery via pgadmin3. And I don't know how to reproduce it. 2. Required: DBMS version. Create table test ... insert into test ... I need at least some data to reproduce the problem.
gitea-mirror commented 2026-05-05 03:32:56 -06:00
Author
Owner
Copy link

@maxargy commented on GitHub (Oct 8, 2024):

Here is it:
create a db test and try to recover data
test.backup.zip
Should give the first error

Then view data inside table test (top 100 rows) and should give other errors

My DBMS version now is v17, but the errors was also with v16
To recover the backup you should have installed postgis extensions

I'm using the executable under x64/Release3.0, since I was not able to compile myself under windows

<!-- gh-comment-id:2399207761 --> @maxargy commented on GitHub (Oct 8, 2024): Here is it: create a db test and try to recover data [test.backup.zip](https://github.com/user-attachments/files/17290367/test.backup.zip) Should give the first error Then view data inside table test (top 100 rows) and should give other errors My DBMS version now is v17, but the errors was also with v16 To recover the backup you should have installed postgis extensions I'm using the executable under x64/Release3.0, since I was not able to compile myself under windows
gitea-mirror commented 2026-05-05 03:32:57 -06:00
Author
Owner
Copy link

@maxargy commented on GitHub (Oct 8, 2024):

Now works fine

<!-- gh-comment-id:2399768557 --> @maxargy commented on GitHub (Oct 8, 2024): Now works fine
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
master
v0.0
Labels
Clear labels   
bug

   
bug

   
enhancement

   
pull-request

Mirrored from GitHub Pull Request

  
question
No labels
bug
bug
enhancement
pull-request
question
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: github-starred/pgadmin3#43
No description provided.
Delete branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?