I am connecting to postgres 6.4.2 through microsoft access97 using an obdc
driver. I am converting some access files into postgres. I have a certain
field that contains NOTES (a text datatype), and some of them can contain
quite a bit of data! Well, as I am pulling the info into postgres, ce
Ok, two days into this and I still can't find archives on how to increase
my tuple limit. Can anyone provide me with instructions on how to increase
my tuple limit?? 8k is not enough for our application - ok, enough for
90%, but not the 10%. I would like to at least double it. Maybe there a
When I vacuum I get two messages:
NOTICE: Index pg_class_relname_index: NUMBER OF INDEX' TUPLES (108) IS NOT
THE SAME AS HEAP' (82)
NOTICE: Index pg_class_oid_index: NUMBER OF INDEX' TUPLES (108) IS NOT THE
SAME AS HEAP' (82)
I had followed some advice I read in one of these postgres maili
Hi all. Head hanging a little low, even though system still seems to work
fine. Here is what I did:
- update pg_class set relname = lower(relname);
- update pg_attribute set attname = lower(attname);
- (why did I do that? Following something I read, not really having
problems in the first pl
You know, I have asked this week how to correct some error messages I get
when I vacuum related to TUPLE<>HEAP sizes - I thought I caused the problem
by setting all relname to lower(relname) in pg_class and attname to
lower(attname) in pg_attribute. But I don't think that caused the problem.
--BTW, the update below, when done in psql and with [. . .and ssms.autoinv
= 101999;] added (in other words, do it for just one record), it works
fine. When I try to do it for multiple records, bombola! Maybe this is
for the sql group. . .
You know, I have asked this week how to correct som
I am using rh 5.2, postgres 6.4.2, linking to postgres with access97 and
odbc driver. I can create a simple table, link to it, open it, and access
tell me that "this recordset is not updateable". However, I have created
many other tables in the same fashion and even much more complex and they
this is a resubmit with my pdbc log file. It shows an error in finding
the file MsysConf. Maybe this is the problem?? Can someone please provide
some insight? Thanks!
I am using rh 5.2, postgres 6.4.2, linking to postgres with access97 and
odbc driver. I can create a simple table, link
aidis [SMTP:[EMAIL PROTECTED]]
Sent: Monday, April 26, 1999 8:40 PM
To: JT Kirkpatrick
Cc: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Subject:Re: [INTERFACES] recordset not updateable
JT Kirkpatrick wrote:
> this is a resubmit with my pdbc log file. It sho
your advice to quit and reenter the database worked! thanks!
-Original Message-
From: ZioBudda [SMTP:[EMAIL PROTECTED]]
Sent: Monday, May 03, 1999 10:21 AM
To: JT Kirkpatrick
Cc: '[EMAIL PROTECTED]'
Subject:Re: [ADMIN] relation already exists?
<< Fi
i had a table, ap (had a primary key constraint named appk), which i
renamed ap2. i then re-created a table named ap, with the same primary key
constraint name appk, which postgres told me already existed. so i dropped
index appk, it said fine, dropped. so i recreated table ap. now it is
t
i got no response on the interfaces list -- maybe someone here has
experienced this too??
(msaccess97 / win98, 6.40.0005 odbc driver, postgres 6.4.2, linux mandrake
5.3) i wrote earlier about getting illegal page faults every time i CLOSE a
certain form (it lets me use it just fine!) that is u
hi all. i have written in about illegal page faults when i try to add
records to a particular table -- editing it seems fine. well, i have
narrowed down another "weird" problem with the same table. i reported that
when i open it directly in datasheet view, the odbc driver fails every
time.
hi all -- just writing to let you know that i recreated the database,
recreated all tables and repopulated them, and now all appears to be cool.
. . big step to correct a problem adding records in only one table!
jt
we have a database (linux, 6.4.2, new odbc, connections from msaccess /
win98) -- access doesn't fully appreciate the monetary type in postgres, so
we made all monetary fields FLOAT4's. weird stuff -- or maybe not to you
-- we insert 23516.69 into a float4 field directly in psql, and then sele
Monday, June 28, 1999 7:32 PM
To: JT Kirkpatrick
Cc: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Subject: Re: [SQL] float4
JT Kirkpatrick <[EMAIL PROTECTED]> writes:
> we made all monetary fields FLOAT4's. weird stuff -- or maybe not to you
> -
i am trying to debug a locking problem in our database. i currently am
starting postgres using this:
'/usr/bin/postmaster -B 256 -S -D /ssms -i'
i am trying to start it with the debugging option, -d 9, following the
advise of a friend. but i can't get it to start. i have tried:
'/usr/bin/p
report, and
not by the user who could / WILL forget to turn it off for normal use. . .
thanks for everyone's help!
jt / mpsllc.com
-Original Message-
From: Bruce Momjian [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, June 30, 1999 11:29 PM
To: JT Kirkpatrick
Cc:
you wrote:
I was wondering if anyone knew of a way to access DOS Paradox 4.5 tables
in PostgreSQL. I currently have several Perl and PAL scripts that
transfer data between the two systems via text, but I would _much_
rather simply be able to read and write to/from the Pardox tables from
Linux.
the front-end done in cgi/perl/html or apache (is that php+??). surely
i shouldn't expect users to get kicked out whenever someone runs a larger
report or query??!!??
i'd appreciate any suggestions you may have. have a great holiday!
jt kirkpatrick / www.mpsllc.com
2.2.2, postgres 6.4.2)
thanks in advance! jt kirkpatrick / mps
though. can you direct me to a place to find more info on setting up
mirroring?? or is it possible with ide hd's??
thanks so much for your help!
jt kirkpatrick / www.mpsllc.com
i set up the following script to run at 5am daily:
touch /var/log/imgonnadoit.at5
su svmaster
psql serviceworks -c 'vacuum;'
exit
touch /var/log/ididit.at5
i had planned to ls -l /var/log/i* to see the times of imgonnadoit.at5 and
ididit.at5 to see if the span looked reasonable -- and therefore
newer
kernel. any ideas?? vacuuming shows no problems now (was showing problem
when the index was bad). any help you could provide would be MUCH
appreciated!
jt kirkpatrick / mps
(linux rh 5.2, pg 6.4.2)
jt kirkpatrick / mps
Monday, September 27, 1999 11:50 AM
To: JT Kirkpatrick
Cc: '[EMAIL PROTECTED]'
Subject:Re: [ADMIN] command prompt select statement
Sure, psql has options for input query and output:
psql database output.
> hello oh-more-knowledgable-than-me postgres
i'm trying to run a query at night, and output the results to a file. i
think i have the syntax right for the proper output, but it now appears
that my little automatic (cron) query ran IMMEDIATELY after the first
command in the same cron file (a VACUUM of the same database) executed. it
did
eedless to say
they were still running when our morning crew arrived, and all were locked
out of the system until i killed everything!
jt
-Original Message-
From: Hitesh Patel [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, September 28, 1999 11:14 AM
To: JT Kirkpatrick
Cc: '[
well, in all my wisdom and quick typing, i dropped a main table rather than
the one i meant to drop. this just happened. can i recover it with some
quick statement i have an actual backup on tape from last night --
not a pgdump but a physical backup of the files in the database direc
i just sent an email saying i dropped a table and didn't mean to.
i haven't done anything else. will rollback work? i hate to try without
asking because this thing is in production use right now. luckily the
table isn't one that is used at the present, but i need it back.
thanks for any hel
well, rollback didn't restore that table i just dropped. . .
er like in israel these days??
jt
-Original Message-
From: Herouth Maoz [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, November 03, 1999 11:00 AM
To: JT Kirkpatrick; '[EMAIL PROTECTED]'
Subject:Re: [ADMIN] rollback
At 17:31 +0200 on 03/11/1999, JT Kirkpatrick wrote
-Original Message-
From: JT Kirkpatrick [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, December 28, 1999 10:00 AM
To: '[EMAIL PROTECTED]'
Subject:vacuum problems
any idea how to correct this problem? system seems to be working fine, but nightly
vacuums give us
values were inserted -- they were. but still get the same error message
when vacuuming! help! we need to vacuum!!!
jt
-Original Message-
From: JT Kirkpatrick [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, December 28, 1999 10:00 AM
To: '[EMAIL PROTECTED]'
Subject:vacuu
convert BOTH the user-input AND the field you are comparing to the SAME
CASE within the sql statement. then the user doesn't have to worry about
which case he/she uses (nor does the sysadmin. . .).
select * from userdata where lower(name) = lower('john');
or replace lower('john') with lower(u
physically COPY the files from the old 6.4.2 directory into the new
database directory in 6.5.3? are the file structures the same for 6.5.3?
is there a better way to do this migration? the pgdump isn't working.
jt kirkpatrick
36 matches
Mail list logo
