[GENERAL] Character encoding problems

Sorry for the duplicate postings. I have only recieved one reply so far and that was a suggestion to post to this forum. I trying to build a database to support natural language processing from a variety of data files posted on the internet. Many of them are identified as using UTF-8 encoding

Re: [GENERAL] Hope for a new PostgreSQL era?

On Thu, Dec 8, 2011 at 6:47 PM, Rodger Donaldson wrote: > On Thu, 8 Dec 2011 16:34:49 -0800, Chris Travers > wrote: >> On Thu, Dec 8, 2011 at 4:09 PM, Rodger Donaldson >> wrote: >>> On Thu, 08 Dec 2011 11:24:12 -0800, John R Pierce >>> wrote: On 12/08/11 11:16 AM, Joshua D. Drake wrote: >>

Re: [GENERAL] Function Question

Jake Stride writes: > I am trying to create a function that gets fired when a new row is > inserted. I can get the following function built but my problem is > that the sequence that is created is called "NEW.key" rather than the > value that is being inserted (it should be a UUID). Instead of th

Re: [GENERAL] Hope for a new PostgreSQL era?

On 12/09/2011 01:02 AM, Tomas Vondra wrote: On 8 Prosinec 2011, 17:11, Marc Cousin wrote: Le Thu, 8 Dec 2011 09:29:28 -0600, - admission control, queuing and resource limiting to optimally load a machine. Some limited level is possible with external pooling, but only by limiting concurrent work

Re: [GENERAL]

"Joshua D. Drake" writes: > On 12/08/2011 03:12 PM, Raymond O'Donnell wrote: >> Just wondering, and without intending to cast any aspersions on the >> poster - is this spam or legit? I didn't take the risk of actually >> clicking it... > It is not legit in any way. Lately we've been seeing a lot

Re: [GENERAL] Hope for a new PostgreSQL era?

On 12/08/2011 08:27 PM, Simon Riggs wrote: On Thu, Dec 8, 2011 at 11:24 AM, Craig Ringer wrote: Areas in which Pg seems significantly less capable include: Please can you explain the features Oracle has in these area, I'm not clear. Thanks. Marc has, as I was hoping, done so much better than

Re: [GENERAL] Hope for a new PostgreSQL era?

On Thu, 8 Dec 2011 16:34:49 -0800, Chris Travers wrote: > On Thu, Dec 8, 2011 at 4:09 PM, Rodger Donaldson > wrote: >> On Thu, 08 Dec 2011 11:24:12 -0800, John R Pierce >> wrote: >>> On 12/08/11 11:16 AM, Joshua D. Drake wrote: > > um, I believe this is referring to Oracle RAC clustering

Re: [GENERAL] OT DBA type question - GRANT PRIVILEDGE

On 12/09/2011 05:46 AM, James B. Byrne wrote: The topic of RDBMS security has arisen in a discussion and, lacking evidence of my own, I am curious to discover just how frequently DBMS userids tied to specific individuals are used in production RDBMS based systems. I am also curious to know how o

Re: [GENERAL] Hope for a new PostgreSQL era?

On Thu, Dec 8, 2011 at 4:09 PM, Rodger Donaldson wrote: > On Thu, 08 Dec 2011 11:24:12 -0800, John R Pierce > wrote: >> On 12/08/11 11:16 AM, Joshua D. Drake wrote: um, I believe this is referring to Oracle RAC clustering, not HA active/standby. I seriously doubt Oracle is dropping

Re: [GENERAL] Hope for a new PostgreSQL era?

On Thu, Dec 8, 2011 at 6:54 AM, Merlin Moncure wrote: > There is simply no comparing mysql's backend programming features with > those of postgres.  Postgres is a development platform in a box, mysql > is not. > This and there are annoyances I have run into with MySQL, such as deadlocks on a

Re: [GENERAL] Hope for a new PostgreSQL era?

On Thu, 08 Dec 2011 11:24:12 -0800, John R Pierce wrote: > On 12/08/11 11:16 AM, Joshua D. Drake wrote: >>> >>> um, I believe this is referring to Oracle RAC clustering, not HA >>> active/standby. I seriously doubt Oracle is dropping RAC. >> >> I meant worrying about it for Pg. > > the odds of Po

