Wei Weng [EMAIL PROTECTED] writes:
But then when I do a psql tsearch2.sql, it complains:
bash-2.05a$ psql testdb tsearch2.sql
ERROR: stat failed on file '$libdir/tsearch2': No such file or directory
Where did I do wrong??
Did you do make install after building tsearch2?
If you did, maybe
When I run psql tsearch2.sql, is psql going to substitute $libdir
internally with what $libdir really is (in my case, it would be
/usr/lib/pgsql)?
Thanks
Wei
On Fri, 26 Sep 2003, Tom Lane wrote:
Wei Weng [EMAIL PROTECTED] writes:
But then when I do a psql tsearch2.sql, it complains:
Wei Weng [EMAIL PROTECTED] writes:
When I run psql tsearch2.sql, is psql going to substitute $libdir
internally with what $libdir really is (in my case, it would be
/usr/lib/pgsql)?
Not psql, the backend. The point of this is that your CREATE FUNCTION
definition can be
On Thu, Sep 25, 2003 at 08:46:39PM -0700, Josh Berkus wrote:
NULLIF is the converse of COALESCE().
Oh, ooops! My apologies.
Any idea when you're going to overhaul the CookBook?
*sighs*
The software is pretty much ready. I'll have time to install and configure
it next week, after my
I amin the process of creating a batch file
that will update some functions in a database for a remote user similar
to:
psql -o output dbname
functionupdate.sql
Is there any way to save any ERROR and
NOTICEmessages to a file?
The -o option doesn't capture this
information.
Thanks,
George,
I am in the process of creating a batch file that will update some
functions in a database for a remote user similar to:
psql -o output dbname functionupdate.sql
Is there any way to save any ERROR and NOTICE messages to a file?
The -o option doesn't capture this information.
You
When I ran psql testdb untsearch2.sql
I got the following error message:
psql:untsearch2.sql:15: ERROR: RemoveAggregate: aggregate stat(tsvector)
does not exist
I didn't really do anything before this. Only dropped the trigger and gist
index I created (in order to use tsearch2), and alter
Hi Josh,
Thanks for the reply.
What I am trying to achieve is to have errors go to a file, rather than show
up on the screen.
Is this possible?
George
- Original Message -
From: Josh Berkus [EMAIL PROTECTED]
To: George Weaver [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday,
George:
Have you tried psql {whatever operations} 2 error_output ?
(for Bash)
Thanks
Wei
On Fri, 26 Sep 2003, George Weaver wrote:
Hi Josh,
Thanks for the reply.
What I am trying to achieve is to have errors go to a file, rather than show
up on the screen.
Is this possible?
Hi Wei,
I hadn't tried that, and it did the trick!
Thank you!
George
- Original Message -
From: Wei Weng [EMAIL PROTECTED]
To: George Weaver [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, September 26, 2003 2:16 PM
Subject: Re: [SQL] Capturing pgsql ERRORS/NOTICES to file
teknokrat wrote:
If I have several selects joined with unions does postgresql execute the
concurrently or not?
nope.
Regards
Gaetan Mendola
---(end of broadcast)---
TIP 6: Have you searched our list archives?
[EMAIL PROTECTED] (Gaetano Mendola) writes:
teknokrat wrote:
If I have several selects joined with unions does postgresql
execute the concurrently or not?
nope.
I was talking with Jan about that very idea yesterday; this would seem
to be the place where PostgreSQL might take some (possibly
Hi folks,
I'm trying to remove items from a set which are similar to items in
another set.
This is the set (MASTER) from which I wish to remove items:
/ports/Mk/bsd.python.mk
/ports/lang/python-doc-html/distinfo
/ports/lang/python/Makefile
/ports/lang/python/distinfo
Dan,
I'm trying to remove items from a set which are similar to items in
another set.
snip
In short, we remove all items from MASTER which are under the directories
specified in MATCHES.
from your example, you are trying to remove all directories which do *not*
match. What do you want,
Where are we on this --- we all decided on #4. Does this just require
an announcment in the release notes.
(I need to complete the release notes soon.)
---
Tom Lane wrote:
Following up this gripe
Bruce Momjian [EMAIL PROTECTED] writes:
Where are we on this --- we all decided on #4. Does this just require
an announcment in the release notes.
I haven't done anything about it --- been busy with other stuff, and I
wasn't sure we'd agreed to change it for 7.4 anyway. I'm willing to
make
16 matches
Mail list logo