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
"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
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
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
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 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
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,
> 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
"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
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
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
> 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
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
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.
--
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
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(),
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
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 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 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 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).
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
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
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
> 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
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
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
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
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
--- 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
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
> 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,
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
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,
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:
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 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
> >
> > 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
--
38 matches
Mail list logo
