[GENERAL] news.postgresql.org down

2006-11-01 Thread Trewern, Ben
Does anyone know what's happened to the news.postgresql.org server? I haven't been able to access it now for a couple of days. Regards, Ben CARILLION VALUES Openness - Collaboration - Mutual Dependency - Professional Delivery -Sustainable Profitable Growth - Innovation

RE: [GENERAL] Outer joins

2001-07-13 Thread Trewern, Ben
Title: RE: [GENERAL] Outer joins Postgres 7.1 does support Left, right outer joins. Functions are similar to stored procedures but they cannot return rows. I think that this limitation is being worked on for the next release (7.2). By the way should there be a 'Postgres Features' page on

RE: [GENERAL] Kylix, dbexpress PostgreSql

2001-05-29 Thread Trewern, Ben
Title: RE: [GENERAL] Kylix, dbexpress PostgreSql Try using ZeosDBO at http://www.zeoslib.org/ this has just been ported to Kylix. Not sure how stable it is but the windows version is great :). Regards Ben -Original Message- From: Denis Gasparin [mailto:[EMAIL PROTECTED]]

RE: [GENERAL] Starting postgresql on startup

2001-03-30 Thread Trewern, Ben
Title: RE: [GENERAL] Starting postgresql on startup 'linuxconf' on Mandrake 7.1 should be able to set postgres to run at boot time as long as you set Postgresql up from an rpm. If you got to 'Control Panel' - 'Control service activity' - 'postgresql'. Set Startup to automatic and select the

RE: [GENERAL] PostGreSql 7.1

2001-03-30 Thread Trewern, Ben
Title: RE: [GENERAL] PostGreSql 7.1 http://www.postgresql.org/sites.html has a list of mirrors try one of them near you and the RPMs should be in directory dev/test-rpms Regards Ben -Original Message- From: Jack [mailto:[EMAIL PROTECTED]] Sent: 30 March 2001 04:14 To: [EMAIL

RE: [GENERAL] I wonder why I don't get an exception on delphi?

2001-03-16 Thread Trewern, Ben
Title: RE: [GENERAL] I wonder why I don't get an exception on delphi? Have you tried the following components: http://www.zeos.dn.ua/download/zeosdbo-5.2.3-beta.zip They seem to work more reliably and much more quickly than the ODBC drivers. They also give the required errors ;-)

RE: [GENERAL] Data types?

2001-03-08 Thread Trewern, Ben
Title: RE: [GENERAL] Data types? I thought: \dT This should do it Ben -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: 08 March 2001 01:00 To: Christopher Sawtell Cc: Flemming Frøkjær; [EMAIL PROTECTED] Subject: Re: [GENERAL] Data types?

RE: [GENERAL] Convert to upper

2001-03-02 Thread Trewern, Ben
Title: RE: [GENERAL] Convert to upper It may be better using a trigger. You don't then get the error message (from the constraint) the record is just updated with the uppercase version of what was inserted. Regards Ben -Original Message- From: Peter Schindler [mailto:[EMAIL

RE: [GENERAL] Does PostgreSQL support Constant Expression (Alias Name)?

2001-03-02 Thread Trewern, Ben
Title: RE: [GENERAL] Does PostgreSQL support Constant Expression (Alias Name)? Try SELECT fname as First Name, lname as Last Name FROM aTable; Regards Ben -Original Message- From: Raymond Chui [mailto:[EMAIL PROTECTED]] Sent: 02 March 2001 14:30 To: [EMAIL PROTECTED]

RE: [GENERAL] postgresql-tcl-7.03 requires libtcl8.0.so

2001-02-27 Thread Trewern, Ben
Title: RE: [GENERAL] postgresql-tcl-7.03 requires libtcl8.0.so Mandrake 7.2 includes tcl-8.3.2-4mdk. Make sure this is installed then, as long as thats the only remaining dependency, install postgresql-tcl-7.0.3-2mdk with --nodeps and all seems to work ;-) Regards Ben -Original

RE: [GENERAL] Re: ALTER DROP COLUMN

2001-02-13 Thread Trewern, Ben
Is there any chance of adding a note about this to the docs? It does not seem to be documented anywhere! Maybe a note in ALTER TABLE (sql-altertable.htm) and changing the FAQ slightly to mention what happen to triggers, views, constraints etc. Regards Ben -Original Message- From:

RE: [GENERAL] 7.0 configuration

2001-02-05 Thread Trewern, Ben
Title: RE: [GENERAL] 7.0 configuration On occasions I have had similar errors when starting up. I'm using Mandrake 7.0.3-2mdk RPMs on Mandrake 7.2. The server still starts and runs OK. Have done a complete reinstall since the last time I had this error so can be of little more help.

RE: [GENERAL] How to see a RULE definition?

2001-01-11 Thread Trewern, Ben
Title: RE: [GENERAL] How to see a RULE definition? You can use: pgdump -s outfile which will dump all the schema for the database. It should be in there somewhere ;) Regards Ben -Original Message- From: Josh Goodman [mailto:[EMAIL PROTECTED]] Sent: 11 January 2001 16:16

Recall: [GENERAL] How to see a RULE definition?

2001-01-11 Thread Trewern, Ben
Title: Recall: [GENERAL] How to see a RULE definition? Trewern, Ben would like to recall the message, [GENERAL] How to see a RULE definition?.

RE: [GENERAL] How to see a RULE definition?

2001-01-11 Thread Trewern, Ben
Title: RE: [GENERAL] How to see a RULE definition? You can use: pg_dump -s dbase outfile which will dump all the schema for the database. It should be in there somewhere ;) Regards Ben -Original Message- From: Josh Goodman [mailto:[EMAIL PROTECTED]] Sent: 11 January 2001

RE: [GENERAL] Updating pg_attribute - Permission denied

2000-10-23 Thread Trewern, Ben
Lane [mailto:[EMAIL PROTECTED]] Sent: 22 October 2000 04:08 To: Trewern, Ben Cc: '[EMAIL PROTECTED]' Subject: Re: [GENERAL] Updating pg_attribute - Permission denied "Trewern, Ben" [EMAIL PROTECTED] writes: I was trying to update attnotnull = 't' in the pg_attribute to ad

[GENERAL] INHERITANCE

2000-08-31 Thread Trewern, Ben
Title: INHERITANCE I have just been trying out Create Table .. Inherits ( ..); Am I right in saying you create a table that inherits fields default values, but not triggers. I have not tried rules or anything else yet. Where can I read more about inheritance and where to use it.