Hi,
I have a problem that has me stumped. We have a table that is the main
table in a production Microsoft Access application. Our users are
complaining that sometimes they enter data in the form, move off of the
record & then upon returning to the record the data reverts back to what
exist
Hello Karen,
intermittent problem, but I have been able to replicate the issue
> consistently on one particular record. We are using PostgreSQL 8.1.4 on Red
> Hat, Microsoft Access 2002 & psqlodbc_09_00_0200.
>
PostgreSQL 8.1 was EndOfLifed in November 2010, you are recommended to plan
for an up
Hi list,
Thanks for the clear answer. However, this is the simple answer that is also in
the manual. Yes I know it is not directly possible to get that data, but I am
quite desparate to get the data back. If one way or another the data is (except
for the 4 days we really have no data for) acces
On 2 Jan 2011, at 13:19, Dick Kniep wrote:
> Thanks for the clear answer. However, this is the simple answer that is also
> in the manual. Yes I know it is not directly possible to get that data, but I
> am quite desparate to get the data back. If one way or another the data is
> (except for th
Hi,
I'm trying to find all recursive dependecies for an object, using the query
in
http://archives.postgresql.org/pgsql-general/2009-05/msg01192.php
I ran into problem with view dependencies.
In the example below, the view "b" depends on view "a".
How is it possible to interpret the result of t
Hi,
I can only think, You could try to parse page files. If you didn't do VACCUM
FULL you could try to restore it, if those rows was not overwritten after
VACCUM (normal). Maybe some "internal" guys can give you answer (if e.g.
VACCUM (nomral) zeros row).
The programm to restore will bo so tri
On 2011-01-02 08:31, Karen Springer wrote:
We are using PostgreSQL 8.1.4 on Red Hat, Microsoft Access 2002 &
psqlodbc_09_00_0200.
You don't say which RedHat.
RHN offers 8.1.22 for RHEL5 currently.Are you not running regular updates?
- Jeremy
--
Sent via pgsql-general mailing list (pgsql
Karen Springer writes:
> I have a problem that has me stumped. We have a table that is the main
> table in a production Microsoft Access application. Our users are
> complaining that sometimes they enter data in the form, move off of the
> record & then upon returning to the record the data r
Joel Jacobson writes:
> I'm trying to find all recursive dependecies for an object, using the query
> in
> http://archives.postgresql.org/pgsql-general/2009-05/msg01192.php
Greg pointed out to start with that that query was unpolished (and,
in fact, basically untested ...)
I modified the query l
On Sunday 02 January 2011 12:31:43 am Karen Springer wrote:
> Hi,
>
> I have a problem that has me stumped. We have a table that is the main
> table in a production Microsoft Access application. Our users are
> complaining that sometimes they enter data in the form, move off of the
> record & the
Hi list,
Thanks for the clear answer. However, this is the simple answer that is also in
the manual. Yes I know it is not directly possible to get that data, but I am
quite desparate to get the data back. If one way or another the data is (except
for the 4 days we really have no data for) acces
Eric McDonald wrote:
> Greetings All:
>
> Does anyone here have any insight on to what EAL level Postgres is at
> for DOD/Military installations? I see that there's an SE-Linux
> fortified version on the Wiki, but no certifications are listed in the
> contents.
>
> Any direction to certification
Hello,
well, I'm new to postgres and this is my post on this list :-)
Anyway, I've to batch-import bulk-csv data into a staging database (as
part of an ETL-"like" pocess). The data ought to be read via STDIN,
however for keeping in simple and stupid, saving it to a file and
importing afterwar
On Sunday 02 January 2011 2:22:14 pm Thomas Schmidt wrote:
> Hello,
>
> well, I'm new to postgres and this is my post on this list :-)
> Anyway, I've to batch-import bulk-csv data into a staging database (as
> part of an ETL-"like" pocess). The data ought to be read via STDIN,
> however for keepi
2011/1/2 Tom Lane
> Greg pointed out to start with that that query was unpolished (and,
> in fact, basically untested ...)
>
> I modified the query like this:
> which is at least a little bit clearer to look at than what you had.
>
Thanks a lot for the help!
I managed to partly solve the proble
One of the issues with using UUIDs for primary keys, or even in a secondary key
using a unique index,would be paging of the index because of the randomness of
the values. This is what I have read, is that true for Posgres?
On the tests in this article, doing large amounts of consecutive inserts,
Good catch! The article is:
http://www.informit.com/articles/printerfriendly.aspx?p=25862
Dennis Gearon
Signature Warning
It is always a good idea to learn from your own mistakes. It is usually a
better
idea to learn from others’ mistakes, so you do not have to make them you
On Fri, Dec 31, 2010 at 11:53 AM, Tom Lane wrote:
> I think you're missing the point here: there is something about your
> standby setup procedure that is causing you to get an inconsistent set
> of row states.
For the sake of the archives, the problem turned out to be due to
impatience. We were
Hi Tom,
Due to the responses I received, I am now thoroughly convinced of the
need to upgrade & have passed this information on. We are running RHEL
4.1 which is why the newer version did not install with RHEL. I
initially was using an older version of psqlodbc, but decided to upgrade
to th
Hi Adrian,
Yes, the complaints have increased with the number or rows and the
number of users accessing the DB.
The problem record looks like this.
BarCode: W205179
PartNumber: 380-013
LRU: 380-013
PartsListRev
SerialNumber
MTN
DocNum: 150-2380-XXX
Comments
SupplierNo
DrawingNoRev
WorkOr
On 3 Jan 2011, at 8:12, Karen Springer wrote:
> This particular record has consistently had a problem (though not always),
> but users are unable to update other records as well. It doesn't occur with
> all records though. Most of the time the updates work fine. I test
> using a new Acce
21 matches
Mail list logo
