Description:
General Discussions about PostgreSQL
|
|
|
re-using RETURNING
|
| |
Hi, just to be sure, it is still (8.4) not possible to use RETURNING within an other INSERT? To show what i mean: test=*# insert into foo2 (id1, id2) (insert into foo(n) values ('a'),('b'),('c') returning currval('some_sequence'), id); ERROR: syntax error at or near "insert" LINE 1: insert into foo2 (id1, id2) (insert into foo(n) values ('a')...... more »
|
|
|
What is the simpliest text search configuration?
|
| |
Hi all, I'd like to implement a full text search with postgresql, and I can't find a text search configuration that would just: map unicode accentuated letters to an un-accentuated equivalent tokenize the words (and skip any non word characters) no stopwords lower case the tokens How can I achieve this? I'm particularly interested in deactivating... more »
|
|
|
DB Restart
|
| |
...Are you saying that you're running out of memory overall, or do you have a ulimit issue for the postgres user?
|
|
|
"duplicate key violates unique constraint" error
|
| |
Hi All I have a cluster setup with one master and one slave . Replication from master to slave is not taking place. I am getting this error "duplicate key violates unique constraint" in my slon.log on slave . This error is thrown while Slon is inserting a row in a table on slave. This must be because of... more »
|
|
|
An elegant watch will make you act more confidently.
|
| |
Dreams come true! Welcome to our on-line shop of exclusive copies of the Swiss watches and place your order for the watch that you have been looking for. The great amount of watches for the cheap price is here for you. A chance to click
|
|
|
knowing which table/schema is going to be chosen
|
| |
I may have several tables with the same name in different schema. pina.mytable, test.mytable, import.mytable I have a search_path that may not just consist of $user, public. eg. $user, public, test, import I'd like to know which table is going to be chosen if I do a select * from mytable; In this case test.mytable will be chosen.... more »
|
|
|
pgfoundry new?
|
| |
Sorry for posting to inappropriate list, but I don't know where to post about pgfoundry... Does anybody know why following news does not appear on the pgfoundry new page? The latest new was: PGCluster-1.9.0rc6 released Atsushi Mitani - 2009-10-28 21:05 and next to above was: SkyTools 2.1.10 Marko Kreen - 2009-09-01 20:19... more »
|
|
|
pgday.eu
|
| |
Hi all, Congratulations and many thanks indeed to all the organisers of and speakers at the conference in Paris. A great couple of days, with really interesting talks...and a really enjoyable session in the pub on Friday night! Ray.
|
|
|
Postgres Clustering Options
|
| |
I'm trying to meet a very high uptime requirement in a high performance environment. to do this we will need to have some form of cluster for our databases What I plan on doing is: Postgres installed on a Cluster configured in active/passive (both pointing to the same SAN (If PG or the OS fails we trigger a failover to the passive node)... more »
|
|
|
upgrade to 8.4 with new character set
|
| |
______________________________ __ ...Sent: Wednesday, November 11, 2009 9:58 AM To: Kevin Duffy ... To those that know, We originally built our database with a character set of SQL_ASCII. We now know the error of our foolish ways. We are trying to upgrade to 8.4 and the windows binaries would like us to use UTF8. I would like to use... more »
|
|
|
|
