Re: [GENERAL] Visualize GiST Index

2010-09-22 Thread Andrew Hunter
On 2010-09-22, at 9:56 PM, Tom Lane wrote: > Andrew Hunter writes: >> I have been trying to install the Gevel module but am getting an error when >> running make on the gevel files download. >> The error is: > >> /contrib/contrib-global.mk: No such file or directory. > >> I have also tried US

Re: [GENERAL] Visualize GiST Index

2010-09-22 Thread Tom Lane
Andrew Hunter writes: > I have been trying to install the Gevel module but am getting an error when > running make on the gevel files download. > The error is: > /contrib/contrib-global.mk: No such file or directory. > I have also tried USE_PGXS=1 make, but get the same result. I am unable to

Re: [GENERAL] [pgsql-sql] Daily digest v1.3328 (5 messages)

2010-09-22 Thread Adrian Klaver
On Wednesday 22 September 2010 5:40:55 pm David Wilson wrote: > On Wed, Sep 22, 2010 at 8:30 PM, Adrian Klaver wrote: > > From here; > > > > http://www.postgresql.org/docs/8.4/interactive/datatype-boolean.html > > I believe the question relates to changing the string *output* of the > database to s

Re: [GENERAL] Kill -9 for a session process caused all the sessions to be killed

2010-09-22 Thread Craig Ringer
On 23/09/2010 12:26 AM, atul.g...@globaldatapoint.com wrote: Hi All, I by mistake ran a query to update a huge table with around 50 rows and has to kill the session. I found the process-id from the query select * from pg_stat_activity. I killed the process using Kill -9 process_id. Why

Re: [GENERAL] [pgsql-sql] Daily digest v1.3328 (5 messages)

2010-09-22 Thread David Wilson
On Wed, Sep 22, 2010 at 8:30 PM, Adrian Klaver wrote: > > From here; > > http://www.postgresql.org/docs/8.4/interactive/datatype-boolean.html > > > I believe the question relates to changing the string *output* of the database to something other than 't' and 'f', not an issue with input formats.

Re: [GENERAL] Can psql show the column type of a result ?

2010-09-22 Thread Nils O. Selåsdal
On 22.09.2010 23:26, Richard Broersma wrote: On Wed, Sep 22, 2010 at 12:52 PM, "Nils O. Selåsdal" wrote: Hello, I'm wondering if there's a way to show the column type of a result with psql, e.g. select sum(r) from mytable; r --- 101.0 I'd like to see the type of the 'r' column.

Re: [GENERAL] [pgsql-sql] Daily digest v1.3328 (5 messages)

2010-09-22 Thread Adrian Klaver
On Wednesday 22 September 2010 5:12:45 pm TJ O'Donnell wrote: > Many frameworks do not natively recognize "t" as true and "f" as false. > I'm using php, json_encode and extjs. > Is it possible to cause the default output of boolean values to be > something other than "t" and "f", say "true" and "fa

Re: [GENERAL] [pgsql-sql] Daily digest v1.3328 (5 messages)

2010-09-22 Thread TJ O'Donnell
Many frameworks do not natively recognize "t" as true and "f" as false. I'm using php, json_encode and extjs. Is it possible to cause the default output of boolean values to be something other than "t" and "f", say "true" and "false" or even 1 and 0? Of course I can do this for an individual query

[GENERAL] One warning on migration from 8.4 --> 9.0

