Re: [GENERAL] can we remove this guy from the list?

2006-04-07 Thread Tom Lane
"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > Can't help you, sorry :( > Cannot unregister [EMAIL PROTECTED]: no matching addresses > He probably is subscribed from some other address, and forwards it to that > one ... I've even checked substrings of 'pdx.ne.jp' and 'ryo4893', just in >

Re: [GENERAL] can we remove this guy from the list?

2006-04-07 Thread Marc G. Fournier
Can't help you, sorry :( Cannot unregister [EMAIL PROTECTED]: no matching addresses He probably is subscribed from some other address, and forwards it to that one ... I've even checked substrings of 'pdx.ne.jp' and 'ryo4893', just in case ... On Fri, 7 Apr 2006, Scott Marlowe wrote:

Re: [GENERAL] Debian package for freeradius_postgresql module

2006-04-07 Thread Tyler MacDonald
Scott Marlowe <[EMAIL PROTECTED]> wrote: > > >> I don't feel it's a questionable reading of the GPL at all. In fact, > > >> it's pretty clear and I'm about 99% sure the FSF has commented on this > > >> as well. It's true that it's unlikely anyone would actually sue Debian > > >> over it but that

Re: [GENERAL] Debian package for freeradius_postgresql module

2006-04-07 Thread Scott Marlowe
On Fri, 2006-04-07 at 19:31, Douglas McNaught wrote: > Scott Marlowe <[EMAIL PROTECTED]> writes: > > >> I don't feel it's a questionable reading of the GPL at all. In fact, > >> it's pretty clear and I'm about 99% sure the FSF has commented on this > >> as well. It's true that it's unlikely anyo

Re: [GENERAL] Debian package for freeradius_postgresql module

2006-04-07 Thread Douglas McNaught
Scott Marlowe <[EMAIL PROTECTED]> writes: >> I don't feel it's a questionable reading of the GPL at all. In fact, >> it's pretty clear and I'm about 99% sure the FSF has commented on this >> as well. It's true that it's unlikely anyone would actually sue Debian >> over it but that doesn't someho

Re: [GENERAL] Debian package for freeradius_postgresql module

2006-04-07 Thread Scott Marlowe
On Fri, 2006-04-07 at 19:13, Stephen Frost wrote: > * Tom Lane ([EMAIL PROTECTED]) wrote: > > Stephen Frost <[EMAIL PROTECTED]> writes: > > >> Or are they selectively enforcing this > > >> policy against PG? > > > > > It's enforced whenever we discover it, really... > > > > I am strongly tempted

Re: [GENERAL] MediaWiki and Postgresql?

2006-04-07 Thread Robert Treat
On Thursday 06 April 2006 16:45, Jim Nasby wrote: > On Apr 4, 2006, at 11:08 AM, Scott Marlowe wrote: > > On Mon, 2006-04-03 at 06:36, Markus Wollny wrote: > >> Hi > >> > >> [EMAIL PROTECTED] wrote: > >>> Has anyone put MediaWiki up using the current version of Postgresql? > >> Most of the code I

Re: [GENERAL] Debian package for freeradius_postgresql module

2006-04-07 Thread Douglas McNaught
"Leif B. Kristensen" <[EMAIL PROTECTED]> writes: > On Saturday 08 April 2006 01:21, Tyler MacDonald wrote: >>Debian a niche distribution? I'd hardly call the defacto standard >>GNU Linux distribution a "niche"... > > Surely, Debian is "niche". Why else should there be a need for > distributions l

Re: [GENERAL] Debian package for freeradius_postgresql module

2006-04-07 Thread Stephen Frost
* Tom Lane ([EMAIL PROTECTED]) wrote: > Stephen Frost <[EMAIL PROTECTED]> writes: > >> Or are they selectively enforcing this > >> policy against PG? > > > It's enforced whenever we discover it, really... > > I am strongly tempted to pull Debian's chain by pointing out that > libjpeg has an adver

