Hi,
I wonder when the committed data is available to other connections, or
more specifically if there is a delay after COMMIT return successfully
and the data will appear in SELECTs made by other connections.
A more detailed description of my problem:
I use postgresql as backend to a REST ser
On 02/11/2011 12:13 PM, Adarsh Sharma wrote:
Dear all,
I have an Integer column in Postgres database table. Let's say the
column has below values :
1
2
3
4
5
6
7
8
9
10
Now if i deleted some rows where id= 3 ,5 and 8 or it have these type
of data then
The data look like as :
1
2
4
6
On 01/24/2011 05:02 PM, A.M. wrote:
On Jan 24, 2011, at 10:50 AM, Fredric Fredricson wrote:
I have been fighting with a select and can find no satisfactory solution.
Simplified version of the problem:
A table that, in reality, log state changes to an object (represented as a row
in another
On 01/24/2011 04:56 PM, Tom Lane wrote:
Fredric Fredricson writes:
... Now I want the latest "someData" for each "ref" like:
The best solution I could find depended on the fact that serial is
higher for higher dates. I do not like that because if that is true, it
is an ind
I have been fighting with a select and can find no satisfactory solution.
Simplified version of the problem:
A table that, in reality, log state changes to an object (represented as
a row in another table):
CREATE TABLE t (
id SERIAL UNIQUE,
ref INTEGER, -- Reference to a row in anoth
On 01/23/2011 12:29 PM, Attila Nagy wrote:
Hello,
I'm looking for a database backend for a dictionary coder project. It
would have three major tasks:
- take a text corpus, get their words and substitute each word by a 64
bit integer (the word:integer is always constant) and store the result
On 01/17/2011 09:00 PM, ? wrote:
I retrieve asynchronous queries results using PQgetResult() which
returns NULL not in case of some error, but when results end - so
there is no way to know if database responded successfully or there
happened some error?
For example, error can
On 01/15/2011 11:52 PM, Randall Smith wrote:
Hi,
I've created a trigger that checks the uniqueness of two columns in a
table. Traditionally, one would use a unique constraint, but in my
case, the size of the unique index would be too large and some
performance loss is acceptable. However, the
On 01/03/2011 12:11 PM, Andre Lopes wrote:
[snip]
The problem with this task is that the information is not linear, if I
try to design tables with fields for all possible data I will end up
with many row fields with NULL values. There are any problem with
this(end up with many row fields with
On 11/24/2010 12:31 PM, Florian Weimer wrote:
* Grzegorz Jaśkiewicz:
2010/11/24 Florian Weimer:
* Grzegorz Jaśkiewicz:
just never use SELECT *, but always call columns by names. You'll
avoid having to depend on the order of columns, which is never
guaranteed, even if the table on disk is one
Hi,
I have designed a handful databases but is absolutely no SQL-expert. Nor
have I had any formal database training and have never worked with
someone who had. What I know about SQL I have read in the documentation,
found with google, and learned from my numerous mistakes.
This question I ha
On 11/17/2010 03:09 PM, Tony Caduto wrote:
On 11/15/2010 5:53 PM, Lee Hachadoorian wrote:
If anyone's interested, I've started accessing the postgres list through
gmane.org (along with several other mailing lists I subscribe to). It's
gives you the choice of reading the list as a threaded archiv
On 11/09/2010 06:01 PM, Andy wrote:
MySQL is GPL'd, just like Linux is.
Well it is and it isn't. A couple of years ago when I was involved with
choosing DB for a (proprietary) application we could not figure MySQLs
license out. It was GPL'd but at the same time if you wanted to use it
commerc
On 10/25/2010 01:19 PM, David W Noon wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, 25 Oct 2010 09:49:02 +0200, Fredric Fredricson wrote abour Re:
[GENERAL] What is "return code" for WAL send command:
On 10/23/2010 02:01 PM, zhong ming wu wrote:
[snip]
For some
On 10/23/2010 02:01 PM, zhong ming wu wrote:
Hello
I have a master PG 8.1.11 sending WAL files to a cold-standby using rsync
For some reason it failed recently with "return codes 32512" and I
couldn't find this num. as a valid rsync exit code
During the time that the error was going on I t
cording to
http://www.postgresql.org/docs/8.2/interactive/auth-pg-hba-conf.html you
should add a line
host all all 0.0.0.0/0 md5
/Fredric
PS. When everything else fails, read the manual.
Best Regards,
On Sat, Apr 24, 2010 at 4:15 PM, Fredric Fredricson
<mailto:fredric.fredric...@bo
Scott Marlowe wrote:
On Tue, Feb 9, 2010 at 1:42 AM, Fredric Fredricson
wrote:
I use locale en_US.UTF-8 but why this should affect how leading characters
in strings are ignored is beyond me.
P.s. this page may shed some light on the subject:
http://en.wikipedia.org/wiki/Collation
OK
Justin Graf wrote:
On 2/8/2010 7:09 PM, Fredric Fredricson wrote:
Hi!
New to the list with a question that I cannot find the answer to in
the manual or on the internet but I suspect is trivial. If somebody
could point me in the correct direction I would be greatful.
This is what I do
Hi!
New to the list with a question that I cannot find the answer to in the
manual or on the internet but I suspect is trivial. If somebody could
point me in the correct direction I would be greatful.
This is what I do (condensed, of course):
# create table tmp ( x text ) ;
CREATE TABLE
# inse
19 matches
Mail list logo
