Anyone know why to_tsvector('sausages') might return "sausages" while
to_tsvector('default','sausages') correctly returns "sausag"?
This is causing me a fairly major headache. I am guessing that the
tsearch2() function used in my trigger is not specifying "default" when
creating the tsvector sinc
On Mon, 30 Apr 2007, psql psql wrote:
Anyone know why to_tsvector('sausages') might return "sausages" while
to_tsvector('default','sausages') correctly returns "sausag"?
This is causing me a fairly major headache. I am guessing that the
tsearch2() function used in my trigger is not specifying "
On Mon, 30 Apr 2007, Brent Wood wrote:
If I'm following this correctly, then interval & extract timepart can be
used to provide all the required functionality:
Thanks, Brent. Your suggestions complete the approach I was considering.
There is no need for real-time response, to checking after
Hi,
I'm trying to select data from a table, converting two values and return
all four. Maybe this is best explained with an example:
The function from the documentation on pl/pgsql:
CREATE FUNCTION sum_n_product(x int, y int, OUT sum int, OUT prod int) AS $$
BEGIN
sum := x + y;
prod :
Rich Shepard wrote:
I wonder if a workweek/holiday calendar table for PostgreSQL already
exists. If not I need to track down the procedure for creating one
as Joe
Celko references such a calendar in his books. I think that any
schema that
has temporal components needs such a table.
There
am Mon, dem 30.04.2007, um 15:45:18 +0200 mailte Heiko Klein folgendes:
> Hi,
>
> I'm trying to select data from a table, converting two values and return
> all four. Maybe this is best explained with an example:
>
> The function from the documentation on pl/pgsql:
>
> CREATE FUNCTION sum_n_pr
On 4/30/07, Oleg Bartunov <[EMAIL PROTECTED]> wrote:
On Mon, 30 Apr 2007, psql psql wrote:
> Anyone know why to_tsvector('sausages') might return "sausages" while
> to_tsvector('default','sausages') correctly returns "sausag"?
>
> This is causing me a fairly major headache. I am guessing that t
"A. Kretschmer" <[EMAIL PROTECTED]> writes:
> am Mon, dem 30.04.2007, um 15:45:18 +0200 mailte Heiko Klein folgendes:
>> How can I do the following:
>>
>> select * from myvals, sum_n_product(myvals.x, myvals.y);
> select x, y, sum_n_product(x,y) from myvals;
This is only part of the answer, how
Hi,
I'm tryng to upgrade a 8.1.3 server to 8.2.4 and I have a problem with
tsearch.
I use french snowball package to compile a stemming lib -> dict_fr.so
Now if I do a query like this
select to_tsvector('default', '... something with more than 200
chars');
-> result ok
but
select to_tsvector(
Andrew - Supernews wrote:
Anyone have any ideas on how to handle a work queue?
Advisory locks (userlocks in pre-8.2).
Can someone explain why these are a better fit than whatever locks
SELECT FOR UPDATE acquires?
Thanks.
- John D. Burger
MITRE
---(end of br
On Mon, 30 Apr 2007, psql psql wrote:
On 4/30/07, Oleg Bartunov <[EMAIL PROTECTED]> wrote:
On Mon, 30 Apr 2007, psql psql wrote:
> Anyone know why to_tsvector('sausages') might return "sausages" while
> to_tsvector('default','sausages') correctly returns "sausag"?
>
> This is causing me a fai
Philippe Amelant <[EMAIL PROTECTED]> writes:
> I'm tryng to upgrade a 8.1.3 server to 8.2.4 and I have a problem with
> tsearch.
> I use french snowball package to compile a stemming lib -> dict_fr.so
Are you sure you used the same snowball version that tsearch2 uses?
The snowball people have mad
Hi,
I have dropped a column (say column name is 'A') from the relation R. By
setting the attisdropped as true in the pg_catalog.pg_attribute table. But
the column is dropped locially not the physically. Can you please tell me
when this column will be physically also dropped. Is this column is
auto
Anyone know why to_tsvector('sausages') might return "sausages" while
to_tsvector('default','sausages') correctly returns "sausag"?
This is causing me a fairly major headache as it seems the tsearch2()
function used by triggers is not specifying "default" which means
many words that are ind
Hi,
I'm tryng to upgrade a 8.1.3 server to 8.2.4 and I have a problem with
tsearch.
I use french snowball package to compile a stemming lib -> dict_fr.so
Now if I do a query like this
select to_tsvector('default', '... something with more than 200
chars');
-> result ok
but
select to_tsvector(
Hi, I finally could repair pljava sources to make it compile in Mac OS
X 10.4.8.
The problem is that XactListener.c (src/C/pljava) references XactEvent
without including the library where it is declared.
XactEvent is declared within xact.c and you can get this file from
postgresql sources.
What I d
>
> config tables are like other user created tables, the same access policy.
> It's up to user grant access to them.
True, but the tables should be created with the same owner as the
database. I'm finding that they're created with owner "postgres" even
though the database they're created in has a
On 4/28/07, Rich Shepard <[EMAIL PROTECTED]> wrote:
I would like to store a temporal frequency as NUMERIC, without units, and
have the application's front end (or middleware) transform the number to the
appropriate interval name. I'm having difficulties figuring out how to do
this.
This is a
Hi, I'm looking for it too, I have the same configuration you do. Have
you found a solution?
Thanks
On Mar 2, 11:31 pm, [EMAIL PROTECTED] ("Eddy D. Sanchez") wrote:
> I'm trying to install pljava on postgresql on macintosh
> I have postgres runing, but I have not got any manual for install
> pl
I am not sure I see why it would be good to do this using SQL, but I do know
that I have used a number of Perl packages for this sort of thing. When I have
done this in the past, I'd do the date and time calculations in Perl and feed
the result to whatever RDBMS I happen to be using (PostgreSQL
On Mon, 30 Apr 2007, John D. Burger wrote:
There was a brief discussion of this just last week, with a few solutions
suggested:
http://archives.postgresql.org/pgsql-general/2007-04/msg01098.php
John,
That thread asked how to find business days between any two specified
dates. I would like
Le lundi 30 avril 2007 à 11:51 -0400, Tom Lane a écrit :
> Philippe Amelant <[EMAIL PROTECTED]> writes:
> > I'm tryng to upgrade a 8.1.3 server to 8.2.4 and I have a problem with
> > tsearch.
>
> > I use french snowball package to compile a stemming lib -> dict_fr.so
>
> Are you sure you used the
On 4/30/07, Oleg Bartunov <[EMAIL PROTECTED]> wrote:
On Mon, 30 Apr 2007, psql psql wrote:
> On 4/30/07, Oleg Bartunov <[EMAIL PROTECTED]> wrote:
>>
>> On Mon, 30 Apr 2007, psql psql wrote:
>>
>> > Anyone know why to_tsvector('sausages') might return "sausages" while
>> > to_tsvector('default',
On Mon, 30 Apr 2007, philippe wrote:
Hi,
I'm tryng to upgrade a 8.1.3 server to 8.2.4 and I have a problem with
tsearch.
I use french snowball package to compile a stemming lib -> dict_fr.so
Now if I do a query like this
select to_tsvector('default', '... something with more than 200
chars');
On Mon, 30 Apr 2007, Ted Byers wrote:
I am not sure I see why it would be good to do this using SQL, but I do
know that I have used a number of Perl packages for this sort of thing.
I am not arguing with you. I just want to know in what circumstances my
schemas can be improved by a calendar
On Apr 18, 2007, at 4:39 PM, Csaba Nagy wrote:
Other than hard disk space, are there any disadvantages on
having a large number of page slots?
It's not using hard disk space, it's using shared memory, so you might
want to adjust it to make that memory available for other purposes...
AFAIK, th
On Apr 21, 2007, at 9:53 PM, Tom Allison wrote:
I am not sure how the permissions work anymore.
What I want to do is create a database and have a user create all
the tables and rules.
I created the database from user postgres.
I then set the owner of the database to my userid
my userid crea
On Apr 23, 2007, at 8:27 AM, shieldy wrote:
where can I get the help of the directory explantation to the
postgresql src?
I have to do some work about the definition of the internal functions.
who can help me ? thankyou!
You should read the developers FAQ, which is in the developers
section
On Apr 24, 2007, at 8:50 PM, William Garrison wrote:
I have a server running Windows Server 2003 32-bit that has 8GB of
memory. Our system administrator installed PAE (Physical Address
Extensions) which I know MS SQL Server will use, but I'm not sure
if PostgreSQL will.
Can PostgreSQL use
On Apr 25, 2007, at 7:36 AM, Listmail wrote:
Is there a way to know how many pages were hit by a Bitmap Heap
scan ?
For instance :
Bitmap Heap Scan on posts
(cost=56.71..295.24 rows=2123 width=67)
(actual time=0.575..1.462 rows=2160 loops=1)
I'd like to know if it hit 2160 pages (i
On Apr 25, 2007, at 4:13 PM, sangeetha k.s wrote:
does postgre sql support bitmap indexing for indexing the
datatables.
will that be possible to get the source of that.
Search the -hackers archives for more information about this; I know
there's a patch floating around, but
I think you might be able to accomplish this by setting up a pgpool
instance for just the read-only connections and limiting how many
connections are allowed there.
On Mar 26, 2007, at 3:20 PM, Saqib Awan wrote:
Yes other than max_connections. I have a read-only user whose
connections
need
On Mon, 30 Apr 2007, psql psql wrote:
On 4/30/07, Oleg Bartunov <[EMAIL PROTECTED]> wrote:
On Mon, 30 Apr 2007, psql psql wrote:
> On 4/30/07, Oleg Bartunov <[EMAIL PROTECTED]> wrote:
>>
>> On Mon, 30 Apr 2007, psql psql wrote:
>>
>> > Anyone know why to_tsvector('sausages') might return "sau
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/27/07 07:01, rupesh bajaj wrote:
> Hi,
> I have dropped a column (say column name is 'A') from the relation R. By
> setting the attisdropped as true in the pg_catalog.pg_attribute table. But
> the column is dropped locially not the physically. Ca
Hello!
I'm in the process of upgrading our PostgreSQL 8.1 databases to PostgreSQL
8.2.4. I have stumbled over a minor issue with the upgrade and some helpful
suggestions here:
http://people.planetpostgresql.org/xzilla/index.php?/archives/291-The-pain-that-is-tsearch2-8.1-8.2-upgrading.html
I sh
Hi,
In my PHP page i upload pictures into database. For that i wrote a simple
function which control which user is logged and will upload his picture.
here is the function :
CREATE OR REPLACE FUNCTION sp_a_006("login" character varying, photo bytea)
RETURNS boolean AS
$BODY$
DECLARE
my_
On Mon, 30 Apr 2007, Markus Wollny wrote:
Hello!
I'm in the process of upgrading our PostgreSQL 8.1 databases to PostgreSQL
8.2.4. I have stumbled over a minor issue with the upgrade and some helpful
suggestions here:
http://people.planetpostgresql.org/xzilla/index.php?/archives/291-The-pain-
On Apr 26, 2007, at 6:51 PM, Tom Lane wrote:
"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
1. What aspect of postgres' memory usage would create an "out of
memory" condition?
I'm guessing you ran the box out of swap space --- look into what
other
processes got started as a result of ad
I'm trying to find the binaries for pgsql (the client) for Mac OSX.
Is there any way to get these without installing all of postgres on a
computer?
I'm not going to use postgres on my MacBook, just connect to it.
---(end of broadcast)---
TIP 3:
On Apr 30, 2007, at 2:28 PM, Tom Allison wrote:
I'm trying to find the binaries for pgsql (the client) for Mac OSX.
Is there any way to get these without installing all of postgres on
a computer?
I'm not going to use postgres on my MacBook, just connect to it.
If you have macports installe
[EMAIL PROTECTED] ("rupesh bajaj") writes:
> Hi, I have dropped a column (say column name is 'A') from the
> relation R. By setting the attisdropped as true in the
> pg_catalog.pg_attribute table. But the column is dropped locially
> not the physically. Can you please tell me when this column will
I found psql in
/System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/psql
which means that I can, as a user, access the database from a Mac.
But I'm still unable to build the perl modules for DBD:Pg support.
And this one seems a bit screwed up from default.
Port is 5433, not 5432.
pg_conf
Jim Nasby wrote:
> On Apr 24, 2007, at 8:50 PM, William Garrison wrote:
>> I have a server running Windows Server 2003 32-bit that has 8GB of
>> memory. Our system administrator installed PAE (Physical Address
>> Extensions) which I know MS SQL Server will use, but I'm not sure if
>> PostgreSQL wi
> "Tom" == Tom Allison <[EMAIL PROTECTED]> writes:
Tom> /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/psql
That's not on my mac. Must be some bolt-on you installed.
--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<[EMAIL PROTECTED]> http://www
"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
> On Apr 26, 2007, at 6:51 PM, Tom Lane wrote:
>> "Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
>>> 3. What would cause postgres to die from a signal 11?
>>> I've also got a core file if that's necessary for further forensics.
>>
>> Send gdb ba
Chris Browne <[EMAIL PROTECTED]> writes:
> Ron's comment is well-suggested[1], but a bit of a red herring, as the
> column will *NEVER* be "physically dropped." [2]
Check.
> What will happen is that new tuples will not have the column, but old
> tuples will continue to have the (invisible) column
On Apr 30, 2007, at 16:20 , Randal L. Schwartz wrote:
"Tom" == Tom Allison <[EMAIL PROTECTED]> writes:
Tom> /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/
psql
That's not on my mac. Must be some bolt-on you installed.
Apple Remote Desktop uses PostgreSQL as it's data sto
Tom Allison <[EMAIL PROTECTED]> writes:
> I found psql in
> /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/psql
> which means that I can, as a user, access the database from a Mac.
> But I'm still unable to build the perl modules for DBD:Pg support.
> And this one seems a bit screwed
On Apr 30, 2007, at 5:20 PM, Randal L. Schwartz wrote:
"Tom" == Tom Allison <[EMAIL PROTECTED]> writes:
Tom> /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/
psql
That's not on my mac. Must be some bolt-on you installed.
--
Randal L. Schwartz - Stonehenge Consulting Service
That might be the thing to do.
I'm wondering how Apple Remote Desktop got onto my machine and how to
remove it.
On Apr 30, 2007, at 5:38 PM, Michael Glaesemann wrote:
On Apr 30, 2007, at 16:20 , Randal L. Schwartz wrote:
"Tom" == Tom Allison <[EMAIL PROTECTED]> writes:
Tom> /System/Libr
That's not on my mac. Must be some bolt-on you installed.
So how did you get it working?
(I have no idea how this file got there. Wouldn't know where to begin)
Coming in late so maybe someone already posted this, but I used this:
http://www.postgresqlformac.com/
I wanted the server too, b
Tom Allison <[EMAIL PROTECTED]> writes:
> I'm wondering how Apple Remote Desktop got onto my machine and how to
> remove it.
There isn't any particular need to remove it; it won't conflict with
a standard PG installation.
regards, tom lane
---(en
> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
Tom> What you can do if you want to build PG from source is build normally
Tom> but only install the client programs. The Fine Manual recommends
Tom> gmake -C src/bin install
Tom> gmake -C src/include install
Tom> gmake -C src/in
On Apr 30, 2007, at 5:03 PM, Tom Allison wrote:
On Apr 30, 2007, at 5:38 PM, Michael Glaesemann wrote:
On Apr 30, 2007, at 16:20 , Randal L. Schwartz wrote:
"Tom" == Tom Allison <[EMAIL PROTECTED]> writes:
Tom> /System/Library/CoreServices/RemoteManagement/rmdb.bundle/
bin/psql
That's
On Apr 30, 2007, at 16:39 , Tom Lane wrote:
Yeah, Apple uses Postgres as a part of Remote Desktop, but I don't
think
they intend it for general use --- it deliberately uses a nonstandard
port to avoid conflicting with a regular PG server.
Really? I've had the Remote Desktop postgres instanc
Please update the Randall Notebook to read:
sudo fink install dbd-pg-unified-pm586
Perhaps this will be done in time for YAPC?
On Apr 30, 2007, at 6:22 PM, Randal L. Schwartz wrote:
"Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
Tom> What you can do if you want to build PG from source is buil
Michael Glaesemann <[EMAIL PROTECTED]> writes:
> On Apr 30, 2007, at 16:39 , Tom Lane wrote:
>> Yeah, Apple uses Postgres as a part of Remote Desktop, but I don't
>> think
>> they intend it for general use --- it deliberately uses a nonstandard
>> port to avoid conflicting with a regular PG serve
You can get libpq (and psql) from the pgEdit distribution. Just right
click on the application and choose "Show Package Contents".
You'll find these files in Contents/MacOS/bin
John
http://pgedit.com/public/pgedit/pgEdit_mac_1.3.dmg
On Apr 30, 2007, at 3:28 PM, Tom Allison wrote:
I'm tryi
Does postgresql have a built in IF function that allows one to eval a
condition and return one or another value? Like:
IIF(mybooleanfield = true, "It's true", "It's not true")
--
View this message in context:
http://www.nabble.com/IF-function--tf3673523.html#a10264910
Sent from the PostgreSQL
On Mon, Apr 30, 2007 at 10:51:36PM -0700, novnov wrote:
>
> Does postgresql have a built in IF function that allows one to eval a
> condition and return one or another value? Like:
>
> IIF(mybooleanfield = true, "It's true", "It's not true")
It has CASE, as in
CASE foo WHEN true THEN 'It''s tru
IF ( condition here)
-- to do
ELSE
-- to
END IF
On 5/1/07, novnov <[EMAIL PROTECTED]> wrote:
Does postgresql have a built in IF function that allows one to eval a
condition and return one or another value? Like:
IIF(mybooleanfield = true, "It's true", "It's not true")
--
View this message
61 matches
Mail list logo