Re: [GENERAL] Debian package for freeradius_postgresql module

2006-04-07 Thread Tom Lane
Stephen Frost <[EMAIL PROTECTED]> writes: >> Or are they selectively enforcing this >> policy against PG? > It's enforced whenever we discover it, really... I am strongly tempted to pull Debian's chain by pointing out that libjpeg has an advertising clause (a much weaker one than openssl's, but n

Re: [GENERAL] Debian package for freeradius_postgresql module

2006-04-07 Thread Stephen Frost
* Tom Lane ([EMAIL PROTECTED]) wrote: > Tyler MacDonald <[EMAIL PROTECTED]> writes: > > OK, I'm kind of confused about how the legal red tape works here. > > Debian packages all sorts of GPL code, and both openssl and postgres are > > released under more liberal licenses. About the only legal i

Re: Allow linking against OpenSSL? (Was Re: [GENERAL] Debian package

2006-04-07 Thread Chris Travers
Tyler MacDonald wrote: Greetings FreeRadius people, This discussion started on the postgresql's "pgsql-general" mailing list. The problem here is that the freeradius-postgresql package needs to link against libpgsql, which means that it may be indirectly linked against openssl. There is

Re: [GENERAL] plgpsql and transactions

2006-04-07 Thread Terry Lee Tucker
> > > > In the latter, you have expanded the scope of the transaction; which, > > sometimes you might want to do. > > Yes, I might. But, I'd like to understand it so I do know when I might > or might not want to do it. Understanding is good. You need to read the documentation on transactions: htt

Re: [GENERAL] Debian package for freeradius_postgresql module

2006-04-07 Thread Leif B. Kristensen
On Saturday 08 April 2006 01:21, Tyler MacDonald wrote: >Debian a niche distribution? I'd hardly call the defacto standard >GNU Linux distribution a "niche"... Surely, Debian is "niche". Why else should there be a need for distributions like Gentoo? I once tried to run Debian, and asked for help

Re: [GENERAL] plgpsql and transactions

2006-04-07 Thread Bill Moseley
On Thu, Apr 06, 2006 at 03:48:15PM -0500, Terry Lee Tucker wrote: > > > > -- fires a trigger that updates more than one table > > insert into semething (default); > > > > and: > > > > begin; > > -- fires a trigger that updates more than one table > > insert into somthing (defaul

Re: [GENERAL] Debian package for freeradius_postgresql module

2006-04-07 Thread Tyler MacDonald
Chris Travers <[EMAIL PROTECTED]> wrote: > My own opinion is this: The Debian crowd are often technical enough > they can build whatever they want from source. Debian is a niche > distribution and not something we should spend too much time worrying > about whether our software can be indirect

Re: [GENERAL] Debian package for freeradius_postgresql module

2006-04-07 Thread Chris Travers
Tyler MacDonald wrote: Scott Marlowe <[EMAIL PROTECTED]> wrote: But the way Douglas' message read, it was only GPL packages that should be affected, and we're not GPL. Or did I or Douglas misunderstand the situation? It's freeradius that's GPL. Then we break GPL rules by impo

Re: Allow linking against OpenSSL? (Was Re: [GENERAL] Debian package for freeradius_postgresql module)

2006-04-07 Thread Tyler MacDonald
Alan DeKok <[EMAIL PROTECTED]> wrote: > > It appears that several other GPL apps have added a special clause > > to their license that allows them to be linked against OpenSSL. > > > > Could this be done for freeradius/freeradius-postgresql as well? > > I have no objection to that. > > D

[GENERAL] can we remove this guy from the list?

2006-04-07 Thread Scott Marlowe
Everytime I send an email to the pgsql-general list I get a failure message back saying this guy: [EMAIL PROTECTED] is over his local limit. Is it possible to remove him from the mailing list? Is it something I can do? I kinda doubt it, so that's why I'm asking here. -

Re: [GENERAL] Debian package for freeradius_postgresql module

2006-04-07 Thread Tyler MacDonald
Scott Marlowe <[EMAIL PROTECTED]> wrote: > > GPL partisans feel that BSD-with-advertising-clause is not compatible > > with the GPL. I think the sticking point here is that openssl is using > > an advertising clause. > > But the way Douglas' message read, it was only GPL packages that should > be

Re: Allow linking against OpenSSL? (Was Re: [GENERAL] Debian

2006-04-07 Thread Scott Marlowe
On Fri, 2006-04-07 at 17:24, Tyler MacDonald wrote: > Greetings FreeRadius people, > > This discussion started on the postgresql's "pgsql-general" mailing > list. The problem here is that the freeradius-postgresql package needs to > link against libpgsql, which means that it may be indirectl

Re: [GENERAL] Debian package for freeradius_postgresql module

2006-04-07 Thread Scott Marlowe
On Fri, 2006-04-07 at 17:16, Tom Lane wrote: > Scott Marlowe <[EMAIL PROTECTED]> writes: > > I thought from Douglas' message, it appeared BSD packages didn't need > > such a clause... > > GPL partisans feel that BSD-with-advertising-clause is not compatible > with the GPL. I think the sticking po

Allow linking against OpenSSL? (Was Re: [GENERAL] Debian package for freeradius_postgresql module)

2006-04-07 Thread Tyler MacDonald
Greetings FreeRadius people, This discussion started on the postgresql's "pgsql-general" mailing list. The problem here is that the freeradius-postgresql package needs to link against libpgsql, which means that it may be indirectly linked against openssl. There is a conflict between OpenSS

Re: [GENERAL] Debian package for freeradius_postgresql module

2006-04-07 Thread Tom Lane
Scott Marlowe <[EMAIL PROTECTED]> writes: > I thought from Douglas' message, it appeared BSD packages didn't need > such a clause... GPL partisans feel that BSD-with-advertising-clause is not compatible with the GPL. I think the sticking point here is that openssl is using an advertising clause.

Re: [GENERAL] Debian package for freeradius_postgresql module

2006-04-07 Thread Scott Marlowe
On Fri, 2006-04-07 at 17:08, Tom Lane wrote: > Douglas McNaught <[EMAIL PROTECTED]> writes: > > I don't think so. I got curious and looked at what's on my Ubuntu > > system: Courier IMAP is GPL with an additional clause that explicitly > > allows linking with OpenSSL; Postfix has an Apache-ish li

Re: [GENERAL] Debian package for freeradius_postgresql module

2006-04-07 Thread Tom Lane
Douglas McNaught <[EMAIL PROTECTED]> writes: > I don't think so. I got curious and looked at what's on my Ubuntu > system: Courier IMAP is GPL with an additional clause that explicitly > allows linking with OpenSSL; Postfix has an Apache-ish license; Exim > is GPL and also explicitly allows linki

Re: [GENERAL] Debian package for freeradius_postgresql module

2006-04-07 Thread Douglas McNaught
Tom Lane <[EMAIL PROTECTED]> writes: > Tyler MacDonald <[EMAIL PROTECTED]> writes: >> OK, I'm kind of confused about how the legal red tape works here. >> Debian packages all sorts of GPL code, and both openssl and postgres are >> released under more liberal licenses. About the only legal iss

Re: [GENERAL] Debian package for freeradius_postgresql module

2006-04-07 Thread Tom Lane
Tyler MacDonald <[EMAIL PROTECTED]> writes: > OK, I'm kind of confused about how the legal red tape works here. > Debian packages all sorts of GPL code, and both openssl and postgres are > released under more liberal licenses. About the only legal issue I could see > is the legalities surroun

[GENERAL] Creating a trigger on n tables?

2006-04-07 Thread Bjørn T Johansen
Is there an easier way to create the same trigger for n tables or do I need to run create trigger n times? Regards, BTJ -- --- Bjørn T Johansen [EMAIL PROTECTED] --

Re: [GENERAL] pgAdmin3 question

2006-04-07 Thread lmyho
--- Dave Page wrote: > > We have test database created in the initdb cluster, but on the Add Server > > page > of > > pgAdmin3, the Maintenance DB dropdown box does not show this database. How > > can > we > > make it to display this db in the dropdown box too? > > You can't without hackin

Re: [GENERAL] pgAdmin3 question

2006-04-07 Thread Dave Page
> We have test database created in the initdb cluster, but on the Add Server > page of > pgAdmin3, the Maintenance DB dropdown box does not show this database. How > can we > make it to display this db in the dropdown box too? You can't without hacking the code. Those databases are just hel

Re: [GENERAL] Debian package for freeradius_postgresql module

2006-04-07 Thread Tyler MacDonald
lmyho <[EMAIL PROTECTED]> wrote: > > Oh right, they're claiming that they can't distribute freeradius using > > postgresql because postgresql links to OpenSSL. freeradius is GPL which > > makes for an incompatabilty. Not something PostgreSQL is responsible > > for, given Debian could compile withou

[GENERAL] pgAdmin3 question

2006-04-07 Thread lmyho
Hi All, Have a question on pgAdmin3: We have test database created in the initdb cluster, but on the Add Server page of pgAdmin3, the Maintenance DB dropdown box does not show this database. How can we make it to display this db in the dropdown box too? As the Maintenance DB dropdown box do

Re: [GENERAL] Running Command Line From Trigger?

2006-04-07 Thread Terry Lee Tucker
On Friday 07 April 2006 03:52 pm, Yudie Pg saith: > Help! > Try to install plperl > ./createlang plperl mydb > > createlang: language installation failed: ERROR: could not access file > "$libdir/plperl": No such file or directory Do you have the Perl module on your machine? If not, you can get

Re: [GENERAL] Running Command Line From Trigger?

2006-04-07 Thread Yudie Pg
Help! Try to install plperl ./createlang plperl mydb   createlang: language installation failed: ERROR:  could not access file "$libdir/plperl": No such file or directory          

Re: [GENERAL] User-defined types

2006-04-07 Thread Tom Lane
"codeWarrior" <[EMAIL PROTECTED]> writes: > BTW: I was thinking more along the lines of: > SELECT PT.*, PA.* FROM pg_attribute PA > JOIN pg_type PT ON PA.attrelid = PT.typrelid > JOIN pg_class PC ON PC.oid = PA.attrelid > WHERE PT.typnamespace = 2200 AND PA.attnum > 0 AND PC.relkind IN ('r', 'c',

Re: [GENERAL] User-defined types

2006-04-07 Thread codeWarrior
I figured it out BTW: I was thinking more along the lines of: SELECT PT.*, PA.* FROM pg_attribute PA JOIN pg_type PT ON PA.attrelid = PT.typrelid JOIN pg_class PC ON PC.oid = PA.attrelid WHERE PT.typnamespace = 2200 AND PA.attnum > 0 AND PC.relkind IN ('r', 'c', 'v'); Perhaps this should b

Re: [GENERAL] User-defined types

2006-04-07 Thread Tom Lane
"codeWarrior" <[EMAIL PROTECTED]> writes: > Anyone know of a quick and dirty query that can retrieve the various type > definitions ? I am looking to retrieve the schema-equivalent representation > of a custom (user-defined) types. Invoking "pg_dump -s" is by far the most future-proof approach.

Re: [GENERAL] could not create shared memory segment in Windows XP

2006-04-07 Thread Merlin Moncure
On 4/5/06, Andrus <[EMAIL PROTECTED]> wrote: > I'm unable to create database cluster in Windows 2000 server. > > initdb returns error > > FATAL: could not create shared memory segment: No such file or directory > > any idea how to create cluster in Windows 2000 ? are you trying to initdb from te

Re: [GENERAL] Running Command Line From Trigger?

2006-04-07 Thread Terry Lee Tucker
Reminds me of an old Star Trek - Next Generation episode. They were stuck in a time loop reliving the same series of events over and over. They had to leave themselves a clue so they could figure it out next time around. Maybe your post is it ;o) On Friday 07 April 2006 02:12 pm, Scott Marlowe

Re: [GENERAL] Running Command Line From Trigger?

2006-04-07 Thread Scott Marlowe
On Fri, 2006-04-07 at 12:38, Terry Lee Tucker wrote: > On Friday 07 April 2006 01:32 pm, Yudie Pg saith: > > Back to my original question where is it possible to run a command line > > from a function? > > From an earlier post: > "Note that plpgsql cannot run external programs on purpose. It's a

Re: [GENERAL] User-defined types

2006-04-07 Thread Daniel Blaisdell
\dT -DanielOn 4/7/06, codeWarrior <[EMAIL PROTECTED]> wrote: Anyone know of a quick and dirty query that can retrieve the various typedefinitions ? I am looking to retrieve the schema-equivalent representationof a custom (user-defined) types.---(end of broadcast)---

[GENERAL] User-defined types

2006-04-07 Thread codeWarrior
Anyone know of a quick and dirty query that can retrieve the various type definitions ? I am looking to retrieve the schema-equivalent representation of a custom (user-defined) types. ---(end of broadcast)--- TIP 1: if posting/reading through Us

Re: [GENERAL] Running Command Line From Trigger?

2006-04-07 Thread Terry Lee Tucker
On Friday 07 April 2006 01:32 pm, Yudie Pg saith: > Back to my original question where is it possible to run a command line > from a function? From an earlier post: "Note that plpgsql cannot run external programs on purpose. It's a security and safety issue." ---(end of b

Re: [GENERAL] Running Command Line From Trigger?

2006-04-07 Thread Yudie Pg
Back to my original question where is it possible to run a command line from a function?

Re: [GENERAL] Running Command Line From Trigger?

2006-04-07 Thread Tony Caduto
Yudie Pg wrote: I'm running postgresql 7.4.1. is it can't really be used for trigger function? http://www.postgresql.org/docs/7.4/static/plperl-missing.html That is true, but you can call a plperl function from a plpgsql trigger function. Wouldn't that work? -- Tony Caduto

Re: [GENERAL] Running Command Line From Trigger?

2006-04-07 Thread Scott Marlowe
On Fri, 2006-04-07 at 10:42, Yudie Pg wrote: > > > I'm running postgresql 7.4.1. is it can't really be used for trigger > function? > > http://www.postgresql.org/docs/7.4/static/plperl-missing.html > Quick followup, the latest plPHP does not work on Postgresql versions < 8.0. So yo

Re: [GENERAL] Running Command Line From Trigger?

2006-04-07 Thread Scott Marlowe
On Fri, 2006-04-07 at 10:42, Yudie Pg wrote: > > > I'm running postgresql 7.4.1. is it can't really be used for trigger > function? > > http://www.postgresql.org/docs/7.4/static/plperl-missing.html > Two points: 1: Upgrade to 7.4.12 (or whatever the latest version is) immediately.

Re: [GENERAL] Running Command Line From Trigger?

2006-04-07 Thread Yudie Pg
  I'm running postgresql 7.4.1. is it can't really be used for trigger function?   http://www.postgresql.org/docs/7.4/static/plperl-missing.html          

Re: [GENERAL] postmaster going down own its on

2006-04-07 Thread Tom Lane
Douglas McNaught <[EMAIL PROTECTED]> writes: > Tom Lane <[EMAIL PROTECTED]> writes: >> Could be. The actual standard use of SIGTERM is to kill processes >> belonging to your terminal process group when you log out. > I thought that was SIGHUP? Doh. Not enough caffeine absorbed yet. As penance,

Re: [GENERAL] postmaster going down own its on

2006-04-07 Thread Douglas McNaught
Tom Lane <[EMAIL PROTECTED]> writes: > Martijn van Oosterhout writes: >> On Fri, Apr 07, 2006 at 03:03:09PM +0100, Richard Huxton wrote: >>> What would be sending SIGTERM to a backend? > >> The only other thing I've ever heard of is some systems do a sigterm >> when you pass a quota limit? > > Co

Re: [GENERAL] postmaster going down own its on

2006-04-07 Thread Tom Lane
Martijn van Oosterhout writes: > On Fri, Apr 07, 2006 at 03:03:09PM +0100, Richard Huxton wrote: >> What would be sending SIGTERM to a backend? > The only other thing I've ever heard of is some systems do a sigterm > when you pass a quota limit? Could be. The actual standard use of SIGTERM is t

Re: [GENERAL] case insensitive match in unicode

2006-04-07 Thread Mike Rylander
On 4/6/06, SunWuKung <[EMAIL PROTECTED]> wrote: > In article <[EMAIL PROTECTED]>, kleptog@svana.org says... > > On Mon, Mar 27, 2006 at 12:45:05PM +0200, SunWuKung wrote: > > > This sounds like a very interesting concept. > > > It wouldn't be 'case insensitive' just insensitive. > > > > > > The way

Re: [GENERAL] postmaster going down own its on

2006-04-07 Thread Martijn van Oosterhout
On Fri, Apr 07, 2006 at 03:03:09PM +0100, Richard Huxton wrote: > >I'm not sure it's that--the OOM killer uses SIGKILL which would take > >down the server before it could write that log entry. > > Hmm... (tests it) you're right. What would be sending SIGTERM to a backend? The only other thing I'v

%Re: %Re: [GENERAL] % tsearch gendict

2006-04-07 Thread David Gama Rodrí­guez
Teodor Sigaev wrote: I see there are some changes in tsearch from postgresql 7.4.3 to postgresql 8.1.3 version, you add some new functions i think and change the tsearch.sql template right? I don't remember what exactly, but why do you ask? Different version on Gentroo and Sun? There is a l

Re: [GENERAL] postmaster going down own its on

2006-04-07 Thread Richard Huxton
Douglas McNaught wrote: Richard Huxton writes: surabhi.ahuja wrote: hi, is it possible for postmaster to go doen on its own? all what the logs say is FATAL: terminating connection dur to administrator's command. Someone or something is issuing a kill command. It couldn't be the infamous Linu

Re: RES: [GENERAL] FAQ 1.1

2006-04-07 Thread Douglas McNaught
Renato Cramer <[EMAIL PROTECTED]> writes: > How much bullshit! > > is there no more nothing to do? Take a close look at the message date. :) -Doug ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to

Re: [GENERAL] postmaster going down own its on

2006-04-07 Thread Douglas McNaught
Richard Huxton writes: > surabhi.ahuja wrote: >> hi, is it possible for postmaster to go doen on its own? >> all what the logs say is FATAL: terminating connection dur to >> administrator's command. > > Someone or something is issuing a kill command. It couldn't be the > infamous Linux out-of-mem

Re: [GENERAL] case insensitive match in unicode

2006-04-07 Thread Martijn van Oosterhout
On Thu, Apr 06, 2006 at 11:12:26PM +0200, SunWuKung wrote: > > There is also a locale-independant case-mapping module there plus > > various locale specific ones also. > > > > http://icu.sourceforge.net/userguide/Transform.html > > http://icu.sourceforge.net/userguide/caseMappings.html > > http://

Re: [GENERAL] help needed (which group do I post these questions to?)

2006-04-07 Thread Martijn van Oosterhout
On Thu, Apr 06, 2006 at 05:39:00PM -0700, Bit Byter wrote: > 1). Does anyone know how to execute a stored procedure (i.e. PL/PGSQL > function), using libpq, and passing it parameters?. An example will be > superb, as I have not managed to find one that does this after about a > week of Googling. S

Re: [GENERAL] could not create shared memory segment in Windows XP

2006-04-07 Thread Ben Trewern
Have you got Cygwin installed? I had similar problems due to Cygwin being eariler in my PATH than Pg. Regards, Ben "Andrus" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I'm unable to create database cluster in Windows 2000 server. > > initdb returns error > > FATAL: could no

[GENERAL] help needed (which group do I post these questions to?)

2006-04-07 Thread Bit Byter
I am getting a little desperate as I have not got any replies yet. I am wondering if this is the correct group for my questions. If not, please point me to the appropriate group. My questions revolve around libpq. 1). Does anyone know how to execute a stored procedure (i.e. PL/PGSQL function), us

ENC: [GENERAL] FAQ 1.1

2006-04-07 Thread Renato Cramer
is there no more nothing to do? >-Mensagem original- >De: Michael Fuhr [mailto:[EMAIL PROTECTED] >Enviada em: sexta-feira, 7 de abril de 2006 09:22 >Para: Jim Nasby; Chris Browne; pgsql-general@postgresql.org >Assunto: Re: [GENERAL] FAQ 1.1 > > >On Fri, Apr 07, 2006 at 10:26:32AM +, U

Re: [GENERAL] postmaster going down own its on

2006-04-07 Thread Richard Huxton
surabhi.ahuja wrote: hi, is it possible for postmaster to go doen on its own? all what the logs say is FATAL: terminating connection dur to administrator's command. Someone or something is issuing a kill command. It couldn't be the infamous Linux out-of-memory handler, could it? Check your sy

RES: [GENERAL] FAQ 1.1

2006-04-07 Thread Renato Cramer
How much bullshit! is there no more nothing to do? >-Mensagem original- >De: Michael Fuhr [mailto:[EMAIL PROTECTED] >Enviada em: sexta-feira, 7 de abril de 2006 09:22 >Para: Jim Nasby; Chris Browne; pgsql-general@postgresql.org >Assunto: Re: [GENERAL] FAQ 1.1 > > >On Fri, Apr 07, 2006 at

Re: [GENERAL] postmaster going down own its on

2006-04-07 Thread James Cradock
It's not normal. What's the installation? OS, applications connecting to the server, etc. On Apr 7, 2006, at 8:20 AM, surabhi.ahuja wrote:hi, is it possible for postmaster to go doen on its own?   all what the logs say is FATAL: terminating connection dur to administrator's command.   thanks, regar

Re: [GENERAL] FAQ 1.1

2006-04-07 Thread Michael Fuhr
On Fri, Apr 07, 2006 at 10:26:32AM +, User Roman wrote: > Looks like a missed opportunity for a April 1st announcement > of disambiguating the two by renaming "postgres" to "pregross". :) Not exactly that change, but http://archives.postgresql.org/pgsql-hackers/2005-04/msg00023.ph

[GENERAL] postmaster going down own its on

2006-04-07 Thread surabhi.ahuja
hi, is it possible for postmaster to go doen on its own?   all what the logs say is FATAL: terminating connection dur to administrator's command.   thanks, regards Surabhi

Re: [GENERAL] Use functions in Pl/Perl language

2006-04-07 Thread User Roman
# [EMAIL PROTECTED] / 2006-03-29 17:17:48 -0800: > Hello, > > I would like to create a function that lets me to search in a table > rows according differents parameters. > I looked in the documentation of postgresql 8.1 about Pl/Perl > procedures but I didn't found how to cross each row of a table

Re: %Re: [GENERAL] % tsearch gendict

2006-04-07 Thread Teodor Sigaev
I see there are some changes in tsearch from postgresql 7.4.3 to postgresql 8.1.3 version, you add some new functions i think and change the tsearch.sql template right? I don't remember what exactly, but why do you ask? Different version on Gentroo and Sun? There is a lot tsearch2 improvements

Re: [GENERAL] Postgres Library natively available for Mac OSX Intel?

2006-04-07 Thread User Roman
# [EMAIL PROTECTED] / 2006-03-31 10:05:06 +0200: > I would like to know if somebody already has a Mac OSX Intel 10.4.5 > pg-Library (for C, C++, Objective C) or knows how to compile it? What problems did you have building libpq? Note: I'm not an OSX user. -- How many Vietnam vets does

Re: [GENERAL] FAQ 1.1

2006-04-07 Thread User Roman
# [EMAIL PROTECTED] / 2006-04-06 12:03:18 -0400: > On Apr 3, 2006, at 11:23 PM, Chris Browne wrote: > >Yeah, someone at the office was asking me on the elevator about > >whether some Post-something was somehow up and coming. > > > >In retrospect, I think he was trying to pronounce Postgre, and arri

Re: [GENERAL] how to document database

2006-04-07 Thread Ottavio Campana
Kaloyan Iliev wrote: > Hi, > > I'm using postgresql_autodoc. It is perfect for me. And if you have > comments in the database the created document is like real documentation:-) I can't make it work. I'm running Debian etch, and I always get [EMAIL PROTECTED]:/tmp$ postgresql_autodoc -d tost Can'

Re: [GENERAL] Debian package for freeradius_postgresql module

2006-04-07 Thread Martijn van Oosterhout
On Thu, Apr 06, 2006 at 02:40:03PM -0700, Tyler MacDonald wrote: > This looks like part of the debate: > > http://lists.debian.org/debian-legal/2002/11/msg00254.html > > I dont know if this applies to openssl though... Oh right, they're claiming that they can't distribute freer

[GENERAL] how to document database

2006-04-07 Thread Ottavio Campana
I need to document the database I develop so that other people can easily understand how it works. I particularly want to document the stored procedures. By now I've used a javadoc style to document them. I can't use tools like doxygen on them but it is always better than nothing. I'd like to kn

Re: [GENERAL] Column descriptions - could they be propagated to new

2006-04-07 Thread Clive Page
On Thu, 6 Apr 2006, Jim Nasby wrote: I seem to recall some astronomer having created some custom types for storing astronomical data in PostgreSQL. Or perhaps he was using PostGIS. I know that other astronomers are using PostgreSQL/PostGIS so if you look around you might be able to save yourse

Re: [GENERAL] MediaWiki and Postgresql?

2006-04-07 Thread Ian Barwick
On 4/4/06, Scott Marlowe <[EMAIL PROTECTED]> wrote: (...) > Given that this page: > > http://www.mediawiki.org/wiki/Help:%24wgDBtype > > says: > > Use ""mysql"" for working code and ""PostgreSQL"" for development/broken > code. The documentation in the MediaWiki wiki isn't always up to date, I sus

Re: [GENERAL] Debian package for freeradius_postgresql module

2006-04-07 Thread Martijn van Oosterhout
On Thu, Apr 06, 2006 at 02:39:44PM -0700, lmyho wrote: > > Sounds terribly unlikely, PostgreSQLs licence doesn't conflict with any > > use anywhere. Can you provide a reference? > > > > I wish things are not like this too! so I won't have to go through so much > trouble! > But that's what happe

Re: [GENERAL] MediaWiki and Postgresql?

2006-04-07 Thread Ian Barwick
On 4/6/06, Jim Nasby <[EMAIL PROTECTED]> wrote: (...) > If I'm not confusing wiki's (and I'm offline now, so I can't check), > Mediawiki is pretty un-interested in supporting PostgreSQL (hard to > imagine why, given that some of their folks are paid by MySQL AB), so > a fork was created on pgFoundr