Hi,
On 6/13/05, Zlatko Matić <[EMAIL PROTECTED]> wrote:
> I want to create VBA procedure that compares value in text box with actual
> password to determine if it is the same. As the password is encrypted (md5)
> I can't read it from pg_shaddow system table. How to retrieve decrypted
> value from
On Sun, Jun 12, 2005 at 23:03:35 +0100,
Simon Windsor <[EMAIL PROTECTED]> wrote:
>
> Has a roadmap and timescale been released for Postgres 8.1?
Feature freeze will be July 1. Expect a beta about 1 month after that
(based on past experience). The date of the release is highly variable,
but will
> Am Sonntag, den 12.06.2005, 17:59 +0900 schrieb Tatsuo Ishii:
> > > For the contents too. I dont think the source code installation
> > > should be so much in the focus of the certification.
> >
> > Since PostgreSQL is an open source database, I think it is important
> > to understand how to ins
Check out EnterprisDB: www.enterprisedb.com
Chris
Edward Peschko wrote:
hey all,
I'm trying to convince some people here to adopt either mysql or postgresql
as a relational database here.. However, we can't start from a clean slate;
we have a very mature oracle database that applications poi
Hi
Has a roadmap and timescale been released for Postgres 8.1?
All the best
Simon
Simon Windsor
Eml: [EMAIL PROTECTED]
Tel: 01454 617689
Mob: 07960 321599
I am using (or was planning on - now having second thoughts) postgres 8.0.3
for windows for a database paper I have to do at university.
I tried installing it on linux and having it talk through samba / ODBC to MS
Access on windows, but his was a bit beyond my knowledge. So I took my
tutors advi
i had the exact same thing using the same scenario but with pg 8.0.3
installed on the same win XP pro machine.
The strange thing is when I closed the table and opened it again, all the
fields containing #deleted then showed up with the values I actually input.
So i'm thinking theres some bug in r
Am Sonntag, den 12.06.2005, 23:12 +0200 schrieb Zlatko Matić:
> How could I retrieve information about actual user password, if md5
> method is set in pg_hba.conf ?
> I want to create VBA procedure that compares value in text box with
> actual password to determine if it is the same. As the passwo
Hello.
If we have a database with defined user groups,
users and permissions on database objects, what happens when we backup database
(dump) and try to install on some other server ? Does information about user
groups, users and permissions migrate along with database itself or I need to
How could I retrieve information about actual user
password, if md5 method is set in pg_hba.conf ?
I want to create VBA procedure that compares value
in text box with actual password to determine if it is the same. As the password
is encrypted (md5) I can't read it from pg_shaddow system tab
Well I can't get any better backtraces (even with --enable-debug). The strange
thing is that this just happens once in a while and the process doesn't stop
until it is killed (or postgre is restarted). Any suggestions ?
Regards,
Jernej Kos.
On Sunday 12 of June 2005 18:01, you wrote:
> Jernej K
On Sat, Jun 11, 2005 at 11:31:02AM -0500, Peter Fein wrote:
> Peter Fein wrote:
> > As an uninformed, off-the-wall idea, could one compare snapshots of the
> > system tables to generate these diffs? I know next-to-nothing about
> > these, but it seems like they'd contain the info you'd need.
>
> H
On Sat, Jun 11, 2005 at 02:47:39PM +0100, Russ Brown wrote:
> I'd be extremely happy if somebody finds such a system that is already
> written!
I've never seen such a system, and one is sorely needed. If someone were
to write one that worked well against multiple databases and didn't
cost a fortu
On Mon, Jun 06, 2005 at 12:52:13PM -0700, Edward Peschko wrote:
> In other words, I'm looking to make a postgresql -> Oracle mirroring
> tool, and syncing the databases on a nightly basis, and I was
> wondering if anybody had experience with this sort of thing.
You should take a look at contrib/d
Howard Cole <[EMAIL PROTECTED]> writes:
> Has case sensitivity changed between 8.0.1 and 8.0.3
Nope.
> Results on 8.0.3 windows server (UNICODE)
Unicode doesn't work at all well on Windows. Consider using a different
encoding. Also, you'd better check that you have matching locale and
encoding
"Darrell A. Sullivan, II" <[EMAIL PROTECTED]> writes:
> I was wondering if someone could answer a question about how PostgreSQL uses
> indexes when performing queries. Particularly, I need to know if the query
> optimizer will use more than index for a query or if it only uses one.
Versions throug
Christopher Barbee <[EMAIL PROTECTED]> writes:
> I am trying to get my PowerBook to host a postgres
> server.
> I seem to be h aving troubles with the
> shared-buffers. I have 1G of ram so don't know why
> this is a problem...
OS X has a pretty small default SHMMAX setting. Read the ins
> create table test (val varchar(10));
> insert into test values ('A');
> insert into test values ('a');
> select * from test where val < 'a';
>
> Results on 8.0.1 linux server (UNICODE)
> val
> -
> (0 rows)
>
> Results on 8.0.3 windows server (UNICODE) val
> -
> A
> (1 row)
>
> I am
On Tue, Jun 07, 2005 at 05:46:50PM -0700, Christopher Barbee wrote:
> Hello there,
> I am trying to get my PowerBook to host a postgres
> server.
>
>
> I seem to be h aving troubles with the
> shared-buffers. I have 1G of ram so don't know why
> this is a problem...
>
> Anyone else
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am having problems getting PostgreSQL to work with Ruby On Rails.
On Windows, I cannot get ActiveRecord to recognize the pure ruby
Postgres driver. On linux, it complains about a missing constant
with the compiled postgres driver. I suspect some
hey all,
I'm trying to convince some people here to adopt either mysql or postgresql
as a relational database here.. However, we can't start from a clean slate;
we have a very mature oracle database that applications point to right now,
and so we need a migration path. I went to the mysql folks
I have a server under very light load -- just me doing some work in php.
I am getting this error often and don't know why:
postgresql max connections Unable to connect to PostgreSQL server:
FATAL: Sorry, too many clients already
my orignal postgresql.conf had:
max_connections = 8
We have a postgresql database in Hindi and English.
The records are entered in Hindi as well as in English.
The problem is in the sorting of hindi records when we give
select * from table order by name the hindi sorting is not correct.
For that we had intialised the initdb with en_US.UTF
BTW in Postgresql 8.0 you can do:
ALTER TABLE foo ALTER foo_timestamp TYPE timestamp(0) with timezone;
It'll do the truncation for you.
Regards,
Ben
"Michael Glaesemann" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
> On Jun 10, 2005, at 11:37 AM, Michael Glaesemann wrote:
>
>
[EMAIL PROTECTED] escreveu:
Some comments:
Firebird is a good small database (small resource footprint) that handles
small databases with many users well.
In the hospital I work we have a 4GB database with 50 users connected
running 24/7 (her I stop it 2.5 hours per month)
It doesn't s
Has case sensitivity changed between 8.0.1 and 8.0.3 or am I missing
some setting somewhere?
I try the following sql on two database servers and get different results:
create table test (val varchar(10));
insert into test values ('A');
insert into test values ('a');
select * from test where val
Hello there,
I am trying to get my PowerBook to host a postgres
server.
I seem to be h aving troubles with the
shared-buffers. I have 1G of ram so don't know why
this is a problem...
Anyone else out there using pg8 on Tiger?
Any advice would be appreciated...
Chris
-
Hello,
I am trying out a few databases to determine which one would best suit a
project.
I was wondering if someone could answer a question about how PostgreSQL uses
indexes when performing queries. Particularly, I need to know if the query
optimizer will use more than index for a query or if it
Jernej Kos <[EMAIL PROTECTED]> writes:
> Well there should be no complex queries executed (there are some huge tables,
> but the queries aren't huge or specially complicated). I tried attaching to
> the process via gdb and the process is executing method:
> HeapTupleSatisfiesSnapshot()
> The bac
Well there should be no complex queries executed (there are some huge tables,
but the queries aren't huge or specially complicated). I tried attaching to
the process via gdb and the process is executing method:
HeapTupleSatisfiesSnapshot()
The backtrace appears to be useless (too many ??s). Is
Sean Davis <[EMAIL PROTECTED]> writes:
> I've been noticing some very useful things that are probably already in
> CVS (return_next in pl/perl, IN/OUT parameters, and probably others).
> I don't have a "mission critical" production environment and was
> wondering how unstable a typical 8.1 CVS
Am Sonntag, den 12.06.2005, 17:59 +0900 schrieb Tatsuo Ishii:
> > For the contents too. I dont think the source code installation
> > should be so much in the focus of the certification.
>
> Since PostgreSQL is an open source database, I think it is important
> to understand how to install Postgre
I've been noticing some very useful things that are probably already in
CVS (return_next in pl/perl, IN/OUT parameters, and probably others).
I don't have a "mission critical" production environment and was
wondering how unstable a typical 8.1 CVS checkout is? I'm not talking
about feature-fr
> For the contents too. I dont think the source code installation
> should be so much in the focus of the certification.
Since PostgreSQL is an open source database, I think it is important
to understand how to install PostgreSQL from the source code.
> I wonder how certifications in other langua
Am Sonntag, den 12.06.2005, 14:36 +1000 schrieb CaT:
> On Sun, Jun 12, 2005 at 12:24:30PM +0900, Tatsuo Ishii wrote:
> > Thank you for interested in PostgreSQL CE. There is a sample
> > examination problems page:
> >
> > http://osb.sra.co.jp/postgresql-ce/sys/quiz.php?titleid=S74_en
> >
> > You c
35 matches
Mail list logo