We have /contrib/soundex and items to help here. 7.2 will have even
more of them.
>
> On Sunday, October 7, 2001, at 01:47 AM, Frank Joerdens wrote:
>
> > Does anyone know how to do a phonetic and/or synonym search (this would
> > be for the German language mostly)? What's the approach in t
On 12 Oct 2001, Doug McNaught wrote:
> Joseph Koenig <[EMAIL PROTECTED]> writes:
>
> > I have a project where a client has products stored in a large Progress
> > DB on an NT server. The web server is a FreeBSD box though, and the
> > client wants to try to avoid the $5,500 license for the Unlimi
J C Lawrence <[EMAIL PROTECTED]> writes:
> Does an error during a transaction invalidate the transaction?
Yes, the transaction goes into ABORTED state and nothing after the
error will succeed.
> Translation: Do I need to monitor for error conditions during a
> transaction and manually do the RO
> I'm creating a function (for use in a trigger) from the example in the
> documentation and encountered an error. If I type the following at
> the psql prompt (database and user are opf):
>
> opf=> create function opf_user_fillin() returns opaque as '
> opf'> begin
> opf'> new.opf_user_id := n
Joseph Koenig <[EMAIL PROTECTED]> writes:
> I have a project where a client has products stored in a large Progress
> DB on an NT server. The web server is a FreeBSD box though, and the
> client wants to try to avoid the $5,500 license for the Unlimited
> Connections via OpenLink software and wou
Three times this week I've been switched from "nomail" to getting mail
for this group. Mail to [EMAIL PROTECTED] seems to
be a black hole. I don't need this cluttering my mailbox when I read
it via news. None of the other lists is doing this to me!
---(end of broadcast)
The failed query will abort the transaction, and throw out
every command that comes before or after it until your rollback.
You don't have to specifically issue a rollback unless you want to issue
more commands though. When you disconnect from the DB it will
automatically roll back the transacti
On 10 Oct 2001, Steve Heaven wrote:
> Does anyone know of a POP3 server that can use a Postgresql DB to
> authenticate usernames & passwords ?
The cyrus mail server has an authentication scheme whereby one
can very easily plug in different ways of authenticating users.
It is really cyrus sasl tha
Konstantinos Agouros wrote:
>
> Hi,
>
> I might be missing something in the documentation but what I would need is
> the time in seconds since 1970 from a datetime-column in a table (in Perl using
> DBD:Pg). Could someone help me without using Posix::mktime?
select date_part('epoch',now()::date
Erwin Lansing <[EMAIL PROTECTED]> writes:
> We are having some trouble with some tables in which we have lots of
> update's (and insert/delete's). "A lot" being several thousands per day
> (I haven't measured the exact numbers recently). VACUUM is running twice
> a day and locks these tables a lo
I may be wrong, but I don't think it's possible to have them
on the same port. The problem is that the TCP/IP port defaults to
the same as the UNIX sockets port, and UNIX sockets are local to the
machine, so they are completely independent of IP addresses and can not
be duplicated. It is possibl
> Myself along with a couple of co-workers have been searching for a way to
> join tables from two postgres database. So far there are no indication that
> this is possible, can someone shed some light on this subject.
>
> (P.S We are attemping to do this in the same database instance)
The curre
On Thu, 11 Oct 2001, Alessio Bragadini wrote:
> What strikes me is that this time the chief developer of MySql, Michael
> 'Monty' Widenius, had time available to reply talking about how good
> MySql is (including his famous benchmarks), which at least shows some
> impolite manners and probably th
> --- Tommy <[EMAIL PROTECTED]> wrote:
> > From what I understand they went out of business. I have not
> > seen the site
> > morrored anywhere.
> >
> > I wonder what this means for the future of PostgreSQL?
>
> I would imagine that it would slow down the development a bit
> until things settle
As usual, a rather harmless article on Slashdot about MySql ("Major
Changes To MySQL Coming Soon") turned into a flaming discussion about
the different virtues of MySql and PostgreSQL.
What strikes me is that this time the chief developer of MySql, Michael
'Monty' Widenius, had time available to
Gaurav Priyolkar writes:
> test=> SELECT foo();
> ERROR: Relation 5483738 does not exist
> test=>
> test=> SELECT relname, relfilenode FROM pg_class WHERE relfilenode=5483738;
> relname | relfilenode
> -+-
> foo_1 | 5483738
> (1 row)
relfilenode has nothing to do wit
"Allan Engelhardt" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> You'll want to ask on the perl groups, but briefly you get an illegal seek
when your command writes to the error file descriptor:
>
> % perl -e '`echo hi 1>&2` or warn "Oops: $! $?";'
> h
On Thu, 2001-10-11 at 00:03, Feite Brekeveld wrote:
> Just, reading it and I always enter these kind of queries like:
>
> select i.isbn,
> t.vendor,
> i.store,
> i.qty
> from bk_inv i,
> bk_title t
> where
>t.vendor = '01672708' and
>i.is
You'll want to ask on the perl groups, but briefly you get an illegal seek when your
command writes to the error file descriptor:
% perl -e '`echo hi 1>&2` or warn "Oops: $! $?";'
hi
Oops: Illegal seek 0 at -e line 1.
It's a perl feature, not a bug ;-) Try
% man perlop
for se
On Wed, Oct 10, 2001 at 04:22:07PM -0400, [EMAIL PROTECTED] wrote:
>
>
> Just to keep things in perspective, how large are your current databases, and
> what do you or the company consider to be a signficant length of time? Right
> now I have a development database with just a few thousand reco
On Wed, Oct 10, 2001 at 04:22:07PM -0400, [EMAIL PROTECTED] wrote:
>
>
> Just to keep things in perspective, how large are your current databases, and
> what do you or the company consider to be a signficant length of time? Right
> now I have a development database with just a few thousand reco
Hi,
Trying to understand the planner estimate costs ... one index scan
seems to be much more expensive then another. Here are the facts:
tiger=# \dbk_inv
Table "bk_inv"
Attribute | Type | Modifier
---+--+--
store | varchar(5) |
Hi,
Is it possible to have multiple postgresql installations on one machine
running on the same port but on different IP addresses?
I've specified different IPs/hostnames for the virtual_host but the unix
socket clashes when I try.
Should I just move the unix sockets somewhere else with -k, wh
23 matches
Mail list logo
