On Tue, Dec 10, 2013 at 5:49 AM, Bill Moran wmo...@potentialtech.com wrote:
On Mon, 09 Dec 2013 06:20:41 -1000 Stephan Fabel sfa...@hawaii.edu wrote:
Hi all,
and sorry if I'm asking a question that has been answered before; has the
PostgreSQL community ever considered different key/value
On Tue, Dec 3, 2013 at 4:32 AM, Shuwn Yuan Tee shuwny...@binary.com wrote:
We recently experienced crash on out postgres production server. Here's our
server environment:
- Postgres 9.3
- in OpenVZ container
- total memory: 64GB
Here's the error snippet from postgres log:
ERROR: could
On Wed, Nov 27, 2013 at 8:35 AM, Joey Quinn bjquinn...@gmail.com wrote:
So, no cancel... keeping my fingers crossed (rolling up on 170,000,000 ms -
a bit over 47 hours - data folder size now at 1.11 TB).
Fortunately, I'm pretty sure this will be my largest batch update (since the
info is
On Wed, Nov 27, 2013 at 9:00 AM, Joey Quinn bjquinn...@gmail.com wrote:
On Wed, Nov 27, 2013 at 9:50 AM, Merlin Moncure mmonc...@gmail.com wrote:
For very large updates on mostly static data it may be better to
SELECT the data into a new table then swap it in when done. MY rule
of thumb
On Tue, Nov 26, 2013 at 9:28 AM, Joey Quinn bjquinn...@gmail.com wrote:
I have a fairly large table (4.3 billion rows) that I am running an update
script on (a bit over 127 thousand individual update queries). I am using
the gui. It has been running for about 24 hours now. Is there any good way
On Tue, Nov 26, 2013 at 2:38 PM, John R Pierce pie...@hogranch.com wrote:
On 11/26/2013 12:30 PM, Merlin Moncure wrote:
There are not many ways to Hand off information outside of the
database while a transaction Is running. one way Is to write a Simple
trigger in plpgsql that 'raise'es
On Tue, Nov 26, 2013 at 3:20 PM, Raymond O'Donnell r...@iol.ie wrote:
On 26/11/2013 20:30, Merlin Moncure wrote:
There are not many ways to Hand off information outside of the
database while a transaction Is running. one way Is to write a Simple
trigger in plpgsql that 'raise'es A notice every
On Mon, Nov 25, 2013 at 11:43 AM, John Kelly jtke...@gmail.com wrote:
Im having a problem changing several cursors in a function to use a passed
in child table name. Database is 8.4.3 on Linux
--Original cursor
c_runway18a cursor is
( select id, geom
, way_num as waydesignator,
On Fri, Nov 15, 2013 at 2:01 AM, Tony Theodore tony.theod...@gmail.com wrote:
Hi,
I was reading about composite types and wondering if I should use them
instead of composite keys. I currently have tables like this:
create table products (
source_system text,
product_id
On Fri, Nov 15, 2013 at 12:43 AM, Philippe Girolami
philippe.girol...@sensorly.com wrote:
Ok so is there a way i can do something similar ? Would a function returning
rows and taking the extra predicate 'values' as parameters be as optimized as
the 'good' query in my first email ?
There is
On Mon, Nov 4, 2013 at 8:31 PM, ajeli...@gmail.com ajeli...@gmail.com wrote:
Along the lines of the equality operator; I have ran into issues trying
to
pivot a table/result set with a json type due what seemed to be no
equality
operator.
For the curious, and also use-case considerations for
On Fri, Nov 1, 2013 at 1:50 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Gregory Haase haa...@onefreevoice.com writes:
The json_data column is not accounted for in pg_stats:
Ah! I hadn't twigged to the fact that your bloat measurement approach
assumed you had pg_stats entries for all the columns.
On Mon, Nov 4, 2013 at 12:14 PM, David Johnston pol...@yahoo.com wrote:
ajeli...@gmail.com wrote
Along the lines of the equality operator; I have ran into issues trying to
pivot a table/result set with a json type due what seemed to be no
equality
operator.
For the curious, and also
On Thu, Oct 31, 2013 at 5:46 AM, Raphael Bauduin rbli...@gmail.com wrote:
Hi,
I have a partitioned table events, with one partition for each month, eg
events_2013_03. The partition is done on the field timestamp, and
constraints are set, but insertion of data is done in the partition
On Wed, Oct 30, 2013 at 3:16 PM, Brian Crowell br...@fluggo.com wrote:
Hello again!
I've been setting up my PostgreSQL server by doing something I've
never done before: I've joined a Linux server to a domain so I can use
integrated Kerberos authentication from server to server.
I've managed
On Tue, Oct 29, 2013 at 5:38 AM, Chris Travers chris.trav...@gmail.com wrote:
On Mon, Oct 28, 2013 at 4:17 PM, Gregory Haase haa...@onefreevoice.com
wrote:
I have a table that is triggering my nagios database bloat alert
regularly. Usually, I have to give it the vacuum full more than once
On Mon, Oct 28, 2013 at 4:06 PM, Perry Smith pedz...@gmail.com wrote:
When I execute the SELECT statement directly I get:
psql:table.sql:28: out of memory for query result
psql will do this automatically if you tell it to:
On Mon, Oct 28, 2013 at 5:49 PM, Perry Smith pedz...@gmail.com wrote:
On Oct 28, 2013, at 5:21 PM, Adrian Klaver adrian.kla...@gmail.com wrote:
On 10/28/2013 02:27 PM, Perry Smith wrote:
On Oct 28, 2013, at 4:11 PM, Merlin Moncure mmonc...@gmail.com wrote:
On Mon, Oct 28, 2013 at 4:06 PM
On Tue, Oct 22, 2013 at 8:16 AM, Rémi Cura remi.c...@gmail.com wrote:
Hey,
when using a for you implicitly use a cursor (I think),
so this is the same, use FOR if you like it more.
It should be *very* fast to write !
As I wrote, relational algebra can handle it, but it is not practically
On Tue, Oct 22, 2013 at 8:41 AM, Rémi Cura remi.c...@gmail.com wrote:
héhé,
nice snipping Merlin !
I guess you are almost there, output is still wrong (should be) (
Eg: Take A,A,A,B,C,A,D,A,A,D,D,B,C,C and return: A,3; B,1; C,1; A,1;
D,1; A,2; D,2; B,1; C,2
)
I don't understand enough to
On Tue, Oct 22, 2013 at 9:09 AM, Rémi Cura remi.c...@gmail.com wrote:
Thanks for this good example Merlin !
I didn't know you could use variable inside custom aggregates, and this
allow to solve the problem!
In my own problem I couldn't use aggregates because
_as it output at most one row,
On Tue, Oct 22, 2013 at 10:01 AM, Elliot yields.falseh...@gmail.com wrote:
On 2013-10-21 20:38, Robert James wrote:
I have a table of event_id, event_time. Many times, several events
happen in a row. I'd like a query which replaces all of those events
with a single record, showing the
On Tue, Oct 22, 2013 at 9:43 AM, Rémi Cura remi.c...@gmail.com wrote:
Thanks again for the precision !
I still don't understand perfectly. We call the aggregate n times, and each
time we compute the aggregate, using (potentially) n rows, thus becoming (at
most) O(n*n).
With a standard loop,
2013/10/22 Merlin Moncure mmonc...@gmail.com
With a standard loop, I loop n times, and each times I only need the
current
row plus the previous row which I put in memory, thus O(n).
For posterity, the above is incorrect. Since the aggregate is ordered
through the window function
On Mon, Oct 21, 2013 at 5:27 AM, KONDO Mitsumasa
kondo.mitsum...@lab.ntt.co.jp wrote:
(2013/10/02 18:57), Michael Paquier wrote:
kondo.mitsum...@lab.ntt.co.jp wrote:
Who is pgFoundery administrator or board member now? I would like to send
e-mail
them. At least, it does not have information
On Fri, Oct 18, 2013 at 8:37 PM, David Johnston pol...@yahoo.com wrote:
Merlin Moncure-2 wrote
Regardless, the point at hand is whether specific plan semantics down
the chain can control whether or not volatile expressions should run.
Clearly, at least to me, they should not.
Put differently
On Mon, Oct 21, 2013 at 2:51 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Moshe Jacobson mo...@neadwerx.com writes:
On Mon, Oct 21, 2013 at 2:53 PM, Tom Lane t...@sss.pgh.pa.us wrote:
How many times should the volatile function get executed? If your answer
is not 10, how is this different from the
On Fri, Oct 18, 2013 at 10:05 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Rob Richardson rdrichard...@rad-con.com writes:
In my opinion, that is ugly to the point of uselessness.
Indeed :-(
For some reason, there's no constructor function to make a box from four
floats. But there is a box
On Wed, Oct 16, 2013 at 7:14 PM, Rowan Collins rowan.coll...@gmail.com wrote:
On 17/10/2013 00:06, Merlin Moncure wrote:
That being said, I do think it might be better behavior (and still
technically correct per the documentation) if volatile query
expressions were force-evaluated
On Fri, Oct 18, 2013 at 4:08 PM, David Johnston pol...@yahoo.com wrote:
And why is volatile so special here? A stable function seems just as good a
candidate for this behavior and even an immutable one.
Absolutely disagree with this. Stable operations do not have side
effects and volatile
On Mon, Oct 14, 2013 at 5:31 AM, Florian Nigsch f...@nigsch.eu wrote:
Hi all,
I am not sure if this is a bug or a misuse on my part.
I am creating a number of indices in parallel on a table by using xargs. To
do that, I write all my indices in a file indices.idx, and then have the
indices
On Thu, Oct 17, 2013 at 4:04 PM, Rob Richardson
rdrichard...@rad-con.com wrote:
I need to determine whether a given pair of coordinates is inside a given
rectangle. According to the documentation, PostgreSQL provides the box and
point types and a contains operator that will be perfect for
On Wed, Oct 16, 2013 at 10:30 AM, CS DBA cs_...@consistentstate.com wrote:
All;
One of our clients is talking about moving to Mongo for their reporting/data
mart. I suspect the real issue is the architecture of their data mart
schema, however I don't want to start pushing back if I can't
On Wed, Oct 16, 2013 at 4:26 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Moshe Jacobson mo...@neadwerx.com writes:
However, It behaves as one would expect if the first CTE is built with INSERT
... RETURNING.
CTEs containing INSERT/UPDATE/DELETE are guaranteed to be executed exactly
once. CTEs
On Sat, Oct 12, 2013 at 4:28 PM, Torsten Förtsch
torsten.foert...@gmx.net wrote:
On 12/10/13 20:08, Scott Ribe wrote:
select * from test where tz = start and tz end and colb like '%foobar%'
I think you can use an index only for wildcard expressions that are
anchored at the beginning. So,
On Fri, Oct 11, 2013 at 7:47 AM, Wolfgang Keller felip...@gmx.net wrote:
Forms these days are written in HTML.
Only by clueless/careless morons.
HTML has never been, is not and will never be a usable GUI framework.
And web apps are unusable garbage.
Look -- I appreciate people with strong
On Thu, Oct 10, 2013 at 1:00 AM, Kaare Rasmussen ka...@jasonic.dk wrote:
Sorry, got tangled up in this thing called 'real life'.
If I understand you correctly, you want a prefix match, and sure there's
a PostgreSQL extension for that:
OK, that seems to do the job, thanks a lot. The only
On Wed, Oct 9, 2013 at 9:24 PM, Adrian Klaver adrian.kla...@gmail.com wrote:
On 10/09/2013 07:05 PM, Sudhir P.B. wrote:
I have developed an application using MS SQL. I have used MS Access for
creating forms to enter data into the database. I am thinking of
changing over to postgresql and
On Thu, Oct 10, 2013 at 10:03 AM, Rob Richardson
rdrichard...@rad-con.com wrote:
I've been curious about this for a long time. The syntax for an INSERT query
is often much easier to use, in my opinion, then the syntax for an UPDATE
query. For example, and this is what I am trying to do,
On Thu, Oct 10, 2013 at 12:16 PM, Adam Mackler postg...@mackler.org wrote:
Hi:
I recently posted a question on stackoverflow, but I suspect it may
require specific PostgreSQL knowledge, so I'm cross-posting a
reference to it here.
On Mon, Oct 7, 2013 at 10:35 PM, Kevin Grittner kgri...@ymail.com wrote:
Aftab Ahmed Chandio afta...@siat.ac.cn wrote:
My query processes from JDBC (Java Program) to PostgreSQL. I use
system time by invoking java function, I collect one time unit
before the query statement perform and second
On Wed, Oct 2, 2013 at 3:37 AM, KONDO Mitsumasa
kondo.mitsum...@lab.ntt.co.jp wrote:
Hi,
I want to submit new project in pgFoundery project.
I submitted new project which is WAL archive copy tool with directIO method in
pgFoundery homepage 2 weeks ago, but it does not have approved and
On Mon, Sep 30, 2013 at 10:03 AM, Carlos Eduardo Sotelo Pinto
carlos.sotelo.pi...@gmail.com wrote:
I need a help on postgresql performance
I have configurate my postgresql files for tunning my server, however it is
slow and cpu resources are highter than 120%
I have no idea on how to solve
On Wed, Oct 2, 2013 at 11:08 AM, Víctor Cosqui victor.cos...@gmail.com wrote:
Hi all
I am developing an application which uses postgres 9.2 to store binaries as
oid objects.
CREATE TABLE content (contentname text, contentoid oid);
I am making some tests to evaluate how much HD space I
On Mon, Sep 30, 2013 at 10:49 AM, Moshe Jacobson mo...@neadwerx.com wrote:
On Sun, Sep 29, 2013 at 2:18 AM, Ken Tanzer ken.tan...@gmail.com wrote:
After restarting the server in another window, I was surprised that my
command did not run in a transaction:
spc_test_scratch=# BEGIN; DROP VIEW
On Wed, Sep 25, 2013 at 4:47 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Lonni J Friedman netll...@gmail.com writes:
If I INSERT a new row into the local table (not the foreign table
version), without specifying the 'id' column explicitly, it
automatically is assigned the nextval in the sequence
On Tue, Sep 24, 2013 at 10:19 PM, François Beausoleil
franc...@teksol.info wrote:
Hi all!
I import many, many rows of data into a table, from three or more computers,
4 times per hour. I have a primary key, and the query I use to import the
data is supposed to dedup before inserting, but I
On Wed, Sep 25, 2013 at 12:50 PM, Steven Schlansker ste...@likeness.com wrote:
On Sep 25, 2013, at 6:04 AM, Merlin Moncure mmonc...@gmail.com wrote:
On Tue, Sep 24, 2013 at 10:19 PM, François Beausoleil
franc...@teksol.info wrote:
Hi all!
I import many, many rows of data into a table, from
On Mon, Sep 23, 2013 at 8:25 AM, Raphael Bauduin rbli...@gmail.com wrote:
On Mon, Sep 23, 2013 at 11:31 AM, Raphael Bauduin rbli...@gmail.com wrote:
Hi,
I'm experimenting with the json data type and functions in 9.3.
I'm storing json objects of this form in the event column:
{type:
On Mon, Sep 23, 2013 at 8:33 AM, Merlin Moncure mmonc...@gmail.com wrote:
On Mon, Sep 23, 2013 at 8:25 AM, Raphael Bauduin rbli...@gmail.com wrote:
On Mon, Sep 23, 2013 at 11:31 AM, Raphael Bauduin rbli...@gmail.com wrote:
Hi,
I'm experimenting with the json data type and functions in 9.3
On Fri, Sep 20, 2013 at 6:29 AM, Kaare Rasmussen ka...@jasonic.dk wrote:
Hi
I'm trying to determine the best way to represent a simple tree structure
(like a file/dir tree or a uri path). I guess that's done a zillion times
before; I just don't seem to be able to find the right solution. I
On Fri, Sep 20, 2013 at 10:26 AM, Marc Mamin m.ma...@intershop.de wrote:
Hi,
here is a function which is about 8 x faster than the one described in the
PostgreSQL SQL Tricks
(
http://postgres.cz/wiki/PostgreSQL_SQL_Tricks#Function_for_decoding_of_url_code
)
The idea is to handle each
On Tue, Sep 17, 2013 at 2:06 AM, Rémi Cura remi.c...@gmail.com wrote:
The only kind of function taking set of record as input I know of is
aggregate function, but it returns only one row and the output of union can
take multiple row.
This may or may not help (I suggest posting a more complete
On Fri, Sep 13, 2013 at 7:52 PM, Chris Travers chris.trav...@gmail.com wrote:
On Fri, Sep 13, 2013 at 8:51 AM, Merlin Moncure mmonc...@gmail.com wrote:
What's your client side stack?
merlin
Right now we are using something a little lighter weight in terms db
discovery but it doesn't handle
On Thu, Sep 12, 2013 at 7:25 PM, Chris Travers chris.trav...@gmail.com wrote:
On Thu, Sep 12, 2013 at 8:47 AM, Merlin Moncure mmonc...@gmail.com wrote:
Can we see a hypothetical example? json best practices for me are to
use standard tables and than serialize/deserialize json as it goes
On Fri, Sep 13, 2013 at 9:30 AM, Chris Travers chris.trav...@gmail.com wrote:
On Fri, Sep 13, 2013 at 6:37 AM, Merlin Moncure mmonc...@gmail.com wrote:
It would certainly be better if we could straight up deserialize json
into a nested structure. For now, my advise is to try
On Fri, Sep 13, 2013 at 8:18 AM, e-letter inp...@gmail.com wrote:
test=*# select extract (year from signup_date)::text || '/' ||
extract(month from signup_date)::text, count(email_address),
sum(count(email_address)) over (ROWS UNBOUNDED PRECEDING) from test
group by 1 order by 1;
Have
On Fri, Sep 13, 2013 at 10:08 AM, Chris Travers chris.trav...@gmail.com wrote:
On Fri, Sep 13, 2013 at 7:58 AM, Merlin Moncure mmonc...@gmail.com wrote:
Yup. As things stand currently, it's better *not* to make
serialization-driving composite types which when learning the json
stuff I did
On Fri, Sep 13, 2013 at 11:17 AM, Patrick Dung patrick_...@yahoo.com.hk wrote:
From: Tom Lane t...@sss.pgh.pa.us
To: Stephen Frost sfr...@snowman.net
Cc: Ivan Voras ivo...@freebsd.org; pgsql-general@postgresql.org
Sent: Friday, September 13, 2013 9:58 PM
On Wed, Sep 11, 2013 at 11:55 PM, Chris Travers chris.trav...@gmail.com wrote:
Hi everyone;
I have been starting to experiment with the JSON accessors in 9.3. I
immediately found that my preferred use, populating nested composite types,
is not supported. Also of course one cannot manipulate
On Thu, Sep 12, 2013 at 11:21 AM, Raymond O'Donnell r...@iol.ie wrote:
On 12/09/2013 17:11, Patrick Dung wrote:
By the way, for in-place major version upgrade (not dumping DB and
import again), MySQL is doing a better job in here.
http://www.postgresql.org/docs/9.3/static/pgupgrade.html
On Tue, Sep 10, 2013 at 5:51 AM, Oliver Kohll - Mailing Lists
oliver.li...@gtwm.co.uk wrote:
On 9 Sep 2013, at 21:03, Alvaro Herrera alvhe...@2ndquadrant.com wrote:
select string_agg(case when words like '*%*' then upper(btrim(words, '*'))
else words end, ' ')
from regexp_split_to_table('The
On Mon, Sep 9, 2013 at 5:15 PM, Florent THOMAS mailingl...@tdeo.fr wrote:
Hy folks,
I'm trying to migrate a database running on mysql for the famous
www.redmine.org from mysql to postgresql.
I was looking for ressources and I found this :
On Fri, Sep 6, 2013 at 8:19 AM, Tim Kane tim.k...@gmail.com wrote:
Ahh. All these years (albeit sporadic), I never knew about FETCH_COUNT.
That makes sense. Thanks muchly.
Not your fault: FETCH_COUNT is a hack IMO. The real issue was that
libpq (until recently) forced the entire result into
On Tue, Sep 3, 2013 at 5:08 PM, Andreas 'ads' Scherbaum
adsm...@wars-nicht.de wrote:
PostgreSQL folks!
We are looking for the next big thing. Actually, it's a bit smaller: a new
design for mugs. So far we had big blue elephants, small blue elephants,
frosty elephants, white SQL code on black
On Thu, Sep 5, 2013 at 10:39 AM, Kevin Grittner kgri...@ymail.com wrote:
M Tarkeshwar Rao m.tarkeshwar@ericsson.com wrote:
I want start contributing in Postgres in code level.
Welcome! You should probably start with this page and its links:
http://wiki.postgresql.org/wiki/Developer_FAQ
On Sat, Aug 24, 2013 at 7:15 PM, Korisk kor...@yandex.ru wrote:
Hi!
I want quick insert into db a lot of data (in form of triplets). Data is
formed dynamical so COPY is not suitable.
I tried batch insert like this:
insert into triplets values (1,1,1);
insert into triplets values (1,1,1),
On Fri, Aug 2, 2013 at 10:25 AM, Kevin Grittner kgri...@ymail.com wrote:
Janek Sendrowski jane...@web.de wrote:
I also tried pg_trgm module, which works with tri-grams, but it's
also very slow with 100.000+ rows.
Hmm. I found the pg_trgm module very fast for name searches with
millions of
All your view and function creation statements should be in scripts that
you maintain as a kind of best practice. If you've done that, then you can
simply drop/cascade the view you're replacing after you renamed it and then
rebuild the rest of them.
I actually go one step further and put the
On Mon, Aug 12, 2013 at 4:21 PM, Bruce Momjian br...@momjian.us wrote:
On Mon, Aug 12, 2013 at 02:15:25PM -0700, Joe Van Dyk wrote:
Mostly just curious, as this is preventing me from using tab-separated
output.
I'd like there to be a header in my files. I have to use CSVs instead.
[ this
On Mon, Aug 5, 2013 at 5:15 PM, Jack Christensen
j...@jackchristensen.com wrote:
When using a subquery as a source for row_to_json, depending on the order of
arguments it may ignore renaming a column.
jack=# create table player(
jack(# player_id serial primary key,
jack(# name varchar
On Fri, Aug 2, 2013 at 1:49 AM, Chris Travers chris.trav...@gmail.com wrote:
Here's my $0.02
Stored procedures have a bunch of problems historically. Part of this is
because the interface traditionally is pretty spartan, and partly because
some people take them too far.
The first issue is
On Tue, Jul 30, 2013 at 4:57 PM, David Johnston pol...@yahoo.com wrote:
I'm in the prefix the id column camp. I do not use ORM middle-ware so
that may be a reason I do not have any difficulties but one of the big
advantages to table-prefixing generic column names is that you can then make
the
On Fri, Jul 26, 2013 at 9:35 AM, akp geek akpg...@gmail.com wrote:
Hi All -
We have been running postgres 9.0.2 since October. Streaming also in
place. Working flawless. yesterday suddenly the replication stopped.
Did you write that correctly? If so, Postgres 9.0 is on patch
release
On Wed, Jul 24, 2013 at 7:52 AM, Aaron Abreu abre...@bay.k12.fl.us wrote:
a NON-technical version...
st.procedures and automation are great...
but...
sounds like everybody is dancing around the main theme..
so lets say it
that dreaded word that developers and DBA's cring to hear...
On Wed, Jul 24, 2013 at 8:31 AM, Some Developer
someukdevelo...@gmail.com wrote:
On 24/07/13 14:21, Gauthier, Dave wrote:
I find stored procedures to be a God-send. The alternative, external
code, is the risky, difficult and often poorer performing approach to the
problems sp's solve. What
On Wed, Jul 24, 2013 at 1:50 PM, pg noob pgn...@gmail.com wrote:
Hi all,
In PostgreSQL 8.4...
I am wondering if autovacuum will periodically rebuild indexes?
it will not. REINDEX requires a heavy lock and for most applications
it would be just plain untenable to be run without some type of
On Wed, Jul 17, 2013 at 3:39 PM, John Smith jayzee.sm...@gmail.com wrote:
guys,
have to use legacy 8.1.
i have 100,000 tables in a schema that need to be queried (optimizing this
by combining them into one will have to wait).
so my query goes like so:
execute 'select * from ' ||
On Thu, Jul 18, 2013 at 9:20 AM, Paul Maddock
paul.madd...@spidasoftware.com wrote:
I am having trouble with postgresql connection.
I am using squirrel sql client to write sql code for data qc'ing. On many
occasions this has happened. It closes my connection on my client and stops
my sql
On Fri, Jul 12, 2013 at 9:24 AM, Kevin Grittner kgri...@ymail.com wrote:
Vincenzo Romano vincenzo.rom...@notorand.it wrote:
I'd like to replace a full table F with an empty one E.
In order to do this I see only one way:
ALTER TABLE F RENAME TO T;
ALTER TABLE E RENAME TO F;
ALTER TABLE T
On Tue, Jul 9, 2013 at 8:55 AM, Peter Kroon plakr...@gmail.com wrote:
Hi,
I want to talk to multiple db's in one session. Is dblink the best solution
or is there another way without installing dblink?
why not use dblink? fdw is getting there but I still find dblink to
be the way to go as
On Mon, Jul 8, 2013 at 4:56 AM, Jov am...@amutu.com wrote:
my first post already try the pg_terminate_backend but failed:
pg_terminate_backend return t but the backend still there.
possibly a kernel problem?
merlin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
On Wed, Jun 26, 2013 at 8:34 PM, Mason Leung h2op...@gmail.com wrote:
Hi,
I am running postgres 9.2.4 and 1 of my columns (column name is old_field)
is type json. When I select from this table, I get the following sample
data
select old_field from table1;
[],
['a', 'b']
['a']
[]
How
On Thu, Jun 20, 2013 at 5:17 AM, Richard Huxton d...@archonet.com wrote:
On 18/06/13 18:31, bhanu udaya wrote:
Hello,
Greetings.
My PostgresSQL (9.2) is crashing after certain load tests. Currently,
postgressql is crashing when simulatenously 800 to 1000 threads are run
on a 10 million
On Wed, Jun 19, 2013 at 12:00 AM, Jayadevan M
jayadevan.maym...@ibsplc.com wrote:
Hi,
I have PostgreSQL 9.2.1. I can see a few json functions under pg_catalog,
json_send, for example. But I can’t find any documentation. Am I missing
something?
json_send like all send functions is internal.
On Wed, Jun 19, 2013 at 3:56 AM, sachin kotwal kotsac...@gmail.com wrote:
While migrating my application from DB2 to PostgreSQL.
I want to migrate ROLLUP() function in PostgreSQL.
Example:
SELECT WEEK(SALES_DATE) AS WEEK,
DAYOFWEEK(SALES_DATE) AS DAY_WEEK,
SUM(SALES) AS
On Tue, Jun 18, 2013 at 12:42 PM, Jeff Herrin j...@openhotel.com wrote:
I'm trying to get a compass bearing (N,S,NW,etc) using earthdistance. I can
successfully get the distance between 2 points using either the point or
cube method, but I've been struggling with getting the bearing. Any tips?
On Wed, Jun 12, 2013 at 9:02 AM, Andrew Tipton and...@kiwidrew.com wrote:
Hi all,
I recently wanted to declare a CHECK constraint to ensure that a JSON value
was an object with keys that were scalars (not nested objects or arrays).
This proved to be more difficult than I had expected. In the
On Sun, Jun 9, 2013 at 10:59 AM, Gustavo Amarilla Santacruz
gusama...@gmail.com wrote:
Hello, all.
In the PostgreSQL documentation I found currval: Return the value most
recently obtained by nextval for this sequence in the current session
In other documentations (pgpool, for example),
On Fri, Jun 7, 2013 at 3:22 AM, Albe Laurenz laurenz.a...@wien.gv.at wrote:
Colin Sloss wrote:
I have been testing the differences between asynchronous and synchronous hot
standby streaming
replication on PostgreSQL 9.2.4. There is some push towards synchronous
replication, but I am finding
On Fri, May 24, 2013 at 10:15 AM, Scott Marlowe scott.marl...@gmail.com wrote:
On Fri, May 24, 2013 at 9:10 AM, Bèrto ëd Sèra berto.d.s...@gmail.com wrote:
The Greater London Authority is also ditching Oracle in favour of PG. I
consulted them while they kick started their transition and the
On Sun, May 19, 2013 at 8:07 PM, Toby Corkindale
toby.corkind...@strategicdata.com.au wrote:
On 11/05/13 02:25, Merlin Moncure wrote:
On Fri, May 10, 2013 at 11:11 AM, Evan D. Hoffman
evandhoff...@gmail.com wrote:
Not sure of your space requirements, but I'd think a RAID 10 of 8x or
more
On Wed, May 15, 2013 at 5:44 AM, Ingmar Brouns swi...@gmail.com wrote:
When I send the mail, I saw it, the problem is that the function
should return setof void instead of void, then it works, sorry for
bothering.
for non-trivial sql language processing functions I tend to return an
error code
On Wed, May 15, 2013 at 11:31 AM, Jorge Arévalo
jorgearev...@libregis.org wrote:
Hello,
I'd like to know what's the best way to reduce the number of server rounds in
a libpq C app that fetches BLOBs from a remote PostgreSQL server.
About 75% of the time my app uses is spent querying
On Tue, May 14, 2013 at 9:48 AM, kristian kvilekval k...@cs.ucsb.edu wrote:
I was really hoping to see be able to store several ten's of millions XML
documents in postgres, but I would also like to use Xquery to retrieve
results. Back in 2010 there was some mailing list discussion about using
On Tue, May 14, 2013 at 4:32 PM, John R Pierce pie...@hogranch.com wrote:
On 5/13/2013 11:27 PM, Jashaswee wrote:
i want to convert numbers into words in postgresql.is there any query for
it?
if yes please reply soon
you mean, like 123 - one hundred twenty three ?that would be better
On Tue, May 14, 2013 at 5:24 PM, Adrian Klaver adrian.kla...@gmail.com wrote:
On 05/14/2013 03:17 PM, John R Pierce wrote:
On 5/14/2013 2:57 PM, Alvaro Herrera wrote:
Jashaswee escribió:
i want to convert numbers into words in postgresql.is there any
query for it?
if yes please reply soon
On Sun, May 12, 2013 at 8:20 PM, John R Pierce pie...@hogranch.com wrote:
On 5/12/2013 6:13 PM, David Boreham wrote:
Not quite. More like : a) I don't know where to buy SLC drives in 2013
(all the drives for example for sale on newegg.com are MLC) and b) today's
MLC drives are quite good
On Fri, May 10, 2013 at 4:41 AM, Mark Morgan Lloyd
markmll.pgsql-gene...@telemetry.co.uk wrote:
I don't know whether anybody active on the list has R (and in particular
PL/R) experience, but just in case... :-)
i) Something like APL can operate on an array with minimal regard for
index
On Fri, May 10, 2013 at 8:43 AM, Carlos Henrique Reimer
carlos.rei...@opendb.com.br wrote:
Hi,
We are developing a solution which will run in thousands of small cash till
machines running Linux and we would like to use PostgreSQL but there is a
insecurity feeling regarding the solution
301 - 400 of 2101 matches
Mail list logo