On Mon, Jul 22, 2002 at 05:41:39PM -0700, Josh Berkus wrote:
>
> I tried to install Tora, but the build blew up since I don't have Oracle
> installed. Any tips?
I just use the Debian packages (/me hugs Debian).
AFAIK, all you have to do is compile with the appropriate flags so it
doesn't try
Roberto,
> Tora (tora.sf.net) has PL/SQL editing and supports PostgreSQL. Since
> Pl/pgSQL is very similar to PL/SQL, you can use Tora for PL/pgSQL editing
> very nicely.
>
> Tora is an overall very nice database administration tool. I use it with
> my Oracle and PostgreSQL installations all th
On Mon, Jul 22, 2002 at 09:36:54AM -0300, Elielson Fontanezi wrote:
> Hello Folks!
>
>
> Maybe every DBA knows that there is a good shareware to editing
> Oracle PL/SQL programs
> named PL/SQL Developer.
> I'd like to know if someone knows something near to this software
> for Postgr
On Mon, Jul 22, 2002 at 04:09:21PM -0400, James Orr wrote:
> On Monday 22 July 2002 12:27 pm, Josh Berkus wrote:
>
> > Me, I use Kate, an MDI text editor from the KDE crew, and CVS for
> > version control. Thanks, KDE guys!But, after 3 years of Postgres,
> > I'm pretty fluent in PL/pgSQL.
James,
> How do you use CVS on your database? I recently started doing this, and i'm
> wondering how other people handle it.
>
> Basically I create a sql folder with three sub-folders tables, views and
> functions. I have a file for each table in tables, each view in views and
for
> each t
On Monday 22 July 2002 12:27 pm, Josh Berkus wrote:
> Me, I use Kate, an MDI text editor from the KDE crew, and CVS for
> version control. Thanks, KDE guys!But, after 3 years of Postgres,
> I'm pretty fluent in PL/pgSQL. I even double-quote without thinking
> about it.
How do you use CVS
hi - i recently upgraded my server from 7.1.2 to 7.2.1 and now one of my
apps is no longer functioning. this is the query:
SELECT DISTINCT rate, sum(extract(epoch from interval (end_time -
start_time)))/3600) AS duration
FROM log
WHERE invoice_state='8'
GROUP BY rate HAV
From: "Jinn Koriech" <[EMAIL PROTECTED]> wrote:
> hi - i recently upgraded my server from 7.1.2 to 7.2.1 and now one of my
> apps is no longer functioning. this is the query:
>
> SELECT DISTINCT rate, sum(extract(epoch from interval (end_time -
> start_time)))/3600) AS duration
> FROM lo
Rudi Starcevic wrote:
>
> Hi Folks,
>
> I have an ecommerce application I'm writing and I'm not sure / undecided
> on a
> particular way to store shipping rates in PostgreSQL
>
> In this application a user may set the shipping rate per item.
>
> So I have 3 fields - local,state and internation
hi - i recently upgraded my server from 7.1.2 to 7.2.1 and now one of my
apps is no longer functioning. this is the query:
SELECT DISTINCT rate, sum(extract(epoch from interval (end_time -
start_time)))/3600) AS duration
FROM log
WHERE invoice_state='8'
GROUP BY rate HA
Hi.
See Aubit-4GL a full compatible 4GL compiler which may access Informix
and Postgress Database.
See more about this at http://aubit4gl.sourceforge.net/index.html
Enjoy it and feedback please...
---(end of broadcast)---
TIP 1: subscribe and uns
Elielson,
> Maybe every DBA knows that there is a good shareware to editing
> Oracle PL/SQL programs
> named PL/SQL Developer.
> I'd like to know if someone knows something near to this software
> for Postgres pgSQL.
No such program, currently.
PGAccess, slated for re-release with a overhaul
> CREATE SEQUENCE conn_id_seq;
> CREATE TABLE conn (
> id INTEGER NOT NULL DEFAULT nextval('conn_id_seq'),
> name VARCHAR(40),
> CONSTRAINT conn_friend_fkey FOREIGN KEY(name)
>REFERENCES friend(name)
>ON UPDATE CASCADE
>ON DELETE RESTRICT
I believe we interpreted restrict as being
Hi,
Right after installting postgres 7.2.1 (from release source) and reading
some chapters of Bruce Momjian's great book I started to play around with a
test database. Now I have a question concerning deferred constraint
checking.
I am new to transactional SQL, so I don't really know, if this sho
Couldn't find any mention of this anywhere. Anyone any idea what it means? A
db stop/start seems to have cured it.
postgres@judas:~$ psql master
psql: FATAL 1: fixrdesc: no pg_class entry for pg_class
postgres@judas:~$ psql -V
psql (PostgreSQL) 7.2.1
contains support for: readline, history, mul
On Sun, Jul 21, 2002 at 10:11:25 +1000,
mark carew <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> Can somebody direct me to a list of the above. Would be nice to know in
> advance of its release.
You can read the development docs. If you follow the developers link on
any of the mirrors you can f
Hello Folks!
Maybe every DBA knows that there is a good shareware to editing
Oracle PL/SQL programs
named PL/SQL Developer.
I'd like to know if someone knows something near to this software
for Postgres pgSQL.
Thanks!
Elielson,
---(end
On Fri, 19 Jul 2002, Tom Lane wrote:
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
> > Agreed. Absolutely. But, since the SQL standard says upper case,
> > wouldn't it be useful to at least have a switch (run time, initdb time,
> > or ./configure time???) called something like FOLDTOUPPER (in
Hi...
anyone knows a workaround for Oracle "no wait" Option in "SELECT ... FOR
UPDATE"?
I wrote a programm which runs twice. Both poll the pgsql database all 5
seconds and make an "SELECT ... FOR UPDATE" for the first row found.
After some work and commit the next row is processed.
The second t
On Fri, 19 Jul 2002, Bruce Momjian wrote:
> scott.marlowe wrote:
> > On Fri, 19 Jul 2002, Tom Lane wrote:
> >
> > > [EMAIL PROTECTED] writes:
> > > > But anyway this is not so important, but why upper cases are bad ?
> > >
> > > It's well established that all-lower-case text is more readable th
Hi...
anyone knows a workaround for Oracle "no wait" Option in "SELECT ... FOR
UPDATE"?
I wrote a programm which runs twice. Both poll the pgsql database all 5
seconds and make an "SELECT ... FOR UPDATE" for the first row found.
After some work and commit the next row is processed. The second t
Hi All,
Can somebody direct me to a list of the above. Would be nice to know in
advance of its release.
Regards Mark
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
On Fri, 19 Jul 2002, Tom Lane wrote:
> [EMAIL PROTECTED] writes:
> > But anyway this is not so important, but why upper cases are bad ?
>
> It's well established that all-lower-case text is more readable than
> all-upper-case ...
Agreed. Absolutely. But, since the SQL standard says upper cas
On Tue, Jul 09, 2002 at 10:36:17AM +0200, David BOURIAUD wrote:
> Field group | count of D | count of R | count of X.
if you want this that way, i suggest using subselects.
like:
select
distinct field_group,
(select count(*) from table t2 where t2.field_group = t1.field_group and
24 matches
Mail list logo
