Joshua D. Drake wrote:
On Fri, 2009-02-27 at 13:30 +0100, Tim Tassonis wrote:
Hi all
I remember, a while ago somebody mentioning an odbc driver for postgres
that is not dependant on a working postgres client installation.
Unfortunately I lost the link to it, can anybody remember?
ODBCng
Hi all
I remember, a while ago somebody mentioning an odbc driver for postgres
that is not dependant on a working postgres client installation.
Unfortunately I lost the link to it, can anybody remember?
(
I tested it then and it worked fine for simple task, but then switched
back to the stan
Tomasz Ostrowski wrote:
On 2008-06-06 07:25, Brent Wood wrote:
Would "real" tables in a tablespace defined on a ramdisk meet this
need?
Bad idea. This would mean an unusable database after a restart.
Funnily, I was thinking the same this night, somehow defining a
tablespace on tmpfs or som
Tino Wildenhain wrote:
Hi,
Tim Tassonis wrote:
Hi all
I assume this is not an uncommon problem, but so far, I haven't been
able to find a good answer to it.
I've got a table that holds log entries and fills up very fast during
the day, it gets approx. 25 million rows per da
Hi all
I assume this is not an uncommon problem, but so far, I haven't been
able to find a good answer to it.
I've got a table that holds log entries and fills up very fast during
the day, it gets approx. 25 million rows per day. I'm now building a web
application using apache/mod_php where
Karsten Hilbert wrote:
On Wed, Apr 23, 2008 at 11:46:35AM +0200, Tim Tassonis wrote:
As you probably are all aware of, this results now in a cluster that
will only allow you to create UTF-8 databases. I have read some posts
regarding this topic where it is explained that allowing LATIN1 on
Martijn van Oosterhout wrote:
On Wed, Apr 23, 2008 at 04:35:04PM +0200, Tim Tassonis wrote:
If specifying a characterset different from the default locale for a
database is such a bad idea, why is it possible at all?
It isn't possible, that's the point. What is possible is that
Peter Eisentraut wrote:
Am Mittwoch, 23. April 2008 schrieb Tim Tassonis:
My question is: Why then is --locale=C not the default for initdb, as I
do regard it as a rather big annoyance that a default installation on
probably almost any modern linux distribution results in a UTF-8 only
cluster
Hi
I just recently compiled and installed 8.3.1 on a System that has UTF-8
as the default characterset in the environment. Copied the binaries, run
initdb without parameters, the usual stuff.
As you probably are all aware of, this results now in a cluster that
will only allow you to create U
Hi all
I saw on the todo list that the "with recursive" option for selects
(equivalent to oracle's connect by, as far as I know) is on the todo
list for postgresql, but apparently not for the upcoming 8.3 release.
Does anybody know about the status of this feature, e.g. is it something
bound
Once upon a time, in the days of 80-column punch cards and no
variable-length character encodings, there were databases that could
handle fixed-width character fields a bit faster than variable-width.
That doesn't apply to Postgres. There is no, none, nada performance
advantage to char(n), and
Tino Wildenhain wrote:
totally off topic,
Tim Tassonis schrieb:
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
My definition is, "toy used/trumpeted by pseudo-professionals as a
professional tool, when it just doesn't measure up".
Boah, here surel
Rich Shepard wrote:
On Thu, 22 Feb 2007, Tim Tassonis wrote:
I do still think it is a bit of an oddity, the concept of the null
column.
From my experience, it creates more problems than it actually solves and
generally forces you to code more rather than less in order to achieve
your goals
Chris wrote:
Erick Papadakis wrote:
So how should I make a database rule in MySQL to not allow blank
strings. Basically to REQUIRE a value for that column, whether it is
NULL or NADA or VOID or whatever you wish to call it. I just want to
make sure that something, some value, is entered for a co
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
My definition is, "toy used/trumpeted by pseudo-professionals as a
professional tool, when it just doesn't measure up".
Boah, here surely speaks a true professional playing in the league of
Donald Knuth or even Alan Kay, as oppo
Hi Tom
Tom Lane wrote:
Tim Tassonis <[EMAIL PROTECTED]> writes:
When examining strange behaviour in one of my programs I found out that
I must have somehow gotten into a timeout situation when fetching rows
from a cursor. My program read the first row, did some stuff for six
minutes an
Hi all
When examining strange behaviour in one of my programs I found out that
I must have somehow gotten into a timeout situation when fetching rows
from a cursor. My program read the first row, did some stuff for six
minutes and then tried to fetch the second row, which failed. The
connecti
The FSF says the MPL is not compatible with the GPL, but, well, the FSF
generally finds **all** non-GPL licenses incompatible with the GPL (BSD,
MPL, Apache, etc.). The only truly GPL-compatible license I know of is
LGPL (and there have been arguments about that). That’s the problem
with the
Thanks to you all for your replies. I was able to solve my problem after
some more reading in the manual:
select c.id, c.name, pc.person_id
from person as p
cross join course as c
left outer join person_course as pc
on (p.id = pc.person_id and c.id = pc.course_id)
where p.id = 2;
A
Hi Andreas
First, you should use referential integrity:
I do, that is not the point. It was a simplified data model. Of course I
have primary keys and stuff, but they don't affect join behaviour at all.
test=# create table person(id int primary key, name text);
NOTICE: CREATE TABLE / PRIMA
Hi all
I have a join problem that seems to be too difficult for me to solve:
I have:
table person
id integer,
namevarchar(32)
data:
1,"Jack"
2,"Jill"
3,"Bob"
table course
id integer,
name varchar(32)
data:
1,"SQL Beginner"
2,"
Hi Tom
Richard Huxton wrote:
Tim Tassonis wrote:
Hi Tom
Tom Lane wrote:
Tim Tassonis <[EMAIL PROTECTED]> writes:
The strange thing is, even with loglevel debug5, I don't get any log
message indicating that postgres is even trying to call the command.
Then it isn't, b
Hi Tom
Tom Lane wrote:
Tim Tassonis <[EMAIL PROTECTED]> writes:
The strange thing is, even with loglevel debug5, I don't get any log
message indicating that postgres is even trying to call the command.
Then it isn't, because there are definitely log messages, which were
Richard Huxton wrote:
Tim Tassonis wrote:
We use version 8.1.3 and the following archive_coomand:
archive_command = 'copy %p d:\\backup\\logs\%f'
^^^
Could the lack of a double-backslash be causing the problem?
Sorry, that was a pro
Richard Huxton wrote:
Tim Tassonis wrote:
Hi
Has anybody got any expierience with PITR recovery under Windows.
PostgreSQL just doesn't seem to copy the WAL Files to the acrive
location. We have done the initial backup and the first wal file was
copied, but after that, it seems to ignor
Hi
Has anybody got any expierience with PITR recovery under Windows.
PostgreSQL just doesn't seem to copy the WAL Files to the acrive
location. We have done the initial backup and the first wal file was
copied, but after that, it seems to ignore the newer ones. We now have
two more wal filex
Joshua D. Drake wrote:
Well, that is hardly surprising. What exactly is your point?
If you want to write portable software, you usually stay with generally
available, standardized features or API's, be it "database independent",
"platform independent", you name it. You certainly don't go for
use
Steve Crawford schrieb:
Guy Rouillier wrote:
Andrew Sullivan wrote:
On Tue, Oct 10, 2006 at 02:50:44PM -0400, Tom Lane wrote:
Some days I think database independence is a myth.
On the day when you don't, please tell me what application you found
where it isn't. I want to buy the developers a
Shane Ambler wrote:
On 2/9/2006 4:11, "Scott Marlowe" <[EMAIL PROTECTED]> wrote:
I think that with either the GPL or BSD, code is returned under a type
of coercion. Not necessarily a bad thing, understand.
The coercion of the GPL is legalistic. If you distribute GPL stuff,
you've got to give
Hi List
I'm currently playing with SSL support in PostgreSQL and have a few
questions:
SSL in general seems to work fine, but the client does not seem to
perform any server verification (Hostname or CA). Is suport for this
planned?
Client Authentication seems to work as well, but there se
30 matches
Mail list logo
