On Thu, 8 Apr 2004, Tom Lane wrote:
> Yup, exactly. If we did not force both LC_COLLATE and LC_CTYPE to have
> the same values cluster-wide, then we *would* have index corruption
> issues.
We really show warn people that using another encoding in a database then
what the cluster uses, breaks so
"Dann Corbit" <[EMAIL PROTECTED]> writes:
> The response from the Mingw team:
>> Symbolic links to files and directories do not work on Win32
>> in general. Support for symlink operation is limited to the source
>> directory or file existing and being able to copy the source to the
>> destination
Chris Browne <[EMAIL PROTECTED]> writes:
> We have encountered a pretty oddball situation involving an "unknown" type.
The way you get this sort of thing is with
CREATE VIEW foo AS SELECT ... , 'literal', ...
The undecorated literal is initially of type UNKNOWN, and there's
nothing to cause it t
Robert Treat <[EMAIL PROTECTED]> writes:
> On Thu, 2004-04-08 at 09:49, [EMAIL PROTECTED] wrote:
>> (2) I would bet that *most* deployments of PostgreSQL only use one
>> database environment per server, so I'm not even sure that it would be an
>> issue for the majority of current or prospective use
Ron,
--- "Nolte, Ronald C." <[EMAIL PROTECTED]>
wrote:
>
> Does anyone have any recommendations for places to
> download Postgres and
> pgtcl libraries to enable running my Tcl/Tk
> application on Windows using
> Postgres?
>
You can grab one here:
http://www.bschwarz.com/projects/pgaccess/
[EMAIL PROTECTED] (S. Hawkins) writes:
> * We're running Postgres 7.2.3 on a more-or-less stock Red Hat 7.3
> platform.
Both the database and the platform are seriously obsolete :-(
> The particular file I'm wrestling with at the moment is ~2.2 Gig
> unzipped. If you try to restore using pg_re
Dennis Bjorklund <[EMAIL PROTECTED]> writes:
> LC_CTYPE is per cluster and not per database as some of the other LC_.
Yup, exactly. If we did not force both LC_COLLATE and LC_CTYPE to have
the same values cluster-wide, then we *would* have index corruption
issues.
reg
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Not having a way to kill backends is like having no way to kill a
> > process except rebooting the server.
>
> Some people think that making a database hard to kill is a good thing.
Sure. But we're not talking about taking down the
Bruno Wolff III wrote:
> On Wed, Apr 07, 2004 at 06:01:03 -0700,
> Michael Groth <[EMAIL PROTECTED]> wrote:
> > hi,
> >
> > is it possible to use an index on the expression '(table_1.field &
> > table_2.field)::int > 0' ?
> >
> > here's the whole query:
> >
> > SELECT
> > COUNT(*)
> > FRO
Michael Groth wrote:
> hi,
>
> is it possible to use an index on the expression '(table_1.field &
> table_2.field)::int > 0' ?
>
> here's the whole query:
>
> SELECT
> COUNT(*)
> FROM
> users AS users
> JOIN
> search_profile AS search_profile ON
> (search_profile.bin_matching_
On Wed, Apr 07, 2004 at 06:01:03 -0700,
Michael Groth <[EMAIL PROTECTED]> wrote:
> hi,
>
> is it possible to use an index on the expression '(table_1.field &
> table_2.field)::int > 0' ?
>
> here's the whole query:
>
> SELECT
> COUNT(*)
> FROM
> users AS users
> JOIN
> searc
> -Original Message-
> From: Dann Corbit
> Sent: Wednesday, April 07, 2004 10:34 AM
> To: Tom Lane
> Cc: [EMAIL PROTECTED]
> Subject: Re: [HACKERS] Small suggestion on build script
>
>
> > -Original Message-
> > From: Tom Lane [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, April 0
On Thu, 2004-04-08 at 09:49, [EMAIL PROTECTED] wrote:
> > On Thu, 8 Apr 2004 [EMAIL PROTECTED] wrote:
> >
> >> more flexable configuration based on the idea that configuration and
> >> data
> >> are in SEPARATE locations is important.
> >
> > Why is it important and wouldn't it just make it harder
Dear folks,
I have a Tcl/Tk application which runs on Unix using either MySql or
Postgres - this works.
The same Tcl/Tk application runs on Windows using MySql.
Does anyone have any recommendations for places to download Postgres and
pgtcl libraries to enable running my Tcl/Tk application on Windo
We have encountered a pretty oddball situation involving an "unknown" type.
mydb=# select version();
version
-
hi,
is it possible to use an index on the expression '(table_1.field &
table_2.field)::int > 0' ?
here's the whole query:
SELECT
COUNT(*)
FROM
users AS users
JOIN
search_profile AS search_profile ON
(search_profile.bin_matching_field_0 &
users.bin_matching_field_0)::int
> Otherwise, I'll stick by my assertion that idle connection management should
> be done in the middleware and NOT by psql.
Perhaps it should be, but as PostgreSQL picks up more and more vendor
applications this is difficult for the person administrating the
database.
Consider a 3rd party applic
Hi all,
We're using pg_dump to backup our databases. The actual pg_dump
appears to work fine. On smaller (< approx. 100 Meg) data sets, the
restore also works, but on larger data sets the restore process
consistently fails.
Other facts that may be of interest:
* We're running Postgres 7.2.3
On Thu, 8 Apr 2004, Tom Lane wrote:
> You're missing the point: strcoll() is not going to compare them as
> latin1 strings. It's going to interpret the bytes as utf-8 strings,
> because that's what LC_CTYPE will tell it to do.
My current understanding of what you are saying now is that LC_CTYPE
Tom Lane wrote:
Andrew Hammond <[EMAIL PROTECTED]> writes:
I've attached a patch for pg_ctl which integrates the Apache project's
rotatelogs for logging.
Why bother? You just pipe pg_ctl's output to rotatelogs and you're
done.
It's not difficult to do, once you know how and once you know that th
Bruce Momjian <[EMAIL PROTECTED]> writes:
> On first glance, I don't see anything dangerous about SIGTERM.
You haven't thought about it very hard :-(
The major difference I see is that elog(FATAL) will call proc_exit
directly from elog, rather than longjmp'ing back to PostgresMain.
The case that
scott.marlowe wrote:
> On Thu, 8 Apr 2004, Bruce Momjian wrote:
>
> > Fabien COELHO wrote:
> > >
> > > > > This would help me, at least, write correct and portable SQL. :)
> > > >
> > > > Added to TODO:
> > > >
> > > > * Add a session mode to warn about non-standard SQL usage
> > >
> > >
> Dennis Bjorklund <[EMAIL PROTECTED]> writes:
>> On Thu, 8 Apr 2004 [EMAIL PROTECTED] wrote:
>>> more flexable configuration based on the idea that configuration and
>>> data
>>> are in SEPARATE locations is important.
>
>> Why is it important and wouldn't it just make it harder to have several
>>
On Thu, 8 Apr 2004, Bruce Momjian wrote:
> Fabien COELHO wrote:
> >
> > > > This would help me, at least, write correct and portable SQL. :)
> > >
> > > Added to TODO:
> > >
> > > * Add a session mode to warn about non-standard SQL usage
> >
> > So it seems that having C-like operators would h
Dennis Bjorklund <[EMAIL PROTECTED]> writes:
> On Thu, 8 Apr 2004, Tom Lane wrote:
>> No, the ordering *will* be the same as it was before, because strcoll()
>> is still functioning the same. You'd get the same answer from a sort
>> operation since it depends on the same operators.
> But, now whe
Honza Pazdziora <[EMAIL PROTECTED]> writes:
> On Thu, Apr 08, 2004 at 10:31:44AM -0400, Tom Lane wrote:
>> It seems that MySQL *will* read /etc/my.cnf if it
>> exists, whether it's appropriate or not, and so it's impossible to have
>> a truly independent test installation, even though you can confi
On Thu, 8 Apr 2004, Tom Lane wrote:
> No, the ordering *will* be the same as it was before, because strcoll()
> is still functioning the same. You'd get the same answer from a sort
> operation since it depends on the same operators.
>
> It interprets them according to LC_CTYPE, which does not ch
Tom Lane wrote:
I've recently had some very unpleasant experiences trying to install
test versions of MySQL on machines that already had older versions
installed normally. It seems that MySQL *will* read /etc/my.cnf if it
exists, whether it's appropriate or not, and so it's impossible to have
a tr
I have the file location discussion in my 7.4 hold mailbox:
http:/momjian.postgresql.org/cgi-bin/pgpatches2
I am going to revisit it the next month and see if I can get all the
opinions merged into a plan everyone can agree on. I think it can be
done.
--
On Thu, Apr 08, 2004 at 10:31:44AM -0400, Tom Lane wrote:
>
> I've recently had some very unpleasant experiences trying to install
> test versions of MySQL on machines that already had older versions
> installed normally. It seems that MySQL *will* read /etc/my.cnf if it
> exists, whether it's ap
Fabien COELHO wrote:
>
> > > This would help me, at least, write correct and portable SQL. :)
> >
> > Added to TODO:
> >
> > * Add a session mode to warn about non-standard SQL usage
>
> So it seems that having C-like operators would hurt a lot;-)
>
> So you want to generate warnings for SER
Dennis Bjorklund <[EMAIL PROTECTED]> writes:
> On Thu, 8 Apr 2004, Tom Lane wrote:
>> See my previous point: the index does not actually fail, in our current
>> implementation, because strcoll() is unaffected by the database's
>> encoding setting.
> How can it be? If I have a utf-8 template1 and a
Dennis Bjorklund <[EMAIL PROTECTED]> writes:
> On Thu, 8 Apr 2004 [EMAIL PROTECTED] wrote:
>> more flexable configuration based on the idea that configuration and data
>> are in SEPARATE locations is important.
> Why is it important and wouldn't it just make it harder to have several
> database c
On Thu, 8 Apr 2004, Tom Lane wrote:
> See my previous point: the index does not actually fail, in our current
> implementation, because strcoll() is unaffected by the database's
> encoding setting.
How can it be? If I have a utf-8 template1 and a table with an index
sorted according to the utf-8
Dennis Bjorklund <[EMAIL PROTECTED]> writes:
> I can also imagine the indexes being wrong when you keep the encoding of
> tables when you create a new database. Since the same character can be
> represented differently, the sort order also changes if you try to
> interpret something with another en
> On Thu, 8 Apr 2004 [EMAIL PROTECTED] wrote:
>
>> more flexable configuration based on the idea that configuration and
>> data
>> are in SEPARATE locations is important.
>
> Why is it important and wouldn't it just make it harder to have several
> database clusters (for example with different loca
On Thu, 8 Apr 2004 [EMAIL PROTECTED] wrote:
> more flexable configuration based on the idea that configuration and data
> are in SEPARATE locations is important.
Why is it important and wouldn't it just make it harder to have several
database clusters (for example with different locale) or sever
About a year or two ago I submitted a configuration patch that allowed
PostgreSQL to be fully configured by postgresql.conf -- enabling data and
configuration to be in separate locations. The idea was that, like most
UNIX systems, that the configuration file could be stored in the /etc
directory (o
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I'm facing a problem with the unfamous:
"idle in transaction"
problem. I'm using the JDBC driver.
Mainly the problem is that the JDBC interface doesn't
provide the method begin() for a transaction, of course this
is not a JDBC postgres interfa
> > Are you talking about the sort order? Then there's no problem with
> > encoding itself.
>
> The tables in template1 in encoding E1 are compied into the new database
> in encoding E2. Not all encodings are compatable, so you can't even
> convert from E1 to E2.
In this case you just set your
On Thu, 8 Apr 2004, Tatsuo Ishii wrote:
> > The tables in template1 in encoding E1 are compied into the new database
> > in encoding E2. Not all encodings are compatable, so you can't even
> > convert from E1 to E2.
>
> In this case you just set your terminal encoding to E1, then SELECT
> the t
On Wed, Apr 07, 2004 at 03:40:57PM -0400, Tom Lane wrote:
>
> In practice, we know that we have seen index failures from altering the
> locale settings (back before we installed the code that locks down
> LC_COLLATE/LC_CTYPE at initdb time). I do not recall having heard any
Cannot the same failu
On Wed, Apr 07, 2004 at 02:20:55PM -0400, Tom Lane wrote:
>
> I've committed changes to do the right thing in CVS tip.
Thanks man!
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---(end of broadcast)---
TIP 3: if po
43 matches
Mail list logo