doumianfeng5065 2016-08-27 00:09 采纳率: 0%
浏览 75

Windows Update之后缺少PostgreSQL数据库列和作业

I only noticed it after the last Windows 10 update. After I looked into my database using PgAdmin I noticed columns missing. I can't see OID column any more. When I select all columns from my users and movies table as you can see:

NO OID VISIBLE

But if I select to view all data it exists

Now it is visible

Also all of my jobs are now gone. Also users are missing from my database but they are still there I know that by the fact that I set up a trigger to check if a email already exists. I tried adding new user and it says "email exists" so that means they are still somewhere.

Now my PHP won't work because it says OID does not exist. But how can that be, since it is clearly visible? And to add to that some of my triggers are missing too. I didn't want to reinstall anything because I'm afraid that I'd lose even more data.

I don't know what's happening? It happened the other day but I restarted my PC and it showed up again. Now restart won't help.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 测距传感器数据手册i2c
    • ¥15 RPA正常跑,cmd输入cookies跑不出来
    • ¥15 求帮我调试一下freefem代码
    • ¥15 matlab代码解决,怎么运行
    • ¥15 R语言Rstudio突然无法启动
    • ¥15 关于#matlab#的问题:提取2个图像的变量作为另外一个图像像元的移动量,计算新的位置创建新的图像并提取第二个图像的变量到新的图像
    • ¥15 改算法,照着压缩包里边,参考其他代码封装的格式 写到main函数里
    • ¥15 用windows做服务的同志有吗
    • ¥60 求一个简单的网页(标签-安全|关键词-上传)
    • ¥35 lstm时间序列共享单车预测,loss值优化,参数优化算法