> >
> > Is there an existing Postgres group?
>
> Yes.
Humm.. It never hurts to be more popular on the net.
Regards,
Gevik Babakhani
PostgreSQL NL http://www.postgresql.nl
TrueSoftware BV http://www.truesoftware.nl
--
Hi all,
The situation: there are users in one table, and their access statistics
in the other. Now I want to find users whose last access time was more
than one month ago. As I've only had to write quite simple queries
involving no sub-selects so far, I'd like to ask your opinion if this
one scal
Here's one without a subquery, so may be master:
select u.login, s.stop_time
from users as a
inner join stats as s
on s.user_id = u.user_id
where status = '3'
and next_plan_id is null
and stop_time < now() - interval '1 month'
group by u.user_id, u.login, s.stop_time
orde
Hi,
Im trying to disable query statistics from log, and I am unable to do it.
Cannot find the correct option. I have been cheking google, postgres
documentation, i didn't found how to do it so ... I am writting here:
I have my logs full of this info:
[...]
DETAIL: ! system usage stats:
Hello,
I think that I understand basic relational theory but then I had an
idea. What I would like to know if this is sometimes done or that I am
possibly mad... Also, I do not know the terminology for this kind of
thing so I do not know where and what to look for.
Basically, instead of adding f
Hi,
vladimir konrad wrote:
I think that I understand basic relational theory but then I had an
idea. What I would like to know if this is sometimes done or that I am
possibly mad... Also, I do not know the terminology for this kind of
thing so I do not know where and what to look for.
Basically
> Yes, this is known as eg. Entity-Attribute-Value model (cf.
> wikipedia).
Thank you for the pointer and term. This will get me started.
> IMO most times its disadvantages (it can be very hard to write
> performant queries compared to the traditional row based model) weigh
> higher than you gain
Hi Greg, hi Tom,
Am Sonntag, 27. Januar 2008 22:44 schrieb Tom Lane:
> [EMAIL PROTECTED] writes:
> > ok, at the moment i got some traffic and my load is at 1.5. But now with
> > logging the timestamp I have seen that the long durations are quite
> > regular at intervals of 10 minutes.
>
> Well, th
--- vladimir konrad <[EMAIL PROTECTED]> wrote:
> I think that I understand basic relational theory but then I had an
> idea.
> Basically, instead of adding field to a table every time there is a
> need for it, have a table split in two: one holds identity (id) and
> one holds the attributes (li
vladimir konrad <[EMAIL PROTECTED]> wrote:
>
> Hello,
>
> I think that I understand basic relational theory but then I had an
> idea. What I would like to know if this is sometimes done or that I am
> possibly mad... Also, I do not know the terminology for this kind of
> thing so I do not know whe
On Thursday 31 January 2008 07:08, [EMAIL PROTECTED] wrote:
> [Following up on my own message.]
>
>
> Also,
>
> > let
> >
> > us
> >
> > know
> >
> > your
> >
> > wal
> >
> > tunning
> >
> > parameters
> >
> > like
> >
> > commit_delay,
> >
> > fsync.
>
> I haven't done any tuning as of yet. I'm ru
On Feb 2, 2008 5:51 AM, Rubén Rubio <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> Im trying to disable query statistics from log, and I am unable to do it.
> Cannot find the correct option. I have been cheking google, postgres
> documentation, i didn't found how to do it so ... I am writting here:
>
> I h
Hello,
The Kenya National Commission for Human Rights is investigating
the violence in Kenya. This has led to an urgent request on Groklaw
http://www.groklaw.net/article.php?story=20080202013451629
for assistance in setting up a database.
I have suggested that a suite of PostgreSQL based tools
> Basically, you would be creating your own data dictionary (i.e.
> system catalog) on top of the db data dictionary. The database
> already comes with a way to easily add columns: ddl. I have seen
> newbie database designers reinvent this method a hundred times. The
> performance hits and compl
On Jan 31, 2008 8:49 AM, Enrico Sirola <[EMAIL PROTECTED]> wrote:
> I'd create a "previousTime" column and manage it using a trigger.
> Anyway, it depends on the time-dependancy of the table
> Then you can perform "temporal" in a much easier way.
> You could be interested in taking a look at the fo
Hi Webb, Joe, Martijn
Webb Sprague ha scritto:
On Feb 1, 2008 2:31 AM, Enrico Sirola <[EMAIL PROTECTED]> wrote:
Hello,
I'd like to perform linear algebra operations on float4/8 arrays
Having avoided a bunch of real work wondering about linear algebra and
PG, did you consider the Gnu Scientifi
Hi,
This is my first message, and I need some help. I have just installed
Postgresql 8.2. (Windows).
At pgAdmin III Query, when I send SELECT * FROM USUARIOS, I get all
columns correctly. But when I try to get only one column, SELECT senha
FROM USUARIOS, I get the error message:
ERROR: column "se
On Sat, Feb 02, 2008 at 01:38:19PM +0100, Thomas Pundt wrote:
> Hi,
>
> vladimir konrad wrote:
>> I think that I understand basic relational theory but
Clearly, you'll have to revisit that thought.
> [example stripped]
>
> Yes, this is known as eg. Entity-Attribute-Value model (cf.
> wikipedia).
On Sat, 2 Feb 2008 15:43:15 -0200
"Aílsom F. Heringer" <[EMAIL PROTECTED]> wrote:
> Hi,
> This is my first message, and I need some help. I have just installed
> Postgresql 8.2. (Windows).
>
> At pgAdmin III Query, when I send SELECT * FROM USUARIOS, I get all
> columns correctly. But when I try
On 02/02/2008 17:43, Aílsom F. Heringer wrote:
At pgAdmin III Query, when I send SELECT * FROM USUARIOS, I get all
columns correctly. But when I try to get only one column, SELECT senha
FROM USUARIOS, I get the error message:
ERROR: column "senha" does not exist
SQL state: 42703
Character: 8
On lau, 2008-02-02 at 15:43 -0200, Aílsom F. Heringer wrote:
> At pgAdmin III Query, when I send SELECT * FROM USUARIOS, I get all
> columns correctly. But when I try to get only one column, SELECT senha
> FROM USUARIOS, I get the error message:
>
> ERROR: column "senha" does not exist
> SQL stat
On Feb 2, 2008 11:43 AM, Aílsom F. Heringer <[EMAIL PROTECTED]> wrote:
> Hi,
> This is my first message, and I need some help. I have just installed
> Postgresql 8.2. (Windows).
>
> At pgAdmin III Query, when I send SELECT * FROM USUARIOS, I get all
> columns correctly. But when I try to get only o
Bill,
The collumn is defined as "Senha", and I am sending "SELECT Senha FROM
Usuarios".
Below, the table definition from SQL Pane:
CREATE TABLE usuarios
(
"CdUsuario" character(6) NOT NULL,
"NmUsuario" character(15) NOT NULL,
"DtCadastro" timestamp without time zone NOT NULL DEFAULT now(),
Ok. That was the problem. Now SELECT "Senha" FROM USUARIOS is working fine.
But, At an application using ODBC connection I will need to send "Senha" too ?
Aílsom
2008/2/2, Ragnar <[EMAIL PROTECTED]>:
> On lau, 2008-02-02 at 15:43 -0200, Aílsom F. Heringer wrote:
>
> > At pgAdmin III Query, when
On 02/02/2008 17:59, Aílsom F. Heringer wrote:
The collumn is defined as "Senha", and I am sending "SELECT Senha FROM
[]
CREATE TABLE usuarios
(
[]
"Senha" character(10),
[]
There you go - you need to do
select "Senha"
Ray.
--
Lewis Cunningham wrote:
--- vladimir konrad <[EMAIL PROTECTED]> wrote:
I think that I understand basic relational theory but then I had an
idea.
Basically, instead of adding field to a table every time there is a
need for it, have a table split in two: one holds identity (id) and
one holds t
> If you have some part of your app that needs to "select" the list of
> columns in a table you should look at
> http://www.postgresql.org/docs/8.2/interactive/catalogs.html
> particularly pg_class and pg_attribute
Thanks, this could come handy.
Vlad
---(end of broadcast
On Feb 2, 2008, at 6:56 PM, Bill Moran wrote:
preserved that. PostgreSQL is case-sensative, so try matching the
column
name exactly and putting "" around it. If that doesn't work,
provide some
That is just plain incorrect, PostgreSQL is *not* case sensitive. The
real problem here (as Sc
thanks. thought dbi-link could only connect across postgres databases,
didn't realize it can connect postgres AND oracle. will look into it.
jzs
On 1/31/08, Chander Ganesan <[EMAIL PROTECTED]> wrote:
>
> John Smith wrote:
> guys,
> i got geometry in postgres, some other data in oracle. is it pos
"John Smith" <[EMAIL PROTECTED]> writes:
> thanks. thought dbi-link could only connect across postgres databases,
> didn't realize it can connect postgres AND oracle. will look into it.
No, you're confusing it with dblink, which is Postgres-specific.
dbi-link relies on the Perl DBI layer, so it sh
> I'm quite proud, this is my first C extension function ;-)
> I'd gladly post the code if it's ok for the list users. It's more or
> less 100 lines of code. This approach seems promising...
I would definitely like to see it.
> By the way, Webb: I took a look at GSL and it seems to me that, from
David Fetter wrote:
> The math beneath this is that query complexity goes up like O(E!A!V!)
> for Entity, Attribute and Value.
Makes sense.
> The first price, though, and by far the biggest, is that it's
> impossible to maintain any kind of data integrity in such a system, as
> such constraints,
On Saturday 02 February 2008 17:43, Aílsom F. Heringer wrote:
> Hi,
> This is my first message, and I need some help. I have just installed
> Postgresql 8.2. (Windows).
>
> At pgAdmin III Query, when I send SELECT * FROM USUARIOS, I get all
> columns correctly. But when I try to get only one column
On Feb 2, 2008 4:51 PM, Karl O. Pinc <[EMAIL PROTECTED]> wrote:
> Hello,
>
> The Kenya National Commission for Human Rights is investigating
> the violence in Kenya. This has led to an urgent request on Groklaw
> http://www.groklaw.net/article.php?story=20080202013451629
> for assistance in settin
On Thu, 2008-01-24 at 13:10 -0500, John DeSoi wrote:
> . The user/login system is extensible, so you could write your own.
I'm not sure if I follow:
Are you suggestion that the CMS system, Drupal, is an example of an
application server model because of its framework extension?
~BAS
IMPORTAN
Don't even bother trying to tune zfs untill after you've tuned postgres,
otherwise your wasting your time.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
As it turns out, I think the ZFS-on-RAID setup I had is the problem[1]. After
running some more I/O tests w
"PostgreSQL 8.2.4 on i386-pc-linux-gnu, compiled by GCC i386-pc-linux-gnu-gcc
(GCC) 4.1.1 (Gentoo 4.1.1)"
I am creating a temporary sequence in a function and it seems like it is not
going away after the function finishes.
The front end is in MS Access 2000 and I have a single connection. When
On Feb 3, 2008 1:39 AM, Sim Zacks <[EMAIL PROTECTED]> wrote:
> "PostgreSQL 8.2.4 on i386-pc-linux-gnu, compiled by GCC i386-pc-linux-gnu-gcc
> (GCC) 4.1.1 (Gentoo 4.1.1)"
>
> I am creating a temporary sequence in a function and it seems like it is not
> going away after the function finishes.
> The
38 matches
Mail list logo