Re: [GENERAL] Foreign Key Storage

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] DateStyle causes drama during upgrade

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] FW: Hi , Semaphore problem --Pl. F1

* 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

[GENERAL] Foreign Key Storage

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] FW: Hi , Semaphore problem --Pl. F1

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

[GENERAL] unicode/japanese support

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,

Re: [GENERAL] regex back-references?

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

Re: [GENERAL] regex back-references?

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] Re: [SQL] database design and diagraming book recommendations..

> "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