[GENERAL] Anyone interested in a Pittsburgh-area Postgres users' group?

I've gotten a couple of inquiries lately about a Postgres users' group in my home town of Pittsburgh PA. There is not one (unless it's very well camouflaged) but perhaps there is critical mass to create one. If you think you might come to meetings of such a group, let me know off-list. If I get e

Re: [GENERAL] 1 foreign key to 2 different tables?

On Sat, May 01, 2004 at 18:09:34 -0400, Ryan Riehle <[EMAIL PROTECTED]> wrote: > For what I am reading now it looks like this is an opportunity to use CREATE > ASSERTION, but this functionality appears to be unstable so far and is not > recommended for production environments. Is this correct?

Re: [GENERAL] 1 foreign key to 2 different tables?

For what I am reading now it looks like this is an opportunity to use CREATE ASSERTION, but this functionality appears to be unstable so far and is not recommended for production environments. Is this correct? Otherwise, can someone post an example of implementing a check constraint or trigger s

Re: [GENERAL] 1 foreign key to 2 different tables?

Sorry; Arrows are going the wrong way (seems like that caused some confusion). Corrected: a c b +--++-++--+ | PriKey1 |<---| ForKey |--->| PriKey2 | | || Flag|| | +--++-+

[GENERAL] bad characters in database

Was wondering if anyone could help me. I have a database with some bad characters in it -- some users had entered MS Word smart quotes, em dashes, foreign characters, and they look like gibberish coming out of the database. What's the best way to replace these characters? I thought I might be able

Re: [GENERAL] pgsql folder and its contents

Alexander Cohen wrote: > Im looking to remove everyth9ing that is not absolutely necessary in > the pgsql folder of my postgres server. Is there anyplace i can find > information on what all the files in lib, share and bin are for? Im > looking for somewhere or someone that can explain what each fi

Re: [GENERAL] Vacuumdb Errors --Any ideas?

Keary Suska <[EMAIL PROTECTED]> writes: > I received the following errors from an automated full vacuum: > vacuumdb: vacuuming of database "milemgr" failed: ERROR: tuple concurrently > updated Hm, could you have had more than one of these beasts running? It's possible to get such an error from c

Re: [GENERAL] users rights per table

victor wrote: > I have to implement a structure of rights. > I'm intrested if postgresql can restrict these > operations(insert, update, select, delete) for a specified postgresql > user. > If this is possible, please tell me were could I find some > documentation about this subject.

Re: [GENERAL] postgresql.org relay failing?

I just re-checked the server in question, and its allowing relaying fine: %rlytest -f [EMAIL PROTECTED] -u [EMAIL PROTECTED] hosting.commandprompt.com Connecting to hosting.commandprompt.com ... <<< 220 hosting.commandprompt.com ESMTP Sendmail 8.11.6/8.11.6; Sat, 1 May 2004 14:24:26 -0700 >>> HE

Re: [GENERAL] cionnected users to server

Alexander Cohen wrote: > Is there a way to get the list of connected users to a postgres > server? ps ax | grep postgres: ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] 1 foreign key to 2 different tables?

On Sat, May 01, 2004 at 14:51:14 -0400, Ryan Riehle <[EMAIL PROTECTED]> wrote: > Hi, > > I have a key structure like so: > > ac b > +--++-++--+ > | PriKey1 |--->| ForKey |<---| PriKey2 | > | || Flag||

[GENERAL] postgresql.org relay failing?

Joshua Drake and Marc Fournier, I sent this to you a week ago and I'm still having problems. Some people just don't get the messages delivered; I just had a person who couldn't subscribe to pgsql-es-ayuda because hosting.commandprompt.com refuses to relay the confirmation message. Please fix hos