RE: [GENERAL] Re: [SQL] database design and diagraming book recommendations..

2000-08-21 Thread Craig L. Ching
> "Francisco Hernandez" <[EMAIL PROTECTED]> > > > anyone know of a good book or books on database modeling? > > like for entity relationship diagrams and such.. > > > To get a good life, go with Chris Date's rather difficult two > volume set. > What are the names of these two books? I just

Re: [GENERAL] regex back-references?

2000-08-21 Thread Michael Blakeley
At 1:30 AM -0400 8/21/2000, Tom Lane wrote: >Michael Blakeley <[EMAIL PROTECTED]> writes: >> Does postgresql support regex back-references? > >There's no such function at the SQL level, AFAIR. > >I'd recommend writing a function in either plperl or pltcl, according >to your taste. Both offer pre

Re: [GENERAL] regex back-references?

2000-08-21 Thread Tom Lane
Michael Blakeley <[EMAIL PROTECTED]> writes: > Do I need to tell postgres to rebuild pg_language, perhaps? See the createlang utility script. PL languages aren't installed by default (due to possibly-overzealous concern about security). regards, tom lane

[GENERAL] unicode/japanese support

2000-08-21 Thread Bret A. Barker
Hi all, I'm interested in using PostgreSQL as the database for a project that needs to use Japanese text, can anyone point me to resources on using Postgres with unicode/japanese characters, especially with JDBC. Also, is there an archive of the mailing lists somewhere? Thanks,

[GENERAL] Foreign Key Storage

2000-08-21 Thread Jessica Engblom
I need to get access to all of the foreign keys in a database, but I am not sure where postgres stores them. Does anyone know it they are stored in a table or not, and if so which table? Thanks.

[GENERAL] DateStyle causes drama during upgrade

2000-08-21 Thread Martijn van Oosterhout
Hi, We were prototyping our system working with the new Postgres 7 so we set up a new machine with all the important programs and copied all the data to it. We used pg_dump in various ways, all with the date style "iso" but always some of the dates appeared to be translated wrong. Eventually we

Re: [GENERAL] Foreign Key Storage

2000-08-21 Thread Stephan Szabo
You can get the information out of pg_trigger. Each references relationship will create three triggers in pg_trigger. It's not in a particularly friendly format though. There should be messages in the archives of either -general or -hackers about the details. (Or if you can't find it, I can g

[GENERAL] FW: Hi , Semaphore problem --Pl. F1

2000-08-21 Thread Moses
HI, My name is Moses, I work as system admin in INDIA and I just got your ID when I was looking out for a solution on Semaphore Problem which I am facing currently. I will be greateful to u if you could help me out on this. I work on SCO Openserve 5.0 .. I have Progress loaded on it .. Whe

Re: [GENERAL] FW: Hi , Semaphore problem --Pl. F1

2000-08-21 Thread Alfred Perlstein
* Moses <[EMAIL PROTECTED]> [000821 17:20] wrote: > HI, > My name is Moses, I work as system admin in INDIA and I just got your ID > when I was looking out for a solution on Semaphore Problem which I am facing > currently. I will be greateful to u if you could help me out on this. > >I wo