I had tomatoes on my eyes. I wrote laufverke but meant laufwerke.
Sorry.
-- Forwarded message --
Date: Mon, 12 Jul 2004 15:03:14 +0200 (CEST)
From: Holger Marzen <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: cannot access or delete view
Hi all,
I installed PostgreSQL
Hi all,
I installed PostgreSQL 7.4.2 from backports.org and all went fine. Then
I did as user postgres:
create view v_laufverke
as
select
distinct
bg.mandant as v_mandant,
bg.benutzer as v_benutzer,
l.laufwerk as v_laufwerk,
l.pfad as v_pfad,
l.benutzer as v_login_benutzer,
l.kennwort
Hi all,
if I have something like this:
SELECT column1,
(... complicated subselect ...),
column1 - (... same subselect as above ...)
FROM table1;
do I really have to rewrite the subselect a 2nd time if I need that
result in another column's expression?
---(e
On Thu, 8 Jan 2004, Tom Lane wrote:
> Holger Marzen <[EMAIL PROTECTED]> writes:
> > When I try to compile PostgreSQL 7.2.4 or 7.4.1 then I get
>
> > |gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations
> > |-I../../../src/include -D_GNU_SOURCE -c hba.c -o
On Fri, 7 Nov 2003, Edwin Quijada wrote:
> I am trying running up using
> pg_ctl -D /data/dir -l logfile
>
>
> This is the last 100 lines from log
>
> The server must be started under an unprivileged user id to prevent
> a possible system security compromise. See the documentation for
> more inf
On Tue, 21 Oct 2003, Markus Wollny wrote:
> Hi!
>
> > -Ursprüngliche Nachricht-
> > Von: Shridhar Daithankar [mailto:[EMAIL PROTECTED]
> > Gesendet: Dienstag, 21. Oktober 2003 08:08
> > An: [EMAIL PROTECTED]
> > Betreff: Re: [GENERAL] Recomended FS
>
> > Can you compare ogbench results for
On Fri, 17 Oct 2003, Nick Burrett wrote:
> > It would be worth revisiting this and trying to understand where the
> > performance problem is, rather than just assuming that you have to work
> > around it.
>
> Luckily my CVS tree has such information. Basically this database holds
> samples of the
On Mon, 6 Oct 2003, CSN wrote:
> Every now and then my connection to my remote server
> will disconnect. If I was using the psql commandline,
> "ps" will show it's still running (after I log back
> on). Is there a way to get access to the running psql
> process again, or cause it to disconnect and
On Sat, 27 Sep 2003, David Griffiths wrote:
>
> We are doing some performance testing among various databases (Oracle, MySQL
> and Postgres).
>
> One of the queries is showing Postgres lagging quite a bit:
>
> SELECT count(*)
> FROM commercial_entity, country, user_account, address_list
> LEFT JOI
Say, we have uptimes from several servers:
Server up_from up_to
-- --- ---
s1 0:00 8:00
s1 10:0020:00
s1 22:0024:00 (would better be a timestamp with 0:00 and next day)
s2 0:00 4:00
s2 6:00 23:00
Now we want to ge
Hi all,
for a long time I am using mod_auth_pgsql for Apache 1.3. But I always
wished that I could limit the number of attempts, so no-one can try as
often as he wants to.
Unfortunately the author of mod_auth_pgsql didn't answer, so I had to do
it by myself. But I didn't want to make major change
How can I list defined triggers on PostgreSQL 7.1.3?
--
PGP/GPG Key-ID:
http://blackhole.pca.dfn.de:11371/pks/lookup?op=get&search=0xB5A1AFE1
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Thu, 26 Jun 2003, Stephan Szabo wrote:
> On Fri, 27 Jun 2003, Holger Marzen wrote:
>
> > In 7.1.3 I can use
> >
> > select timestamp(date '2001-01-01', time '00:00');
> >
> > but in 7.2.4 I get
> >
> > db1=# select tim
In 7.1.3 I can use
select timestamp(date '2001-01-01', time '00:00');
but in 7.2.4 I get
db1=# select timestamp(date '2001-01-01', time '00:00');
ERROR: parser: parse error at or near "date"
I get the same error when using actual columns in actual tables. Both
PostgreSQL versions are com
14 matches
Mail list logo
