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
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
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]]
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
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
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 ;-)
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?
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
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]
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
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:
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.
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
Title: Recall: [GENERAL] How to see a RULE definition?
Trewern, Ben would like to recall the message, [GENERAL] How to see a RULE definition?.
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
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
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.
17 matches
Mail list logo