[GENERAL] A Query on PG_ tables

2000-06-19 Thread NRonayette
Hi everybody, I'm using Postgresql 7.0. I want to find, by a query on the postgres table (like pg_class, pg_attribute, pg_trigger, etc), the name of all the colonnes that are foreign key on my base. Pg_trigger gives me some information about the foreigns key i added on my tables (n

Re: [GENERAL] Lock rekord

2000-06-19 Thread Herbert Liechti
"Pawe³ Dubin" wrote: > List z dnia: Sat, 17 Jun 2000, : > > > I usually prefer the following trick for preventing long locking > > > times. On every > > > table I define a timestamp field which is updated every time the record is > > > written to the database. If a user edits a record (without

[GENERAL] PostgreSQL on NT: new cygwin?

2000-06-19 Thread Andrea Aime
Hi people, I'm trying to install pgsql on NT using cygwin's last release... well, it seems quite different from b20, you already got cygwin-ipc and there's no more a cygwin-b20 directory, the root directory seems to be unix like even if you don't install Andy Piper tools... is there anyone who