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] 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: [EM
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 th
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 ;-)
Regard
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] 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] 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] 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 Mes
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.
Regar
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 200
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:
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: RE: [GENERAL] info please
For an SQL tutorial try http://sqlcourse.com/ but if you want information on PostgreSQL then look at http://www.postgresql.org/users-lounge/docs/7.0/tutorial/ which is not really written for beginners but if you persist you should get there in the end ;).
Hope
m: Tom 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 tryi
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.
Tha
18 matches
Mail list logo
