Hi!
If I correctly understand v7.4 manual, value, say,
'2003-11-26 12:00' in TIMESTAMP WITHOUT TIMEZONE column
should output '2003-11-26 19:00' for "+08:00" timezone.
The following test results seem to be somewhat unexpected.
Restting OS timezone (/etc/timezone and /etc/localtime in
Linux) do
"cnliou" <[EMAIL PROTECTED]> writes:
> If I correctly understand v7.4 manual, value, say,
> '2003-11-26 12:00' in TIMESTAMP WITHOUT TIMEZONE column
> should output '2003-11-26 19:00' for "+08:00" timezone.
Not at all. TIMESTAMP WITHOUT TIMEZONE will not react to timezone
environment at all. Wh
Użytkownik Robert Treat napisał:
On Tue, 2003-11-25 at 08:07, Marek Lewczuk wrote:
Yes. I think the gist of your post was "out of the box postgresql
performed like garbage compared to mysql, but then i spent some time
tweaking and tuning, taking advantage of indexes, and now it performs so
quickly
I found the problem. It was not hardware problems or any malfunction in
postgresql.
I thought I had dropped all tables that inherited from the problem table, but
apparently I forgot one.
It really sucks that inheritance breaks their parent tables constraints :-(.
Which is also why we had to drop
On Tuesday 25 November 2003 21:13, Jason Tesser wrote:
> I did go back and edit the files manually. As far as I can tell it is
> entered correctly in the pg_hba.conf file
Do you have a file set up on the pam side of things? Each service using pam
should have a config file (in /etc/pam.d on redha
Hello! Tom,
>Not at all. TIMESTAMP WITHOUT TIMEZONE will not react to
timezone
>environment at all.
Absolutely right! I seemed to have trouble understanding
lengthy, though good, documentation.
Here are some minor issues I have encountered:
- SQL commands like "SET TIMEZONE TO NZDT" are ille
>> I'm curious as to what type of application you run and
what first
>> prompted you to switch to postgresql?
I would like to add my 2 cents to this although I have not
been asked by anyone about this :-)
If I remember correctly the fact about 7 years ago...
when PostgreSQL already supported
-
On Wed, Nov 19, 2003 at 11:16:18PM -0700, [EMAIL PROTECTED] wrote:
> Turning OFF AUTOCOMMIT as suggested didn't solve the problem.
Sure as it is OFF by default. You have to turn it ON.
Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber
On Wednesday 26 November 2003 09:02, cnliou wrote:
> [QUOTE]
> Note: When timestamp values are stored as double precision
> floating-point numbers (currently the default), the
> effective limit of precision may be less than 6. timestamp
> values are stored as seconds since 2000-01-01, and
> microse
Am 21.11.2003 um 06:54 schrieb Tom Lane:
Martin Hampl <[EMAIL PROTECTED]> writes:
Index Scan using word_lower_idx on token (cost=0.00..98814.08
rows=25382 width=16)
Index Cond: (lower((word)::text) = 'saxophone'::text)
The rows estimate (and therefore also the cost estimate) is a complete
g
How does the performance compare using models mimicked from Oracle? Is
there any information anywhere on that?
Marek Lewczuk wrote:
Użytkownik Robert Treat napisał:
On Tue, 2003-11-25 at 08:07, Marek Lewczuk wrote:
Yes. I think the gist of your post was "out of the box postgresql
performed like
I was wondering if there is something I can do that would act similar to
a index over more than one table.
I have about 3 million people in my DB at the moment, they all have
roles, and many of them have more than one name.
for example, a Judge will only have one name, but a Litigant could have
Hello list
I have two tables with identical structure, one holds 'correct' data (from
an application standpoint) and the other has data 'in error'. Anyway, I need
sometimes to query both tables at the same time, so I constructed an
elementary view
create view v1 as select * from t1 union select *
Hmm, what about
create view v1 as
select *,1 as source from t1
union
select *,2 as source from t2;
>Hello list
>
>I have two tables with identical structure, one holds 'correct' data
(from
>an application standpoint) and the other has data 'in error'. Anyway, I
>need
>
Baldur Norddahl <[EMAIL PROTECTED]> writes:
> It really sucks that inheritance breaks their parent tables constraints :-(.
Yeah, we know :-(. Sooner or later someone will work out a solution
to that.
Thanks for following up to close out this open issue.
regards, tom lane
OK I am still trying to get pam working
here is the messages I have is the log from trying to log in
Nov 26 08:55:16 localhost postgresql(pam_unix)[22693]: authentication failure;
logname= uid=26 euid=26 tty= ruser= rhost= user=cherring
Nov 26 08:55:16 localhost pam_winbind[22693]: user 'cher
sorry for teh double posting I forgot the steps at the end
OK I am still trying to get pam working
here is the messages I have is the log from trying to log in
Nov 26 08:55:16 localhost postgresql(pam_unix)[22693]: authentication failure;
logname= uid=26 euid=26 tty= ruser= rhost= user=cherrin
Randolf Richardson <[EMAIL PROTECTED]> writes:
>>> How can I create an index on an array element?
>>
>> You need 7.4 and an extra layer of parentheses:
>>
>> create index foodex on foo ((textarray[3]));
> Sorry, but this isn't obvious to me as arrays in a database are a new
> concept for
Base-two artihmetic sounds pretty broad. If only you could come up with a
scheme for division and multiplication by powers of two through
bitshifting.
On Wed, 26 Nov 2003, Tom Lane wrote:
> Randolf Richardson <[EMAIL PROTECTED]> writes:
> >> They've managed to patent ye olde elevator algorith
Please remember:
- OIDs are NOT unique
- CTIDs are unique but not constant
- SERIALs are unique and forever
On Wed, Nov 26, 2003 at 10:39:43AM -0600, James Thompson wrote:
>
> I think oid is what you want.
>
> select oid,* from table;
>
> Take Care,
> James
>
> On Wed, 26 Nov 2003, Barbara Li
We are evaluating Postgres and would like some input about disaster recovery. I know
in MsSQL they have a feature called transactional
logs that would enable a database to be put back together based off those logs. Does
Postgres do anything like this? I saw in the documentation
transactional l
On Tue, 2003-11-25 at 16:58, Randolf Richardson wrote:
> [sNip]
> >> In summary, you could be charging them for some very expensive courier
> >> services, if for which they don't pay then you won't deliver. =)
> >
> > Of course a competitor could purchase a copy or get it from a customer
> > and
Jason,
it seems you are unfamiliar with the basic rules of user support. If you
try to filter as much as possible and only post the tiny snippets of
information "you" think are important, the chances that someone else
finds the point you overlooked are close to none.
Please post a comprehensiv
Clinging to sanity, Randolf Richardson <[EMAIL PROTECTED]> mumbled into her beard:
> Aside from that, I don't see how the individual actions of one
> organization that has been charging for open source software can
> possibly reflect on all those projects which are totally free
It most certainly w
>> Aside from that, I don't see how the individual actions of one
>> organization that has been charging for open source software can
>> possibly reflect on all those projects which are totally free
>
> It most certainly would, in InfoWeek, and other such "sources of
> journalism" which happen to
Cross-posted to "comp.databases.postgresql.advocacy" because
PostgreSQL could be very helpful to MySQL DBAs who wish to optimize their
databases -- just convert it to PostgreSQL on a test system and use EXPLAIN
and ANALYZE to identify the weaknesses.
Even if these MySQL DBAs don
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
This is a PGP-signed copy of the checksums for PostgreSQL version 7.4.
The latest copy of the checksums for this and other versions, as well
as information on how to verify the files you download for yourself,
can be found at:
http://www.gtsm
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> Is there something in Postgres that corresponds to the rowid
> pseudocolumn in Oracle, which represents the unique address of the
> row of data in the table? If so, how would you access that
> in a query?
> ...
> so what do you have to do to cre
> Please post a comprehensive description of what you're trying to do
> together with the configuration files you use.
I thought I did that sorry. I am trying to get Postgres to authenticate through Pam
so I can authenticate to Active
Directory on our network. All the steps I took are posted b
Jason Tesser wrote:
We are evaluating Postgres and would like some input about disaster recovery.
I'm going to try to communicate what I understand, and other list
members can correct me at their selected level of vehemence :)
Please send corrections to the list - I may take days to post follow-up
Alex Satrapa <[EMAIL PROTECTED]> writes:
> 1) Under Linux, if you have the file system containing the WAL mounted
> with asynchronous writes, "all bets are off". The *BSD crowd (that I
> know of) take great pleasure in constantly reminding me that if the
> power fails, my file system will be in an
Happy Thanksgiving to everyone!
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com
Mammoth PostgreSQL Replicato
Ben wrote:
> Base-two artihmetic sounds pretty broad. If only you could come up with a
> scheme for division and multiplication by powers of two through
> bitshifting.
I already have that patent! :-)
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED]
[EMAIL PROTECTED] writes:
> The problem is that the oid column has no "unique" constraint ...
unless you add one, viz:
create unique index mytable_oids on mytable (oid);
which is de rigueur for any table you intend to rely on OID as an
identifier for. The index is needed not only to ens
Alex Satrapa wrote:
> Some caveats though:
> 1) Under Linux, if you have the file system containing the WAL mounted
> with asynchronous writes, "all bets are off". The *BSD crowd (that I
> know of) take great pleasure in constantly reminding me that if the
> power fails, my file system will be i
Doug McNaught <[EMAIL PROTECTED]> writes:
> Alex Satrapa <[EMAIL PROTECTED]> writes:
>> 1) Under Linux, if you have the file system containing the WAL mounted
>> with asynchronous writes, "all bets are off".
> ...
> Even with ext2, WAL files are preallocated and PG calls fsync() after
> writing, so
Hi All;
I may be able to do this in Perl, but if there is enough interest in doing
something like this in C, maybe I can still help (however, consider your
self warned about my skill at coding C).
I am looking at the following design. The clustering daemon either need to
run on separate computer
Hi all;Since we are on the
topic of what prompted us to use PostgreSQL, I figured Iwould share my
experiences as well, and some additional thoughts that I had.I chose
PostgreSQL about 2 years ago when I realized that the application Iwas
building needed something more robust than MySQL. I fo
38 matches
Mail list logo
