On Jul 26, 2007, at 11:06 AM, Jeff Davis wrote:
If you really do need an unsigned type, this is a good use of
postgresql's extensible type system. You can just create an unsigned
type for yourself.
If you do that please start a project on pgfoundry so others can
contribute and benefit. In fac
On Jul 25, 2007, at 6:17 PM, Joseph S wrote:
If you don't mind the downtime it would be simpler to upgrade to
8.2 and then worry about Slony. If you do mind you can use slony
to do the upgrade which needs much less downtime as you switch
servers.
Double-check with the Slony guys, but ISTR
On Jul 22, 2007, at 4:18 AM, Matthew Snape wrote:
I have just listened to Josh Berkus on FLOSS regarding postgresql.
It was suggested that postgresql has advantages over other
databases when it comes to reporting. Why is this?
I'll venture a guess that Josh was referring to our ability to
On Jul 26, 2007, at 5:57 PM, Stuart wrote:
I have a table with a composite PK like
CREATE TABLE t (
grp INT NOT NULL,
itm SMALLINT NOT NULL,
...,
PRIMARY KEY (grp,itm));
Normally the app takes care of providing the correct
grp,itm values when inserting records. However
(during
On Fri, 27 Jul 2007, Jean-Denis Girard wrote:
The NAS would be from LaCie, using 4 disks (Raid5 + spare)
(http://www.lacie.com/fr/products/product.htm?pid=10876), mounted via NFS
from a Linux server running Postgresql .
Leaving aside the general issue here for others to chime in on (my opinio
somewhere you need to use to_tsvector instead of to_tsquery.
Oleg
On Thu, 26 Jul 2007, JohnSense wrote:
SELECT *, rank(ts_vec, to_tsquery('default', 'lc & 11(')) FROM us
WHERE ts_vec @@ to_tsquery('default', 'lc & 11(') LIMIT 9 OFFSET 0
this query gives an error
in tsearch2
saying syntax error
On Fri, Jul 27, 2007 at 09:33:37AM -0700, [EMAIL PROTECTED] wrote:
> Is there a way to configure PostgreSQL 8.0 so that when prompted for a
> password, the user enters the MD5 hash of his password, instead of the
> normal plaintext password?
What problem are you trying to solve?
--
Michael Fuhr
On Jul 26, 2007, at 13:22 , Tony Crisera wrote:
ERROR: unterminated dollar-quoted string at or near "$$
BEGIN
NEW.mod_date := now();" at character 63
ERROR: syntax error at or near "RETURN" at character 9
WARNING: there is no transaction in progress
ERROR: unterminated dollar-quoted stri
On Fri, 27 Jul 2007, pc wrote:
> Hi,
>
> I have a table test with columns col1 col2.col2 contains an entry
> '\N' .I want to select all entries which have '\N' in col2.How do i
> do that?
>
> select * from test where col2 like '\N' ;
> select * from test where col2 like '\\N' ;
select * from
Hi list,
I'm looking for advices / experiences concerning PostgreSQL with data
storage on NAS via NFS. I've found a few references in the archives or
the docs, but they are old, and opinions differ:
. "There are a lot of horror stories concerning running databases (not
only Postgres) over NFS
Some sites with cheap marlboro:
http://www.google.com/search?q=new%20marlboro%20cigarettes&hl=en
He may neatly move between polite clever summers.
I was moving pitchers to active Quincy, who's calling in front of the
shirt's window. Who excuses amazingly, when Simon irritates the
cold po
HiI have a problem . I try install PostgreSQL but i cant do that
becouse i have an error window. when i am config "initialise database cluster"
window and click next then an error window popup , and write : "The "Secondary
Logon" service is not running. The service is requied for the
Hello,
in the documentation is written that there'a a perfomrance impact if
another locale than C or POSIX is used.
problem is that using the standard locale results in unusable order
results for languages with spcial chars. in my example "umlauts" in
german.
it isn't acceptable to use the databas
Is there a way to configure PostgreSQL 8.0 so that when prompted for a
password, the user enters the MD5 hash of his password, instead of the
normal plaintext password?
That is, when prompted for the password, instead of typing the
plaintext password as you normally would ("Foo", for example), you
SELECT *, rank(ts_vec, to_tsquery('default', 'lc & 11(')) FROM us
WHERE ts_vec @@ to_tsquery('default', 'lc & 11(') LIMIT 9 OFFSET 0
this query gives an error
in tsearch2
saying syntax error
any idea on how 2 strip the non safe tsearch stuff
before feeding it to sql
this is from a web search
Hi,
I have a table test with columns col1 col2.col2 contains an entry
'\N' .I want to select all entries which have '\N' in col2.How do i
do that?
select * from test where col2 like '\N' ;
select * from test where col2 like '\\N' ;
both return 0 rows.Could some one please tell me the right que
I apologize for cross-posting, but I need some help w/o too many
advices RTFM :). After Oracle and MySQL, this becomes the third
product that I need to learn to some degree, and I need a few links
which would provide a 'quick tutorial' especially for folks with
Oracle background like myself. Last t
We have gotten these errors every time we try to create a function
through psql. However, if we run the same statements using phpPgAdmin
or pgAdmin III query tool it works fine.
Here's the error-
ERROR: unterminated dollar-quoted string at or near "$$
BEGIN
NEW.mod_date := now();" at charac
Hi,
As discussed at the first meeting of what will become the European
PostgreSQL Users Group after pgDay in Prato, we now have a mailing list
setup at [EMAIL PROTECTED]
This is for the European users group, so is not really intended as a
technical list but as a place to discuss events, advo
19 matches
Mail list logo