[GENERAL] Function Question

I am trying to create a function that gets fired when a new row is inserted. I can get the following function built but my problem is that the sequence that is created is called "NEW.key" rather than the value that is being inserted (it should be a UUID). I have tried putting the key into a variab

Re: [GENERAL]

On 08/12/2011 23:19, Bèrto ëd Sèra wrote: > spam, it has a redirect to a spam site. > > On 9 December 2011 02:15, Joshua D. Drake > wrote: > > > On 12/08/2011 03:12 PM, Raymond O'Donnell wrote: > > > On 08/12/2011 23:07, sharmi...@yahoo.com >

Re: [GENERAL]

spam, it has a redirect to a spam site. On 9 December 2011 02:15, Joshua D. Drake wrote: > > On 12/08/2011 03:12 PM, Raymond O'Donnell wrote: > >> >> On 08/12/2011 23:07, sharmi...@yahoo.com wrote: >> >>> http://**happenenstappengroningen.nl/**news.html?r5h1h5

Re: [GENERAL] Hope for a new PostgreSQL era?

On Thu, Dec 8, 2011 at 3:24 AM, Craig Ringer wrote: > > On Dec 8, 2011 1:27 PM, "Chris Travers" wrote: >> >> Additionally I am not entirely sure what he means by the last point. >> If you look at the work that NTT along with EDB has put into >> Postgres-XC, for example, it looks to me like the Po

Re: [GENERAL]

On 12/08/2011 03:12 PM, Raymond O'Donnell wrote: On 08/12/2011 23:07, sharmi...@yahoo.com wrote: http://happenenstappengroningen.nl/news.html?r5h1h5 Just wondering, and without intending to cast any aspersions on the poster - is this spam or legit? I didn't take the risk of actually clicking

Re: [GENERAL]

On 08/12/2011 23:07, sharmi...@yahoo.com wrote: > http://happenenstappengroningen.nl/news.html?r5h1h5 Just wondering, and without intending to cast any aspersions on the poster - is this spam or legit? I didn't take the risk of actually clicking it... There have been a few posts like this recentl

[GENERAL]

http://happenenstappengroningen.nl/news.html?r5h1h5

Re: [GENERAL] Statistics mismatch between n_live_tup and actual row count

Andreas Brandl writes: > we're currently investigating a statistics issue on postgres. We have some > tables which frequently show up with strange values for n_live_tup. If you > compare those values with a count on that particular table, there is a > mismatch of factor 10-30. This causes the p

Re: [GENERAL] Clarification on CONTEXT: xlog redo xid assignment

What were the ramifications of the bug? I don't see any details in the release notes. It is not really an option to upgrade before the move. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Clarification-on-CONTEXT-xlog-redo-xid-assignment-tp5059725p5060301.html Sent

Re: [GENERAL] OT DBA type question - GRANT PRIVILEDGE

On 12/8/2011 3:46 PM, James B. Byrne wrote: Do many of you implement fine grained security provisions at the DBMS level using GRANT PRIVILEGE ON object TO user/role? My background with DBMS security is mostly in CODASYL shallow network systems where user level access control to datasets and fiel

Re: [GENERAL] Database system identifier via SELECT?

You can get the database system identifier from the OS shell as part of the control data: pg_controldata /Library/PostgreSQL/9.1/data Here, '/Library/PostgreSQL/9.1/data' is my data directory on os x; replace it with your own data directory. >From there, you can isolate the database system identif

Re: [GENERAL] Database system identifier via SELECT?

On Thu, Dec 8, 2011 at 4:27 PM, Bruce Momjian wrote: > Joshua D. Drake wrote: > > > > On 12/08/2011 12:57 PM, Bruce Momjian wrote: > > > > > > Chris Redekop wrote: > > >> Is there any way to get the database system identifier via a select > > >> statement? I have a primary/secondary async replic

[GENERAL] OT DBA type question - GRANT PRIVILEDGE

