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
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 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
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
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:
> http://archives.postgresql
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 Consult
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 resu
<[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 na
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 10/
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
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
On Fri, 7 Oct 2005, Bruce Momjian wrote:
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.
I'm not for sale, else I would have sold a *
The ## operator is for finding the closest point to one geometric
object from another (e.g., point ## lseg), not for searching an
entire table. In this example you'll have to calculate the distance
to each point and order the results by it:
SELECT position, position <-> '55.4,-6.4'::point AS dis
Bruce Momjian 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
claims to having transac
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;
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
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
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 rela
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
> http://developers.slashdot.org/article.pl
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 d
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/1224213&from=rss
From the linked article...
http://w
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/
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
muc
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 broadcast)---
In this thread, no one has mentioned their dual license, which I think of
as more duplicitous than dual. Neither free as in freedom nor free as in
beer, really.
[EMAIL PROTECTED] wrote on 10/07/2005 12:45:39 PM:
> On Thu, 2005-10-06 at 23:00 -0400, Tom Lane wrote:
>
> > So, yeah, the above claim
>"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 formulat
On Thu, 2005-10-06 at 23:00 -0400, Tom Lane wrote:
> So, yeah, the above claim is just FUD. It'd be interesting to ask some
> hard questions about exactly how solid MySQL AB's finances are ... and
> how many other support options users will have if they go under.
A possibly more likely and scary
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();
o
Mr. Armbrust,
Hopefully, this isn't off topic. Just wondering why SWT instead of
swing?
Michael Schmidt
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, Post
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 ifyo
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 loca
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, Sqlite
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 c
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
> mig
"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'
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
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 LOA
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 ha
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 l
Greetings,
I am looking for a tool that provides interface for pg_dump/pg_restore
under windows OS.
PgAdminII seems a bit slow, could someone suggests some any tools that
are quick at dumping and restore data through the GUI please?
Thanks a lot,
Emi
---(end of bro
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
> > > equiva
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, tr
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 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 erro
[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 att
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
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
wor
[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.
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 v
"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 nev
"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
"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
-
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 4
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
---
"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)---
TI
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.
--
To
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 wha
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
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 ha
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 PRO
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 tha
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
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.
>
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 Gols
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. H
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-fr
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 expand
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 pgfou
> 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 c
>> 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
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?
--
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 s
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 -9'
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) significant
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 or
76 matches
Mail list logo
