Re: [GENERAL] Debian PLPython

2004-12-16 Thread Simon Wittber
> > createlang -d databasename plpython > excellent, that does the trick. thankyou. I guess I was confused, as the langauges came 'pre-created' on the 8.0 RC1 windows install. ---(end of broadcast)--- TIP 7: don't forget to increase your free spa

[GENERAL] Debian PLPython

2004-12-16 Thread Simon Wittber
Hi Chaps, I'm still learning, so please be patient. I recently installed 8.0.0 RC1 on my windows machine. The languages node (in pgadmin) listed two languages, one being plpython. I've now installed 7.4 on our debian server, but it appears not to come with plpython installed. I am unable to find

[GENERAL] Debian Packages for Postgresql 8.0.0 RC1

2004-12-15 Thread Simon Wittber
Despite 30 minutes of googling, I am unable to find any debian packages for Postgresql 8.0.0 RC1. Does anyone know where I might obtain them? Sw. ---(end of broadcast)--- TIP 8: explain analyze is your friend

[GENERAL] source control integration

2004-12-05 Thread Simon Wittber
What is currently regarded as postgresql best-practice for controlling changes to a database? I currently administer SQL Server. I implemented a system which scripts every database object each hour (into a SQL script on the filesystem), and then uses SVN to track changes and email me if a change h

Re: [GENERAL] relation does not exist error

2004-12-02 Thread Simon Wittber
Wow, 4 responses in 10 minutes to my newbie question. Thanks guys. I'm coming from a SQL Server background, so quoting table names didn't immediately spring to mind. I can see support will not be a problem. 10 out of 10. Sw. ---(end of broadcast)-

[GENERAL] relation does not exist error

2004-12-02 Thread Simon Wittber
I'm evaluationg PostgreSQL 8.0 beta 5 for a new development project. I've created a user 'simon' and a database named 'WMSDV'. I've created some tables (see below) and assigned arwdRxt privledges to the 'simon' user. However, when i use psql, I am unable to select these tables. I receive a 'rela