Do many of you implement fine grained security provisions at the DBMS level using GRANT PRIVILEGE ON object TO user/role? My background with DBMS security is mostly in CODASYL shallow network systems where user level access control to datasets and fields was mainly a matter for the application and

Re: [GENERAL] Database system identifier via SELECT?

Joshua D. Drake wrote: > > On 12/08/2011 12:57 PM, Bruce Momjian wrote: > > > > Chris Redekop wrote: > >> Is there any way to get the database system identifier via a select > >> statement? I have a primary/secondary async replication setup, and I'd > >> like be able to verify from the client sid

Re: [GENERAL] Database system identifier via SELECT?

-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Bruce Momjian Sent: Thursday, December 08, 2011 3:57 PM To: Chris Redekop Cc: pgsql-general Subject: Re: [GENERAL] Database system identifier via SELECT? Chris Redekop wrote

Re: [GENERAL] Database system identifier via SELECT?

On 12/08/2011 12:57 PM, Bruce Momjian wrote: Chris Redekop wrote: Is there any way to get the database system identifier via a select statement? I have a primary/secondary async replication setup, and I'd like be able to verify from the client side that the provided primary and secondary conn

Re: [GENERAL] Database system identifier via SELECT?

Chris Redekop wrote: > Is there any way to get the database system identifier via a select > statement? I have a primary/secondary async replication setup, and I'd > like be able to verify from the client side that the provided primary and > secondary connection strings do in fact refer to the sam

Re: [GENERAL] Clarification on CONTEXT: xlog redo xid assignment

On Thu, Dec 8, 2011 at 6:37 PM, kc5 wrote: > Dec  7 12:40:55  postgres[28199]: [ID 748848 local2.info] [5-1] LOG:  file > "pg_subtrans/8732" doesn't exist, reading as zeroes > Dec  7 12:40:55  postgres[28199]: [ID 748848 local2.info] [5-2] CONTEXT: > xlog redo xid assignment xtop 2268215780: subx

Re: [GENERAL] Hope for a new PostgreSQL era?

On 12/08/2011 11:24 AM, John R Pierce wrote: On 12/08/11 11:16 AM, Joshua D. Drake wrote: um, I believe this is referring to Oracle RAC clustering, not HA active/standby. I seriously doubt Oracle is dropping RAC. I meant worrying about it for Pg. the odds of Postgres developing something

Re: [GENERAL] Hope for a new PostgreSQL era?

On 12/08/11 11:16 AM, Joshua D. Drake wrote: um, I believe this is referring to Oracle RAC clustering, not HA active/standby. I seriously doubt Oracle is dropping RAC. I meant worrying about it for Pg. the odds of Postgres developing something as complex and intricate as RAC are probably be

Re: [GENERAL] Hope for a new PostgreSQL era?

On 12/08/2011 10:54 AM, John R Pierce wrote: On 12/08/11 10:14 AM, Joshua D. Drake wrote: - shared-storage clustering. Dunno if anyone still cares about this one though. This one seems to be moving into the legacy category over the next 3-5 years. um, I believe this is referring to Oracl

Re: [GENERAL] Hope for a new PostgreSQL era?

On 12/08/11 10:14 AM, Joshua D. Drake wrote: - shared-storage clustering. Dunno if anyone still cares about this one though. This one seems to be moving into the legacy category over the next 3-5 years. um, I believe this is referring to Oracle RAC clustering, not HA active/standby. I

[GENERAL] Clarification on CONTEXT: xlog redo xid assignment

Looking for some clarification on some log output. We are moving our databases to new physical machines. To do this we are taking zfs snapshots from the slaves copying the snapshots to the new machines and then restarting the new machines with a failover file. The database is able to start an

Re: [GENERAL] Hope for a new PostgreSQL era?

On 12/08/2011 03:24 AM, Craig Ringer wrote: - shared-storage clustering. Dunno if anyone still cares about this one though. This one seems to be moving into the legacy category over the next 3-5 years. JD -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Trainin

[GENERAL] Database system identifier via SELECT?

Is there any way to get the database system identifier via a select statement? I have a primary/secondary async replication setup, and I'd like be able to verify from the client side that the provided primary and secondary connection strings do in fact refer to the same data set...

