Ow Mun Heng wrote:
Anyhow, searching the archives (in my mail client - no internet at the
moment), I see references that when I use TEXT, I will create TOAST
tables which will have them lie _outside_ of my main data table.
The same is true of varchar, and quite a few other data types. There's
Thisis the same problempostgresql has whendoing sorting when runonwindows vs.
linux. Postgresql relies on the OS tohandlecollating aka sort orders.
to Quote
PostgreSQL uses the standard ISO C and POSIX locale facilities provided by the
server operating system
http://www.postgresql.org/docs
"Randal T. Rioux" <[EMAIL PROTECTED]> writes:
> bash-3.00# ldd /usr/local/ssl/lib/libssl.so
...
> libgcc_s.so.1 => (file not found)
Smoke, meet gun ...
> Now why would libssl.so not be linked to libgcc_s.so.1? Why would
> PostgreSQL care and not Apache?
Well, it is "linked", but
Hi,
I'm a (more than a) bit confuse as to the diference between TEXT and
varchar data-types.
AFAIK, varchar will have a max limit char of, if not mistaken ~65k? But
for TEXT, it's more like a BLOB and there's supposed to be no limit?
Anyhow, searching the archives (in my mail client - no interne
Hi all,
I have 2 postgresql running on linux on 2 different physical machines.
Then I create 2 identical database on them, both using utf8 as server
encoding and GBK as client encoding.
But when I try to order by some query result with a column containing
Chinese characters, the result is differ
On Sun, September 7, 2008 12:47 am, Tom Lane wrote:
> "Randal T. Rioux" <[EMAIL PROTECTED]> writes:
>> On Sat, September 6, 2008 8:21 pm, Tom Lane wrote:
>> ldd or local equivalent might help debug this.
>
>> bash-3.00# ldd /usr/local/lib/sparcv9/libgcc_s.so.1
>> libc.so.1 => /lib/64/li
I'd like to learn a little more about writing psql scripts does anyone
know of any resources outside of the manual?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
2008/9/7 c k <[EMAIL PROTECTED]>:
> Hello,
> I have a question regarding secure connections between pg clients and pg
> server. As per manual for 8.3 we can use openssl for this purpose. does odbc
> driver supports it and how? Is there any other method for this?
Yes the ODBC driver (as well as all
That sounds like something that is good to handle with PgQ that is part of
SkyTools package.
PgQ is very efficient event processing system for PostgreSQL. Each event
queue may have several consumers.
What may interest you is that PgQ takes care of processed events by keeping
them in rotated tables
In article <[EMAIL PROTECTED]>,
"Uwe C. Schroeder" <[EMAIL PROTECTED]> writes:
> or maybe not and I'm just not getting it.
> So here's the scenario:
> I have 3 tables
> forum: with primary key "id"
> forum_thread: again primary key "id" and a foreign key "forum_id" referencing
> th primary key
Hello,
I have a question regarding secure connections between pg clients and pg
server. As per manual for 8.3 we can use openssl for this purpose. does odbc
driver supports it and how? Is there any other method for this?
Thanks
CPK
On Sunday 07 September 2008, Gregory Stark wrote:
> "Uwe C. Schroeder" <[EMAIL PROTECTED]> writes:
> > I want to get a list looking like
> >
> > forum idthread_id post_id
> > 1 6 443
> > 2 9 123
> > 3 3 557
>
> ...
>
> > It all boils down
Joshua D. Drake wrote:
Andrew Dunstan wrote:
Hasn't integer-datetimes been the default for a while? Of course, a
catversion bump will force a dump/reload regardless of that.
Unfortunately not. It is the default on some versions of linux such as
Debian/Ubuntu.
The point I was making
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <[EMAIL PROTECTED]> writes:
> On Sun, 2008-09-07 at 11:01 -0400, Andrew Dunstan wrote:
>> Hasn't integer-datetimes been the default for a while?
> No. I added it as a macro to 8.3, but did not enable it by default,
> because I am trying to be binary compatible w
Andrew Dunstan wrote:
Hasn't integer-datetimes been the default for a while? Of course, a
catversion bump will force a dump/reload regardless of that.
Unfortunately not. It is the default on some versions of linux such as
Debian/Ubuntu.
Sincerely,
Joshua D. Drake
--
Sent via pgsql-gen
Hello,
On Sun, 2008-09-07 at 11:01 -0400, Andrew Dunstan wrote:
> Hasn't integer-datetimes been the default for a while?
No. I added it as a macro to 8.3, but did not enable it by default,
because I am trying to be binary compatible with Red Hat / Fedora RPMs.
I believe Tom will also add it to
Devrim GÜNDÜZ wrote:
Hi,
I just released new RPM sets, which is based on today's CVS snapshot
(Sep 7, 12:00AM PDT).
These packages *do* require a dump/reload, even from previous 8.4
packages, since I now enabled --enable-integer-datetimes in PGDG RPMs by
default (and IIRC there is a catversio
Thenx,
The preparation of such simulation would take me much longer :(. Thenx!
But out of the results, I was wandering if this is an exotic RDMB use,
or may be it would be worth pondering at this point, of improvements to
the Postgres RULE system.
I'm not really up to any technical discussion re
Hi,
I just released new RPM sets, which is based on today's CVS snapshot
(Sep 7, 12:00AM PDT).
These packages *do* require a dump/reload, even from previous 8.4
packages, since I now enabled --enable-integer-datetimes in PGDG RPMs by
default (and IIRC there is a catversion update in recent commit
"Uwe C. Schroeder" <[EMAIL PROTECTED]> writes:
> I want to get a list looking like
>
> forum idthread_id post_id
> 1 6 443
> 2 9 123
> 3 3 557
...
> It all boils down to me not being able to come up with a query that gives me
> the latest
or maybe not and I'm just not getting it.
So here's the scenario:
I have 3 tables
forum: with primary key "id"
forum_thread: again primary key "id" and a foreign key "forum_id" referencing
th primary key of the forum table
forum_post: again primary key "id" with a forign key "thread_id" referen
Tom Lane <[EMAIL PROTECTED]> writes:
> The only recovery strategy that I can think of in 8.1 is to blow away
> your WAL with pg_resetxlog, let the database come up in a damaged
> condition, and then try to extract data from it.
Would it work if he rebuilt 8.1 with a "return;" as the first line
22 matches
Mail list logo
