Re: [GENERAL] [EMAIL PROTECTED]

2008-08-04 Thread Robert Treat 
Hiroshi-san, 

Is this something specific to windows? If so, should this be consider a bug?

Robert Treat

On Sunday 03 August 2008 18:01:05 Hiroshi Saito wrote:
 Hi.

 Sorry, it was not included in release.
 please see,
 http://winpg.jp/~saito/pg_work/OSSP_win32/

 Regards,
 Hiroshi Saito

 Hi all,
 
 I installed postgresql-8.3.3-1 for win2000 with UUID-OSSP. Following
 the documentation I issued this query:
 
 SELECT uuid_generate_v3(uuid_ns_url(), 'http://www.postgresql.org');
 
 but the DB returns with this error message:
 
 ERROR: function uuid_ns_url() does not exist
 SQL state: 42883
 Hint: No function matches the given name and argument types. You might
 need to add explicit type casts.
 Character: 25
 
 Any hint to use UUID within my database tirggers?
 
 Thank you,
 Laci
 
 
 --
 Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
 To make changes to your subscription:
 http://www.postgresql.org/mailpref/pgsql-general



-- 
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] [EMAIL PROTECTED]

2008-08-04 Thread Hiroshi Saito 
Hi Robert-san

Ahh yes..
I'm sorry delaying release bugfix was not included in pg8.3.3. 
Then,I will adjust next release(1.6.3/4) with Rarf-san again.

Regards,
Hiroshi Saito.

Hiroshi-san, 

Is this something specific to windows? If so, should this be consider a bug?

Robert Treat

On Sunday 03 August 2008 18:01:05 Hiroshi Saito wrote:
 Hi.

 Sorry, it was not included in release.
 please see,
 http://winpg.jp/~saito/pg_work/OSSP_win32/

 Regards,
 Hiroshi Saito

 Hi all,
 
 I installed postgresql-8.3.3-1 for win2000 with UUID-OSSP. Following
 the documentation I issued this query:
 
 SELECT uuid_generate_v3(uuid_ns_url(), 'http://www.postgresql.org');
 
 but the DB returns with this error message:
 
 ERROR: function uuid_ns_url() does not exist
 SQL state: 42883
 Hint: No function matches the given name and argument types. You might
 need to add explicit type casts.
 Character: 25
 
 Any hint to use UUID within my database tirggers?
 
 Thank you,
 Laci
 
 
 --
 Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
 To make changes to your subscription:
 http://www.postgresql.org/mailpref/pgsql-general



-- 
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] [EMAIL PROTECTED]

2008-08-03 Thread grafl 

Hi all,

I installed postgresql-8.3.3-1 for win2000 with UUID-OSSP. Following  
the documentation I issued this query:


SELECT uuid_generate_v3(uuid_ns_url(), 'http://www.postgresql.org');

but the DB returns with this error message:

ERROR: function uuid_ns_url() does not exist
SQL state: 42883
Hint: No function matches the given name and argument types. You might  
need to add explicit type casts.

Character: 25

Any hint to use UUID within my database tirggers?

Thank you,
Laci


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

UUID in windows was Re: [GENERAL] [EMAIL PROTECTED]

2008-08-03 Thread Scott Marlowe 
Pretty sure the uuid stuff only works in non-windows OSes.

Oh, and next time, use a more descriptive subject line for better /
quicker responses.

On Sun, Aug 3, 2008 at 2:18 PM,  [EMAIL PROTECTED] wrote:
 Hi all,

 I installed postgresql-8.3.3-1 for win2000 with UUID-OSSP. Following the
 documentation I issued this query:

 SELECT uuid_generate_v3(uuid_ns_url(), 'http://www.postgresql.org');

 but the DB returns with this error message:

 ERROR: function uuid_ns_url() does not exist
 SQL state: 42883
 Hint: No function matches the given name and argument types. You might need
 to add explicit type casts.
 Character: 25

 Any hint to use UUID within my database tirggers?

 Thank you,
 Laci


 --
 Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
 To make changes to your subscription:
 http://www.postgresql.org/mailpref/pgsql-general


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] [EMAIL PROTECTED]

2008-08-03 Thread Hiroshi Saito 
Hi.

Sorry, it was not included in release. 
please see,
http://winpg.jp/~saito/pg_work/OSSP_win32/

Regards,
Hiroshi Saito

Hi all,

I installed postgresql-8.3.3-1 for win2000 with UUID-OSSP. Following  
the documentation I issued this query:

SELECT uuid_generate_v3(uuid_ns_url(), 'http://www.postgresql.org');

but the DB returns with this error message:

ERROR: function uuid_ns_url() does not exist
SQL state: 42883
Hint: No function matches the given name and argument types. You might  
need to add explicit type casts.
Character: 25

Any hint to use UUID within my database tirggers?

Thank you,
Laci


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] [EMAIL PROTECTED]: Re: port fault on pg_ctl's

2007-02-03 Thread Bruce Momjian 

Documentation patch attached and applied to HEAD and 8.2.X.

---

Palle Girgensohn wrote:
 
 
 --On onsdag, december 13, 2006 11.04.54 -0500 Tom Lane [EMAIL PROTECTED] 
 wrote:
 
  Gergely CZUCZY [EMAIL PROTECTED] writes:
  This is wierd, I agree. The split between server and client is really
  made = in the postgresql sources,
  I just follow their guidelines.
 
  [ checks RPM specfiles ... ]  Both Devrim and I put pg_ctl in the server
  subpackage, dunno where you think that the sources encourage something
  else ...
 
  regards, tom lane
 
 
 
 From INSTALL:
 ...
Client-only installation: If you want to install only the client
applications and interface libraries, then you can use these
commands:
 gmake -C src/bin install
 gmake -C src/include install
 gmake -C src/interfaces install
 gmake -C doc install
 ...
 
 src/bin has pg_ctl et al. Maybe encourage is a strong word... ;-)
 
 Just moving pg_ctl to the server package and let the server package depend 
 on libpq.so.5 should help in this case, I guess...
 
 /Palle
 
 
 ---(end of broadcast)---
 TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

-- 
  Bruce Momjian   [EMAIL PROTECTED]
  EnterpriseDBhttp://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +
Index: doc/src/sgml/installation.sgml
===
RCS file: /cvsroot/pgsql/doc/src/sgml/installation.sgml,v
retrieving revision 1.281
diff -c -c -r1.281 installation.sgml
*** doc/src/sgml/installation.sgml	1 Feb 2007 19:10:24 -	1.281
--- doc/src/sgml/installation.sgml	3 Feb 2007 22:59:31 -
***
*** 1365,1370 
--- 1365,1372 
  userinputgmake -C src/interfaces install/
  userinputgmake -C doc install/
  /screen
+ filenamesrc/bin/ has a few binaries for server-only use,
+ but they are small.
  /para
 /formalpara
/step

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org/

[GENERAL] [EMAIL PROTECTED]: Re: port fault on pg_ctl's place]

2006-12-13 Thread Gergely CZUCZY 
hello,

please read this post and the comment for it, maybe
the postgresql may need an update at separating the binaries.

this was pointed out in the FreeBSD ports collection.

- Forwarded message from Palle Girgensohn [EMAIL PROTECTED] -

Date: Tue, 12 Dec 2006 11:52:00 +0100
From: Palle Girgensohn [EMAIL PROTECTED]
To: Gergely CZUCZY [EMAIL PROTECTED]
Subject: Re: major port fault on pg_ctl's place

Hi!

This is wierd, I agree. The split between server and client is really made in 
the postgresql sources, 
I just follow their guidelines. None the less, I'll look into patching the 
sources to get this 
correct. Thanks for pointing it out.

Regards,
PAlle

--On torsdag, december 07, 2006 17.19.28 +0100 Gergely CZUCZY [EMAIL 
PROTECTED] wrote:

hello

i've upgrading atm a 8.1.4 double-installation (normal+testserver).
i've updated -client into 8.2, and now i'm unable to start the 8.1.4
service anymore. the problem is that, the pg_ctl is part of the -client
package, whereas it has nothing to do wit client-side things. postmaster
and postgres are part of -server. so atm, the installation is unstartable.
there was a change among them.

i had updated the client to be able to make a dump in 8.2's new format
features.

it would be _very_ wise to move the pg_ctl into -server _ASAP_

Bye,

Gergely Czuczy
mailto: [EMAIL PROTECTED]

--
Weenies test. Geniuses solve problems that arise.






- End forwarded message -

Bye,

Gergely Czuczy
mailto: [EMAIL PROTECTED]

-- 
Weenies test. Geniuses solve problems that arise.


pgpkbR7Pa36LK.pgp
Description: PGP signature

Re: [GENERAL] [EMAIL PROTECTED]: Re: port fault on pg_ctl's place]

2006-12-13 Thread Tom Lane 
Gergely CZUCZY [EMAIL PROTECTED] writes:
 This is wierd, I agree. The split between server and client is really made =
 in the postgresql sources,
 I just follow their guidelines.

[ checks RPM specfiles ... ]  Both Devrim and I put pg_ctl in the server
subpackage, dunno where you think that the sources encourage something
else ...

regards, tom lane

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly

Re: [GENERAL] [EMAIL PROTECTED]: Re: port fault on pg_ctl's place]

2006-12-13 Thread Tom Lane 
Palle Girgensohn [EMAIL PROTECTED] writes:
 From INSTALL:
 ...
Client-only installation: If you want to install only the client
applications and interface libraries, then you can use these
commands:
 gmake -C src/bin install
 gmake -C src/include install
 gmake -C src/interfaces install
 gmake -C doc install
 ...

 src/bin has pg_ctl et al. Maybe encourage is a strong word... ;-)

Actually there's quite a lot of stuff under src/bin that has no value in
a client-only installation: initdb, ipcclean, pg_controldata,
pg_resetxlog ... probably those instructions need some amendment.

regards, tom lane

---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [GENERAL] [EMAIL PROTECTED]: Re: port fault on pg_ctl's

2006-12-13 Thread Palle Girgensohn 



--On onsdag, december 13, 2006 11.04.54 -0500 Tom Lane [EMAIL PROTECTED] 
wrote:



Gergely CZUCZY [EMAIL PROTECTED] writes:

This is wierd, I agree. The split between server and client is really
made = in the postgresql sources,
I just follow their guidelines.


[ checks RPM specfiles ... ]  Both Devrim and I put pg_ctl in the server
subpackage, dunno where you think that the sources encourage something
else ...

regards, tom lane





From INSTALL:

...
  Client-only installation: If you want to install only the client
  applications and interface libraries, then you can use these
  commands:
gmake -C src/bin install
gmake -C src/include install
gmake -C src/interfaces install
gmake -C doc install
...

src/bin has pg_ctl et al. Maybe encourage is a strong word... ;-)

Just moving pg_ctl to the server package and let the server package depend 
on libpq.so.5 should help in this case, I guess...


/Palle


---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly

Re: [GENERAL] [EMAIL PROTECTED],65$($k!NY$N1|MMEp;#Ej9F$N?$BJT

2005-12-15 Thread Michelle Konzack 
Hello *,

Since some days we become SPAMed.

How can this happen, if the list is subscriber only?
I have this question, because [EMAIL PROTECTED] and
[EMAIL PROTECTED] are two servers where I do not filter
SPAM (wast of resources because they are subscriber only)

Greetings
Michelle


Am 2005-12-07 23:15:45, schrieb ?$BNY$N$$NL$OAG?M100%:
 ?¡?ª?ª?ª?ª?ª?ª?ª?ª?ª?f?l?Š?e?ê?Ÿ?µ?}?K?W???ª?ª?ª 2005/?N?Ì?£?Á?å?? ?ª?ª?¡

snip



-- 
Linux-User #280138 with the Linux Counter, http://counter.li.org/
# Debian GNU/Linux Consultant #
Michelle Konzack   Apt. 917  ICQ #328449886
   50, rue de Soultz MSM LinuxMichi
0033/3/8845235667100 Strasbourg/France   IRC #Debian (irc.icq.com)

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] [EMAIL PROTECTED],65$($k!NY$N1|MMEp;#Ej9F$N?$BJT

2005-12-15 Thread Michelle Konzack 
Hello Tom,

Am 2005-12-15 11:19:03, schrieb Tom Lane:
 Michelle Konzack [EMAIL PROTECTED] writes:
  Since some days we become SPAMed.
 
  How can this happen, if the list is subscriber only?
 
 Marc accidentally turned off the subscribers-only filter for a few days :-(
 It's been fixed, though, and I have not noticed any spam getting through
 since then.  Have you seen any in the last week?

I was some days in Aserbaijan and was coming back today.

And no, no singel SPAM found.

Thanks
Michelle

-- 
Linux-User #280138 with the Linux Counter, http://counter.li.org/
Michelle Konzack   Apt. 917  ICQ #328449886
   50, rue de Soultz MSM LinuxMichi
0033/3/8845235667100 Strasbourg/France   IRC #Debian (irc.icq.com)

---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [GENERAL] [EMAIL PROTECTED] and http://www.postgresql.org/community/lists/

2005-10-12 Thread Robert Treat 
On Thursday 29 September 2005 01:28, pkondratev wrote:
 Hi,
 two questions
 1. Why on page http://www.postgresql.org/community/lists/ no reference
 to [EMAIL PROTECTED]

Oversight, fixed now in CVS, will appear on next site build. 

As a reminder for everyone, questions about website content / correction are 
best sent to pgsql-www or webmaster.  If you post elsewhere, we'll probably 
see it, but it might take awhile. 

-- 
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

[GENERAL] [EMAIL PROTECTED] and http://www.postgresql.org/community/lists/

2005-09-28 Thread pkondratev 
Hi,
two questions
1. Why on page http://www.postgresql.org/community/lists/ no reference
to [EMAIL PROTECTED] 
2. Somebody tried work Kernel Mode Linux and PostgreSQL, there were
problems?

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly