Re: [GENERAL] [pgsql-www] Forums at postgresql.com.au

On Sun, Nov 21, 2010 at 05:04, Alban Hertroys wrote: > On 21 Nov 2010, at 24:17, Trevor Talbot wrote: >> Elliot, Magnus wants forum->list email to come from a per-user address >> so that when he replies directly to that address (without sending it >> to the list), the re

Re: [GENERAL] [pgsql-www] Forums at postgresql.com.au

On Sat, Nov 20, 2010 at 05:46, Elliot Chance wrote: > On 21/11/2010, at 12:32 AM, Magnus Hagander wrote: >> On Sat, Nov 20, 2010 at 14:22, Elliot Chance wrote: >> Use "Reply To All" when you want to send to the list. It's what >> everybody else has been doing for ages :-) If you want to read u

Re: [GENERAL] How to safely compare transaction id?

On 1/11/08, alphax <[EMAIL PROTECTED]> wrote: > I want to determines a given record which visible to current transaction > whether or not be updated after some time point, that time point is > indicated by aother transaction id started and committed in past time. I'm not sure I understand, but ma

Re: [TLM] Re: [GENERAL] How to insert on duplicate key?

On 12/28/07, Robert Treat <[EMAIL PROTECTED]> wrote: > On Thursday 27 December 2007 12:23, Samantha Atkins wrote: > > Since it is known to be dead > > is it automatically removed when there are no live transaction that > > reference or may reference it and its data page space marked available > >

Re: [GENERAL] pgsql cannot read utf8 files moved from windows correctly!

On 12/23/00, Martin Gainty <[EMAIL PROTECTED]> wrote: > the specifics.. > > Some byte oriented protocols expect ASCII characters at the beginning of a > file. > If UTF-8 is used with these protocols, use of the BOM as encoding form > signature should be avoided. Sure, but that isn't true of gener

Re: [GENERAL] pgsql cannot read utf8 files moved from windows correctly!

On 12/23/07, Martin Gainty <[EMAIL PROTECTED]> wrote: > it seems the use of BOM in UTF-8 is discouraged > http://unicode.org/faq/utf_bom.html#BOM Where do you see it being discouraged? ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] pgsql cannot read utf8 files moved from windows correctly!

On 12/20/07, Martijn van Oosterhout <[EMAIL PROTECTED]> wrote: > On Tue, Dec 18, 2007 at 02:53:16PM +0800, bookman bookman wrote: > > I know that every line of utf8 files is started with "fffe" or "feff" > > and ended with "\r\n" in windows but not in linux,so the character > > "1" has a space

Re: [GENERAL] Hijack!

On 12/11/07, Guy Rouillier <[EMAIL PROTECTED]> wrote: > Now, a gripe rightly attributable to the to PG mailing list setup is > that every time I reply, I have to: > > (1) use reply all, because reply is set to go to the individual rather > than the list > > (2) delete all the individual addressees

Re: [GENERAL] Hijack!

On 12/11/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote: > On Tue, 11 Dec 2007 06:48:35 -0800 > "Keith Turner" <[EMAIL PROTECTED]> wrote: > > I apologize; I had assumed that the threads were simply grouped by > > subject. If this is such a problem, probably it should be laid out on > > the list in

Re: [GENERAL] SQL design pattern for a delta trigger?

On 12/10/07, Colin Wetherbee <[EMAIL PROTECTED]> wrote: > Vivek Khera wrote: > > On Dec 10, 2007, at 5:04 PM, Colin Wetherbee wrote: > >> IF (a query matching your old data returns rows) THEN UPDATE with > >> your new data ELSE INSERT your new data > > Still exists race condition. Your race come

Re: [GENERAL] Restore problem

On 12/10/07, Keith Turner <[EMAIL PROTECTED]> wrote: > We are running 8.1 on Windows 2003 server and have had a server crash > over the weekend. A virus is suspected - we maintain an app server on > someone else's network, though we do have anti-virus running, the > symptoms were worrying - so we

Re: [GENERAL] partitioned table query question

On 12/10/07, Trevor Talbot <[EMAIL PROTECTED]> wrote: > On 12/10/07, Tom Lane <[EMAIL PROTECTED]> wrote: > > Erik Jones <[EMAIL PROTECTED]> writes: > > > I guess what I don't understand is that given the query > > > > > SELECT COUNT(*) >

Re: [GENERAL] partitioned table query question

On 12/10/07, Tom Lane <[EMAIL PROTECTED]> wrote: > Erik Jones <[EMAIL PROTECTED]> writes: > > I guess what I don't understand is that given the query > > > SELECT COUNT(*) > > FROM table > > WHERE some_id=34; > > > on a table with the much discussed constraint (34 % 100) = 32 isn't > > simply evalu

Re: [GENERAL] Linux v.s. Mac OS-X Performance

On 11/30/07, Wolfgang Keller <[EMAIL PROTECTED]> wrote: > > For example, if you have an application that needs high > > database write throughput, to make that work well with PostgreSQL you > > must have a controller with a battery backed cache. > Hmm, what would be the difference compared to ple

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

On 11/29/07, Laurent Duperval <[EMAIL PROTECTED]> wrote: > To summarize: when I run unit tests with eclipse (and with Ant) on > Windows, at some point, I run out of available connections. I tried > increasing the maximum number of connections, but then I started seeing > the postgres server die an

Re: [GENERAL] Linux v.s. Mac OS-X Performance

On 11/28/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote: > On Wed, 28 Nov 2007 09:53:34 -0800 > "Trevor Talbot" <[EMAIL PROTECTED]> wrote: > > > On Wed, 2007-11-28 at 07:29 -0700, Scott Ribe wrote: > > > > > Yes, very much so. Windows lac

Re: [GENERAL] Linux v.s. Mac OS-X Performance

On 11/28/07, Magnus Hagander <[EMAIL PROTECTED]> wrote: > Trevor Talbot wrote: > > On 11/28/07, Magnus Hagander <[EMAIL PROTECTED]> wrote: > >> There is at least one other bottleneck, probably more than one. Context > >> switching between processes is a

Re: [GENERAL] Linux v.s. Mac OS-X Performance

On 11/28/07, Magnus Hagander <[EMAIL PROTECTED]> wrote: > On Wed, 2007-11-28 at 07:29 -0700, Scott Ribe wrote: > > > Yes, very much so. Windows lacks the fork() concept, which is what makes > > > PostgreSQL much slower there. > > > > So grossly slower process creation would kill postgres connectio

Re: [GENERAL] Linux v.s. Mac OS-X Performance

On 11/27/07, Tom Lane <[EMAIL PROTECTED]> wrote: > Doug McNaught <[EMAIL PROTECTED]> writes: > > Kind of. Mach is still running underneath (and a lot of the app APIs > > use it directly) but there is a BSD 'personality' above it which > > (AIUI) is big parts of FreeBSD ported to run on Mach. So

Re: [GENERAL] postgresql storage and performance questions

On 11/20/07, Josh Harrison <[EMAIL PROTECTED]> wrote: > We are working on migrating our database from oracle to postgres. > Postgres tablesize is twice than oracle tablesize for all my > tables.And so the query also takes twice as much time than oracle. So > we were checking to see what makes post

Re: [GENERAL] postgresql storage and performance questions

On 11/19/07, Josh Harrison <[EMAIL PROTECTED]> wrote: > I have 2 tables with 2 cols each( 1 numeric(8,0) and 1 varchar(3) ). > In table1 both the cols are filled and in table2 the varchar colm is null > > So when I checked the tablesize for these two tables (using pg_relation_size) > table1 - 573

Re: [GENERAL] how should I do to disable the foreign key in postgres?

On 11/13/07, froast <[EMAIL PROTECTED]> wrote: > in mysql, I used :"set foreign_key_check = 0;" to disable the foreign key > check, now I'm trying to migrate from mysql to postgres, how should I do to > disable it? PostgreSQL isn't really designed to let your data be compromised. What actual prob

Re: [GENERAL] Variable LIMIT and OFFSET in SELECTs

