Not sure if this was answered.I've been rather quick with the delete key
lately (oops).
I'm replying from memory, I went through the exercise a while back and I
can't find my notes. It sounds like you have not initialised the
PostgreSQL database directory. You need to run the "initdb" command. Do
Chris Carbaugh wrote:
>
> Havn't got any responses yet though. Has anybody installed under RH6.1?
I have installed successfully under rh6.1. What's seems to be wrong?
Just wanted to apoligize for this message.
Not only did I post it 3 times (the message kept bouncing back to me, so
I didn't think it was going through), but I also posted it to the wrong
list.
I have reposted to the Admin list.
Havn't got any responses yet though. Has anybody installed under R
This is a follow up to my previous question about this
subject.
I found out there are existing tables that hold all of
the info about a database. All of them begin with
'pg_'
(ie 'pg_tables'). You can use all of these tables in
combination to get the data you need about your
database. I have come
Hi,
Im very new to this list please excuse me if ive posted to the wrong place.
I was just wondering if postgresql has support for SMP/threads ?
I was also wondering how scalable it is ?
At work we are considering whether to switch to oracle or continue with
postgresql.
We currently use postgresq
Mark Jewiss writes:
> What I want to be able to do is store details of every transaction that is
> made against a database to a log file.
This is planned for 7.1. Right now there's no easy way.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 7526
select
raw.ipaddress,
formatted.ipaddress
from
raw ,
formatted
where
raw.stat_date < '2000-02-26 02:00:24-08'
AND
formatted > '2000-02-26 02:00:24-08'::datetime - '24 hour'::timespan
AND
raw.ipaddress = formatted.ipaddress;
gives this:
NOTICE: unknown node tag 704 in f
Peter Eisentraut wrote:
>
> Patrik Hall writes:
>
> > I am in need of median, quartile and percentile functions in postgres.
> >
> > Has anybody implemented any of them allready?
>
> Haven't heard, but if you can come up with a way to calculate them with a
> single pass over the data rows (keep
Thanks to all for the great responses. Foreign keys do seem to be the way to
go. That would be my luck to pick a data type for a table name...this type
seems a bit obscure--I wasn't able to find any documentation on it. Does
anyone know what it is for?
Thanks,
-Jason
Ed Loehr <[EMAIL PRO
G. Anthony Reina writes:
> It's interesting that "select target, avg(reaction_time) from data_table
> GROUP BY target;" works but not "select target, avg(reaction_time) from
> data_table;".
>
> Doesn't the parser automatically group by the first variable returned?
The parser really doesn't know
Patrik Hall writes:
> I am in need of median, quartile and percentile functions in postgres.
>
> Has anybody implemented any of them allready?
Haven't heard, but if you can come up with a way to calculate them with a
single pass over the data rows (keeping several state variables, if
necessary)
Jason Vasquez writes:
> PostgreSQL lets me create the class myItem with a "acl" field type, but I
> can't figure out how to insert multiple values (or any values!) into the
> access_control field...
This seems to be a remnant of the highly praised "object-relational"
features once present in Pos
Chris Jones schrieb:
> I'm currently getting this error on my nightly vacuum. These two
> indices (as you may have guessed already) are on columns named
> interface and ewhen, on a table named error. The error table is
> constantly being updated. (No comments about the implications of
> that,
Hi,
Am I correct in impression that the only way you can store binary data
(meaning data that could have all control characters including \0 in it)
is using Large Objects interface? I have tried bytea and text, both
truncate string on receipt of \0...
Also, what's physical storage size of a LOB?
14 matches
Mail list logo
