Re: [SQL] surrogate key or not?

On Sunday 08 August 2004 04:29, Kenneth Gonsalves wrote: > but why would anyone want to change the value of an autogenerated serial > row? because of catenating data from two or more databases. ---(end of broadcast)--- TIP 8: explain analyze is y

Re: [SQL] TSearch2 other languages

Cavit, > If you have tsearch support for the other languages we will greatly > appreciate your help. I'm pretty sure that you'll need to implement the other languages yourself. The OpenFTS project (openfts.sourceforge.net) has some documentation on how to do so. The community will really appr

Re: [SQL] reply to setting

Greg Stark wrote: Just as a side comment, one trick I found very helpful in my mail filters is to treat any message with one of my message-ids in the references as a personal message as far as mail notifications. This way I get notifications for any message on a thread following a post of my own. I

Re: [SQL] array_in: '{}}'::text[]

Markus Bertheau wrote: Is there a reason the array_in parser accepts additional closing braces at the end? oocms=# SELECT '{}}'::text[]; text -- {} (1 ÑÑ) Hmmm, I was *about* to say that this is fixed in cvs (and indeed, the array_in parser is significantly tightened up compared to previ

[SQL] TSearch2 other languages

We are working on 9 separate databases for 9 different languages: Turkish, English, Spanish, Russian, Arabic, Danish, German, Japanese and Albanian. tsearch2 (fult-text search) is the one for internal search engine but only English and Russian for tsearch2 are supported in Postgresql sourc

Re: [SQL] sleep function

Hi Greg, On Aug 22, 2004, at 11:52 PM, Greg Stark wrote: test=# create or replace function sleep(integer) returns integer as 'return sleep(shift)' language plperlu; CREATE FUNCTION The original request was for something in built-in to PostgreSQL. I have not used plperl (or any of the other pl la

Re: [SQL] disable constrained (contd.)

Ð ÐÑÐ, 22.08.2004, Ð 02:41, Roman Kunert ÐÐÑÐÑ: > I am also looking for an easy way to disable foreign key constraint > check while importing data from one database to PostgreSQL. The one > suggested method (see link above) that modifies pg_catalog.pg_class is > not preferrable, as it requires

Re: [SQL] array_in: '{}}'::text[]

Ð ÐÐÐ, 23.08.2004, Ð 13:45, Markus Bertheau ÐÐÑÐÑ: > Is there a reason the array_in parser accepts additional closing braces > at the end? In fact it seems to accept everything after the closing brace matching the first opening brace. Thanks -- Markus Bertheau <[EMAIL PROTECTED]>

[SQL] array_in: '{}}'::text[]

Is there a reason the array_in parser accepts additional closing braces at the end? oocms=# SELECT '{}}'::text[]; text -- {} (1 ÑÑ) Thanks -- Markus Bertheau <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 6: Have you searched our lis

Re: [SQL] pg_dump/pg_restore question

Worik wrote: Freinds I am new to this list, and this is my first message. I hope this is the correct forum, and the question not too stupid/simple. I have a database on a debian stable system... dpkg -l postgresql [snip] ii postgresql 7.2.1-2woody5 Object-relational SQL database, descended f