unsubscribe
<>
S. C. wrote:
> Hi, list,
>
>
> Does statistics has any relation to query optimizer? If I turn on statistics
> collector, will it do help to query optimizer?
No.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If
Tom Lane wrote:
> "Tomeh, Husam" <[EMAIL PROTECTED]> writes:
>
>>(I was referring to object partitioning. For instance, if I have a huge
>>table with US counties as my partition key, I could create partitions
>>within the same table based on the partition key (a US county for
>>example). When quer
Joshua D. Drake wrote:
> Tomeh, Husam wrote:
>
>> Does PostgreSQL support/allow "partitioning" of objects like tables and
>> indexes, like Oracle does?
>>
> We support tablespaces but not table partitioning. You can get around
> this by using namespaces and unions however.
I demonstrate that at
Tomeh, Husam wrote:
> Thanks Josh, I'll check out the namespace concept.
>
> (I was referring to object partitioning. For instance, if I have a huge
> table with US counties as my partition key, I could create partitions
> within the same table based on the partition key (a US county for
> example
Did you try select lower(columnname) from tbl
?
ex:
select lower(clientnum) from tblcase where clientnum = 'WAZ'
Joel Fradkin
Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel. 941-753-7111 ext 305
[EMAIL PROTECTED]
www.wazagua.com
Powered by Wazagua
Providing you with the latest We
lower()
On Thu, 2005-02-24 at 14:57, Zouari Fourat wrote:
> Hello,
> Am looking for a 'tolowercase' function that returns lowercase string
> that can be used like this :
>
> SELECT lowercase(column) FROM table;
>
> anyone can help me ?
>
> ---(end of broadcast)--
Hello,
Am looking for a 'tolowercase' function that returns lowercase string
that can be used like this :
SELECT lowercase(column) FROM table;
anyone can help me ?
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregiste
>> (The NOCREATEUSER option used when creating the collective user does
>> prevent it from changing its own password via
>> ALTER USER guest WITH ... PASSWORD ...
>You think so?
>
>This approach is doomed to failure --- the system sees no reason not to
>allow a user to change his own configuratio
Most of the time you have one login account, the problem would be better
solved with a group. Most of the time...
On Thu, 2005-02-24 at 11:36, Goulet, Dick wrote:
> Collective user accounts are all well & good so long as everyone using
> it understands that you don't change stuff. If you've got
Collective user accounts are all well & good so long as everyone using
it understands that you don't change stuff. If you've got a user who is
adamant that they have to have a specific password, etc... Then your
only recourse is to create them their own user account. I've done that.
It's a bit pa
Tom Lane wrote:
I don't know what behavior you thought you were getting from upper/lower
on UTF-8 data in 7.4, but it was surely not correct. If you want to
duplicate that misbehavior, try SQL_ASCII with C locale. This does not
stop you from storing UTF-8 in your database, mind you --- it just
lo
I ended up using SQL_ASCHII and could see lower works fine but on extended
chars it does nothing.
SO if that's what your shooting for it worked ok for me.
I would have preferred to have my encoding Unicode , but don't want to
figure out why the odbc driver was not able to insert extended chars.
I
Alex Gutman <[EMAIL PROTECTED]> writes:
> (The NOCREATEUSER option used when creating the collective user does
> prevent it from changing its own password via
> ALTER USER guest WITH ... PASSWORD ...
You think so?
This approach is doomed to failure --- the system sees no reason not to
allow a use
On Wed, 2005-02-23 at 22:35, JinNet Picker wrote:
> Hi,
>
> I am using Postgres database for my Application.
>
> All my developers will be updating the database during development,
> i.e like Adding a New Field, Drop Field, Add Records etc things.
>
> The main database will be on Server, My q
On Thu, 2005-02-24 at 07:54, Marcin Giedz wrote:
> Hello...
>
> Here is my server hardware configuration: 2x Xeon 1MB Cache 3GHZ + 4GB RAM
> basicly it one of Intel Server SR2400 configuration ;) with two Seagate discs
>
> 146GB 15k connected with RAID1. I have installed PSQL ver. 8.0 and try
Bjoern Metzdorf <[EMAIL PROTECTED]> writes:
> Is 8.0 just stricter or is this just a side effect
> of your fix for multibyte upper/lower problem for locale != C?
Both those statements are true.
> If 7.3 and 7.4 behaviour is intended, is there a way to let 8.0 behave
> the same?
I don't know wh
Dnia czwartek, 24 lutego 2005 15:39, Rick Apichairuk napisał:
> I think you should also state what operating system you are using.
Ohhh Debian Sarge of course ;)
>
>
> On Thu, 24 Feb 2005 14:54:46 +0100, Marcin Giedz
>
> <[EMAIL PROTECTED]> wrote:
> > Hello...
> >
> > Here is my server hardware c
I think you should also state what operating system you are using.
On Thu, 24 Feb 2005 14:54:46 +0100, Marcin Giedz
<[EMAIL PROTECTED]> wrote:
> Hello...
>
> Here is my server hardware configuration: 2x Xeon 1MB Cache 3GHZ + 4GB RAM
> basicly it one of Intel Server SR2400 configuration ;) with t
Hello...
Here is my server hardware configuration: 2x Xeon 1MB Cache 3GHZ + 4GB RAM
basicly it one of Intel Server SR2400 configuration ;) with two Seagate discs
146GB 15k connected with RAID1. I have installed PSQL ver. 8.0 and try to
find best configuration. Nowadys we have about 300 clients
Greetings,
I've established a read-only collective account (sort of guest) with
no privileges. Nevertheless, the collective user in question can still
issue commands
ALTER USER guest SET parameter TO value
and so change the default setting of any user-alterable run-time
configuration variable.
21 matches
Mail list logo