Re: [GENERAL] FOSS Reporting tools (was Oracle 10g Express - any danger for Postgres?)

2005-11-03 Thread James Thompson
> (There are many, many others that don't have a GUI designer > available. There's at least one on pgfoundry that explicitly supports > postgresql. They usually seem to take XML as an input template and > render to HTML or PDF.) Our reports tool does this as well and works with most major datab

CLI Reporting Tool Was: Re: [GENERAL] Oracle 10g Express - any danger for Postgres?

2005-11-02 Thread James Thompson
> > > > I haven't used Oracle since the mid 90s so I don't have a working example > > but a description of some of the commands can be found here > > > > http://www.siue.edu/~dbock/cmis564/otext3.htm > > Given the choice, I'd *MUCH* rather have a good, easy-to-use CLI than a > reporting tool. I'm

Re: [GENERAL] Oracle 10g Express - any danger for Postgres?

2005-11-02 Thread James Thompson
> Yes, sqlplus looks especially bad once you're used to banging around > in psql. Although, I recently discovered rlwrap (a generic readline > wrapper) which makes sqlplus almost tolerable. It's the best thing to > happen to sqlplus since... well, since "quit" I suppose. I just wish pgsql had so

Re: [GENERAL] GUI

2005-03-01 Thread James Thompson
On Tuesday 01 March 2005 08:07 am, Hrishikesh Deshmukh wrote: > Hi All, > > I want to spend less time coding and more time running queries against > the DB which i am building. What about QT from TrollTech!! Can that be > used to whip up gui real fast! Dreamweaver? > > Hrishi You could use gnue-de

Re: [GENERAL] Python Driver

2005-02-11 Thread James Thompson
On Thursday 10 February 2005 08:56 pm, Alex Turner wrote: > Just a small warning for those people using python with postgresql: > pysgresql and psycopg are very different animals. You cannot drop in > one as a replacement for the other, even though both 'claim' to be DB > API 2.0 compliant. None

Re: [GENERAL] Python Interface

2005-02-10 Thread James Thompson
On Thursday 10 February 2005 10:19 am, you wrote: > Alex Turner wrote: > >Can anyone recommend a python interface other than pygresql for > >postgresql. Yet again they have changed the API (pg.error is now > >pg.Error), and I can get no information from the mailing list, which > >seems dead. > > P

Re: [GENERAL] Data entry - forms design or other APIs etc. - what is there?

2005-01-25 Thread James Thompson
On Fri, 21 Jan 2005 18:55:27 +, Chris Green <[EMAIL PROTECTED]> wrote: > > What methods are available to produce data entry forms for postgresql > > databases? If, for example, one wanted to migrate a system that used > > Oracle Forms to Postgresql what would one use? This seems to me to be

Re: [GENERAL] Adding flexibilty to queries

2004-03-25 Thread James Thompson
gt; Mike Nolan > > > > > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > >http://archives.postgresql.org -- ->->->->->->->->->->->->->-&g

Re: [GENERAL] GUI Interfaces

2001-01-28 Thread James Thompson
db is postgresql. You can get it from the download section of www.gnue.org. ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-< James Thompson138 Cardwell Hall Manhattan, Ks 66506785-532-0561 Kansas State University Department of Mathematics ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<

[GENERAL] GNUe Forms 0.0.5 Released

2001-01-26 Thread James Thompson
as well as some outdated screenshots at www.gnue.org Take Care James ([EMAIL PROTECTED]) ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-< James Thompson13

[GENERAL] GNUe Forms 0.0.5 Released

2001-01-26 Thread James Thompson
of "usefullmaybe" :) You can find the python source code, rpms, and win32 version as well as some outdated screenshots at www.gnue.org Take Care James ([EMAIL PROTECTED]) ->->->->->->->->->->->->->->->->->->---<-<-<-<

[GENERAL] Trig functions in manual

2000-04-17 Thread James Thompson
c |m raised to the power of n (1 row) Thanks, James ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-< James Thompson138 Cardwell Hall Manhattan, Ks 66506785-532-0561 Kansas State University Department of Mathematics ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<

Re: [GENERAL] 6.5.1 possibly lost rows

1999-07-29 Thread James Thompson
nce a sequence generator is read it immediately increments. There is no way to roll that back due to the fact that other processes could have read the sequence generator after your process did and incremented it even further. ->->->->->->->->->->->->->->->

Re: [GENERAL] Embedded SQL in 'C' (cursors)

1999-06-04 Thread James Thompson
d for ecpg usage. IIRC There is an example of cursor usage in one of .pgc files. ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-< James Thompson138 Cardwell Hall Manhattan, Ks 66506785-532-0561 Kansas State University Department of Mathematics ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<

Long - More info on project Was Re: [GENERAL] Would this project beof interest to anyone?

1999-04-14 Thread James Thompson
ava components are certainly welcome, I just didn't think it fit the bill for the core library. ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-< James Thompson138 Cardwell Hall Manhattan, Ks 66506785-532-0561 Kansas State University Department of Mathematics ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<

RE: [GENERAL] info on people running postgre

1999-03-25 Thread James Thompson
will not be alone in depending upon postgresql. ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-< James Thompson138 Cardwell Hall Manhattan, Ks 66506785-532-0561 Kansas State University Department of Mathematics ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<

[GENERAL] Sharing DB connections between programs

1999-03-20 Thread James Thompson
suggestions you may have are greatly appreciated. Thank you. ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-< James Thompson138 Cardwell Hall Manhattan, Ks 66506785-532-0561 Kansas State University Department of Mathematics ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<

Re: [GENERAL] Postgre superuser?? (fwd)

1999-03-03 Thread James Thompson
up a unique group for each user anyway as it doesn't hurt anything and in some cases it can be usefull. ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<

[GENERAL] Max length of a field name

1999-01-20 Thread James Thompson
I know I've read this is the docs but I can't find it now that I need it. What's the max length of a field name. ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-&

[GENERAL] Oracle vs Postgresql

1999-01-20 Thread James Thompson
? Why switch to postgresql? I'd really appreciate peoples thoughts on this. ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-< James Thompson138 Cardwell Hall Manhattan, Ks 66506785-532-0561 Kansas State University Department of Mathematics ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<