On 2015-04-08 13:10, Glyn Astill wrote:
>> From: Chris Mair
>
>
>
> 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.
>
> http://www.postg
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 chang
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_C
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 cons
Do
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
t db that psql tries to log 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
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 bein
On 30 Aug, 00:02, björn lundin 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 wildcar
On 9 Juni, 16:37, t...@sss.pgh.pa.us (Tom Lane) wrote:
> Marinos Yannikos 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" is r
r NOT NULL,
> etc
> );
Perhaps you want to not use the "" around the table and column names.
It makes them 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
ow do you perform VACUUM?
> 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 ve
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 -ef
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 resu
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
o for
embedded RDBMS.
or perhaps Mimer <http://www.mimer.com/>
/Björn
Björn Lundin
/Björn
Björn Lundin
b dot f dot lundin at gmail dot com
s 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 t
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
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 ...
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 que
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 broadcast)-
24 matches
Mail list logo