On 11/16/07, Reg Me Please <[EMAIL PROTECTED]> wrote: > Il Friday 16 November 2007 08:33:14 Tom Lane ha scritto: > > Let me try to explain one more time. You propose allowing > > > > select ... from > > table1 join table2 on table1.x = table2.y > > limit table1.z > > > > Now

Re: [GENERAL] Postgresql and resource isolation

On 11/15/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote: > Well I know that FreeBSD through Jails and Linux through Xen can give > you fine grained control over how much resources a particular instance > can use. I hadn't seen the new limits in jail, the CPU limiting in particular is neat. I'm no

Re: [GENERAL] Postgresql and resource isolation

On 11/15/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote: > > A) "resource governor" - the ability to configure how much resources > > (IO per second, CPU slices) particular users or sessions are allowed > > to use > That is controlled from the operating system. What OSes support this? --

Re: [GENERAL] Variable LIMIT and OFFSET in SELECTs

On 11/15/07, Reg Me Please <[EMAIL PROTECTED]> wrote: > In any case, what'd be the benefit for not allowing "variables" as LIMIT and > OFFSET argument? When you can fully describe the semantics of your example, you'll probably be able to answer that question too :) ---(en

Re: [GENERAL] execute pg_dump via python

On 10/25/07, Garry Saddington <[EMAIL PROTECTED]> wrote: > I am using zope on windows with an external python method to backup my > database. I am struggling to run the following command: > > pg_dump.exe database > file > subprocess.Popen(['c:/dir/dir/pg_dump.exe','database','>','c:/dir/dir/output

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

On 10/23/07, Rainer Bauer <[EMAIL PROTECTED]> wrote: > "Trevor Talbot" wrote: > >It could be that there's a significant difference between XP and 2003 > >in how that's handled though. I do have an XP SP2 machine here with > >512MB RAM, and I'l

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

On 10/23/07, Harald Armin Massa <[EMAIL PROTECTED]> wrote: > > The Desktop Heap appears to be a place for processes belonging to the same > > "desktop" to allocate shared objects such as GUI elements. These are > > allocated > > in shared space so they can be manipulated by any process running in

Re: [HACKERS] [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

On 10/22/07, Tom Lane <[EMAIL PROTECTED]> wrote: > Magnus Hagander <[EMAIL PROTECTED]> writes: > > I was planning to make it even easier and let Windows do the job for us, > > just using RegisterWaitForSingleObject(). Does the same - one thread per > > 64 backends, but we don't have to deal with th

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

On 10/22/07, Magnus Hagander <[EMAIL PROTECTED]> wrote: > Trevor Talbot wrote: > > I'd probably take the approach of combining win32_waitpid() and > > threads. You'd end up with 1 thread per 64 backends; when something > > interesting happens the thread co

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

I wrote: [ desktop heap usage ] > It could be that there's a significant difference between XP and 2003 > in how that's handled though. I do have an XP SP2 machine here with > 512MB RAM, and I'll try tests on it as soon as I can free up what it's > currently occupied with. ...yep, under XP I'm

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

On 10/22/07, Magnus Hagander <[EMAIL PROTECTED]> wrote: > I read somewhere that Vista makes the size of the desktop heap dynamic, but > you were on 2003, right? Yeah, 32bit 2003 SP2, which has the same limits as XP. It looks like Vista also has the same limits on actual heap sizes, but manages k

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

On 10/22/07, Dave Page <[EMAIL PROTECTED]> wrote: > Dave Page wrote: > > So, we seem to be hitting two limits here - the desktop heap, and > > something else which is cluster-specific. Investigation continues... > > In further info, I've been testing this with the 8.3b1 release build > that we put

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

On 10/21/07, Magnus Hagander <[EMAIL PROTECTED]> wrote: > > I tried generating idle connections in an effort to reproduce > > Laurent's problem, but I ran into a local limit instead: for each > > backend, postmaster creates a thread and burns 4MB of its 2GB address > > space. It fails around 490.

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

On 10/22/07, Rainer Bauer <[EMAIL PROTECTED]> wrote: > Well after installing Postgres explorer and starting the system information > program the kernel memory section shows me the current count, but not the > limits (it says "no symbols"). I am currently downloading the "Debugging Tools > for Wind

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

On 10/20/07, Rainer Bauer <[EMAIL PROTECTED]> wrote: > Anyway, the problem are the no. of semaphores created by Postgres: > Every backend creates at least 4* semaphores. Just > increase to an unusual high value (say 1) and > start creating new connections while monitoring the handle count. H

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

On 10/20/07, Rainer Bauer <[EMAIL PROTECTED]> wrote: > I could reproduce this here: > > Server closed the connection unexpectedly > This probaly means the server terminated abnormally before or while processing > the request > > 2007-10-20 23:33:42 LOG: server process (PID 5240) exited with exit

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

On 10/20/07, Shelby Cain <[EMAIL PROTECTED]> wrote: > > --- Trevor Talbot <[EMAIL PROTECTED]> wrote: > > > On 10/20/07, Shelby Cain <[EMAIL PROTECTED]> wrote: > > > > > I'd personally vote for a lower warning limit like 175 as I can > &

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

On 10/20/07, Shelby Cain <[EMAIL PROTECTED]> wrote: > I'd personally vote for a lower warning limit like 175 as I can > consistently crash Postgresql on Windows system right around the 200th > connection. What error gets logged for your crashes? ---(end of broadcast)-

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

On 10/20/07, Rainer Bauer <[EMAIL PROTECTED]> wrote: > "Magnus Hagander" wrote: > > >> - Max_connections is set to 500. I did that originally because I kept > >> seeing a message about no connection available and I thought it was > >> because I was not allocating enough connections. My machine has

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

On 10/17/07, Magnus Hagander <[EMAIL PROTECTED]> wrote: > On Wed, Oct 17, 2007 at 02:40:14AM -0400, Tom Lane wrote: > > Maybe we should put an #ifdef WIN32 into guc.c to limit max_connections > > to something we know the platform can stand? It'd be more comfortable > > if we understood exactly wh

Re: [GENERAL] downloading and installing postgreSQL

On 10/17/07, Ken Johansson <[EMAIL PROTECTED]> wrote: > Im installing the latest software > (postgresql-8.2.5-1-binaries-no-installer.) on windows > xp but i dont know what file to click to install - this seems very > ambiguous. Can anyone help? You want to get postgresql-8.2.5-1.zip instea

Re: [GENERAL] atomic commit;begin for long running transactions , in combination with savepoint.

On 10/17/07, Syan Tan <[EMAIL PROTECTED]> wrote: > my understanding was it used more resources than read committed > because it keeps track of the version id of rows selected > so far in a transaction, "transaction-level consistency", Transaction-level consistency covers all the data in aggregate

Re: [GENERAL] Inconsistence in transaction isolation docs

On 10/16/07, Nico Sabbi <[EMAIL PROTECTED]> wrote: > well, I know how read committed behaves, but > I don't see why should anyone expect an update of the resultset > of the currently executing query after a commit by a different > transaction. A currently executing UPDATE will see changes made to

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

On 10/16/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > Laurent Duperval wrote: > > >> I get en error in the logs that state: > > >> > > >> Server process exited with exit code -1073741502 FYI, this exit code means a DLL's initialization routine indicated failure during process startup. > > If

Re: [GENERAL] Inconsistence in transaction isolation docs

On 10/16/07, Nico Sabbi <[EMAIL PROTECTED]> wrote: > /From: > http://www.postgresql.org/docs/8.2/interactive/transaction-iso.html > > " > Read Committed/ is the default isolation level in PostgreSQL. When a > transaction runs on this isolation level, a SELECT query sees only data > committed before

Re: [GENERAL] atomic commit;begin for long running transactions , in combination with savepoint.

On 10/15/07, Syan Tan <[EMAIL PROTECTED]> wrote: > >Also keep in mind that MVCC is not the only way to implement > >transactions; pure locking is more common in other databases. In the > >locking model, most transactions prevent others from writing until > >after they are finished. Rows simply c

Re: [GENERAL] atomic commit;begin for long running transactions , in combination with savepoint.

On 10/15/07, Syan Tan <[EMAIL PROTECTED]> wrote: > thanks. I'll try it out, but sounds true enough; so there is no > isolation level where transaction state keeps track of all the read versions > of any item read so far by the transaction ? Right. That would be a whole different set of semantics.

Re: [GENERAL] atomic commit;begin for long running transactions , in combination with savepoint.

On 10/15/07, Syan Tan <[EMAIL PROTECTED]> wrote: > >In order to detect a change occurred, what you want is a SERIALIZABLE > >transaction: you want the update to fail if the row it matches is no > >longer the same version as your snapshot. However, in order to read > >the new value to decide if yo

Re: [GENERAL] atomic commit;begin for long running transactions , in combination with savepoint.

On 10/14/07, Syan Tan <[EMAIL PROTECTED]> wrote: > I meant commit and continue current transaction. The transaction is opened > on the user application caching composite data from many tables regarding > a root object. Because almost all applications cache data, there is apparently > a pattern "opt

Re: [GENERAL] atomic commit;begin for long running transactions , in combination with savepoint.

On 10/13/07, syan tan <[EMAIL PROTECTED]> wrote: > I was wondering whether there could be an atomic commit;begin command > for postgresql, in order to open up a transaction at the beginning of > a unit of work in a client session, so that client applications don't > have to duplicate work with havi

Re: [GENERAL] can I define own variables?

On 10/12/07, Guy Rouillier <[EMAIL PROTECTED]> wrote: > I've had several occasions when a user-defined variable would have come > in handy. What is the scope of user_vars as you've defined them above? > Are they unique to a connection? A user_id? Or defined globally? > Ideally, they would be

Re: [GENERAL] help w/ SRF function

On 9/17/07, Ow Mun Heng <[EMAIL PROTECTED]> wrote: > > > CREATE OR REPLACE FUNCTION foo_func(fromdate timestamp, todate > > > timestamp, code text) > > > LANGUAGE 'sql' IMMUTABLE STRICT; > > But If I were to use ALIASINg, I get an error > > > > eg: DECLARE > > DECLARE > > fromdate ALIAS fo

Re: [GENERAL] Locking entire database

On 9/15/07, Panagiwths Pediadiths <[EMAIL PROTECTED]> wrote: > Shouldn't the serializable level prevent these duplicates? As I understand > it serializable > should give the same result as if the transactions were performed the one > after the other. http://www.postgresql.org/docs/8.2/static/tran

Re: [GENERAL] Time Zone design issues

> > The browser may not know the setting, or may not tell it to you, > > or you might not be able to make any sense of what it says > > (timezone names are hardly standardized). > > Well that's true. Except for numeric offsets. Offsets aren't good enough due to changing DST rules. A current offs

Re: [GENERAL] Scalability Design Questions

On 9/8/07, novnov <[EMAIL PROTECTED]> wrote: > But basically, it seems that the answer to one of my questions is that there > is currently no way with postgres to spread a single database over multiple > servers, ala a loadbalanced apache cluster, where requests are forwarded to > different boxes.

Re: [GENERAL] a provocative question?

There's also a point in regard to how modifications are made to your data store. In general, things working with text files don't go to much effort to maintain durability like a real database would. The most direct way of editing a text file is to make all the changes in memory, then write the wh

Re: [GENERAL] psql hanging

On 9/5/07, Martijn van Oosterhout <[EMAIL PROTECTED]> wrote: > On Wed, Sep 05, 2007 at 10:44:20AM -0700, Trevor Talbot wrote: > > Unless psql is turning on keepalive or similar, or the OS is forcing > > it on by default, there are no timeouts for idle TCP connections. I

Re: [GENERAL] psql hanging

On 9/5/07, Richard Huxton <[EMAIL PROTECTED]> wrote: > Steve Crawford wrote: > > A while back I had to restart the server and today discovered that some > > of the client machines have psql processes dating back several months. > > > > Obviously no TCP connection on the server end but client-side

Re: [HACKERS] [GENERAL] Undetected corruption of table files

On 8/27/07, Jonah H. Harris <[EMAIL PROTECTED]> wrote: > On 8/27/07, Tom Lane <[EMAIL PROTECTED]> wrote: > > that and the lack of evidence that they'd actually gain anything > > I find it somewhat ironic that PostgreSQL strives to be fairly > non-corruptable, yet has no way to detect a corrupted pa

Re: [GENERAL] FATAL: could not reattach to shared memory (Win32)

On 8/24/07, Tom Lane <[EMAIL PROTECTED]> wrote: > "Trevor Talbot" <[EMAIL PROTECTED]> writes: > > On 8/23/07, Magnus Hagander <[EMAIL PROTECTED]> wrote: > >> Not that wild a guess, really :-) I'd say it's a very good possibility - > >

Re: [GENERAL] FATAL: could not reattach to shared memory (Win32)

On 8/23/07, Magnus Hagander <[EMAIL PROTECTED]> wrote: > Shelby Cain wrote: > > Wild guess on my part... could that error be the result of an attempt > > to map shared memory into a process at a fixed location that just > > happens to already be occupied by a dll that Windows had decided to > > re

Re: [GENERAL] Yet Another COUNT(*)...WHERE...question

On 8/16/07, Rainer Bauer <[EMAIL PROTECTED]> wrote: > My point is that whatever search criterias are involved and how many items > are found eBay always returns the *accurate* number of items found. > > Before this drifts off: > * I do know *why* count(*) is slow using Postgres. > * I *think* tha

Re: [GENERAL] Accessing tables in other databases, through functions

On 8/16/07, Phoenix Kiula <[EMAIL PROTECTED]> wrote: > Probably an optimistic question - can a user with access to two > databases create a function in one to access tables in the other? Or > triggers? If this is related data that you just need logically separated, schemas might work for you too

Re: [GENERAL] Yet Another COUNT(*)...WHERE...question

On 8/16/07, Rainer Bauer <[EMAIL PROTECTED]> wrote: > >> But if you go to eBay, they always give you an accurate count. Even if the > >> no. > >> of items found is pretty large (example: ). > > > >And I'd bet money that they're using a full text search of some kind to

Re: [GENERAL] Writing most code in Stored Procedures

On 8/15/07, Steve Manes <[EMAIL PROTECTED]> wrote: > I'm fairly hardcore about keeping as much business logic as I can in the > database. In fact, I only do SELECTs from the application, and usually > via Views. All inserts, updates and deletes are via procs. I'm a > proponent of separating app

Re: [GENERAL] language interface in postgresql

On 8/14/07, Jasbinder Singh Bali <[EMAIL PROTECTED]> wrote: > Let me fine tune my question here. What I mean to say is the way we can > write stored procedures in C, perl etc in Postgres specifying the language > parameter at the end of stored procedure, compared to that, in SQL Server > 2000 I've

Re: [GENERAL] language interface in postgresql

On 8/14/07, Jasbinder Singh Bali <[EMAIL PROTECTED]> wrote: > I was wondering if any other database has language interface for different > programing languages such as C , perl , python etc the way postgresql has. Assuming you mean stored procedures, Microsoft's SQL Server hosts the CLR, which me

Re: [GENERAL] Moving to postgresql and some ignorant questions

On 8/14/07, Phoenix Kiula <[EMAIL PROTECTED]> wrote: > > *And* you can define compound foreign key constraints, > Thank you for this detailed explanation Alban. But I want to include > FK constraints on a table2 on a column in the referenced table1 where > column values are not unique. > > I just

Re: [GENERAL] tsearch2: plainto_tsquery() with OR?

On 8/8/07, Tom Lane <[EMAIL PROTECTED]> wrote: > Oleg Bartunov <[EMAIL PROTECTED]> writes: > > On Wed, 8 Aug 2007, cluster wrote: > >> Does anyone know where I can request an OR-version of plainto_tsquery()? > > > plainto_tsquery expects plain text, use to_tsquery for boolean operators. > > Are eit