~/.psql_history is everything you typed in psql
On Sat, 02 Apr 2005 01:42:05 +0200, Mauro Bertoli <[EMAIL PROTECTED]>
wrote:
Hi,
I've installed a Postgres 8.0.
There's a history file with all executed queries?
Thanks!
___
Nuovo Yahoo! Messenger: E' molto pià d
Hello!
I want to store some structure like:
CREATE TABLE node
(
nodeid SERIAL PRIMARY KEY,
parent INT REFERENCES node(nodeid)
ON UPDATE CASCADE ON DELETE CASCADE,
label TEXT,
UNIQUE (parent, label),
...
data
...
- Original Message -
From: "_moray" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, March 29, 2005 12:25 PM
Subject: [SQL] a very big table
hullo all,
I have a problem with a table containing a lot of data.
referred tables "inserzionista" and "pubblicazioni" (referenced 2 times)
have resp. 1909
beta_jgw=# update scenario1.time_test set local_hour = extract(hour from
to_timestamp(to_char(gmt_date,'-MM-DD')||'
'||to_char(gmt_hour,'99')||':00:00-00','-MM-DD HH24:MI:SS') at time
zone 'EST');
This sounds like a stupid answer, but shouldn't that be :00:00:00?
On Sun, 3 Apr 2005, Axel Straschil wrote:
Hello!
I want to store some structure like:
CREATE TABLE node
(
nodeid SERIAL PRIMARY KEY,
parent INT REFERENCES node(nodeid)
ON UPDATE CASCADE ON DELETE CASCADE,
label TEXT,
UNIQUE (parent, label)
Hello!
>> I found, http://www.sai.msu.su/~megera/postgres/gist/ltree/ which seems
> what's a problem with ltree ?
I think ltree would be exactly what I need, the Problem ist that I've
got absolutly no Idea how to get that thing into a running Pg 7.4 under
Gentoo and a Pg 7.3 under Fedora?
Is th
On gentoo (at least on my box) it's installed by default in 8.0, I
believe it was installed by default, too, on 7.4.X
On Sun, 03 Apr 2005 19:26:03 +0200, Axel Straschil <[EMAIL PROTECTED]>
wrote:
Hello!
I found, http://www.sai.msu.su/~megera/postgres/gist/ltree/ which seems
what's a problem
Use the ltree datatype !
It's made specifically for this purpose.
http://www.sai.msu.su/~megera/postgres/gist/
On Sun, 03 Apr 2005 12:13:48 +0200, Axel Straschil <[EMAIL PROTECTED]>
wrote:
Hello!
I want to store some structure like:
CREATE TABLE node
(
nodeid SER
On Sun, 3 Apr 2005, Axel Straschil wrote:
Hello!
I found, http://www.sai.msu.su/~megera/postgres/gist/ltree/ which seems
what's a problem with ltree ?
I think ltree would be exactly what I need, the Problem ist that I've
got absolutly no Idea how to get that thing into a running Pg 7.4 under
Gentoo
I'd suggest modifying your query generator to make it smarter :
FROM
pubblicita
LEFT OUTER JOIN materiali ON
(pubblicita.codice_materiale=materiali.codice_materiale)
LEFT OUTER JOIN inserzionisti ON
(pubblicita.codice_inserzionista=inserzionisti.codice_inserzionista)
(snip)
WHERE
Hello!
> I have no experience with those beasts, but what's wrong just untar source,
> configure and compile by hand ?
+ Testing and maybe reinstall all stuff depending on posgressql on that
server every release you want to go with ;-)
Lg,
AXEL.
--
"Aber naja, ich bin eher der Forentyp." Wolfib
Hello!
> On gentoo (at least on my box) it's installed by default in 8.0, I
> believe it was installed by default, too, on 7.4.X
Tried with gentoo just under 7.4.x and 8.0.1:
axel=# CREATE TABLE test ( path ltree);
ERROR: type "ltree" does not exist
Any idea?
Thanks,
AXEL.
--
"Aber n
On Sun, 3 Apr 2005, Axel Straschil wrote:
Hello!
On gentoo (at least on my box) it's installed by default in 8.0, I
believe it was installed by default, too, on 7.4.X
Tried with gentoo just under 7.4.x and 8.0.1:
axel=# CREATE TABLE test ( path ltree);
ERROR: type "ltree" does not exist
An
you need to load ltree into your database !
psql yourdb < ltree.sql
use 'locate ltree.sql' to find if ltree is installed
Yeah, I remember now having to do that, but the binary module definitely
was here without having to do anything besides "emerge postgresql" :
[EMAIL PROTECTED] peufeu $ loca
James G Wilkinson <[EMAIL PROTECTED]> writes:
> I hope that this is some silly beginner's mistake. I have spent quite a bit
> of
> time
> reading the PostgreSQL documentation and cannot find my error. I have also
> scanned the PostgreSQL archive and the web for help, but I have not found
> anyt
Hello!
> psql yourdb < /usr/share/postgresql/contrib/ltree.sql
*STRIKE*, thanks, works perfektyl now!
Lg,
AXEL.
--
"Aber naja, ich bin eher der Forentyp." Wolfibolfi's outing in
http://www.informatik-forum.at/showpost.php?p=206342&postcount=10
---(end of broadcast)---
Hello!
> psql yourdb < /usr/share/postgresql/contrib/ltree.sql
*STRIKE* ... I'm a lucky guy now ;-)
Thanks to all!
Lg,
AXEL.
--
"Aber naja, ich bin eher der Forentyp." Wolfibolfi's outing in
http://www.informatik-forum.at/showpost.php?p=206342&postcount=10
---(end of
PFC <[EMAIL PROTECTED]> writes:
> Here you don't need to LEFT JOIN, you can use a straight simple
> unconstrained join because the rows generated by the LEFT JOINs which have
> NULL in the right columns will be rejected by the WHERE clause anyway :
In recent versions of Postgres, the pla
18 matches
Mail list logo
