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
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
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
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
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.
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.
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
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
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 (
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
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
> 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
=?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
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
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
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
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:
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
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
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
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
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
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
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
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
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
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
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/[
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
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
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
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
32 matches
Mail list logo