Re: [GENERAL] Triggers: options besides compiled code?

1998-07-09 Thread Brian
On 9 Jul 1998, Roland Roberts wrote: > I started to look at the triggers documentation and was immediately > dismayed to discover that I would have compile code to create a > trigger. I have been using the old "rules" mechanism to automatically > put a sequence number into a tuple when inserting

[GENERAL] Mirror- unix.wizard.ca

1998-07-09 Thread Anil Amarakoon
Hi! The links that does not work on Canadian Mirror. Anil http://unix.wizard.ca/postgres/software/ gets directory Listing http://unix.wizard.ca/postgres/software/Overview.shtml - search All categories returns if you do not enter anything on the text boxes Fi

Re: [GENERAL] postgresql website

1998-07-09 Thread The Hermit Hacker
On Wed, 8 Jul 1998, The Web Administrator wrote: > Well, humour me for a second.. I am just setting up a Canadian Mirror.. So > far most of the links seem to keep working, and the rest of the links > actually take you to the main postgres site..(For the message search's etc.) > > Check to see if

Re: [GENERAL] translate "bug"?

1998-07-09 Thread Bruce Momjian
> Yeah, I've rethough about it and it does seem a bit out-there ;) ... I'm > sure there was one time where I encountered a situation where you would > want to use the \d? commands in an SQL statement environment but I can't > even begin to remember... so maybe it wasn't that important afterall and

[GENERAL] Re: [INTERFACES] pb compiling JDBC interface

1998-07-09 Thread Peter T Mount
On Wed, 8 Jul 1998, Cyril Ferrand wrote: > Thanks for your answer but I find the Pb it was a bad version of JDK (1.0.2) > now I have installed the 1.1.3 and there is no error. Ah yes, JDBC was quite different for 1.0.2... > But now I have a pb with exeample, because I don't understand wh

Re: [GENERAL] How to rename a database?

1998-07-09 Thread Aleksey Dashevsky
Use following syntax: alter table rename to Al. On Wed, 8 Jul 1998, Farzad FARID wrote: > > How do I rename an existing database? Is it enough to just rename the > directory? If that's the only way to do it do I have to first shut the > server down? > > -- > Farzad FARID > Administrateur Re

[GENERAL] Python

1998-07-09 Thread Konstantin S. Kuznetsov
Hello! I have PostgreSQL-6.3.2 and Python1.5 with RedHat-5.1 distribution. But I can't connect PostgreSQL from Python script, cause there are no pg.py (or smth like that) module installed. Can anyone have experience with using such modules? Thank you.

Re: [GENERAL] postgresql website

1998-07-09 Thread Oliver Mueschke
hi, after the third party stuff being available via the german mirror i noticed that the at least 4 or 5 of the 57 third party entries are junk. the image buttons "Prev" and "Next" (to navigate the search result) are shown w/o images. the links to the html mirrorsites in poland and germany (embe

Re: [GENERAL] more nodeError problems and general view failures!

1998-07-09 Thread Bruce Momjian
> brecard=> create view on_test2 as > brecard-> select in_words,number,number * number as "number squared" from > test1; Here is the cause. The code could not handle an AS with multiple words, because of the way it was stored in the rewrite system. This patch should fix the problem. Does it fi

Re: [GENERAL] more nodeError problems and general view failures!

1998-07-09 Thread Stuart Rison
Erm, dunce question (sorry) How do I apply that patch? Do I cut and paste from ? src/Makefile.custom down into a file and then use patch? And -more scarily- does that mean I have to recompile postgres? That aside, thanks for your help Bruce, as soon I figure out how to apply the patch I'll let

[GENERAL] Triggers: options besides compiled code?

1998-07-09 Thread Roland Roberts
I started to look at the triggers documentation and was immediately dismayed to discover that I would have compile code to create a trigger. I have been using the old "rules" mechanism to automatically put a sequence number into a tuple when inserting new rows. Are my choices limited to just (1)

Re: [GENERAL] How to rename a database?

1998-07-09 Thread James Olin Oden
> Use following syntax: > alter table rename to > > I don't think that will work for the entire database. Remember a table is part of the database. So I don't think alter will change the actual database's name... > > > > How do I rename an existing database? Is it enough to just rename the

Re: [GENERAL] postgresql website

1998-07-09 Thread The Web Administrator
Well, humour me for a second.. I am just setting up a Canadian Mirror.. So far most of the links seem to keep working, and the rest of the links actually take you to the main postgres site..(For the message search's etc.) Check to see if you find any links not working, and let me know :> Saves m