Re: [GENERAL] Hope for a new PostgreSQL era?

On 8 Prosinec 2011, 14:20, Andrew Sullivan wrote: > On Thu, Dec 08, 2011 at 01:53:45PM +0100, Tomas Vondra wrote: >> I wonder if the prioritisation could be done using nice - each backend >> is >> a separate process, so why not to do 'nice(10)' for low priority >> processes >> or something like tha

Re: [GENERAL] Hope for a new PostgreSQL era?

On Thursday 08 December 2011 18:34:35 Tomas Vondra wrote: > On 8 Prosinec 2011, 18:14, Marc Cousin wrote: > >> > It means you keep your session variables, your prepared > >> > statements, > >> > your running transaction, etc… in each individual session while > >> > having the multiplexing equivalen

Re: [GENERAL] Hope for a new PostgreSQL era?

On 8 Prosinec 2011, 18:14, Marc Cousin wrote: >> > It means you keep your session variables, your prepared statements, >> > your running transaction, etc… in each individual session while >> > having the multiplexing equivalent of a 'statement level' from >> > pgbouncer. >> >> Yes. But if you expec

Re: [GENERAL] Hope for a new PostgreSQL era?

On 8 Prosinec 2011, 17:56, Merlin Moncure wrote: > regarding the "enterprises won't use community supplied postgresql add > ons" point, this completely true in many cases. I do think pgbouncer > should be seriously considered for advancement as a core feature. That > said, this should be done on it

Re: [GENERAL] Hope for a new PostgreSQL era?

Le Thu, 8 Dec 2011 10:56:39 -0600, Merlin Moncure a écrit : > On Thu, Dec 8, 2011 at 10:11 AM, Marc Cousin > wrote: > > Le Thu, 8 Dec 2011 09:29:28 -0600, > > Merlin Moncure a écrit : > > > >> On Thu, Dec 8, 2011 at 9:11 AM, Marc Cousin > >> wrote: > >> > Le Thu, 8 Dec 2011 12:27:22 +, > >

Re: [GENERAL] Hope for a new PostgreSQL era?

Le Thu, 8 Dec 2011 18:02:51 +0100, "Tomas Vondra" a écrit : > On 8 Prosinec 2011, 17:11, Marc Cousin wrote: > > Le Thu, 8 Dec 2011 09:29:28 -0600, > >> >> > - admission control, queuing and resource limiting to > >> >> > optimally load a machine. Some limited level is possible with > >> >> > exte

Re: [GENERAL] Hope for a new PostgreSQL era?

