Re: [GENERAL] list non alphanumeric

Hi Thanks for the response but I tried that and it does not work here is an example of names which still display. test sadadds Hillary BEN NAME ALAN MCGARVEY + From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce Sent: 12 April 2013 0

Re: [GENERAL] list non alphanumeric

On 4/11/2013 11:23 PM, Baboo, Isa wrote: Firstly let me mention I am a noob to postgres,DB and sql anyway, I have a column with First names and need to list names that have non-alphanumeric characters in them like + or * and the list goes on. I did google a bit and tried: /select * from TA

[GENERAL] list non alphanumeric

Hi Firstly let me mention I am a noob to postgres,DB and sql anyway, I have a column with First names and need to list names that have non-alphanumeric characters in them like + or * and the list goes on. I did google a bit and tried: select * from TABLE where first_name not like '%[a-z0-9]%'

[GENERAL] GSL in mcbc(redhat)

Hello, colleagues ! I have to develop some functions onto postgresql server 9.2 based on Gnu Scientific Library. Under redhat I compile gsl with ./configure --prefix=/usr/local compile postgresql with ./configure --prefix=/usr/local --with-uuid-ossp --with-xml --with-xslt. After that I try to put

Re: [GENERAL] Update

On 04/11/2013 07:39 AM, jpui wrote: But is it possible that a client running postgres 8.3 to comuniccate with thw server running postgres 8.4? They should, but it would be best to verify against a test instance of whatever version you choose. FYI, 8.4 end of life is July 2014, might be better

Re: [GENERAL]

On 4/9/2013 4:23 AM, News Subsystem wrote: PostgreSQL verison is 8.1 that version has been out of date for YEARS now. the last release in the 8.1 family, 8.1.23, was in 2010. 8.1 was released in 2005. The oldest version still supported is 8.4, and 9.2 is the latest. that said, how big is

Re: [GENERAL] PostgreSQL Upgrade from 9.1.8 to 9.1.9

Hi Ascot, I am new to Postgresql, I have installed the Postgresql 9.1.8 in my ubuntu > 12.04 machine and I found 9.1.9 was released last week, can someone advise > me how to upgrade pg from 9.1.8 to 9.1.9? > > or, are the following commands correct for this upgrade? > apt-get update > apt-get upgr

Re: [GENERAL] PostgreSQL 9.1.8 Upgrade to 9.1.9

Le 2013-04-08 à 22:45, Ascot Moss a écrit : > I am new to Postgresql. > > I have the Postgresql 9.1.8 installed in my Ubuntu 12.04 machine, I found > 9.1.9 was released last week, can anyone advise me the steps to upgrade 9.1.8 > to 9.1.9? > > o/s: ubuntu 12.04 64-bit > current postgresql: 9.

[GENERAL] Re: How to reset windows password including Windows 8, Windows 7 and Windows XP

In oder to reset Windows password including Windows 8, Windows 7 and Windows XP, we have many solutions to it. Firstly, we can make use of a password reset disk , if you have created one

[GENERAL] PostgreSQL Upgrade from 9.1.8 to 9.1.9

