On 10/7/05, Michael Fuhr [EMAIL PROTECTED] wrote:
On Thu, Oct 06, 2005 at 05:47:36PM -0500, Jeffrey Melloy wrote:
The only thing I could see actually being an issue is the random() one
and add missing from. The rest are trivial. The random() thing is
interesting, esoteric, and probably
We are pleased to announce the release of Rekall V2.4.0
What is Rekall?
---
Rekall is a database independent, programmable Rapid
Application Development or RAD tool for producing
database applications. With Rekall you can build desktop
application and without any additional coding
Hello!
I'm interested in SELECT ... FOR SHARE 8.1 feature. I'd tried to measure
performance degradation and got something about 30-60% for queries retrieve a
lot of rows. Is it realistic estimation? Does this penalty depend on something
(data types, triggers, foreign keys, whatever)
Scott Marlowe wrote:
It's just where they're defined. See this bug for an explanation:
And a table-level foreign-key can involve more than one column of course.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 2: Don't 'kill
CSN wrote:
Yep, I think the SQL spec says fold to uppercase. I'm
not sure why PostgreSQL folds to lowercase instead,
but if folding has to occur, I prefer lowercase.
I think preference was why lowercase was chosen many moons ago. It's
stayed that way because otherwise existing users would be
Hugo wrote:
hi everybody , is it possible to schedule vacuum in the server (
postgres 8.0.3 on Windows XP SP2) ? I want to vacuum the DB everyday at
22:00 and I want to automate the process
Is there a reason why (1) autovacuum or (2) Windows' built-in scheduler
aren't any good for you?
--
Gregory S. Williamson wrote:
[ re COUNT(*) ]
On Informix however it is blindingly fast, and can also be instantly
conjured with the dbaccess tool (Info/Table/Status). They might be
stashing this count somewhere, but it is not available when the table
is locked, as during a load. However
PostgreSQL does not run in Windows 98
You can run PostgreSQL on Cygwin on Win98, I think.
But ifyou're running your database server on win98, you obviously don't
care much about your data :)
My goal is to allow my application demo, trial and development versions to
run in every Windows.
If
If you have huge plain text dumps, and just want to restore one table
it's usually painful. Attached is a small shell script that can take a
plain text dump and extract a single table's COPY data commands from it.
If people think it's interesting and should be developed, I can pop it
on
On 10/7/05, David Fetter [EMAIL PROTECTED] wrote:
Here's my thoughts on a summary:
[-t [table | glob]]...# 0 or more -t options
[-T [table | glob]]...# 0 or more -T options
[--include-tables-from-file f]
[--exclude-tables-from-file f]
where globs get expanded just
On Fri, Oct 07, 2005 at 11:47:26AM +0300, WireSpot wrote:
On 10/7/05, David Fetter [EMAIL PROTECTED] wrote:
Here's my thoughts on a summary:
[-t [table | glob]]...# 0 or more -t options
[-T [table | glob]]...# 0 or more -T options
[--include-tables-from-file f]
Never used it, but look at contrib/dblink and better use different
schemas instead of different databases in future -- if you want to
exchange data.
On 07.10.2005 03:55, [EMAIL PROTECTED] wrote:
Hi, I have a table A in both database d1 and d2. I would like to copy
data in A in d1 to A in d2.
Hello!
I want to select data from two tables obtaining
exclusive lock for records of the first table and
nonexclusive lock for records of the second one.
In other words, I need something like
select a.f, b.f from a,b for update of a for share of b.
Any hints?
Thanks.
--
Best regards
Ilja
On Fri, Oct 07, 2005 at 04:46:12PM +0800, Christopher Kings-Lynne wrote:
If you have huge plain text dumps, and just want to restore one table
it's usually painful. Attached is a small shell script that can take a
plain text dump and extract a single table's COPY data commands from it.
If
Tom,
Thank you very much for the enlightenment again!
I notice that PostgreSQL does disable triggers but it seems to not
disable CHECK constraint:
Why should it?
(Hint: a check constraint that looks at anything but the row being
checked is broken by definition.)
Maybe my case is rare
try: delete from pg_catalog.pg_largeobject;
from your database.
2005/10/6, Premsun Choltanwanich [EMAIL PROTECTED]:
Dear All,
I use '$libdir/lo' for manage my PostgreSQL Large Object. It work fine for
me to get and put Large Object from and to database. However I found
something that may
As an alternate solution, what about using a pass through query? Access
won't mess with the SQL that way. I don't know if that will suit your
needs, but I tend to use them almost exclusively in my Access/PostgreSQL
project.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
Dear friends,
I need to development one system in
native Linux, Language and DataBase, today I use PostgreSQL with Delphi 2005 in Windows 2005
Servers, and I need to know what language will use to do this ?
That you suggest ?
This Langage work good in what Linux
SO ?
This language
I'd go for a scripting language and a cross-platform GUI-toolkit like
GTK, QT or XUL. If you dislike scripting languages for some reason,
write it in plain C and use one of the GUI-toolkits above.
Besides this there is Kylix, but if you are using Delphi anyway, you
should know about it.
The
Gerson - Yahoo wrote:
_Dear friends,_
_ _
_I need to development one system in native Linux, Language and
DataBase, today I use PostgreSQL with Delphi 2005 in Windows 2005
Servers, and I need to know what language will use to do this ?_
_That you suggest ?_
_This Langage work good in
1.pgAdmin refuses to run in Windows 98, displays that it is compiled with
unicode support.
Where to find binary version of pgAdmin for Windows 98 ?
You could try PG Lightning Admin, it should work in windows 98.
I don't have access to a win98 box to really test, but it *should* work.
--
Andrus [EMAIL PROTECTED] writes:
Apache runs well in Windows 98. Why this is so difficult in native Windows
Postgres?
I *think* it's because we use certain features of NTFS, which Win98
will never support.
-Doug
---(end of broadcast)---
TIP 2:
Moises Alberto Lindo Gutarra [EMAIL PROTECTED] writes:
try: delete from pg_catalog.pg_largeobject;
from your database.
Umm, the standard way to do this is lo_unlink(). You can put an
ON DELETE trigger on your referencing table that calls this function.
-Doug
Hello,
We have a table of people with a date-of-birth and a surname, both indexed.
We have queries like this:
select report from table where dateofbirth = '1966-12-12' and surname like
'boer%'
The planner estimates that in a 1.5M record table 'boer%' will have one record
and 1966-12-12 about
Ilja Golshtein [EMAIL PROTECTED] writes:
I'm interested in SELECT ... FOR SHARE 8.1 feature. I'd tried to
measure performance degradation and got something about 30-60% for
queries retrieve a lot of rows.
Degradation relative to what?
regards, tom lane
Tony Caduto [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
1.pgAdmin refuses to run in Windows 98, displays that it is compiled with
unicode support.
Where to find binary version of pgAdmin for Windows 98 ?
You could try PG Lightning Admin, it should work in windows 98.
I don't
Douglas McNaught [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Andrus [EMAIL PROTECTED] writes:
Apache runs well in Windows 98. Why this is so difficult in native
Windows
Postgres?
I *think* it's because we use certain features of NTFS, which Win98
will never support.
Hello pgsql is complaining and I can't seem to figure out what the
error is talking about.
Basically it's claiming that multiple default vaues are being
specified, but nowhere in statement below is there one single place
where I can see an error.
Please help!
SQL error:
ERROR: multiple default
[EMAIL PROTECTED] writes:
Is there a way to tell the planner to always prefer the dateofbirth index ?
Alternatively, to inform it about the wildly uneven distribution of surnames
(this must be even worse in China).
Increase the statistics target for that column, and re-ANALYZE the
table.
Gerson - Yahoo wrote:
Dear friends,
I need to
development one system in
native Linux, Language and DataBase, today I use PostgreSQL with Delphi
2005 in
Windows 2005
Servers, and I need to know what language will use to do this ?
That you
suggest ?
This Langage
On Fri, Oct 07, 2005 at 11:36:27AM +0200, Martijn van Oosterhout wrote:
On Fri, Oct 07, 2005 at 04:46:12PM +0800, Christopher Kings-Lynne wrote:
If you have huge plain text dumps, and just want to restore one table
it's usually painful. Attached is a small shell script that can take a
[EMAIL PROTECTED] writes:
ERROR: multiple default values specified for column txnid of table
ec_transaction
CREATE TABLE ec_transaction (
txnid BIGSERIAL NOT NULL DEFAULT
nextval('public.ec_transaction_txnid_seq') ,
SERIAL/BIGSERIAL implies a default clause. If you want to attach the
On Fri, 7 Oct 2005 [EMAIL PROTECTED] wrote:
Hello pgsql is complaining and I can't seem to figure out what the
error is talking about.
Basically it's claiming that multiple default vaues are being
specified, but nowhere in statement below is there one single place
where I can see an error.
On Thursday 06 October 2005 17:31, Michael Fuhr wrote:
On Thu, Oct 06, 2005 at 12:35:38PM -0700, CSN wrote:
Scott Marlowe [EMAIL PROTECTED] wrote:
But what really bugs me is that some things that ARE bugs simply aren't
getting fixed and probably won't. Specifically, while mysql
On Friday 07 October 2005 04:22, Andrus wrote:
PostgreSQL does not run in Windows 98
You can run PostgreSQL on Cygwin on Win98, I think.
But ifyou're running your database server on win98, you obviously don't
care much about your data :)
My goal is to allow my application demo, trial and
On Thursday 06 October 2005 18:18, Jim C. Nasby wrote:
On Thu, Oct 06, 2005 at 12:40:49PM -0700, CSN wrote:
--- Scott Marlowe [EMAIL PROTECTED] wrote:
Federated Storage Engine: Allows MySQL to access
tables in other
servers like they are here. No real direct
equivalent in
You could increase statistics or try contrib/tsearch2
Oleg
On Fri, 7 Oct 2005, [EMAIL PROTECTED] wrote:
Hello,
We have a table of people with a date-of-birth and a surname, both indexed.
We have queries like this:
select report from table where dateofbirth = '1966-12-12' and surname
Hi,
Using COMMENT ON DATABASE only allows you to create a comment
for your current database which is then only visible from that database.
However, if I manually insert appropriate values into pg_description
in other databases I can make comments appear for another database.
e.g. If some users
Hi everybody, thanks for your answers about hardware requirements. DB design
was succesful and now we are migrating stored procedures from oracle to
PostgreSQL.
I can't handle cursors very well in PostgreSQL, for example, i need to
migrate this stored procedure:
CREATE OR REPLACE PROCEDURE
On Fri, Oct 07, 2005 at 10:45:06AM -0400, Robert Treat wrote:
On Thursday 06 October 2005 17:31, Michael Fuhr wrote:
Also, notice the TYPE innodb clause of the CREATE TABLE
statement. The default table type in MySQL is MyISAM, which
doesn't support foreign key contraints at all, but
Robert Treat [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Friday 07 October 2005 04:22, Andrus wrote:
PostgreSQL does not run in Windows 98
You can run PostgreSQL on Cygwin on Win98, I think.
But ifyou're running your database server on win98, you obviously don't
care much
On 10/7/05, Rafael Montoya [EMAIL PROTECTED] wrote:
Hi everybody, thanks for your answers about hardware requirements. DB design
was succesful and now we are migrating stored procedures from oracle to
PostgreSQL.
I can't handle cursors very well in PostgreSQL, for example, i need to
migrate
Mark Rae [EMAIL PROTECTED] writes:
Using COMMENT ON DATABASE only allows you to create a comment
for your current database which is then only visible from that database.
...
Also is there any intention to have a 'COMMENT ON [ROLE|USER|GROUP]'
facility.
There's been some discussion of
Andrus wrote:
I must support demo versions for 1 to 100 users in all Windowses using free
software.
So there are the following options :
1. Use Firebird
2. Use Postgres + cygwin all cases, even in XP
3. Use Postgres native for XP, Postgres+cygwin in Win 98
4. Use Postgres native for XP,
On 10/6/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
On Thursday 06 October 2005 18:20, Tom Lane wrote:
No, there's no reason for 8.0 to be slower at this than 7.4, if all else
is equal. I'm betting that all else is not equal. Maybe you are using
a different encoding or locale in the
On Fri, Oct 07, 2005 at 07:00:27PM +0300, Andrus wrote:
Robert Treat [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Friday 07 October 2005 04:22, Andrus wrote:
PostgreSQL does not run in Windows 98 You can run PostgreSQL on
Cygwin on Win98, I think. But ifyou're running
Am Freitag, den 07.10.2005, 19:00 +0300 schrieb Andrus:
...
I must support demo versions for 1 to 100 users in all Windowses using free
software.
So there are the following options :
1. Use Firebird
2. Use Postgres + cygwin all cases, even in XP
3. Use Postgres native for XP,
Mr. Armbrust,
Hopefully, this isn't off topic. Just wondering why SWT instead of
swing?
Michael Schmidt
Thanks for your answer.
In your example you are handling record, isn't it necessary to use fetch to
read all the table? or the for in select loop... reads all the
records?
For executing this procedure, must this calling be at the end of the
function?
--- select load_exp();
or
Ilja Golshtein [EMAIL PROTECTED] writes:
I'm interested in SELECT ... FOR SHARE 8.1 feature. I'd tried to
measure performance degradation and got something about 30-60% for
queries retrieve a lot of rows.
Degradation relative to what?
Thanks for response and sorry for bad formulating.
I've
http://lnk.nu/prnewswire.com/4dv.pl
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---(end of
Michael Schmidt wrote:
Mr. Armbrust,
Hopefully, this isn't off topic. Just wondering why SWT instead
of swing?
Michael Schmidt
I'm pretty sure this is completely off topic, but I'll indulge it -
I've done development using Swing and SWT - and I find SWT's APIs to be
much
IBM have previously bought Informix (who bought Illustra, RedBrick,
Cloudscape) None of those take-
overs has led to a product actually surviving.
Thats not exactly true - Cloudscape was just given to Apache, and is now
opensourced under the name Derby
http://db.apache.org/derby/
But no, Mark, I'm not worried by the FUD. It just means there's nothing
real for them to throw at PostgreSQL.
This just appeared on slashdot...
MySQL To Be Ikea Of The Database Market
http://developers.slashdot.org/article.pl?sid=05/10/07/1224213from=rss
From the linked article...
Simon Riggs wrote:
IBM have previously bought Informix (who bought Illustra, RedBrick,
Cloudscape) and Oracle have previously bought DEC RDB, so both have
track record of successful competitor take-overs. None of those take-
overs has led to a product actually surviving.
Informix to some
On 10/7/05, Philip Hallstrom [EMAIL PROTECTED] wrote:
But no, Mark, I'm not worried by the FUD. It just means there's nothing
real for them to throw at PostgreSQL.
This just appeared on slashdot...
MySQL To Be Ikea Of The Database Market
Jim C. Nasby wrote:
http://lnk.nu/prnewswire.com/4dv.pl
Amazing. You have to love the totally unrelated license mention Oracle
added to the press release:
InnoDB is not a standalone database product: it is distributed as a
part of the MySQL database. InnoDB's contractual
Bruce,
What is our vulnerability? Oracle offering big-money jobs to PostgreSQL
developers. I think that is our only weakness, unless they buy Marc
(Marc, are you for sale? :-):-) ) and own the domains and trademark.
Well, that *is* a serious concern. That's why Marc and I are working on
Ultimately, MySQL should drop InnoDB.
This will happen eventually, there is no doubt, Sun seems like its
going to eventually integrate PostgreSQL into Solaris as a pkg most
likely:
http://www.computerworld.com.au/index.php/id;116679278;fp;16;fpid;0
Hopefully that should make PostgreSQL
Aly S.P Dharshi wrote:
Ultimately, MySQL should drop InnoDB.
This will happen eventually, there is no doubt, Sun seems like its
going to eventually integrate PostgreSQL into Solaris as a pkg most
likely:
http://www.computerworld.com.au/index.php/id;116679278;fp;16;fpid;0
Bruce Momjian pgman@candle.pha.pa.us writes:
Ultimately, MySQL should drop InnoDB.
Given that MyISAM is still their first love, I don't think that outcome
is preposterous at all. If Oracle tries to squeeze too hard, that's
probably exactly what they'll do. It'll put a bit of a dent in their
On 10/7/05, Rafael Montoya [EMAIL PROTECTED] wrote:
Thanks for your answer.
In your example you are handling record, isn't it necessary to use fetch to
read all the table? or the for in select loop... reads all the
records?
the for construct hide the cursor details for you...
On Fri, 2005-10-07 at 13:32 -0500, Dan Armbrust wrote:
IBM have previously bought Informix (who bought Illustra, RedBrick,
Cloudscape) None of those take-
overs has led to a product actually surviving.
Thats not exactly true - Cloudscape was just given to Apache, and is now
Title: Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase
It may be hard for u to
resist if those wacky guyz from Redwood offered eight figures (and I'm not
counting the ones to the right of the decimal point).
--Luss
From: [EMAIL PROTECTED] on
behalf of Marc G. FournierSent: Fri
[EMAIL PROTECTED] wrote
Hi, I have a table A in both database d1 and d2. I would like to copy
data in A in d1 to A in d2. How can I do it? I do not want to copy all
data, just some part of A,
Here is a way if you feel want to try. The basic idea is that create a table
(say OS file name of
On Fri, Oct 07, 2005 at 02:07:47AM -0700, David Fetter wrote:
On Fri, Oct 07, 2005 at 11:47:26AM +0300, WireSpot wrote:
But... will the resulting dump be consistent as far as foreign keys
are concerned? Or will the current -t warning still apply (YMMV as
to the consistency of the resulting
On Thu, Oct 06, 2005 at 11:42:57PM +0100, Mark Cave-Ayland wrote:
- All the companies that have tried to operate by selling PostgreSQL
support
services have gone bankrupt, except for EnterpriseDB.
Damn, guess I need to update my resume...
--
Jim C. Nasby, Sr. Engineering
On Thu, Oct 06, 2005 at 07:29:44PM -0400, Tom Lane wrote:
Well, it's surely legitimate material as a gotcha. The example is
taken from
http://archives.postgresql.org/pgsql-general/2004-11/msg01375.php
and the previous discussion referred to is this thread:
On Fri, Oct 07, 2005 at 08:44:34AM +0100, Richard Huxton wrote:
CSN wrote:
Yep, I think the SQL spec says fold to uppercase. I'm
not sure why PostgreSQL folds to lowercase instead,
but if folding has to occur, I prefer lowercase.
I think preference was why lowercase was chosen many moons
On Fri, Oct 07, 2005 at 01:18:03PM +0400, Ilja Golshtein wrote:
Hello!
I want to select data from two tables obtaining
exclusive lock for records of the first table and
nonexclusive lock for records of the second one.
In other words, I need something like
select a.f, b.f from a,b for
Hello All,
Thanks for advance
Has anyone ran pgsql tests under Valgrind and monitered its performance.
I executed it after building, like
valgrind --tool=memcheck make check
but I believe by this Valgrind runs memcheck on make and not
postgresql
In insights, suggestions
Thanks
Manish
On Fri, Oct 07, 2005 at 09:18:00PM -0500, Jim C. Nasby wrote:
On Fri, Oct 07, 2005 at 01:18:03PM +0400, Ilja Golshtein wrote:
I want to select data from two tables obtaining
exclusive lock for records of the first table and
nonexclusive lock for records of the second one.
In other
72 matches
Mail list logo
