On 9/22/2010 12:18 PM, Scott Marlowe wrote:
On Tue, Sep 21, 2010 at 9:10 PM, Christopher Gorge A. Marges
go...@apollo.com.ph 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
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 actually
On Tue, Sep 21, 2010 at 12:23 PM, Lincoln Yeoh ly...@pop.jaring.my 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).
On Tue, Sep 21, 2010 at 7:28 PM, Joshua J. Kugler jos...@eeinternet.com 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
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
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
Mike Christensen m...@kitchenpc.com 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
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
atul.g...@globaldatapoint.com 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
On 2010-09-15 15:33, Tom Lane wrote:
=?ISO-8859-1?Q?Johannes_=D6berg?=johannes.ob...@proactivegaming.com 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
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
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
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
On Wed, Sep 22, 2010 at 9:53 AM, Lincoln Yeoh ly...@pop.jaring.my 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
Maciek Sakrejda msakre...@truviso.com 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
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:
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
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
On Wed, Sep 22, 2010 at 12:52 PM, Nils O. Selåsdal
nosel...@asgaard.homelinux.org 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
=?UTF-8?B?Ik5pbHMgTy4gU2Vsw6VzZGFsIg==?= nosel...@asgaard.homelinux.org
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
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 think I
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
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
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
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 using
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 false or even 1
On 22.09.2010 23:26, Richard Broersma wrote:
On Wed, Sep 22, 2010 at 12:52 PM, Nils O. Selåsdal
nosel...@asgaard.homelinux.org 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
On Wed, Sep 22, 2010 at 8:30 PM, Adrian Klaver adrian.kla...@gmail.comwrote:
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
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.
On Wednesday 22 September 2010 5:40:55 pm David Wilson wrote:
On Wed, Sep 22, 2010 at 8:30 PM, Adrian Klaver adrian.kla...@gmail.comwrote:
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
Andrew Hunter ahun...@ucalgary.ca 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.
On 2010-09-22, at 9:56 PM, Tom Lane wrote:
Andrew Hunter ahun...@ucalgary.ca 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
32 matches
Mail list logo