Take a look at the Pentaho project (http://www.pentaho.org/). They
have an ETL and reporting framework. You can use any DB as the back
end as long as it has JDBC drivers (PostgreSQL included ). The
ETL piece is Kettle, which is fairly mature, the reporting piece is
still a little rough arou
Tom Lane wrote:
"Peter L. Berghold" <[EMAIL PROTECTED]> writes:
What I'm seeing is the first time my web application is being run there
is a bunch of processes running around that look like:
"postgres: peter peter_trialdb 127.0.0.1(46222) idle"
"idle" is fine, "idle in transaction" is not so f
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] ("Jaime
Casanova") transmitted:
> Anyone here knows if exists a data warehouse software that uses
> postgresql? if it is open source that will be a plus...
There tends to be 3 parts to this...
1. Data storage
The RDBMS of
Tom Lane wrote:
Jack Orenstein <[EMAIL PROTECTED]> writes:
Assigning SPI_prepare output to a local makes sense. Assigning
SPI_saveplan output to a static makes sense. But I don't see
the point in assigning SPI_saveplan output to a local, yet
that's what one case the doc specifically mentions.
Jack Orenstein <[EMAIL PROTECTED]> writes:
> Assigning SPI_prepare output to a local makes sense. Assigning
> SPI_saveplan output to a static makes sense. But I don't see
> the point in assigning SPI_saveplan output to a local, yet
> that's what one case the doc specifically mentions.
Hm, are you
Tom Lane wrote:
Jack Orenstein <[EMAIL PROTECTED]> writes:
I'm missing something very basic. If I do this:
Datum foobar(PG_FUNCTION_ARGS)
{
...
void* plan = SPI_prepare(...);
void* saved_plan = SPI_saveplan(plan);
...
}
then how can I acce
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Behrang Saeedzadeh wrote:
> Stephan,
>
> But "not null" is in contradiction with "default null" so the create
> statement should not proceed successfuly IMHO.
I see your point, but those are run-time (i.e. DML) operations, not
DDL statements. Added
"Behrang Saeedzadeh" <[EMAIL PROTECTED]> writes:
> Actually I read in a blog that this works in PostgreSQL (the author
> expected this) and not in MySQL. But to me, the way MySQL is handling
> this looks more reasonable.
MySQL's way of doing things is seldom reasonable. In the example
given, they
Jack Orenstein <[EMAIL PROTECTED]> writes:
> I'm missing something very basic. If I do this:
> Datum foobar(PG_FUNCTION_ARGS)
> {
> ...
> void* plan = SPI_prepare(...);
> void* saved_plan = SPI_saveplan(plan);
> ...
> }
> then how can I access th
Hi,
Actually I read in a blog that this works in PostgreSQL (the author
expected this) and not in MySQL. But to me, the way MySQL is handling
this looks more reasonable.
You may want to read the blog here:
http://www.redhillconsulting.com.au/blogs/simon/archives/000347.html
Regards,
Behi
On 9/
Hi,
Anyone here knows if exists a data warehouse software that uses postgresql?
if it is open source that will be a plus...
--
regards,
Jaime Casanova
"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to prod
Stephan,
But "not null" is in contradiction with "default null" so the create
statement should not proceed successfuly IMHO.
Regards,
Behi
On 9/10/06, Stephan Szabo <[EMAIL PROTECTED]> wrote:
On Sun, 10 Sep 2006, Behrang Saeedzadeh wrote:
> Shouldn't this create statement trigger an error?
>
Peter,
On 9-Sep-06, at 2:14 PM, Peter L. Berghold wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi folks,
I've run into an issue that I'm sure there's a fix for, I just haven't
quite figured it out on my own.
First the overview of the environment:
Linux (CentOS release 4.2)
On Sun, 10 Sep 2006, Behrang Saeedzadeh wrote:
> But "not null" is in contradiction with "default null" so the create
> statement should not proceed successfuly IMHO.
The fact that the default value isn't going to pass a constraint means
that it's invalid to not provide a value or use default, y
"Peter L. Berghold" <[EMAIL PROTECTED]> writes:
> What I'm seeing is the first time my web application is being run there
> is a bunch of processes running around that look like:
> "postgres: peter peter_trialdb 127.0.0.1(46222) idle"
"idle" is fine, "idle in transaction" is not so fine, because t
The documentation on SPI_saveplan says:
SPI_saveplan saves a passed plan (prepared by SPI_prepare) in
memory ... and returns a pointer to the saved plan. This gives
you the ability to reuse prepared plans in the subsequent
invocations of your procedure in the current session. You
Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Sun, 10 Sep 2006, Behrang Saeedzadeh wrote:
>> Shouldn't this create statement trigger an error?
>> create table bar (col1 int not null default null);
> I think it should forbid it when the default actually comes into play like
> on insert or update,
On Sun, 10 Sep 2006, Behrang Saeedzadeh wrote:
> Shouldn't this create statement trigger an error?
>
> create table bar (col1 int not null default null);
>
> Shouldn't I be forbidden to insert null values into a non null column?
I think it should forbid it when the default actually comes into p
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Behrang Saeedzadeh wrote:
> Hi,
>
> Shouldn't this create statement trigger an error?
>
> create table bar (col1 int not null default null);
>
> Shouldn't I be forbidden to insert null values into a non null column?
What happens when you actually
Hi,
Shouldn't this create statement trigger an error?
create table bar (col1 int not null default null);
Shouldn't I be forbidden to insert null values into a non null column?
Regards,
Behi
--
"We can only see a short distance ahead,
but we can see plenty there
that needs to be done." - Alan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi folks,
I've run into an issue that I'm sure there's a fix for, I just haven't
quite figured it out on my own.
First the overview of the environment:
Linux (CentOS release 4.2)
Tomcat 5.x application server
Struts/Tiles MVC
Michelle Konzack wrote:
> Hello,
>
> the OP is using mutt like me and I have never seen mutt,
> breaking the Subject in multiple lines. If I send mails,
> with such subjects, the are always bandworms...
I don't know what the conditions are, but mutt frequently produces
multiline Subjects on my
On Fri, 8 Sep 2006, Michelle Konzack wrote:
Am 2006-09-07 06:15:15, schrieb Joshua D. Drake:
Honestly, it may be time we start looking at mailman.
From what I can tell Majordomo isn't even supported any longer.
Secondly we get some better management (not great but better) interfaces
with ma
Martijn van Oosterhout wrote:
Please don't use "reply" to start new thread, thanks.
On Fri, Sep 08, 2006 at 05:55:44AM -0800, Poul Jensen wrote:
I need to fetch strings from a database with ECPG and then sort them in
C. Here is one of my failed attempts:
varchar filenms[][maxlen
On Sat, Sep 09, 2006 at 05:19:26PM +0530, Purusothaman A wrote:
> I usually log in to postgresql server with admin username.
>
> But whatever its, according to documentation, if client machine's user has
> write access
> permission, this query should successfully be executed.
Read carefully, you
Hi Milen A. Radev,Thank you for your response.I have read this in PostgreSQL documentation. I usually log in to postgresql server with admin username.But whatever its, according to documentation, if client machine's user has write access
permission, this query should successfully be executed.Both
Purusothaman A написа:
> Hi all,
>
> I have problem while using "lo_export()" and "lo_import()" from remote
> system.
>
> eg:
>
> select lo_export(img_file, 'E:\\temp\\1001.jpg') from master where emp_id =
> '1001';
> insert into master(img_file) values(lo_import('E:\\temp\\1001.jpg')) where
Am 2006-09-07 06:15:15, schrieb Joshua D. Drake:
> >>Honestly, it may be time we start looking at mailman.
> From what I can tell Majordomo isn't even supported any longer.
> Secondly we get some better management (not great but better) interfaces
> with mailman.
>
> Mailman is a supported, la
Hello,
the OP is using mutt like me and I have never seen mutt,
breaking the Subject in multiple lines. If I send mails,
with such subjects, the are always bandworms...
Greetings
Michelle Konzack
Systemadministrator
Tamay Dogan Network
Debian GNU/Linux Consultant
--
Linux-Use
Hi all,I have problem while using "lo_export()" and "lo_import()" from remote system.eg:select lo_export(img_file, 'E:\\temp\\1001.jpg') from master where emp_id = '1001';
insert into master(img_file) values(lo_import('E:\\temp\\1001.jpg')) where emp_id = '1001';Here column "img_file" is OID da
hello everyone:
i want find a free software for design postgresql database model
please commend one ~ thanks
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
31 matches
Mail list logo