Hi, I am new to Postgresql, I have installed the Postgresql 9.1.8 in my ubuntu 12.04 machine and I found 9.1.9 was released last week, can someone advise me how to upgrade pg from 9.1.8 to 9.1.9? or, are the following commands correct for this upgrade? apt-get update apt-get upgrade (os Ubuntu 12

[GENERAL] Are partitions getting pruned?

Postgres 8.4.9 on CentOS I partitioned some tables over the weekend by month using a date field as the partitioning column. Table inheritance was used and all indexes on the parent were created on the partitions. constraint_exclustion = partition. My question is, are partitions really

[GENERAL] PostgreSQL 9.1.8 Upgrade to 9.1.9

Hi, I am new to Postgresql. I have the Postgresql 9.1.8 installed in my Ubuntu 12.04 machine, I found 9.1.9 was released last week, can anyone advise me the steps to upgrade 9.1.8 to 9.1.9? o/s: ubuntu 12.04 64-bit current postgresql: 9.1.8 target postgresql: 9.1.9 Is it ok to run "apt-get upda

[GENERAL]

Tue, 09 Apr 2013 04:21:51 -0700 (PDT) 09 Apr 2013 04:21:50 -0700 (PDT) X-Newsgroups: pgsql.general Date: Tue, 9 Apr 2013 04:21:50 -0700 (PDT) Complaints-To: groups-ab...@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=210.143.35.31; posting-account=GbL1LQo5

[GENERAL]

Tue, 09 Apr 2013 04:23:04 -0700 (PDT) Apr 2013 04:23:04 -0700 (PDT) X-Newsgroups: pgsql.general Date: Tue, 9 Apr 2013 04:23:03 -0700 (PDT) In-Reply-To: <47408590-a31c-4541-a2e4-1da06bb7c...@googlegroups.com> Complaints-To: groups-ab...@google.com Injection-Info: glegroupsg2000goo.googlegro

Re: [GENERAL] Cost of initiating cursors

Matthew Churcher writes: > I've tried cursor_tuple_fraction values as low as 0.01 which by my > reckoning should be low enough and also 0 but the planner is still selecting > seqscan-and-sort. Hm. Keep in mind that plpgsql caches query plans, so if you're examining this by checking th

Re: [GENERAL] Cost of initiating cursors

Thanks Tom, That's very enlightening and I really appreciate you taking time to respond. I've tried cursor_tuple_fraction values as low as 0.01 which by my reckoning should be low enough and also 0 but the planner is still selecting seqscan-and-sort. Kind regards, Matthew Churcher -

Re: [GENERAL] crash proof for semi-embedded system

On Apr 11, 2013, at 5:11 AM, David Welton wrote: > Hi, > > I'm going to be deploying Postgres in a semi-embedded system where end > users might simply power the thing off from one moment to the next. > Or the disk might start to go wonky, or any number of other problems. > Because it's a standa

Re: [GENERAL] pulling year out of a timestamp

On Apr 11, 2013, at 10:55 AM, Ryan Kelly wrote: > You want date_part, not date_trunc. > > -Ryan Thanks Ryan. It looks like " EXTRACT(YEAR FROM table2.time2)" works as well.

Re: [GENERAL] pulling year out of a timestamp

On Thu, Apr 04/11/13, 2013 at 10:50:53AM -0500, Kirk Wythers wrote: > I am trying to perform a join between two tables where I need to join "year" > in table 1 with the year component of a timestamp in table 2. > > Something like this: > > table1.year = table2.timestamp > where timestamp has th

[GENERAL] pulling year out of a timestamp

I am trying to perform a join between two tables where I need to join "year" in table 1 with the year component of a timestamp in table 2. Something like this: table1.year = table2.timestamp where timestamp has the format: "2009-01-01 00:00:00" I've tried date_trunc('year', table2.timestamp

Re: [GENERAL] Update

On 04/11/2013 09:39 AM, jpui wrote: But is it possible that a client running postgres 8.3 to comuniccate with thw server running postgres 8.4? Yes. Aside from some system view changes that may break slash-commands in psql, the libraries should be all backwards compatible with old clients. Y

Re: [GENERAL] UPDATE .. JOIN?

Replace the tables on this query with your joined tables Update service_reminderschedule srs set reminder_sent = false from ( select ss.fk_man_service_id, ss.serviceschedule_id, v.vehicle_id from serviceschedule ss inner join manufactureservices ms

Re: [GENERAL] UPDATE .. JOIN?

Re: Updating a table with joins I have been trying to achieve the same thing for quite a period of months but could not get the right query, finally now i am sorted, this one works like a charm for me. Replace the tables on this query with joined tables Up

Re: [GENERAL] Update

But is it possible that a client running postgres 8.3 to comuniccate with thw server running postgres 8.4? Thank you -- View this message in context: http://postgresql.1045698.n5.nabble.com/Update-tp5751759p5751776.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. --

Re: [GENERAL] Update

On 04/11/2013 10:29 AM, Ian Lawrence Barwick wrote: There are some notes on limitations when upgrading from 8.3: http://www.postgresql.org/docs/9.2/static/pgupgrade.html#AEN147114 I wrote this up a long time ago when pg_upgrade was still called pg_migrator, and it specifically works around th

Re: [GENERAL] Update

2013/4/11 Joshua Berry : > >> Am 11.04.2013 10:29, schrieb jpui: >> > Hi, >> > I'm running a server using postgres 8.3 and i was adviced to update >> > it... >> > what i have to do in order to update it and don't stop the service? >> >> 8.3 is out of support so you will need to at a very minimum 8

Re: [GENERAL] Streaming Replication 9.2

On 04/11/2013 09:51 AM, David Greco wrote: I’ve setup streaming replication between two 9.2 servers, and have a few concerns/questions. I set it up with a very large wal_keep_segments, 17000, and do NOT ship the logs to the standby. O_o When I failover to the slave, MUST the process for brin

Re: [GENERAL] Cost of initiating cursors

Matthew Churcher writes: > For example: > FOR curr_foo > IN > SELECT foo FROM bar > WHERE wibble > ORDER BY wobble > LOOP > EXIT; -- always break out of loop > END LOOP; > For some reason this is hugely expensive and slow regardless of the selected > execution pla

[GENERAL] Streaming Replication 9.2

I've setup streaming replication between two 9.2 servers, and have a few concerns/questions. I set it up with a very large wal_keep_segments, 17000, and do NOT ship the logs to the standby. When I failover to the slave, MUST the process for bringing back up the former master initially as a slav

[GENERAL] Cost of initiating cursors

Hi All, I have a question in regards to the cost of initiating a cursor (for loop) over a large number of rows (100,000+) and actually retrieving little or none of them. For example: FOR curr_foo IN SELECT foo FROM bar WHERE wibble ORDER BY wobble LOOP EXIT; -- alw

Re: [GENERAL] Update

> Am 11.04.2013 10:29, schrieb jpui: > > Hi, > > I'm running a server using postgres 8.3 and i was adviced to update it... > > what i have to do in order to update it and don't stop the service? > > 8.3 is out of support so you will need to at a very minimum 8.4. This > cannot be done without rest

Re: [GENERAL] Update

Am 11.04.2013 10:29, schrieb jpui: > Hi, > I'm running a server using postgres 8.3 and i was adviced to update it... > what i have to do in order to update it and don't stop the service? 8.3 is out of support so you will need to at a very minimum 8.4. This cannot be done without restarting. Plea

[GENERAL] crash proof for semi-embedded system

Hi, I'm going to be deploying Postgres in a semi-embedded system where end users might simply power the thing off from one moment to the next. Or the disk might start to go wonky, or any number of other problems. Because it's a standalone device, it may well run in an environment where we can't sh

[GENERAL] Update

Hi, I'm running a server using postgres 8.3 and i was adviced to update it... what i have to do in order to update it and don't stop the service? Also, will clients running postgres 8.3 be able to comunicate with the server running an updated version? Thank you for your help -- View this messag