Hi!
below are some commands to
replicate a strange sorting order.
I do not see why id:s 3-6 are in the middle of the result set.
What am I missing?
begin;
create table T_SORT (
ID bigint default 1 not null , -- Primary Key
NAME varchar(100) default ' ' not null
);
alter table T_SORT add
On 2015-04-08 11:33, Glyn Astill wrote:
The collation of your bnl database is utf8, so the . punctuation
character is seen as a variable element and given a lower weighting in
the sort to the rest of the characters. That's just how the collate
algorithm works in UTF8.
Try with LC_COLLATE =
On 2015-04-08 11:36, Chris Mair wrote:
I don't know what's the rationale behin this,
but it looks like Linux ignores the . when doing the sort.
Yes, I see that now,
and it makes sense
Thanks.
--
Björn
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
On 2015-04-08 13:10, Glyn Astill wrote:
From: Chris Mair ch...@1006.org
I think this is down to behaviour changes in glibc, there was a thread a
while ago where somebody replicating via streaming rep between with different
versions of glibc ended up in a bit of a pickle.
create table foo( bar int);
Instead of
Create table
foo (bar int);
/björn lundin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
in to...
--
björn lundin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 30 Aug, 00:02, björn lundin b.f.lun...@gmail.com wrote:
Or is it just beeing late, and me being blind?
eyetv=# select * from programmes where title like 'Star*';
It was of course me being blind...
select * from programmes where title like 'Star%';
is the correct way.
Wrong wildcard
I got a table holding tv air time but I got a unexpected (to me)
behaviour.
Using like, I do not get the recordset I'd like.
I've installed it using mac-ports on an old mac-mini, ppc
I'd expect to see the same rows with wildcard, as I see without, see
below
Or is it just beeing late, and me
On 9 Juni, 16:37, t...@sss.pgh.pa.us (Tom Lane) wrote:
Marinos Yannikos m...@geizhals.at writes:
It seems that poll() never receives a connection closed notification under
Linux
(https://lists.linux-foundation.org/pipermail/bugme-new/2003-April/008...-
very old report,
very old report
case sensitive
--
Björn Lundin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
?
a) vacuumdb - shell command
I like the idea of fewer tools.
Will change to do VACUUM from psql instead
/Björn Lundin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Ashish Karalkar wrote:
Hello All,
I want to export data from PostgreSQL tables to MS Excel.
Is there any way?
ODBC is one way to do it.
Use the data import, that runs msquery
--
/Björn
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 9: In
On Thursday 19 July 2007 00:03:19 Roderick A. Anderson wrote:
I'll post my solution ... when I figure one out!
You could, in the script from cron:
1 - check for the presence of rows in a 'alive_scripts_table'
if any , then exit, and go for the next run,
alternativly, check that pid in 'ps
Hello!
I'm connecting via libpq and want to
use prepared statements in a cursor.
Is there a sample somewhere, since I cannot get
it to work.
sebjlun=# \d ssignal
Table public.ssignal
Column | Type | Modifiers
-+---+---
ssignam | character(12) | not
28 jun 2007 kl. 16.45 skrev Tom Lane:
=?ISO-8859-1?Q?Bj=F6rn_Lundin?= [EMAIL PROTECTED] writes:
I'm connecting via libpq and want to
use prepared statements in a cursor.
You can't.
That explains why I could not find an example...
If you're just interested in fetching a large query
for
embedded RDBMS.
or perhaps Mimer http://www.mimer.com/
/Björn
Björn Lundin
Björn Lundin
b dot f dot lundin at gmail dot com
may be run by hand
instead.
I think pgtcl will run on windows, and the docbook tools I used were
all java.
/Björn
Björn Lundin
b dot f dot lundin at gmail dot com
Lada 'Ray' Lostak wrote:
I will also appreciate any links to web resources, talking about this
problem. I didn't find anything usefull around.
I'm working with developing a fairly big warehouse management system, and
there we see this problem every day. We've settled (many years ago) for
Dino Vliet wrote:
MUCH better nowI did manage to get an insert into
the table lessons with these adjustments...BUT now it
seems the FOR LOOP didn't work because I only get 1
record and expected that I would get 8 records due to
the i variabele.
What could be wrong?
My code is now:
Erwin Van de Velde wrote:
Hi,
I have to copy data from one table to another, and I was wondering if
there is an easier way to do that than to have a lot of inserts one after
another.
insert into target_table select * from source-table where ...;
Björn Lundin
Yes, I meant turn off Autocommit for the entire psql session.
Starting every manipulation of the database with a BEGIN is
a bit tiresome, and i often catch myself with forgetting it.
If it isn't possible, it would be a nice featue!?
Björn
Tim Mickol wrote:
Actually, I think the original
Hi!
Is there a way of turning autocommit of in psql ?
It would be nice for people used to Oracle's SQL*Plus.
No fatal error has occurred yet, but some minor problems could have been
avoided if rollback was possible when the fingers on the keyboard are
faster than the brain :)
Björn
Christian Marschalek wrote:
Hi all of you! :o)
I guess I do have to shut down the database before shutting down the
linux box?
How would I accomplish this?
Just by killing the postmaster per pid?
Tia and regards!
---(end of
24 matches
Mail list logo