On 8 Prosinec 2011, 18:00, Marc Cousin wrote: > Le Thu, 8 Dec 2011 16:27:56 +, > "Nicholson, Brad (Toronto, ON, CA)" a écrit : > >> On Thu, Dec 8, 2011 at 9:11 AM, Marc Cousin >> > > wrote: >> > >> > I wish it was the same (I use and like both pgbouncer and pgpool >> > too, and they do a good

Re: [GENERAL] Hope for a new PostgreSQL era?

On 8 Prosinec 2011, 17:27, Nicholson, Brad (Toronto, ON, CA) wrote: > On Thu, Dec 8, 2011 at 9:11 AM, Marc Cousin >> > wrote: >> >> I wish it was the same (I use and like both pgbouncer and pgpool too, >> and they do a good job, I'm not arguing on that). But unfortunately it >> isn't: you still ha

Re: [GENERAL] Hope for a new PostgreSQL era?

Le Thu, 8 Dec 2011 17:54:20 +0100, "Tomas Vondra" a écrit : > On 8 Prosinec 2011, 16:11, Marc Cousin wrote: > >> > - admission control, queuing and resource limiting to optimally > >> > load a machine. Some limited level is possible with external > >> > pooling, but only by limiting concurrent wo

Re: [GENERAL] Hope for a new PostgreSQL era?

On Thu, Dec 8, 2011 at 10:11 AM, Marc Cousin wrote: > Le Thu, 8 Dec 2011 09:29:28 -0600, > Merlin Moncure a écrit : > >> On Thu, Dec 8, 2011 at 9:11 AM, Marc Cousin >> wrote: >> > Le Thu, 8 Dec 2011 12:27:22 +, >> > Simon Riggs a écrit : >> > >> >> On Thu, Dec 8, 2011 at 11:24 AM, Craig Rin

Re: [GENERAL] Hope for a new PostgreSQL era?

Le Thu, 8 Dec 2011 16:27:56 +, "Nicholson, Brad (Toronto, ON, CA)" a écrit : > On Thu, Dec 8, 2011 at 9:11 AM, Marc Cousin > > > wrote: > > > > I wish it was the same (I use and like both pgbouncer and pgpool > > too, and they do a good job, I'm not arguing on that). But > > unfortunately it

Re: [GENERAL] Hope for a new PostgreSQL era?

On 8 Prosinec 2011, 17:11, Marc Cousin wrote: > Le Thu, 8 Dec 2011 09:29:28 -0600, >> >> > - admission control, queuing and resource limiting to optimally >> >> > load a machine. Some limited level is possible with external >> >> > pooling, but only by limiting concurrent workers. >> > >> > Oracle

Re: [GENERAL] Hope for a new PostgreSQL era?

On 8 Prosinec 2011, 16:11, Marc Cousin wrote: >> > - admission control, queuing and resource limiting to optimally >> > load a machine. Some limited level is possible with external >> > pooling, but only by limiting concurrent workers. > > Oracle has natively two ways of handling inbound connection

Re: [GENERAL] Hope for a new PostgreSQL era?

On 8 Prosinec 2011, 14:17, Craig Ringer wrote: > You can. > > ALTER USER username SET work_mem = '100MB'; > > It's not a hard cap - the user can raise/lower it however they like. The > initial value can be set globally, per-user, per-database, or globally. Oh, shame on me! I wasn't aware of this.

Re: [GENERAL] Hope for a new PostgreSQL era?

On Thu, Dec 8, 2011 at 9:11 AM, Marc Cousin > > wrote: > > I wish it was the same (I use and like both pgbouncer and pgpool too, > and they do a good job, I'm not arguing on that). But unfortunately it > isn't: you still have the notion of session for each connected client > in Oracle when using t

[GENERAL] Statistics mismatch between n_live_tup and actual row count

Hi, we're currently investigating a statistics issue on postgres. We have some tables which frequently show up with strange values for n_live_tup. If you compare those values with a count on that particular table, there is a mismatch of factor 10-30. This causes the planner to come up with very

Re: [GENERAL] Hope for a new PostgreSQL era?

Le Thu, 8 Dec 2011 09:29:28 -0600, Merlin Moncure a écrit : > On Thu, Dec 8, 2011 at 9:11 AM, Marc Cousin > wrote: > > Le Thu, 8 Dec 2011 12:27:22 +, > > Simon Riggs a écrit : > > > >> On Thu, Dec 8, 2011 at 11:24 AM, Craig Ringer > >> wrote: > >> > >> > Areas in which Pg seems significant

Re: [GENERAL] Hope for a new PostgreSQL era?

On Thu, Dec 08, 2011 at 09:29:28AM -0600, Merlin Moncure wrote: > > you have a couple of very good options to achieve the same in postgres > -- pgbouncer, pgpool. One of the central issues that Postgres has in the "enterprise" land is exactly this sort of answer: "you have good options" but they'

Re: [GENERAL] concat(NULL,NULL) returns empty string

Hello 2011/12/8 Ingmar Brouns : > > Hi, > > The documentation of the function concat states: Concatenate all arguments. > NULL arguments are ignored. > Intuitively I would expect that > > concat(NULL, NULL) IS NULL > > but this is not the case as it equals the empty string. As no empty string > wa

[GENERAL] concat(NULL,NULL) returns empty string

Hi, The documentation of the function concat states: Concatenate all arguments. NULL arguments are ignored. Intuitively I would expect that concat(NULL, NULL) IS NULL but this is not the case as it equals the empty string. As no empty string was passed, the empty string seems to come from nowher

Re: [GENERAL] Hope for a new PostgreSQL era?

On Thu, Dec 8, 2011 at 9:11 AM, Marc Cousin wrote: > Le Thu, 8 Dec 2011 12:27:22 +, > Simon Riggs a écrit : > >> On Thu, Dec 8, 2011 at 11:24 AM, Craig Ringer >> wrote: >> >> > Areas in which Pg seems significantly less capable include: >> >> Please can you explain the features Oracle has in

Re: [GENERAL] Fwd: postgres 9.0.4 Streaming related question ..

Thanks , it worked On Wed, Dec 7, 2011 at 12:01 PM, Ben Chobot wrote: > > On Dec 7, 2011, at 8:45 AM, akp geek wrote: > > > Small Clarification. I have gone through the documentation. I did not > find any thing related to start ans stop replication after the replication > is setup > > > > 1. If

Re: [GENERAL] Hope for a new PostgreSQL era?

Le Thu, 8 Dec 2011 12:27:22 +, Simon Riggs a écrit : > On Thu, Dec 8, 2011 at 11:24 AM, Craig Ringer > wrote: > > > Areas in which Pg seems significantly less capable include: > > Please can you explain the features Oracle has in these area, I'm not > clear. Thanks. Maybe I can answer fro

Re: [GENERAL] Hope for a new PostgreSQL era?

On Wed, Dec 7, 2011 at 8:52 PM, Rodrigo E. De León Plicet wrote: > http://www.dbms2.com/2011/11/23/hope-for-a-new-postgresql-era/ > > Some of the points mentioned: > - MySQL is narrowing the gap, but PostgreSQL is still ahead of MySQL >  in some ways.  (Database extensibility if nothing else.) Th

Re: [GENERAL] Hope for a new PostgreSQL era?

2011/12/08 21:53, Tomas Vondra wrote: - performance monitoring and diagnostics. It's way harder to find out what's causing load on a busy Pg server or report on frequent/expensive queries etc. Tooling is limited and fairly primitive. It's find, but nowhere near as powerful and easy as some if the

Re: [GENERAL] Hope for a new PostgreSQL era?

On Thu, Dec 08, 2011 at 01:53:45PM +0100, Tomas Vondra wrote: > I wonder if the prioritisation could be done using nice - each backend is > a separate process, so why not to do 'nice(10)' for low priority processes > or something like that. This won't work because if you are holding a lock on some

Re: [GENERAL] Hope for a new PostgreSQL era?

On 12/08/2011 08:53 PM, Tomas Vondra wrote: On 8 Prosinec 2011, 12:24, Craig Ringer wrote: - admission control, queuing and resource limiting to optimally load a machine. Some limited level is possible with external pooling, but only by limiting concurrent workers. o d The first thing I'd like

Re: [GENERAL] Hope for a new PostgreSQL era?

On 8 Prosinec 2011, 12:24, Craig Ringer wrote: > - admission control, queuing and resource limiting to optimally load a > machine. Some limited level is possible with external pooling, but only by > limiting concurrent workers. The first thing I'd like to see is "user profiles" - being able to set

Re: [GENERAL] Hope for a new PostgreSQL era?

On Thu, Dec 8, 2011 at 11:24 AM, Craig Ringer wrote: > Areas in which Pg seems significantly less capable include: Please can you explain the features Oracle has in these area, I'm not clear. Thanks. > - admission control, queuing and resource limiting to optimally load a > machine. Some limit

Re: [GENERAL] Hope for a new PostgreSQL era?

On Dec 8, 2011 1:27 PM, "Chris Travers" wrote: > > Additionally I am not entirely sure what he means by the last point. > If you look at the work that NTT along with EDB has put into > Postgres-XC, for example, it looks to me like the Postgres ecosystem > is growing by leaps and bounds and we are

Re: [GENERAL] Very slow table

On 8 December 2011 06:28, Richard Weiss wrote: > Hi, I am using squeryl, which is based on jdbc, and I am trying to run the > following statement: > delete from "Entry" where ("id" = 0) > but the query never seems to finish. I have tried it in both the program I > am writing, and the above stateme