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,
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
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
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
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
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
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 database
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
Some sites with cheap marlboro:
http://www.google.com/search?q=new%20marlboro%20cigaretteshl=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 pool
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
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 test
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 string
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
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, 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
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 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 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
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
19 matches
Mail list logo
