From: Constantin Teodorescu <teo@flex.ro>
To: David Conners <davidthewise@earthlink.net>
To: PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: [INTERFACES] Forms too complex or to large in pgaccess?
Date: Sat, 15 Jan 2000 00:03:23 +0200
Message-ID: <387F9D2B.FDEDA351@flex.ro> (raw)
References: <387F9541.512D18A7@earthlink.net>
David Conners wrote:
>
> Hi all,
>
> I'm using PgAccess v0.98, postgreSQL 6.5.1, tcl 8.0.3-20 on a RedHat
> 5.2 machine.
>
> Is there a limit on how large a form pgaccess can create?
Yes, the 8K record limit!
> I've created a form that displays records selected from three associated
> tables. While adding buttons to which would update the tables with
> information changed by the user, I reached a point at which I could not
> save the form. When I tried, a column the length of my screen is
> displayed, showing what looks like a stack dump of the failed attempt to
> write the form. At this point PgAccess no longer responds.
:-( . Yes I know! Seems that I have to redesign the form storage!
> WHen I try to start PgAccess again, I encounter various problems, It
> won't start and complains about abnormal termination, or it starts but
> one or more of my forms are missing.
Seems that it crashes the pga_forms.
> To recover, I replace the associated pga_forms file with a good backup
> copy.
>
> The two UPDATE statements I'm trying to add total 1787 bytes.
>
> I can add one, or the other can save the form.
> I can't find a way to include both and have the save succeed.
>
> ANy help or advise is appreciated. I didn't want to burden the group
> with big attachments, but if anyone would like to look at the forms
> and such, I'd be more than happy to send them.
Send me directly (teo@flex.ro) a small database dump with your example
(table, forms).
I'll try to locate it and find a sollution
Teo
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: teo@flex.ro, davidthewise@earthlink.net
Subject: Re: [INTERFACES] Forms too complex or to large in pgaccess?
In-Reply-To: <387F9D2B.FDEDA351@flex.ro>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox