Re: [HACKERS] misread release notes

2007-02-07 Thread ohp
Hi Tom,
On Tue, 6 Feb 2007, Tom Lane wrote:

 Date: Tue, 06 Feb 2007 11:50:56 -0500
 From: Tom Lane [EMAIL PROTECTED]
 To: ohp@pyrenet.fr
 Cc: pgsql-hackers list pgsql-hackers@postgresql.org
 Subject: Re: [HACKERS] misread release notes

 ohp@pyrenet.fr writes:
  I read the fix incorrect permission check in
  information_schema_key_column_usage_view chapter in HISTORY far too fast
  and fed psql on each database with share/information_schema.sql.
  Too late to stop it!
  What did I do wrong, and how can I go backwards (I imagine %I broke
  something!)

 I don't think you changed anything --- none of the commands say OR REPLACE
 so they'd just all fail.
Yes but I saw a lot of inserts...


   regards, tom lane


-- 
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
15, Chemin des Monges+33-5-61-50-97-01 (Fax)
31190 AUTERIVE   +33-6-07-63-80-64 (GSM)
FRANCE  Email: ohp@pyrenet.fr
--
Make your life a dream, make your dream a reality. (St Exupery)

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


Re: [HACKERS] misread release notes

2007-02-06 Thread Tom Lane
ohp@pyrenet.fr writes:
 I read the fix incorrect permission check in
 information_schema_key_column_usage_view chapter in HISTORY far too fast
 and fed psql on each database with share/information_schema.sql.
 Too late to stop it!
 What did I do wrong, and how can I go backwards (I imagine %I broke
 something!)

I don't think you changed anything --- none of the commands say OR REPLACE
so they'd just all fail.

regards, tom lane

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

   http://archives.postgresql.org


Re: [HACKERS] misread release notes

2007-02-06 Thread Andrew Dunstan

ohp@pyrenet.fr wrote:

Unrelated, I have problem with conforming string: adding a E is easy in C
or PHP but SpamAssassin has this plpgsql function  :


  

[snip]

As you see, token is bytea where do I put the E in the insert query?

  


Since you aren't using a string literal in this function for token or 
anything else, AFAICS, I don't understand why you would need to.


cheers

andrew

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