Re: [GENERAL] free WINDOWS rekall?

2005-04-27 Thread Chris Green
a Windows version is downloadable and only costs $25 if I have read it correctly. I think there was some sort of (rather acrimonious) split between the people who now run both www.totalrekall.co.uk and www.rekallrevealed.org and the people who run www.theKompany.com. -- Chris Green ([EMAIL PROTECTED

Re: [GENERAL] www.thekompany.com rekall

2005-04-27 Thread Chris Green
On Tue, Apr 26, 2005 at 09:30:49PM -0400, [EMAIL PROTECTED] wrote: >I just downloaded the windows demo for Rekall, which is an MSAccess >like product (loosely speaking) with native drivers for postgresql and >some other engines (plus odbc for yet others). I was a bit confused >on c

Re: [GENERAL] Confused by to_char

2005-02-08 Thread Chris Green
like this. Look at the documentation for to_char() for the format of the pattern. date_time is a date column in your database. -- Chris Green ([EMAIL PROTECTED]) "Never ascribe to malice that which can be explained by incompetence." ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] When is a blank not a null or ''

2005-02-02 Thread Chris Green
mail addresses coming up > Maybe you have some entries in the work_email column set to one or more spaces. -- Chris Green ([EMAIL PROTECTED]) "Never ascribe to malice that which can be explained by incompetence." ---(end of broadcast)--

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

2005-01-22 Thread Chris Green
On Sat, Jan 22, 2005 at 08:13:52AM -0500, Sean Davis wrote: > None have mentioned pgaccess yet. I haven't used it on a regular basis, > but at least it builds and runs on my Mac (and therefore, linux, etc.) > It looks good but I can't work out how to actually download i

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

2005-01-22 Thread Chris Green
On Fri, Jan 21, 2005 at 06:19:53PM -0600, Andrew L. Gould wrote: > On Friday 21 January 2005 12:55 pm, Chris Green wrote: [snip question] > > Many languages have the capacity to access PostgreSQL databases > including Python (with PyGreSQL), Perl (with DBI), PHP (compile in > s

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

2005-01-21 Thread Chris Green
that front. Any suggestions or ideas would be very welcome. -- Chris Green ([EMAIL PROTECTED]) "Never ascribe to malice that which can be explained by incompetence." ---(end of broadcast)--- TIP 3: if posting/reading through Usene

Re: [GENERAL] Is there a way to view a rewritten query?

2004-12-03 Thread Chris Green
diagnostics, then go back to the edit window and edit the original and try again. -- Chris Green ([EMAIL PROTECTED]) "Never ascribe to malice, that which can be explained by incompetence." ---(end of broadcast)--- TIP 3: if

Re: [GENERAL] Upcoming Changes to News Server ...

2004-12-02 Thread Chris Green
ewsgroup and the mailing list. It all seems to work quite well. In the case of mutt the mailing list tends to get the more specialised mutt related discussion whereas the newsgroup gets more beginners and general questions. -- Chris Green ([EMAIL PROTECTED]) "Never ascri

Re: [GENERAL] [HACKERS] Adding Reply-To: to Lists configuration ...

2004-12-02 Thread Chris Green
I've implemented a quick fix using my procmail recipes:- :0 fh * ^TOpostgres | sed 's/\[GENERAL\]//' :0 A: postgres I now get to see more of the subject without the distraction of [GENERAL] stuck in the middle of it! :-) -- Chris Green ([EMAIL PROT

Re: [GENERAL] UNION with ORDER BY -allowed?

2004-12-02 Thread Chris Green
On Thu, Dec 02, 2004 at 10:13:26AM -0500, [EMAIL PROTECTED] wrote: > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf Of Chris Green > > Sent: Thursday, December 02, 2004 9:56 AM > > To: [EMAIL PROTECTED] > > Su

[GENERAL] UNION with ORDER BY -allowed?

2004-12-02 Thread Chris Green
both varchar(1). I want the ORDER BY to order the result of the UNION. -- Chris Green ([EMAIL PROTECTED]) "Never ascribe to malice, that which can be explained by incompetence." ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] [HACKERS] Adding Reply-To: to Lists configuration ...

2004-12-01 Thread Chris Green
On Wed, Dec 01, 2004 at 02:02:41AM -0600, Bruno Wolff III wrote: > On Mon, Nov 29, 2004 at 12:49:46 +, > Chris Green <[EMAIL PROTECTED]> wrote: > > > > This is a perpetual problem, if people all used the same MUA and > > (assuming it has the capability) all us

Re: [GENERAL] USENET vs Mailing Lists Poll ...

2004-11-29 Thread Chris Green
news reader vs a mail > reader ... > but reading news from a 'special' news server is not so much of a gain as having it as a 'proper' newsgroup. -- Chris Green ([EMAIL PROTECTED]) "Never ascribe to malice, that which can be explained by incompe

Re: [GENERAL] Adding Reply-To: to Lists configuration ...

2004-11-29 Thread Chris Green
On Mon, Nov 29, 2004 at 07:35:41AM -0500, Jim Seymour wrote: > > Chris Green <[EMAIL PROTECTED]> wrote: > > > > On Sun, Nov 28, 2004 at 07:34:28PM -0400, Marc G. Fournier wrote: > > > > > > What is the general opinion of this? I'd like to implemen

Re: [GENERAL] Adding Reply-To: to Lists configuration ...

2004-11-29 Thread Chris Green
I'll often get two replies when people reply to my postings. However it's not a big issue for me. -- Chris Green ([EMAIL PROTECTED]) "Never ascribe to malice, that which can be explained by incompetence." ---(end of broadcast)--

Re: [GENERAL] Can one alter the format of a numeric column?

2004-11-27 Thread Chris Green
On Sat, Nov 27, 2004 at 10:50:47AM -0700, Michael Fuhr wrote: > On Sat, Nov 27, 2004 at 05:29:42PM +0000, Chris Green wrote: > > > Can one alter the precision of a numeric column? > > > > I want to reduce the precision of a column from 20,4 to 20,2. > > In PostgreS

[GENERAL] Can one alter the format of a numeric column?

2004-11-27 Thread Chris Green
Can one alter the precision of a numeric column? I want to reduce the precision of a column from 20,4 to 20,2. -- Chris Green ([EMAIL PROTECTED]) "Never ascribe to malice, that which can be explained by incompetence." ---(end of

Re: [GENERAL] How to display structure of a table

2004-11-25 Thread Chris Green
On Thu, Nov 25, 2004 at 10:47:33AM +, Chris Green wrote: > On Thu, Nov 25, 2004 at 04:08:30PM +0530, Nageshwar Rao wrote: > >I have created a table and would like to display the structure to find > >out datatype and length. > > > >Just like in Oracle d

Re: [GENERAL] How to display structure of a table

2004-11-25 Thread Chris Green
much of what DESCRIBE does for Oracle and mysql. \? to see all the \ commands. -- Chris Green ([EMAIL PROTECTED]) "Never ascribe to malice, that which can be explained by incompetence." ---(end of broadcast)--- TIP 1: subscribe and unsu

Re: [GENERAL] Any good report/form generators for postgresql?

2004-11-24 Thread Chris Green
On Wed, Nov 24, 2004 at 08:55:35AM +0100, Alberto Cabello Sanchez wrote: > On Sun, Nov 21, 2004 at 05:50:30PM +0000, Chris Green wrote: > > Has anyone got any recommendations for forms/reports generators for > > postgresql? I can probably get the forms I want from Rekall so

[GENERAL] Any good report/form generators for postgresql?

2004-11-21 Thread Chris Green
want from Rekall so the bigger requirement is a report generator. The particular thing I can't manage in Rekall at the moment is a 'running total' output column on a report. -- Chris Green ([EMAIL PROTECTED]) "Never ascribe to malice, that which ca

Re: [GENERAL] phpPgAdmin problem - this list?

2004-11-20 Thread Chris Green
ists. But check that the extension is enabled in the > php.ini first (uncomment the extension=pgsql.so line). > Excellent, that was it, thanks very much, it's saved me some time hunting elsewhere. Strangely phpMyAdmin doesn't need the mysql.so extension enabled but phpPgAdmin

[GENERAL] phpPgAdmin problem - this list?

2004-11-19 Thread Chris Green
me to somewhere better to ask? -- Chris Green ([EMAIL PROTECTED]) "Never ascribe to malice, that which can be explained by incompetence." ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] Odd permission denied message when starting client

2004-11-18 Thread Chris Green
On Thu, Nov 18, 2004 at 09:27:08PM +, Chris Green wrote: > I have just installed Postgresql 7.3.4 on my slackware 9.1 system. > The installation went fairly smoothly and the server process has > started normally:- > > postgres 21027 20767 0 20:12 pts/500:00:00 -su

[GENERAL] Odd permission denied message when starting client

2004-11-18 Thread Chris Green
ning about? -- Chris Green ([EMAIL PROTECTED]) "Never ascribe to malice, that which can be explained by incompetence." ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining colum

[GENERAL] authenticating local users

2000-12-29 Thread Chris Green
controls with psql -U Thanks, Chris -- Chris Green <[EMAIL PROTECTED]> "Yeah, but you're taking the universe out of context."