Sorry, as a final follow up here, another option (should anyone run into
this and want to keep the intarray extension) is to create the index using
the gin__int_ops operator:
CREATE INDEX ON sets USING GIN(obj_id gin__int_ops);
On Sun, Aug 20, 2017 at 4:22 PM, Wells Oliver
wrote:
>
ff Janes wrote:
> On Sun, Aug 20, 2017 at 1:28 PM, Wells Oliver
> wrote:
>
>>
>> Why is this happening and what can I do to get my GIN indexes working?
>> Thanks!
>>
>>
> What extensions do you have installed in each database? I bet one of them
> (like inta
: (obj_id @> '{2,3}'::integer[])
Rows Removed by Filter: 100999697
Planning time: 0.206 ms
Execution time: 30015.883 ms
Why is this happening and what can I do to get my GIN indexes working?
Thanks!
--
Wells Oliver
wells.oli...@gmail.com
> On 13 Apr 2016, at 16:48, David G. Johnston
> wrote:
>
> On Wed, Apr 13, 2016 at 8:38 AM, Oliver Kohll <mailto:oli...@agilechilli.com>> wrote:
> Hello,
>
> We currently use prepared statements for most of the work an app does, as an
> SQL injection
PREPARE test(text) as SET LOCAL myprefix.mysetting = $1;
but this isn't supported (currently on PG 9.3)
I suspect the answer is 'no' but no harm in asking if it's likely to be
considered in future. I can't see it here:
https://wiki.postgresql.org/wiki/Todo <https://wiki.postgresql.org/wiki/Todo>
Oliver
We are running a 64-bit PostgreSQL 9.4.5 server on Windows Server
2012. The system is a virtual machine on a VMware ESX 6.0 server and
has 24 GB of memory. The database server is only accessed locally by
two services and there is only a single database in the server. The
disk is located on a st
(Replying to the digest post)
Having watched this discussion from the start, I think the project
would be better off without any CoC. The list has always been
conducted well and if something isn't broken you shouldn't try to fix
it.
--
Oliver Elphick
Lincolnshire, England
--
Sent
{2, 3}
{2, 4}
{2, 5}
{3, 4}
{3, 5}
{4, 5}
Any tips? Thanks!
--
Wells Oliver
wells.oli...@gmail.com
; (stupid smartphone-app, sorry for top-posting)
>
> Am 27. Dezember 2015 22:39:58 MEZ, schrieb Wells Oliver <
> wells.oli...@gmail.com>:
> >
> >Is there some easier way for me to maintain the structure of the view
> >without copying/pasting it 4 times and making one sma
without copying/pasting it 4 times and making one small tweak? I find
myself adding/removing columns to these views and I do it 4 times each time.
Thanks!
--
Wells Oliver
wells.oli...@gmail.com
On Sun, 2015-11-08 at 17:50 -0500, Tom Lane wrote:
> Oliver Elphick writes:
> > I tried to do this:
> > SELECT p.company, p.start, p.yearend, p.idnum,
> >s.pdno, s.pdend,
> >CASE WHEN nth_value(s.pdend,(row_number() OVER w)::INTE
I tried to do this:
SELECT p.company, p.start, p.yearend, p.idnum,
s.pdno, s.pdend,
CASE WHEN nth_value(s.pdend,(row_number() OVER w)::INTEGER -1) OVER
w IS NULL
THEN p.start
ELSE nth_value(s.pdend,(row_number() OVER w)::INTEGER -1) + '1
achines?
You can reconfigure the timezone for the machine:
sudo dpkg-reconfigure tzdata
Oliver
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Sun, 2015-05-24 at 18:25 +0630, Arup Rakshit wrote:
> >
> > Assuming you are using Unix, or can install Unix tools, run the input
> > files through
> >
> > sort -u
> >
> > before passing them to COPY.
> >
> > Oliver Elphick
> >
is the best solution here. Can anybody suggest which approach
> should I adopt ? Or if any better ideas you guys have on this task,
> please share.
Assuming you are using Unix, or can install Unix tools, run the input
files through
sort -u
before passing them to COPY.
Oliver Elphick
On Mon, 2015-05-11 at 06:46 -0400, Steve Clark wrote:
> Hi List,
> I am having trouble trying to figure out
> how to get the result listed at the bottom.
>
> I have 3 tables units, types of units which has a description of the units,
> and a table that list associations of the units. I can't figur
On Sun, 2015-04-26 at 12:39 +0200, Bjørn T Johansen wrote:
>
> CREATE COLLATION nb_NO (LOCALE = nb_NO.utf8)
>
> But then I get this:
>
> ERROR: could not create locale "nb_no.utf8": No such file or
> directory
> DETAIL: The operating system could not find any locale data for the
> locale name
t; (tried without the varchar also..)
ALTER [ COLUMN ] column_name [ SET DATA ] TYPE data_type [ COLLATE
collation ] [ USING expression ]
You need to add the TYPE key word, I think.
Oliver Elphick
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subsc
Hello,
Is there a way to create a dump file of a Postgres DB to Oracle DB?
I've found some ways using general snippets but I would like to know what is
the best way to do it.
Thanks
Regards,
__
Oliver G. Dizon
Z Getcare Systems Team
RTZ Associates, Inc.
jo
lt;
joca...@kaleidoscopemediasystems.com>:
> Hello Adrian,
>
> Not sure if this is what your looking for insofar as a solution but have
> you taken a look at this page from the documentation.
>
> http://www.postgresql.org/docs/9.3/static/multibyte.html
>
>
>
> On Mo
2015-02-09 14:01 GMT+00:00 Vincent Veyron :
> On Mon, 9 Feb 2015 08:11:25 +
> Oliver wrote:
>
> > 2015-02-09 7:52 GMT+00:00 Oliver :
> >
> > > regional configuration name not valid <>
> > > SQL state: 42809
> > >
> > > I'v
2015-02-09 7:54 GMT+00:00 Oliver :
> 2015-02-08 20:50 GMT+00:00 BladeOfLight16 :
>
>> On Sun, Feb 8, 2015 at 2:20 PM, Oliver wrote:
>>
>>> If I want change postgresql encoding, I have understood that I should
>>> reinstall postgresql (I do installation from r
2015-02-09 7:52 GMT+00:00 Oliver :
> 2015-02-08 20:44 GMT+00:00 Adrian Klaver :
>
>> On 02/08/2015 11:20 AM, Oliver wrote:
>>
>>> Hi,
>>> I have a new postgresql installation done, it has utf-8 encoding.
>>> I have to make a Oracle database migration
2015-02-08 20:50 GMT+00:00 BladeOfLight16 :
> On Sun, Feb 8, 2015 at 2:20 PM, Oliver wrote:
>
>> If I want change postgresql encoding, I have understood that I should
>> reinstall postgresql (I do installation from rpm official binary files for
>> red hat)
>>
&g
2015-02-08 20:44 GMT+00:00 Adrian Klaver :
> On 02/08/2015 11:20 AM, Oliver wrote:
>
>> Hi,
>> I have a new postgresql installation done, it has utf-8 encoding.
>> I have to make a Oracle database migration and it has ISO8859-15
>> encoding, should I change post
Hi,
I have a new postgresql installation done, it has utf-8 encoding.
I have to make a Oracle database migration and it has ISO8859-15 encoding,
should I change postgresql encoding to same Oracle encoding or with utf-8
it should go well?
If I want change postgresql encoding, I have understood that
With the hstore you can do hstore ? 'key' to check if the object contains
the key-- is there a similar function for json objects?
(still on 9.3 so no jsonb)
--
Wells Oliver
wellsoli...@gmail.com
Oliver Dizon schrieb am 27.01.2015 um 11:46:
> I hope I'm in the right place to throw this. I just want to ask the reason
> behind this weird scenario.
>
> All records were deleted in a table even if the subquery in the where clause
> has a missing a column.
>
> --f
Oliver Dizon writes:
> Hi Guys,
> I hope I'm in the right place to throw this. I just want to ask the reason
> behind this weird scenario.
> All records were deleted in a table even if the subquery in the where clause
> has a missing a column.
> --from a certain scrip
ad.
Version: psql (8.4.9, server 9.2.5)
Thanks and Regards,
__
Oliver G. Dizon
Z Getcare Systems Team
RTZ Associates, Inc.
johnoli...@rtzassociates.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.post
I can't use jsonb, but if there's any input here
I'd appreciate it.
Thanks.
--
Wells Oliver
wellsoli...@gmail.com
>>
>>> select * from dblink(‘dbname=database2 username=db_link
>>> password=mypassword','select username, email from appuser') as t1(username
>>> text, email text);:
>
> I think the problem is the above- ^^^
>
> username=db_link should be user=db_link
>
> The accepted key
nk so there’s probably something simple I’m
missing, but I thought I had provided a password. Any ideas?
Regards
Oliver Kohll
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
r an updater to do for any reason. Why
> would it do that?
>
> --
> Craig Ringer http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Wells Oliver
wellsoli...@gmail.com
'published' or 'finalized'.
What I don't get is an 'all' rollup. Which I could do with another flat
table and a cross join on a table of report statuses, but I'd love to keep
this is as a view if possible.
Using 9.3, so I have the "latest and greatest". Wh
Thank you very much for your replies.
Cheers...
2014-06-29 13:28 GMT+01:00 Michael Paquier :
>
>
>
> On Fri, Jun 27, 2014 at 9:55 PM, Oliver wrote:
>
>> Thank you very much for your reply.
>> I've spoken with my boss, databases aren't so important, so
beforehand.
Cheers...
2014-06-27 15:36 GMT+01:00 :
> Oliver,
>
> You want to retain all the segments archived between backups. That's the
> safest method that I know of. What do you mean by original WAL segments?
> Are you speaking about what PostgreSQL writes into pg_xlog? That&#
al_senders can be to 1 only
for base backups and continuous archiving doesn't need that parameter with
>0? I understand well?
Thanks beforehand.
Cheers...
2014-06-27 13:55 GMT+01:00 Oliver :
> Thank you very much for your reply.
> I've spoken with my boss, databases aren
oftware RAID.
> Again that is easy to set up and saves the db in case the harddrive dies.
> This even speeds up read access to the db a bit.
>
>
>
> Am 17.06.2014 11:51, schrieb Oliver:
>
> Hi,
>> I'm a newbie in postgresql. I've mounted my first postgr
how
shared_buffers" query shows 2GB in psql, and system has little memory used
due to inactivity of database and it will go reaching more when database
has connections.
Thanks for all.
Cheers...
2014-06-20 17:13 GMT+01:00 Jeff Janes :
> On Fri, Jun 20, 2014 at 4:51 AM, Oliver wrote:
>
fy the
> sender by telephone or return e-mail message and delete the original
> transmission, its attachments, and any copies without reading or saving in
> any manner. Thank you.
>
>
> On Fri, Jun 20, 2014 at 5:21 PM, Oliver wrote:
>
>> Hello,
>> I'm new
Hello,
I'm new in postgresql, I'm sorry if I do something bad.
Default value or shared_buffers is 128MB, I have a dedicated server for
postgresql with 8GB RAM. I've changed shared_buffers value to 2048MB and
uncommented the entry in postgresql.conf. It shows now:
# - Memory -
shared_buffers = 204
beforehand.
Cheers...
2014-06-17 14:52 GMT+01:00 François Beausoleil :
> Hi!
>
> Le 2014-06-17 à 08:31, Oliver a écrit :
>
> > Hi,
> > I'm a newbie in postgresql. I've mounted my first postgresql instance,
> it is empty now, only with default postgres DB.
Hi,
I'm a newbie in postgresql. I've mounted my first postgresql instance, it
is empty now, only with default postgres DB.
It is under Linux, with 2 filesystems, one for data and another for
archiving (I've enabled archiving as it will be for production).
Could someone recommend me a strategy for b
taking a few seconds to run even though there are only a
thousand rows in the table. I finally found that running CLUSTER on the table
sorted that out, even though we're on an SSD so I would have thought seeking
all over the place for a seq. scan wouldn't have made that much difference.
As a way of upgrading, I'd like to setup a 9.3 cluster as a slave to a 9.1
master so that I can then promote that 9.3 instance to master, using
streaming replication.
Curious if this is a possible/advisable route.
--
Wells Oliver
wellsoli...@gmail.com
This is the most helpful thing I've seen in months. Bravo.
On Thu, Jan 30, 2014 at 12:52 PM, bricklen wrote:
>
> On Thu, Jan 30, 2014 at 12:45 PM, Wells Oliver wrote:
>
>> Since Postgres does not consider a table as a dependency of a function if
>> that table is
asy way of essentially grep'ing all of the functions in a
given schema for a string?
Clearly if you had all of your functions in a nice VCS you could do this
but alas I don't yet live in that perfect world.
--
Wells Oliver
wellsoli...@gmail.com
ngredients like monosodium glutamate), but you
could probably do a more complex regex in regexp_split_to_table to cope with
that, or use pl/perl as previously suggested.
Thanks
Oliver
www.agilebase.co.uk
On 9 Sep 2013, at 14:41, David Johnston wrote:
> Oliver Kohll - Mailing Lists wrote
>> select regexp_replace(sentence,'\*(.*?)\*','' || upper('\1'),'g') from
>> sentences;
>
> Yeah, you cannot embed a function-call result in the &qu
| upper('\1'),'g') from
sentences;
I thought of using substring() to split the parts up after replacing the stars
with start and end markers, but that would fail if there was more than one word
starred.
Any other ideas?
Oliver
--
Sent via pgsql-general mailing lis
On 9 August 2013 02:49, Tom Lane wrote:
>
> I wonder whether we shouldn't change the syslogger to emit something to
> stderr when it takes over logging, saying "logging is now redirected to
> ".
>
>
Shouldn't you also, or instead, log to stderr just before leaving it, in
case the configuration of
it is getting as far as
reading the configuration files - that is not mentioned in the log.
There is no other instance of postgres running.
On 9 August 2013 00:59, Oliver Elphick wrote:
> To start with, it worked but the pg_hba.conf entry appeared to be wrong.
> I tried changing that and t
Linux Mint (from Ubuntu) version 9.1.
Postgres will no longer start, but I cannot find out why.
Command line:
$ /usr/lib/postgresql/9.1/bin/pg_ctl start -D /home/postgresql/9.1/main -l
/var/log/postgresql/postgresql-9.1-main.log -s -w -o '-c
config_file="/etc/postgresql/9.1/main/postgresql.conf"'
t_avg(bigint, bigint) does not exist
Integer is definitely the right type to use for the underlying table. Do I
really need to have an explicit cast to bigint in these views? Seems
tedious.
--
Wells Oliver
wellsoli...@gmail.com
#x27;::hstore - 'a=>1'::hstore), 1);
select array_length(akeys('a=>1'::hstore - 'a=>1'::hstore), 1);
select skeys('a=>1'::hstore - 'a=>1'::hstore) is null
select 'a=>1'::hstore - 'a=>1'::hstore is null
Etc.
--
Wells Oliver
wellsoli...@gmail.com
Ah, bananas. Someone had created a round(double, integer) function in
public that did some shenanigans. Now I've wasted everyone's time.
Though, I do find it odd that it could cause such a crash, bad function or
no.
On Fri, Feb 8, 2013 at 5:13 PM, Tom Lane wrote:
> Wells Oliver
1)'
works fine.
Version: PostgreSQL 9.1.7 on x86_64-unknown-linux-gnu, compiled by
gcc-4.4.real (Ubuntu 4.4.3-4ubuntu5.1) 4.4.3, 64-bit
Nothing shows up in the log.
Have I broken my cast function? My round function? Have I angered the RDMS
gods? Can anyone give me any pointers?
--
W
eferred, but it's nice to have both records.
Will anyone tell me there's some terrible side effect of this approach that
I am not realizing?
On Wed, Feb 6, 2013 at 11:10 AM, Greg Donald wrote:
> On Wed, Feb 6, 2013 at 12:41 PM, Wells Oliver
> wrote:
> > I have a wide
idea, probably a terrible idea, was to use hstore to create a
list of the old values and new values, and have this history table just be
the timestamp, action, and two hstore columns.
Surely this has been done thousands of times. What are the thoughts
regarding best practices in PG?
Thanks everyo
you describe.
> But since CREATE INDEX takes strong locks, it can
> easily get locked by other "harmless" things.
OK, I've reduced the calls to CREATE INDEX, waiting to test that. If there's
still an issue I will use CONCURRENTLY as you suggested.
Many thanks
Oliver
ing and try to replicate. Next time I will look at pg_locks too.
Also, the PG version is 9.1.6.
Oliver
unt(*) from pg_class;
count
---
5361
(1 row)
I wonder if I'm running up against some sort of limit. I am going to change the
code so it doesn't add an index (it's not always necessary) but would like to
get to the bottom of things first.
Regards
Oliver Kohll
www.gtwm.co
plpgsql IMMUTABLE COST 100;
The reason I'm doing this is because i repeat this formula in a bunch of
views and queries, and it's easier to have one function. Would this somehow
be slower than reproducing the formula in every view its used? I'm hoping
not...
--
Wells Oliver
wellsoli...@gmail.com
the second
line, I see a bunch of:
FATAL: no pg_hba.conf entry for replication connection from host 10,
user "replicationuser", SSL off
Why is this? What am I missing?
--
Wells Oliver
wellsoli...@gmail.com
do about this? Why isn't autovacuum cleaning these tables? Is
this number of dead tuples acceptable?
Lastly, would it make sense to do a weekly full manual vacuum + analyze?
Thanks.
--
Wells Oliver
wellsoli...@gmail.com
ut it seems drastic. This is not a high load
environment and given that the view combines all of the tables via primary
keys, I feel like this should be quicker. Is there some clue in the EXPLAIN
output I am missing?
The throttling of the disk causes other processes to queue up.
Thanks!
--
Wells Oliver
wellsoli...@gmail.com
Here's a bit of positive news spin - in a backhanded way perhaps, but still a
compliment:
http://www.theregister.co.uk/2012/08/31/postgresql_too_cool_for_school/
Oliver
www.agilebase.co.uk
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
e and/or disk size
implications. Would converting these columns to integer (or double
precision on the handful that require the precision) and forcing developers
to use explicit casting be worth the time?
Thanks for any clarification.
--
Wells Oliver
wellsoli...@gmail.com
--
Wells Oliver
wellsoli...@gmail.com
instance, given a
client has just proposed running on one. If there are none forthcoming in the
short term I may be in a position to provide some results myself in a month or
two.
Oliver Kohll
www.agilebase.co.uk
idual to put 98
indexes on a table. Wondering what you folks have come across in terms of
creative solutions that might be native to postgres. I can build something
that indexes the data and caches it and runs separately from PG, but I
wanted to exhaust all native options first.
Thanks!
--
Wells
dependee.oid
WHERE dependee.relname = 'myviewname'
AND dependent.relname != 'myviewname'
Haven't tested this much yet either. I'll compare yours to mine and check the
differences.
Regards
Oliver
www.agilebase.co.uk
s on but that's not what I'm
after.
Regards
Oliver Kohll
www.agilebase.co.uk
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
e
> latest Bucardo5 beta, as Bucardo4 will be deprecated soon:
>
> http://bucardo.org/downloads/Bucardo-4.99.3.tar.gz
Thanks, I'll do that.
Oliver
www.agilebase.co.uk
ables, fields, views etc.) as well as data
Create/update/delete frequencies are reasonably low, generally individuals
updating single records so of the order of thousands per day max.
Any experiences/thoughts?
Oliver Kohll
www.gtwm.co.uk
--
Sent via pgsql-general mailing list (pgsql-ge
r will know
> which Oid is LOB oid.
So you just end up with a conservative collector, not an exact
collector. In practice conservative collectors work OK. (You can use a
subtype to identify OIDs-that-refer-to-a-LO as suggested elsewhere in
the thread if you want an exact collector)
Oliver
--
On 10 January 2012 00:29, Oliver Jowett wrote:
> So I'm still confused about what you'd like to see changed in the JDBC
> driver. Can you explain?
Perhaps what you're looking for here is "it all just works out of the
box". In that case, the missing piece seems to
On 10 January 2012 00:06, Stefan Keller wrote:
> 2012/1/9 Oliver Jowett :
>> Otherwise, what should JDBC do differently here? Be specific. It would
>
> First, I pretty sure that Hibernate nor the Tomcat/Java GC are
> misconfigured - since it works now after having installed the
On 9 January 2012 14:29, Stefan Keller wrote:
> 2012/1/9 Oliver Jowett :
>> As a LO is independent storage that might have multiple references to> it
>> (the OID might be stored in many places), without explicit deletion> you
>> need a GC mechanism to collect
ere? (Perhaps we
could do something like interpret Blob.truncate(0) as "delete the blob
right now" - but is that what Hibernate actually does?)
(Much of this is the whole LO vs. bytea argument all over again. If
you want to store data with a lifetime that's the same as the row it&#x
created) query, so I think what I might do is
get the application to detect this case from the query plan where there is a
slow query and automatically test turning off nested joins. I'll just have to
keep an eye on it to see if it becomes unnecessary in future PG versions.
Regards
Oliver
JOIN dbvcalc_delivery_charges ON b2deliveryorders.idb2deliveryorders =
dbvcalc_delivery_charges.idb2deliveryorders
WHERE b2deliveryorders.complete = false AND b2deliveryorders.invoiced = false
ORDER BY b2deliveryorders.expectedby NULLS FIRST;
Oliver
Begin forwarded message:
> From: Oliver Kohll - Maili
joins to a second report dbvcalc_delivery_charges which
I can also send if necessary. I've only guesses as to the reasons the default
plan is slow or how to affect it, can someone enlighten me?
Regards
Oliver Kohll
www.agilebase.co.uk
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
Many thanks both, those solutions are great and have gone in my wiki for future
ref.
Regards
Oliver
On 21 Sep 2011, at 21:56, Szymon Guz wrote:
>
>
> >> Short answer is: yes. More information you can find
> >> here
> >> http://simononsoftware.com/problem-wi
27;, E'\\d', trunc(random() * 9 +
1)::text,'g');
regexp_replace
+1 111 111 111
(1 row)
As you can see, it returns the same digit each time. I've tried wrapping a
select around the trunc too.
Regards
Oliver Kohll
www.gtwm.co.uk / www.agilebase.co.uk
I'll definitely use them
for frequently written logs, if not I may still do so but will need some extra
backup steps.
Regards
Oliver
GTwM
oli...@gtwm.co.uk
(sent from iPad)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscrip
atible. Uncheck
Implict, same error. The 'Function' drop-down list is empty.
Can anyone help me clear this up? It's a very nagging issue to have my two
servers in a different state..
--
Wells Oliver
Architect, Baseball Systems
619-795-5359
San Diego Padres | 100 Park Boulevard | San
Sorry to pester the list with this, but I've unsubscribed @ the web interface
and I'm still getting email. Can an admin help me out here?
- Wells
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-g
ourse what you decide depends on what the business use case is and what
demands there are on the system. In my cases so far the slowest charts take 1
or 2 seconds to generate by SQL so if necessary, each could be loaded in in
real time over AJAX, though that hasn't been needed yet.
Regards
Oliver Kohll
Hello all- I am using psql from the command line in an Ubuntu
environment, and I'd like to setup (if possible) some sort of client
configuration for myself that sets some environment variables, mainly
client_min_messages. Is there a way to do this?
Thanks.
--
Wells Oliver
Developer, Bas
earth() looks
like it returns a datatype of type earth, so not sure if it will work. Maybe
things have changed in a recent release, please let me know if so.
So an example would be
select point(-2.2171,56.8952)<@>point(-1.2833,51.6667) as miles;
miles
--
3
wo lat/longs, the point<@>point syntax is simple to use:
http://www.postgresql.org/docs/8.3/static/earthdistance.html
Regards
Oliver Kohll
oli...@agilebase.co.uk / +44(0)7814 828608 / skype:okohll
www.agilebase.co.uk - software
on is will
the replication coming in v9.0 change things and would it be worth holding off
until then? In particular Command Prompt's PITR tools look useful for restoring
to a particular point in time, will these still work or will there be
equivalents?
Regards
Oliver Kohll
oli...@agilebas
oops=1)
-> Seq Scan on a2e9a7e9e257153de (cost=0.00..833.58
rows=24126 width=32) (actual time=0.032..26.683 rows=12605 loops=1)
Total runtime: 44.396 ms
Regards
Oliver Kohll
oli...@agilebase.co.uk / +44(0)7814 828608 / skype:okohll
www.agilebase.co.uk - software
www.gtwm.co.uk - company
signup_date)
>> )
>>
>> (adjust for typos, I didn't test it)
>
> Yes that does work thanks, if you give the subquery a name. I'd still like to
> know if it's possible to do with a window function rather than a subquery.
>
> Oliver Kohll
>
>
Y extract(year from signup_date)
> )
>
> (adjust for typos, I didn't test it)
Yes that does work thanks, if you give the subquery a name. I'd still like to
know if it's possible to do with a window function rather than a subquery.
Oliver Kohll
mail_address),
sum(count(email_address)) over (partition by 1 order by 1 asc rows unbounded
preceding)
from email_list group by 1 order by 1;
Does anyone have any other ideas?
Regards
Oliver Kohll
oli...@agilebase.co.uk / +44(0)7814 828608 / skype:okohll
www.agilebase.co.uk - software
www.
er/src/com/gtwm/pb/model/manageSchema/DatabaseDefn.java
- private void updateViewDbAction
is the top level function.
Regards
Oliver Kohll
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
rrors - some view updates can work just fine
anyway.
I can point you to the relevant code in GitHub if you're interested (it's Java).
Regards
Oliver Kohll
oli...@agilebase.co.uk / +44(0)7814 828608 / skype:okohll
www.agilebase.co.uk - software
www.gtwm.co.uk - company
On 24 Apr 2010,
1 - 100 of 366 matches
Mail list logo
