[GENERAL] PgAccess Scripts & Forms

I have problem of scripts in PgAccess. Which is as follows : I developed a form say form1. A startup script Scripts::open "form1 startup" connects all entries in form1 with a namespace eval DataControl(.form1.query1) { ... } in the same form using .form1.entry$x configure -textva

Re: [GENERAL] RDBMSs comparison (on Linux)

On Fri, 14 Apr 2000, Alessio Bragadini wrote: > LinuxCare runs a comparison chart and poll about different databases > available for Linux > > > A self selecting population. Invalid I'm afraid.

Re: [GENERAL] Parallel databases?

On Fri, 14 Apr 2000, A James Lewis wrote: > > Does anyone have any suggestions for a way to keep 2 databases in sync? > > Ideally updates need to be made to both... this can't be too uncommon a > requirement. any kind of HA would need it I believe the drbd system can do this across a L

Re: [GENERAL] Postgresqlism & Vacuum?

on 4/14/00 11:08 PM, Thomas at [EMAIL PROTECTED] wrote: > Stephen J Lombardo wrote: > >> ... Consider a table where you have some round number of >> tuples, say 100,000. Suppose you had b-tree indexes on two attributes, >> employee_id (primary key) and last_name. Now if you were to run a query

Re: [GENERAL] Does error within transaction imply restarting it?

Haroldo Stenger writes: > I seems that other DBMSs, don't care about erroneous statements within > a transaction. Now, I have several paths to follow: 1) Hacking the > backend ;-) If you're really brave you can try this change in backend/tcop/postgres.c: if (sigsetjmp(Warn_restart, 1) !

Re: [GENERAL] Does error within transaction imply restarting it?

[Charset ISO-8859-1 unsupported, filtering to ASCII...] > Haroldo Stenger writes: > > > I seems that other DBMSs, don't care about erroneous statements within > > a transaction. Now, I have several paths to follow: 1) Hacking the > > backend ;-) > > If you're really brave you can try this change

Re: [GENERAL] Parallel databases?

On Sat, 15 Apr 2000, Colin Smith wrote: > On Fri, 14 Apr 2000, A James Lewis wrote: > > > > > Does anyone have any suggestions for a way to keep 2 databases in sync? > > > > Ideally updates need to be made to both... this can't be too uncommon a > > requirement. any kind of HA would need i

[GENERAL] catching errors from BDI.pm

Hi, I am having trouble catching errors from postgress. I am connecting to the database via perl and DBI.pm The following will work ($dbh = DBI->connect("$dsn", "", "") ) or (print $DBI::errstr and exit()); But this wont (from deliberately spelled wrong) ($sth=$dbh->prepare("select * form table

[GENERAL] Win32 Install

I am trying to run postgress on an NT workstation. Do I have to run it in a bash prompt? This is the error I get if I try to run postgres.exe at nt cmd prompt: D:\cygnus\cygwin-b20>postgres FATAL 1: SetPgUserName: no entry in host passwd file The admin.pdf doesn't seem to give much help. I am

Re: [GENERAL] database file size bloat

> > AS for the process pool ... there are two camps here ... if you use > threads, when one threads crashes the server, the server is done. With > forking,if one backend dies, the server is still running ... in a 24x7 > shop, I'd rather the solution that doesn't die cause JoeBlow down the hall >

Re: [GENERAL] Character encodings...

> On Fri, Apr 14, 2000 at 03:44:09PM +0900, Tatsuo Ishii wrote: > > Oh, he is using the multibyte support and expects an automatic code > > conversion between KOI8-R and UNICODE that is not supported yet. > Not exactly. If you had a look on my first message, you would see that the > problem I see