> 1. What is your favorite GUI tool for PostgreSQL?
Just psql in an emacs window.
Emacs lets me see large result sets, and keep a history of my commands.
> 2. In your organization, do you have someone who works as full time
> PostgreSQL DBA?
Our Oracle DBA is also the DBA for our production Pos
Hi Robert,
I admit your opinion. But I thought it could be a kind of service just for
convenience.
On the other hand there are a lot of commands in the PostgreSQL language
which does not appear in the original SQL standard.
Despite I think almost everybody find them very useful. So I would not say
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Mon, Jul 14, 2003 at 04:10:15PM -0600, Kathy Zhu wrote:
>> The question is, is it ok to fail this regression test since I do change
>> the NAMEDATALEN ???
> AFAICS this is testing the ability to correctly truncate the identifier
> length to 31
Updated my RH80 installation with the full complement of Postgres 7.3.3 RPMs.
Added python and tcl ( already have pl/sql) language bindings to the database
without issue. However, the compiler complains about perl:
ERROR: Load of file /usr/lib/pgsql/plperl.so failed: libperl.so: cannot open
shar
On Mon, Jul 14, 2003 at 04:10:15PM -0600, Kathy Zhu wrote:
> parallel group (13 tests): float8 boolean float4 oid int4 int8 char int2 name t
> ext varchar bit numeric
> boolean ... ok
> char ... ok
> name ... FAILED
>
>
> I am attachin
The demo on the hermes website is not working. I tried to login with
the demo username and password and got this:
Warning: Access denied for user: '[EMAIL PROTECTED]'
(Using password: YES) in
/home/groups/h/he/hermesweb/htdocs/demo/hermes/DBAL_mysql-1.0.0-b.php on
line 40
Warning: MySQL Connecti
On Mon, 2003-07-14 at 17:13, Jay O'Connor wrote:
> What impact in performance does vacuum have on an active database? I'm
> being asked about this...or rather...someone is questioning the use of
> postgresql because of this
There is no easy answer to this question, other than if you vacuum
approp
Hi;
Hermes is the foundation for CRM and ERP tools for business processes
such as field service automation, sales force automation, contact
management and some scheduling tasks as well. It supports both MySQL
(mostly) and PostgreSQL (fully).
The 0.1.0 release will be suitable for small consul
On 14 Jul 2003 at 20:55, Ron Johnson wrote:
> On Mon, 2003-07-14 at 17:44, Dan Langille wrote:
> > On 14 Jul 2003 at 15:16, Terence Chang wrote:
> >
> > > Hi all:
> [snip]
> >
> > Stored procedures is one reason I moved http://www.FreshPorts.org/
> > from MySQL to PostgreSQL.
>
> Oh, the shame!
I have been working with various databases since the 80's.
Terence Chang wrote:
Hi all:
I am new to PostgreSQL DB, however I have years experience with Oracle 8i
and MS SQL. I am in the process to promot PostgreSQL to my future client,
due to the cost. I am just wondering if overall people feels
On Mon, 2003-07-14 at 17:44, Dan Langille wrote:
> On 14 Jul 2003 at 15:16, Terence Chang wrote:
>
> > Hi all:
[snip]
>
> Stored procedures is one reason I moved http://www.FreshPorts.org/
> from MySQL to PostgreSQL.
Oh, the shame! Advertising AOL For Broadband on a FreeBSD ports
site?
--
+--
--- Terence Chang <[EMAIL PROTECTED]> wrote:
> I have the following questions. Please reply me
> offline, so the mailling
> list won't get flood. Thanks!
But if they don't read it, they can't correct me!
;-)
> 1. What is your favorite GUI tool for PostgreSQL?
I create apps using MS Access as the
I think I figured out what went wrong.
regression.diffs is created by compareing src/test/regress/expect/name.out with
src/test/regress/results/name.out.
Since expected/name.out comes with the jar, so any changes I made won't be
reflected in the that file.
Now the question is, is there a way
On 14 Jul 2003 at 15:16, Terence Chang wrote:
> Hi all:
>
> I am new to PostgreSQL DB, however I have years experience with Oracle
> 8i and MS SQL. I am in the process to promot PostgreSQL to my future
> client, due to the cost. I am just wondering if overall people feels
> frustrated with Postgr
On Mon, 2003-07-14 at 04:07, Csaba Nagy wrote:
[snip]
> This feature is often requested because it's very useful, especially in
Amen! Give the app developer the opportunity to travel down a different
code path if s/he tries, for example, to insert a duplicate key.
[snip]
> The main reason why th
Elein,
actually I do not store my source in a cvs or anything similar.
Yes, you are absolutally right I should but I'm allways busy and
do not have the time to deal enought with these nice softwares.
But I think my problem is not about this. I have the latest
source code in a separate file so I ca
This has been discussed for many times on this list, but shortly: when
inserting a new row, there's no previous row to select for update. If
you have 2 concurrent transactions, both of them can execute the select
for update at the same time, select nothing, and then try to insert the
same key, and
On 14 Jul 2003 at 19:32, Peter Moscatt wrote:
> I have just installed postgresql from the RPMs on the MD dist CDs - all
> went to plan.
>
> I can manually start the server using: pg_ctl start -l -D
> /usr/local/pgsql/data.
You should place a logfile name after -l option. See if that log file get
Ok - discovered the solution in pgsql-php, repeated below for reference:
From: "Peter De Muer (Work)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Re: 7.3.1 update gives PHP libpq.so.2 problem
Date: Tue, 4 Feb 2003 14:06:04 +0100
try making a soft
On Mon, 14 Jul 2003, Alvaro Herrera wrote:
> On Mon, Jul 14, 2003 at 12:54:55AM -0500, Ron Johnson wrote:
>
> > SQL is only one possible relational query language. It didn't
> > become de facto standard until the mid- to late-80s.
> >
> > It is an outgrowth of SEQEL (Structured English QuEry
Hi
On 14 Jul 2003, Peter Moscatt wrote:
> I can manually start the server using: pg_ctl start -l -D
> /usr/local/pgsql/data.
>
> But when I put this line in the: /etc/rc.d/rc.local file then check the
> boot.log file to see if it's loading - I see this is not the case.
AFAIK you should write
I have just installed postgresql from the RPMs on the MD dist CDs - all
went to plan.
I can manually start the server using: pg_ctl start -l -D
/usr/local/pgsql/data.
But when I put this line in the: /etc/rc.d/rc.local file then check the
boot.log file to see if it's loading - I see this is not t
On 14 Jul 2003 at 5:18, Mike Mascari wrote:
> I agree. However a common scenario that has appeared on these lists is
> a request for an atomic 'CREATE IF NOT EXISTS, ELSE REPLACE' without
> race conditions. Because Oracle doesn't rollback the transaction, it
> is implementable in SQL. For PostgreS
Peter Childs wrote:
> On Mon, 14 Jul 2003, Mike Mascari wrote:
>
>>Jörg Schulz wrote:
>>
>>Presumably Oracle is not rolling back a duplicate key violation,
>>allowing the transaction to continue. This is an often requested
>>feature not present in PostgreSQL.
>
>
> Bug. Not Feature
>
>
On Mon, 2003-07-14 at 10:43, Peter Childs wrote:
> On Mon, 14 Jul 2003, Mike Mascari wrote:
>
> > Jörg Schulz wrote:
> >
> > >>... I have this feeling the reason Oracle gives this result may
> > >>be again because transactions have been switched off!
> > >
> > > This snippet comes from the Oracl
Oracle does not roll back any transaction unless explicitly requested by
the client application. If there are errors while executing statements
inside a transaction, their effect is rolled back, not the whole
transaction. The application can then decide if the successful part of
the transaction is
Hi,
I'm having trouble with libpg.so.2.
Specifically:
Can't load '/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/
Pg/Pg.so' for module Pg: libpq.so.2: cannot open shared object file: No
such file or directory at /usr/lib/perl5/5.8.0/i386-linux-thread-multi/
DynaLoader.pm line 229.
I
This was executed via sql+ on an Oracle 9i installation:
SQL> select 1 from dual where 1 in (1,2,null);
1
--
1
SQL> select 1 from dual where 1 in (null);
no rows selected
I would say the Oracle implementation is correct and the same as in
Postgres. For your problem I
On Mon, 14 Jul 2003, Mike Mascari wrote:
> Jörg Schulz wrote:
>
> >>... I have this feeling the reason Oracle gives this result may
> >>be again because transactions have been switched off!
> >
> > This snippet comes from the Oracle console:
> > (table name is "a" not "test" / messages are in ge
Jörg Schulz wrote:
>>... I have this feeling the reason Oracle gives this result may
>>be again because transactions have been switched off!
>
> This snippet comes from the Oracle console:
> (table name is "a" not "test" / messages are in german)
>
...
> SQL> select * from a;
>
> A
>
> ... I have this feeling the reason Oracle gives this result may
> be again because transactions have been switched off!
This snippet comes from the Oracle console:
(table name is "a" not "test" / messages are in german)
SQL> show autocommit;
autocommit OFF
SQL> select * from a;
A
This worked for me...
./configure --with-libs=/sw/lib --with-includes=/sw/include
> After reading this:
>
> http://marc.theaimsgroup.com/?l=postgresql-general&m=103886532224699&w=2
>
> It looks like some of you out there have successfully installed
> postgresql on OS X with readline support.
On Mon, 14 Jul 2003, Jörg Schulz wrote:
> Suppose the following:
>
> create table test (a int primary key);
> insert into test values (1);
>
> select * from test;
> a
> =
> 1
>
> In Postgresql if you do the following in a transaction (either with
> autocommit=off or with an explizit begin):
>
Um, the behaviour you are seeing is what would happen in PostgreSQL if
everything were all in one transaction. What you show for Oracle is what
would happen if each statement were in it's own transaction.
On the postgresql server here, without transactions:
create temp table test (a int primary k
> Standard issue. When you specify an unquoted number in a query it's
> interpreted as an int4 which doesn't match your indexes. Suggestions are:
>
> - Put quotes around your numbers or eg. '1'
> - Cast them to the right type eg. 1::bigint
Huh, yeah, I remember now reading about this. T
Suppose the following:
create table test (a int primary key);
insert into test values (1);
select * from test;
a
=
1
In Postgresql if you do the following in a transaction (either with
autocommit=off or with an explizit begin):
insert into test values (2); -> ok
insert into test values (1); ->
On Sun, 13 Jul 2003, Vincent Hikida wrote:
> Oops forgot to cc the list.
>
> > Unfortunately, intra-row functions using nulls return nulls. Inter-row
> > functions "usually" ignore the nulls. I think there may be a few
> exceptions.
> > Though there is a relational theory which has is rigorously
37 matches
Mail list logo
