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 pgFoundry. I
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 happened:-(
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 suspect.
I'd guess
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
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
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
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't
# [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 arrived
at
# [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
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
# [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 with
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
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.php
--
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,
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
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
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 +, User
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),
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 not create
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
Richard Huxton dev@archonet.com 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
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
Douglas McNaught wrote:
Richard Huxton dev@archonet.com 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
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
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've
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 I imagine it now
Martijn van Oosterhout kleptog@svana.org 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
Tom Lane [EMAIL PROTECTED] writes:
Martijn van Oosterhout kleptog@svana.org 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?
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, here's a
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
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.
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 you'd
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
Back to my original question where is it possible to run a command line from a function?
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
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
\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
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
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
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 terminal
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.
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
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',
'v');
Help!
Try to install plperl
./createlang plperl mydb
createlang: language installation failed: ERROR: could not access file $libdir/plperl: No such file or directory
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 it
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
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 without SSL and
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 helpful
--- Dave Page dpage@vale-housing.co.uk 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
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]
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 surrounding
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 issue I could
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 linking
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 license;
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.
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
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 point here
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 indirectly
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 affected,
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.
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
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 indirectly
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 (default);
commit;
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 on
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:
* 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 issue I
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
* 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 advertising clause
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 like Gentoo?
I
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 have seen has been
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 somehow change
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 anyone would
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.
Debian should
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
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 doesn't somehow
75 matches
Mail list logo