Markus Schulz <[EMAIL PROTECTED]> writes:
> This works fine and then i've created the new Type like:
> CREATE OR REPLACE FUNCTION etextin(cstring)
> RETURNS etext AS
> '$libdir/new_types.so', 'etextin'
> LANGUAGE 'c' VOLATILE;
> CREATE OR REPLACE FUNCTION etextout(etext)
> RETURNS cstring A
On Tue, Oct 04, 2005 at 04:46:04PM -0400, Douglas McNaught wrote:
> Lexington Luthor <[EMAIL PROTECTED]> writes:
> > I have a number of large tables in a schema all of which are related
> > by foreign keys.
> >
> > Now, what I would like to be able to do is run some long-running
> > queries (mostly
On Tuesday 04 October 2005 19:13, Richard Huxton wrote:
> Jeff MacDonald wrote:
> > 2: On the support page beside pgsql-bugs, it tells us to post in the
> > bug reporting form, AND signup for 2 mailing lists. I can't possibly
> > see how this would encourage anyone to want to report a bug if they
>
In order to address several issues identified since our last Point
Releases, we have just released the following new versions of PostgreSQL:
7.3.11, 7.4.9 and 8.0.4.
A few of the more prominent fixes across all three versions are:
- Fix error that allowed "VACUUM" to remove ctid ch
Jeff MacDonald wrote:
Hi,
I very rarely have reason to post to this list so I was reluctant to
sign up for such heavy traffic, but I have a few things to bring up
and they're all 'general'
1: Go to the website and type in "now()" into the search box, it will break
Error in query: Unmatched pare
Jeff MacDonald <[EMAIL PROTECTED]> writes:
> 1: Go to the website and type in "now()" into the search box, it will break
> Error in query: Unmatched parenthesis
> 2: On the support page beside pgsql-bugs, it tells us to post in the
> bug reporting form, AND signup for 2 mailing lists. I can't poss
> On Tuesday 04 October 2005 17:25, Tom Lane wrote:
> > [EMAIL PROTECTED] writes:
> > > select expensive_function(table) from table
> > > where expensive_function(table) is not null;
> > >
> > > Is there a way to avoid that expensive_function is evaluated twice (if
> > > it's n
I had thought we were completely sunk until we moved everything over
to .Net.
Insert microsoft wisecrack of your choice here : )
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Tuesday 04 October 2005 22:26, [EMAIL PROTECTED] wrote:
> Just a guess but have you tried using an in clause?
>
> select something from table where fase in ('1' , '2');
>
Not surprisingly, this also does a sequential scan on the table. (It would be
_very_ diffcult to see that this is a union,
On Tue, Oct 04, 2005 at 09:32:41PM +0200, [EMAIL PROTECTED] wrote:
> I've got a table with an index, let's call it fase.
>
> The following query is fine: 'select something from table where fase = '1';
>
> However, this is disastrously slow:
> select something from table where fase = '1' or fase
Lexington Luthor <[EMAIL PROTECTED]> writes:
> Hi,
>
> I have a number of large tables in a schema all of which are related
> by foreign keys.
>
> Now, what I would like to be able to do is run some long-running
> queries (mostly selects, but also some updates and inserts into the
> tables), to ge
On 10/4/05, Welty, Richard <[EMAIL PROTECTED]> wrote:
> Aaron Glenn wrote:
> >Completely incorrect. You can do whatever you like with PostgreSQL;
> >you just can't sue anyone when things go south.
>
> _and_ you need to preserve the copyright notices.
excellent point.
---(e
I never imagined that I would get so many responses. Thanks for all the
great information! This really cleared it up for us. It looks like I
will take a good long look at postgresql and see how well I can make it
interface into our product. This was extremely good news for me... I had
thought w
On Tue, Oct 04, 2005 at 02:14:28PM -0400, Richmond Dyes wrote:
> I am looking to build a commercial application with postgresql as the
> backend database. Besides using php for a web interface, what other
> development environment would developers advice to use to make a good
> secure windows
Just a guess but have you tried using an in clause?
select something from table where fase in ('1' , '2');
On Tuesday 04 October 2005 13:32, [EMAIL PROTECTED] wrote:
> Hello
>
> I've got a table with an index, let's call it fase.
>
> The following query is fine: 'select something from table w
Richmond Dyes wrote:
From my understanding of the license for Postgresql, there is no
licensing fees as long as you are not selling it yourself for a profit.
This is incorrect. Please see the other messages on this thread. The
product you are thinking of is MySQL.
Sincerely,
Joshua D. Drak
Aaron Glenn wrote:
>On 10/4/05, Richmond Dyes <[EMAIL PROTECTED]> wrote:
>> From my understanding of the license for Postgresql, there is no
>> licensing fees as long as you are not selling it yourself for a profit.
>Completely incorrect. You can do whatever you like with PostgreSQL;
>you just
Aaron,
If you are new to free software, it is best to familiarize yourself with
the different types of licenses, and especially with the concept of
copyleft:
http://www.fsf.org/fsf/licensing
BSD, LGPL, and GPL are all very different animals, and representative of
many of the licenses used in FOS
Hello,
i'm trying to develop a selfmade pg-datatype derived from type text (at
first) with postgresql 7.4.7.
At first i have taken the original code from textin and textout
($SRC/backend/utils/adt/varlena.c) and compiled them renamed to etextin
and etextout into new .so file.
This works fine and
> This brings me here. I have heard of PostGreSQL, so it's not
> new to me.
> But all this licensing is. And maybe you can help get some
> clarification for the MySQL licensing too.
>
> We will not be selling the database software. We may install
> it for them, though. In fact, most of the t
Hello
I've got a table with an index, let's call it fase.
The following query is fine: 'select something from table where fase = '1';
However, this is disastrously slow:
select something from table where fase = '1' or fase = '2';
The reason is that the query planner decides to ignore the inde
Also sprach Aaron Smith ([EMAIL PROTECTED])
[License questions]
PostgreSQL is released under BSD License. This license say (informal,
IANAL) Do whatever you want with the code, but keep the author's
acknowledgements.
BSD licensed software is quite often incorporated into commercial
products, li
Hi,
I very rarely have reason to post to this list so I was reluctant to
sign up for such heavy traffic, but I have a few things to bring up
and they're all 'general'
1: Go to the website and type in "now()" into the search box, it will break
Error in query: Unmatched parenthesis
2: On the suppo
On 10/4/05, Richmond Dyes <[EMAIL PROTECTED]> wrote:
> From my understanding of the license for Postgresql, there is no
> licensing fees as long as you are not selling it yourself for a profit.
Completely incorrect. You can do whatever you like with PostgreSQL;
you just can't sue anyone when thin
From my understanding of the license for Postgresql, there is no
licensing fees as long as you are not selling it yourself for a profit.
There are also free platforms to build your application on. I am myself
exploring the use of Centos with php, postgresql, apache with ssl
running as a secur
Hi,
>You can close source it, you can sell it, you can rename it.
Add to that: As long as you leave the copyrights notices alone...
Isn't that what the BSD license is particularly about? [but then, I
might be wrong there]
Regards,
Arthur
---(end of broadcast)-
On Tue, 2005-10-04 at 09:49, Aaron Smith wrote:
SNIP
> We will not be selling the database software. We may install it for
> them, though. In fact, most of the time, we will be the ones to install
> it, and we charge for that time. Our customers are very aware that we
> did not write it, nor a
[snip]
> Knowing all this, what do we need to purchase, what can we do and what
> can't we do? It's hard getting a straight answer from anyone that is
why
> I am here. If we can't do it, we won't. If we can save our customers
> some money while getting them really good options and software, we
woul
Joshua D. Drake wrote:
This brings me here. I have heard of PostGreSQL, so it’s not new to me.
But all this licensing is. And maybe you can help get some clarification
for the MySQL licensing too.
You can do anything you want with PostgreSQL. You can close source it,
you c
On Tuesday 04 October 2005 17:25, Tom Lane wrote:
> [EMAIL PROTECTED] writes:
> > select expensive_function(table) from table
> > where expensive_function(table) is not null;
> >
> > Is there a way to avoid that expensive_function is evaluated twice (if
> > it's not null) ?
>
>
Hi,
If I'm not wrong, Postgres comes with a BSD license, which means that
it (literally) doesn't matter what you do with the sources or how you
link your applications to the Postgres libraries. Pervasive goes into
details here: http://www.pervasivepostgres.com/postgresql/mysql.asp.
Regards,
Ar
My understanding is that PG does not eliminate common subqueries within
complex queries. I just wanted to confirm this.
I also tried wrapping subqueries in STABLE or IMMUTABLE functions
returning SETOF, but from the PG 8.0.3 log, I see that the function is
invoked redundantly anyway. I know
> This brings me here. I have heard of PostGreSQL, so it’s not new to me.
> But all this licensing is. And maybe you can help get some clarification
> for the MySQL licensing too.
>
You can do anything you want with PostgreSQL. You can close source it,
you can sell it, you can rename it.
You
Hi,
I have a number of large tables in a schema all of which are related by
foreign keys.
Now, what I would like to be able to do is run some long-running queries
(mostly selects, but also some updates and inserts into the tables), to
generate some reports which will eventually be rolled-bac
I did a quick search on the mailing list and didn’t really find my
answer, so I am posting it to this list…
I’d like to apologize for my lack in understanding all this license
stuff. I am not an open source developer, I am a commercial developer,
so this is the first time I have even looked to
On Tue, 2005-10-04 at 14:14 -0400, Richmond Dyes wrote:
> I am looking to build a commercial application with postgresql as the
> backend database. Besides using php for a web interface, what other
> development environment would developers advice to use to make a good
> secure windows frontend
I am looking to build a commercial application with postgresql as the
backend database. Besides using php for a web interface, what other
development environment would developers advice to use to make a good
secure windows frontend with postgresql running either Windows or Linux?
---
On Tue, Oct 04, 2005 at 06:21:51AM -0700, jing han wrote:
> Hello,
>
> After 6 days busy running, one of my process dead of
> cannot connect to database, and the log message shows
> that exceeding max_connections. The max_connections =
> 30.
>
> By running watch -d "ps ax |grep postgres" I only f
On Tue, 2005-10-04 at 07:00, ctobini wrote:
> Hello,
>
> I don't find in the PostgreSQL doc how to export a select result in a
> text file.
If you want to get the data without being IN psql (like in an automated
script) you can use the -tc switches ("t"uples only, run this
"c"ommand):
psql dbnam
On Mon, 2005-10-03 at 16:36 -0300, Giovanni M. wrote:
> Yes! That did it, thanks for the help
>
> On 10/3/05, Tony Wasson <[EMAIL PROTECTED]> wrote:
> > On 10/3/05, Giovanni M. <[EMAIL PROTECTED]> wrote:
> > > Round and trunc dont provide the functionality I need.
> > >
> > > Say for example I hav
[EMAIL PROTECTED] writes:
> select expensive_function(table) from table
> where expensive_function(table) is not null;
> Is there a way to avoid that expensive_function is evaluated twice (if it's
> not null) ?
You can do something like this:
select f from
(select expensi
am 04.10.2005, um 5:00:16 -0700 mailte ctobini folgendes:
> Hello,
>
> I don't find in the PostgreSQL doc how to export a select result in a
> text file.
>
> Thanks if you can help me.
You can use \o in psql to redirect the result to a file.
\o out.file
Regards, Andreas
--
Andreas Kretschm
Please forgive me if this is not the right mailing list to post this message at.
I'm trying to run PostgreSQL 8.0 on a Win XP notebook. Right after the instalation, it works fine. But after turning the computer off and on again I can´t get the service to run. The error message I get says that the
Hi guys, I need some help on setting up pgsql 8.0 on windows xp. I know
that this must be a basic task but somehow I couldn't figure out how to
get it work. I did setup pgsql correctly in that I can have access to
pgAdmin III console, but when i try to setup a new server, even though
I uncheck the
On Friday 30 September 2005 17:48, Devrim GUNDUZ wrote:
> Sorry for the late response.
>
> On my RH 9 box, I've rebuilt our SRPM and here is the result:
>
> [EMAIL PROTECTED] SRPMS]# cat /etc/redhat-release
> Red Hat Linux release 9 (Shrike)
> [EMAIL PROTECTED] SRPMS]# rpm -qp --requires
> /usr/src
Hello,
I don't find in the PostgreSQL doc how to export a select result in a
text file.
Thanks if you can help me.
C. Tobini
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Hello,
I've got the following situation:
select expensive_function(table) from table
where expensive_function(table) is not null;
Is there a way to avoid that expensive_function is evaluated twice (if it's
not null) ?
I've tried stuff like immutable, but that doesn't do
On Sun, Oct 02, 2005 at 11:27:29AM -0400, Tom Lane wrote:
> Steve Manes <[EMAIL PROTECTED]> writes:
> > Questions: is there a hard limit to the number of schemas you could have
> > in a database?
>
> No.
>
> > Are there any caveats/pitfalls/pitbulls to having a
> > large number of duplicate sch
What version of Access?
Confirm that Access is interpreting the target field as MEMO, (either look at the linked table in design
mode, or use Tools->Analyze->Documenter).
For the query, determine the "type" of the parameter - Query menu->Parameters. Be sure you are using type
MEMO.
By the way,
Easy way:
SELECT table_name FROM information_schema.columns WHERE column_name = ''
or
SELECT table_name FROM pg_sysviews.pg_user_table_columns WHERE
column_name = ''
If those don't work, select from pg_attribute a join pg_class c on
(c.oid = a.reloid)
On Fri, Sep 30, 2005 at 10:55:44AM -0400, Emi
Tom Lane <[EMAIL PROTECTED]> writes:
> "Chris St Denis" <[EMAIL PROTECTED]> writes:
>> Does postgres support in-memory only tables like the mysql HASH table type?
>
> No, and it doesn't seem particularly necessary: a table that is being
> hit heavily will stay in cache buffers anyhow. You don't n
On 10/3/05 7:41 PM, "J B" <[EMAIL PROTECTED]> wrote:
> On 10/3/05, Dann Corbit <[EMAIL PROTECTED]> wrote:
>> Using SQL*Server, and OLEDB or ODBC data source can be connected as a
>> linked server. Then, TSQL queries can go against PostgreSQL tables as
>> though they were ordinary SQL*Server table
Hello.
I have the following problem with MS
Access/PostgreSQL combination:
There is a form in Access that has an unbound
text box, used for entering a commentary of a batch of records.
There is a DAO Append Query that has a parameter
that is passed from the text box using parameter of DAO Que
On Mon, 2005-10-03 at 17:44 +0200, Martijn van Oosterhout wrote:
> On Mon, Oct 03, 2005 at 03:31:42PM +0200, Daniel Schregenberger wrote:
> > I recently stumbled uppon the following thing:
> > If I compare a field of type "numeric" to a small decimal constant like
> > "3.6", the constant is interpr
54 matches
Mail list logo
