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 small quibble is
that it's an extension.
I'm quite surprised there seem to
On Wed, Oct 9, 2013 at 7:04 PM, John R Pierce pie...@hogranch.com wrote:
On 10/8/2013 8:35 AM, Chris Travers wrote:
First, while vacuum is usually preferred to vacuum full, in this case, I
usually find that vacuum full clears up enough cruft to be worth it (not
always, but especially if you
On 09/10/2013 15:20, Albe Laurenz wrote:
Jesse Long wrote:
There is no problem with row visibility, there is only one connection to
the database - the connection I am using to do these selects.
No idea why the plans cannot be used.
It might be helpful to see the table and index definitions.
Hi,
I am developing .Net application using PSQL. I am using npgsql to connect
PSQL database. In single database I have more than one schemas. After I
connect database I set search path using Set Searchpath command for the
required schema. It works perfectly.
But after sometime, I need to change
On 09/10/2013 18:06, Tom Lane wrote:
Jesse Long j...@unknown.za.net writes:
The query runs for much longer than I expect it to run for, and I think
this is due to it using the incorrect subplan. As you can see, subplans
1 and 3 make use of and index, but these subplans are not used.
Subplans
Hello
2013/10/10 Kalai R softlinne...@gmail.com
Hi,
I am developing .Net application using PSQL. I am using npgsql to connect
PSQL database. In single database I have more than one schemas. After I
connect database I set search path using Set Searchpath command for the
required schema. It
On Wed, Oct 9, 2013 at 9:58 AM, 高健 luckyjack...@gmail.com wrote:
The most important part is:
2013-09-22 09:52:47 JST[28297][51d1fbcb.6e89-2][0][XX000]FATAL: Could not
receive data from WAL stream: could not receive data from server: connection
timeout
scp:
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
Chris Travers chris.trav...@gmail.com wrote:
John R Pierce pie...@hogranch.com wrote:
I often find in those cases it is a choice between vacuum full
and dumpall/initdb/reload/analyze.
Way back in the 8.1 days I often found CLUSTER to be my best option
-- as long as I had room enough for a
hi all,
the automatic update for views is really a helpful feature, but i think it
would be more useful with returning support.
currently we have to construct a rule/trigger to support queries like
'insert into simple_view returning pk'
is it possible (or desired) to implement something like
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
Hi Merlin
On Thu, Oct 10, 2013 at 1:00 AM, Kaare Rasmussen ka...@jasonic.dk wrote:
I'm quite surprised there seem to be no way in core to treat an array as an
array. Using @ treats it as a set, AFAICT.
can you elaborate on that?
merlin
To me, an array is a vector (or a vector of vectors).
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, assume you have a
table of inner covers containing a name field and fields named x 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,
Hey sorry if my answer is stupid,
but there is an extension for array, even if it is limited to int (but int
could be indexes of row)
It's named http://www.postgresql.org/docs/9.3/static/intarray.html
It provides essential function, although lacking some (I re-implemented
union of array with
Hi Rémi
Hey sorry if my answer is stupid,
but there is an extension for array, even if it is limited to int (but
int could be indexes of row)
It's named http://www.postgresql.org/docs/9.3/static/intarray.html
It provides essential function, although lacking some (I
re-implemented union of
On Sat, Sep 14, 2013 at 09:40:01PM -0400, Robert Nix wrote:
Running a pg_upgrade task is causing Segmentation fault:
command: /usr/lib/postgresql/9.3/bin/pg_dump --host /var/lib/postgresql
--port 50432 --username postgres --schema-only --quote-all-identifiers
--binary-upgrade --format=custom
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.
http://stackoverflow.com/questions/19237450/can-sql-view-have-infinite-number-of-rows-repeating-schedule-each-row-a-day
The gist is that I
Adam Mackler-3 wrote
http://stackoverflow.com/questions/19237450/can-sql-view-have-infinite-number-of-rows-repeating-schedule-each-row-a-day
I currently have a user-defined function that returns the results I
want, but the problem is in the invocation: Some host-language client
libraries
On Thu, Oct 10, 2013 at 10:03 AM, Rob Richardson
rdrichard...@rad-con.com wrote:
UPDATE inner_covers
SET X = (SELECT sl.X FROM storage_locations sl where sl.name =
inner_covers.name),
Y = (SELECT sl.Y FROM storage_locations sl where sl.name =
inner_covers.name)
Or is there
On Thu, Oct 10, 2013 at 10:42:47AM -0700, David Johnston wrote:
Adam Mackler-3 wrote
http://stackoverflow.com/questions/19237450/can-sql-view-have-infinite-number-of-rows-repeating-schedule-each-row-a-day
Not sure how you can state But I'm willing to agree never to query such a
view
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.
Adam Mackler-3 wrote
If someone can answer this challenge
without imposing that requirement, then I shall be all the more
impressed.
Fair enough; my goal wasn't to complete a challenge but to actually be
practical.
The library I'm using is SLICK:
http://slick.typesafe.com/
As far
On 10/10/2013 01:57, Brian Wong wrote:
And the extra data that's showing up is being added to the resultset
cuz without the additional where clause, the result set did not
contain any of those rows like pg_statistics/etc.
To add to what Brain said on this already, the key thing is that
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.
http://stackoverflow.com/questions/19237450/can-sql-view-have-infinite-number-of-rows-repeating-schedule-each-row-a-day
The gist is that I
Now the Steps:
USE_PGXS=1 make
USE_PGXS=1 make install
are working.
But I still dont have the directory SHAREDIR/contrib/pg_similarity.sql
Janek Sendrowski
Hello everyone
I have to reverse a string like EA;BX;CA to CA;BX;EA. or EA,BX,CA to
CA,BX,EA
Is there any function to do this?
Thanks all!
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/String-reverse-funtion-tp5773871.html
Sent from the PostgreSQL - general
On 10/09/2013 05:57 PM, Brian Wong wrote:
But from a user's perspective, why would it ever make sense that by
adding an additional where clause, it actually brings in more data
into the picture? If I have query returning 100 rows. Adding an
additional where clause should only cut down the
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
I'm amazed how complete pgAdmin, postgreSQL, all the interface options,
and this forum works.
It's time to reflect. I feel like donating.
(Maybe I'll feel the same about our politicians someday) Nnn!
Is https://www.postgresql.us/donate the place to donate?
--
Sent via pgsql-general
On 10/10/2013 03:01 PM, Bret Stern wrote:
I'm amazed how complete pgAdmin, postgreSQL, all the interface options,
and this forum works.
It's time to reflect. I feel like donating.
(Maybe I'll feel the same about our politicians someday) Nnn!
Is https://www.postgresql.us/donate the place
On Sun, Sep 29, 2013 at 07:12:43AM -0300, Clodoaldo Neto wrote:
Someone claims to have fixed it patching pg_upgrade:
http://dba.stackexchange.com/a/50714/6978
Quoting:
My solution is to rebuild the pg_upgrade from sources, with update to file
contrib/pg_upgrade/server.c:199 where
Thank you all a lot!
I have got it.
Best regards
2013/10/10 Stuart Bishop stu...@stuartbishop.net
On Wed, Oct 9, 2013 at 9:58 AM, 高健 luckyjack...@gmail.com wrote:
The most important part is:
2013-09-22 09:52:47 JST[28297][51d1fbcb.6e89-2][0][XX000]FATAL: Could
not
receive data
Me bad. It was right there in front me.
I'm now in Digest Mode.
- Bob
On Wed, Oct 9, 2013 at 12:00 PM, Igor Neyman iney...@perceptron.com wrote:
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Raymond
Hello.
I'm having problems postgesql coredump.
Do you have any idea?.
OS:Scientific Linux release 6.1
DB:postgresql91-9.1.6
MEM:4G
(gdb) bt full
#0 SearchCatCacheList (cache=0x1d70440, nkeys=1, v1=value optimized out,
v2=value optimized out, v3=value optimized out, v4=value optimized
out)
35 matches
Mail list logo