2010-09-22 Thread Karl Denninger
If you use Slony, expect it to lose the replication status. I attempted the following: 1. Master and slaves on 8.4. 2. Upgrade one slave to 9.0. Shut it down, used pg_upgrade to perform the upgrade. 3. Restarted the slave. Slony appeared to come up, but said it was syncing only TWO tables (

Re: [GENERAL] What was new in 8.4 & 8.3?

2010-09-22 Thread John R Pierce
On 09/22/10 4:28 PM, Scott Ribe wrote: The what's new in 9.0 document on the wiki is great. Is there anything similar for 8.4& 8.3& so on? I haven't had time to take advantage of all new features for a while. (Always read the release notes, just couldn't do much about them.) And now I'm loo

[GENERAL] What was new in 8.4 & 8.3?

2010-09-22 Thread Scott Ribe
The what's new in 9.0 document on the wiki is great. Is there anything similar for 8.4 & 8.3 & so on? I haven't had time to take advantage of all new features for a while. (Always read the release notes, just couldn't do much about them.) And now I'm looking at it being a good time to really up

Re: [GENERAL] Nested literal parsing rules?

2010-09-22 Thread Maciek Sakrejda
> The record and array escaping rules are here: > http://www.postgresql.org/docs/9.0/static/rowtypes.html#AEN7091 > http://www.postgresql.org/docs/9.0/static/arrays.html#ARRAYS-IO > and I think the hstore rules are spelled out in the docs for that > contrib module. Thanks, that helped a lot. I thi

Re: [GENERAL] Can psql show the column type of a result ?

2010-09-22 Thread Tom Lane
=?UTF-8?B?Ik5pbHMgTy4gU2Vsw6VzZGFsIg==?= writes: > I'm wondering if there's a way to show the column type of a result with > psql, e.g. >>> select sum(r) from mytable; > r > --- > 101.0 > I'd like to see the type of the 'r' column. There's nothing built-in to psql, but you could mod

Re: [GENERAL] Can psql show the column type of a result ?

2010-09-22 Thread Richard Broersma
On Wed, Sep 22, 2010 at 12:52 PM, "Nils O. Selåsdal" wrote: >  Hello, > I'm wondering if there's a way to show the column type of a result with > psql, e.g. > >> select sum(r) from mytable; >   r > --- >  101.0 > > I'd like to see the type of the 'r' column. > > > -- > Sent via pgsql-general m

Re: [GENERAL] Compiling openssl

2010-09-22 Thread Alban Hertroys
On 22 Sep 2010, at 22:00, Awodipe James wrote: > Good day, > Is it possible to use any of your products to compile openssl-1.0.0a.tar.gz No. Relational databases aren't generally used to compile code ;) I think you're looking to contact the guys of Mingw/Msys or possibly Cygwin. Alban Hertroys

[GENERAL] Compiling openssl

2010-09-22 Thread Awodipe James
Good day, Is it possible to use any of your products to compile openssl-1.0.0a.tar.gz form http://www.openssl.org/source/ for Win32 environment, how? OR can you help complile it with this adjustment to the makefile: To build, I needed to modify the first lines of the example code's Makefile as

[GENERAL] Can psql show the column type of a result ?

2010-09-22 Thread Nils O. Selåsdal
Hello, I'm wondering if there's a way to show the column type of a result with psql, e.g. > select sum(r) from mytable; r --- 101.0 I'd like to see the type of the 'r' column. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] Nested literal parsing rules?

2010-09-22 Thread Tom Lane
Maciek Sakrejda writes: > I have a UDT: > CREATE TYPE foo AS (a integer, b integer, c hstore); > I need to construct the literal representation of an array of these > for input to a textual COPY. The hstore escaping rules are fairly > clear (I can quote all keys and values with double quotes, an

Re: [GENERAL] How about synchronous notifications?

2010-09-22 Thread Vick Khera
On Wed, Sep 22, 2010 at 9:53 AM, Lincoln Yeoh wrote: > Given these issues I guess it would be easier to use a separate messaging > server (despite that still not being that easy :) ). This would have the > characteristic of not being DB specific, so apps wouldn't be locked in to > postgresql. Whet

Re: [GENERAL] Kill -9 for a session process caused all the sessions to be killed

2010-09-22 Thread Francisco Reyes
atul.g...@globaldatapoint.com writes: to be killed? What is the best way to kill a session in Postgres? Just plain kill would have worked better. I believe the issue is with the '-9'. Also see http://www.postgresonline.com/journal/index.php?/archives/134-Terminating-An noying-Back-Ends.ht

[GENERAL] Nested literal parsing rules?

2010-09-22 Thread Maciek Sakrejda
Hi, I have a UDT: CREATE TYPE foo AS (a integer, b integer, c hstore); I need to construct the literal representation of an array of these for input to a textual COPY. The hstore escaping rules are fairly clear (I can quote all keys and values with double quotes, and escape double quotes in keys

[GENERAL] file output via trigger/queue

2010-09-22 Thread Whit Armstrong
I am in a similar situation described by this thread: http://www.mail-archive.com/pgsql-general@postgresql.org/msg78604.html I need to write a few xml files to be consumed by a vendor application in real-time. The queue / (poll/cronjob) seems simple enough. Before I commit I just wondered if any

Re: [GENERAL] Force ARE in regexp string

2010-09-22 Thread Johannes Öberg
On 2010-09-15 15:33, Tom Lane wrote: =?ISO-8859-1?Q?Johannes_=D6berg?= writes: I've set regex_flavor to ARE, and I've tried prefixing my strings, i.e. ~* E'***:abc' but for some reason postgres treats all my regexps as BRE's. Well, the symptom as described seems pretty improbable. You didn't

Re: [GENERAL] Kill -9 for a session process caused all the sessions to be killed

2010-09-22 Thread Tom Lane
writes: > I by mistake ran a query to update a huge table with around 50 rows and > has to kill the session. > I found the process-id from the query select * from pg_stat_activity. I > killed the process using Kill -9 process_id. > This caused all other sessions in the system to be killed

[GENERAL] Kill -9 for a session process caused all the sessions to be killed

2010-09-22 Thread Atul.Goel
Hi All, I by mistake ran a query to update a huge table with around 50 rows and has to kill the session. I found the process-id from the query select * from pg_stat_activity. I killed the process using Kill -9 process_id. This caused all other sessions in the system to be killed and databa

Re: [GENERAL] What's wrong with this query?

2010-09-22 Thread Tom Lane
Mike Christensen writes: > So are you saying that a JOIN can only refer to itself and the last > table on the FROM list? Um, I think you've got the wrong mental model of the syntax. JOIN is a binary operation between two tables: tab1 JOIN tab2 ON some-condition-involving-tab1-and-tab2-o

Re: [GENERAL] How about synchronous notifications?

2010-09-22 Thread Lincoln Yeoh
At 07:55 PM 9/22/2010, Vick Khera wrote: Here's how you do it: first, make sure you are not within a transaction or other Pg activity. Get the socket's file handle from the Pg connection handle. When you're ready to wait for a notify event, just do a select() system call on that file handle wa

Re: [GENERAL] versioned pl/pgsql functions

2010-09-22 Thread Nagy Zoltan
hi, a few weeks ago i found a project aimed at providing version control for pq: http://www.pgcon.org/2009/schedule/events/158.en.html http://www.post-facto.org/ it worth to try it out, and use it ;) regards, kirk On 09/21/10 21:56, Rhys A.D. Stewart wrote: > hey all, > > I think versioned pl/[

Re: [GENERAL] versioned pl/pgsql functions

2010-09-22 Thread Vick Khera
On Tue, Sep 21, 2010 at 7:28 PM, Joshua J. Kugler wrote: > Keep version control in version control. Make creation/replacement of > stored procedures part of your deployment system. > +1 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: h

Re: [GENERAL] How about synchronous notifications?

2010-09-22 Thread Vick Khera
On Tue, Sep 21, 2010 at 12:23 PM, Lincoln Yeoh wrote: > To me what would also be useful would be synchronous notifications. > > This would allow many programs to wait for events to happen rather than all > of them polling the database (and wasting CPU cycles, battery life, etc). > You could still

Re: [GENERAL] What's wrong with this query?

2010-09-22 Thread Mike Christensen
Hi Tom, sorry to be a total n00b, but can you give me a few more pointers? I've noticed if I swap the two "tables" around, like: FROM plainto_tsquery('quiche') query, Recipes R then it works.. So are you saying that a JOIN can only refer to itself and the last table on the FROM list? I actuall

Re: [GENERAL] Reclaiming space

2010-09-22 Thread Christopher Gorge A. Marges
On 9/22/2010 12:18 PM, Scott Marlowe wrote: On Tue, Sep 21, 2010 at 9:10 PM, Christopher Gorge A. Marges wrote: But how would the newer version prevent bloat and eliminate making the database unavailable while the *maintenance* goes on? The database is more than five years old, and we did n