Does anyone know if this is configurable?
Or should I file a feature request?
Rob
On Wed, Sep 1, 2010 at 10:05 AM, Rob Gansevles wrote:
> Hi,
>
> From the docs I see that you can control null values being sorted
> before or after all non-null-values using 'NULLS LAST' or 'NULLS
> FIRST' in the
Le 07/09/2010 09:57, Rob Gansevles a écrit :
> Does anyone know if this is configurable?
>
You can only add that clause in the order by. There's no way to have a
"default value" at connection time or as a server configuration parameter.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
Rob Gansevles writes:
> Does anyone know if this is configurable?
> Or should I file a feature request?
It is not, and a feature request is probably going to go nowhere.
The reason configurability seems like a bad idea is that null sort
direction is wired into things like index contents. If a us
On Fri, Sep 03, 2010 at 09:20:39AM +0200, Yeb Havinga wrote:
>
> If the index is useless anyway, you might consider dropping it.
> Otherwise, increasing random_page_cost might help in choosing the
> otherplan, but on the other hand that plan has index scanning too,
> so I'm not to sure t
Kurt writes:
>> i'm trying to replicate tables containing XML-fields using Pg 8.4.4 and
>> 9.0B4 with Bucardo and got:
>> DBD::Pg::st execute failed: ERROR: could not identify an equality
>> operator for type xml
Tom Lane writes:
> You would need to create a default btree or hash opclass for xm
On 7/09/2010 10:32 PM, Tom Lane wrote:
Rob Gansevles writes:
Does anyone know if this is configurable?
Or should I file a feature request?
It is not, and a feature request is probably going to go nowhere.
The reason configurability seems like a bad idea is that null sort
direction is wired in
Sorry for not replying earlier, I've been quite busy.
On 31 Aug 2010, at 16:50, Henk van Lingen wrote:
> syslog=# \d systemevents
> Table "public.systemevents"
> Column |Type |
> Modi
> fiers
On Tue, Sep 7, 2010 at 8:48 AM, Henk van Lingen wrote:
>
> Thanks for your answer. Dropping the (pkey) index is not an option.
> iostat suggest the thing is CPU bound (%iowait remaining 11% but cpu
> rizing from 1 to 13 %)
How man cores that server have? If you've got 8 cores and one IO
bound on
On Fri, 2010-09-03 at 11:29 -0400, Tom Lane wrote:
> > I'm confused. I'm still seeing a bug in here: I cannot restore a
> dump
> > effectively... Running CLUSTER or VACUUM FULL does not make any
> sense to
> > me in here.
>
> Oh, wait. What you need is this patch:
>
> 2010-06-06 23:01 itagaki
Hello guys,
I have a problem with my web application and postgres. I have several servlets
on a page which results in severeal simultaneous data base calls kind of:
SELECT d.id, d.aa, d.ab, ts.ac, d.ad, d.af, d.ag, d.ah, d.ai, d.aj, d.ak, d.al,
d.am, d.an, d.ao, d.ap, d.ar, d.as, d.at, d.au, d
I have a character field in a table that contains either a file name
or a full path and file name. I need to pick out the ones that have
no full path. I do this by looking for no \. This is what I am doing:
select MM_PATH_FILE from MULTI_MEDIA Where MM_PATH_FILE NOT ILIKE '%\\%'
-this g
On 09/07/2010 02:04 PM, Christine Penner wrote:
I have a character field in a table that contains either a file name or
a full path and file name. I need to pick out the ones that have no full
path. I do this by looking for no \. This is what I am doing:
select MM_PATH_FILE from MULTI_MEDIA Wher
On 09/07/2010 02:04 PM, Christine Penner wrote:
I have a character field in a table that contains either a file name
or a full path and file name. I need to pick out the ones that have no
full path. I do this by looking for no \. This is what I am doing:
select MM_PATH_FILE from MULTI_MEDIA Wh
On 09/07/2010 02:04 PM, Christine Penner wrote:
I have a character field in a table that contains either a file name
or a full path and file name. I need to pick out the ones that have no
full path. I do this by looking for no \. This is what I am doing:
select MM_PATH_FILE from MULTI_MEDIA Wh
On 09/07/10 2:44 PM, Steve Crawford wrote:
Any other suggestions?
... like E'%%'
and, for extra fun, if that SQL statement is a constant string in a C or
similar programming language, you may well need to double up those \'s
again so that SQL sees them as the C/C++/etc parser itself d
Stefan Wild writes:
> I have a problem with my web application and postgres. I have several
> servlets on a page which results in severeal simultaneous data base calls
> kind of:
> SELECT d.id, d.aa, d.ab, ts.ac, d.ad, d.af, d.ag, d.ah, d.ai, d.aj, d.ak,
> d.al, d.am, d.an, d.ao, d.ap, d.ar,
Assume I want to install an instance of postgres such that it cannot interfere
with another install, or even be visible to other apps. Is this all I need to
do:
- install pg somewhere within my own directory
- init the db somewhere within my own directory
- disallow IP connections
- set the sock
On 09/07/10 5:15 PM, Scott Ribe wrote:
Assume I want to install an instance of postgres such that it cannot interfere
with another install, or even be visible to other apps. Is this all I need to
do:
- install pg somewhere within my own directory
- init the db somewhere within my own director
On Tuesday 07 September 2010, John R Pierce elucidated thus:
> On 09/07/10 5:15 PM, Scott Ribe wrote:
> > Assume I want to install an instance of postgres such that it
> > cannot interfere with another install, or even be visible to other
> > apps. Is this all I need to do:
> >
> > - install pg s
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> Assume I want to install an instance of postgres such
> that it cannot interfere with another install,
> or even be visible to other apps. Is this all I need to do:
>
> - install pg somewhere within my own directory
> - init the db somewhere
On 09/07/10 5:24 PM, Joshua J. Kugler wrote:
I'm pretty sure the socket directory is hard coded in the source, I
don't think you can override it even with ./configure
postgresql.conf:
unix_socket_directory = '/var/run/postgresql'
for some reason, I'm remembering that last time I looked, the
It is defined in postgresql.conf
unix_socket_directory = '/var/run/postgresql'
On Tue, 07 Sep 2010 17:20:24 -0700
John R Pierce wrote:
> On 09/07/10 5:15 PM, Scott Ribe wrote:
> > Assume I want to install an instance of postgres such that it
> > cannot interfere with another install, or even
On Sep 7, 2010, at 6:30 PM, John R Pierce wrote:
> for some reason, I'm remembering that last time I looked, there were places
> where this value wasn't being used. but then again, maybe I'm thinking of
> something else entirely different and am just confused. wouldn't be the
> first time.
On Sep 7, 2010, at 6:28 PM, Greg Sabino Mullane wrote:
> Yep, that should do it. I do this all the time for testing
> various programs. Set the socket with pg_ctl -o "-k newsocketdir"
Thanks :-)
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
John R Pierce writes:
> On 09/07/10 5:24 PM, Joshua J. Kugler wrote:
>>> I'm pretty sure the socket directory is hard coded in the source, I
>>> don't think you can override it even with ./configure
>> postgresql.conf:
>> unix_socket_directory = '/var/run/postgresql'
> for some reason, I'm rem
On Sep 7, 2010, at 7:09 PM, Tom Lane wrote:
> Personally, though, I think it's easier to change the default port
> number and not worry about sharing /tmp. Changing the port is a good
> idea anyway to avoid any possible conflicts on shared memory IDs.
I was planning on changing the default port
hi-
supposing i have the following table structure:
vendors
- id int
- name varchar
products
- product_list_id int
- vendor_id int references vendors
- part_number varchar
- description varchar
- price
- textsearch
how can i execute some type of join and get the name of the vendor to be
inclu
We're about to purchase a new server for our Postgres 8.4 database. We'd
like to go with Windows 64bit for possible future developments, but are
happy to stick with 32bit Postgres + Npgsql, ODBC, OpenSSL, slony2 and
libxml2, libpq.
I understand that Postgres 32bit runs fine in Windows 64bit, bu
Hi,
It seems the news section on http://pgfoundry.org wasn't updated for
a while. I thought this is automatically done if each project put a
news. pgpool-II project put news several times, but it never appeas on
the page. Does anybody know who is able to fix this?
--
Tatsuo Ishii
SRA OSS, Inc. Jap
> We're about to purchase a new server for our Postgres 8.4 database.
> We’d like to go with Windows 64bit for possible future developments,
> but are happy to stick with 32bit Postgres + Npgsql, ODBC, OpenSSL,
> slony2 and libxml2, libpq.
Any specific reasons for choosing Windows? Once in a whil
30 matches
Mail list logo
