On Oct 11, 2005, at 15:12 , Jim C. Nasby wrote:
Out of curiosity... why don't we have unsigned ints? I for one would
certainly use them for id fields, as well as some other places where I
knew negative numbers weren't valid.
Check the archives. I know this has come up a number of times in the
Am Montag, den 10.10.2005, 22:12 -0300 schrieb Marc G. Fournier:
> On Mon, 10 Oct 2005, Joshua D. Drake wrote:
...
> Just as a suggestion/thought ... *if* you have the resources (or someone
> else wants to step up to it), why not setup the bug tracker, work with the
> -www guys on having the 'bug
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> Out of curiosity... why don't we have unsigned ints?
Quick, is 42 an int or an unsigned int?
I think it'd create a slew of new ambiguous cases in the
numeric-datatype hierarchy, for what is really pretty darn small gain.
We're already just barely getti
Am Montag, den 10.10.2005, 19:33 -0500 schrieb Jim C. Nasby:
> On Mon, Oct 10, 2005 at 05:20:13PM -0700, Joshua D. Drake wrote:
> > J B wrote:
...
> IIRC the last time this was brought up it was violently shot-down on
> -hackers (and the fact that bugzilla didn't directly support PostgreSQL
> back
On Mon, Oct 10, 2005 at 10:59:03PM -0400, Tom Lane wrote:
> CSN <[EMAIL PROTECTED]> writes:
> > If integer's range is -2147483648 to +2147483647, why
> > is serial's range only 1 to 2147483647 instead of 1 to
> > about 4294967294?
>
> How are you going to stuff 4294967294 into an integer field, wh
Well, if we're considering some kind of trial stage I don't see why we
couldn't setup a few different trackers and see what people think.
Of course, that could well be setting us up for a bickshed big enough to
play NFL football in...
On Mon, Oct 10, 2005 at 10:10:26PM -0400, Tom Lane wrote:
> "J
I tried it on a test RedHat server
PostgreSQL 8.0.2beta1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2
20020903 (Red Hat Linux 8.0 3.2-7)
and the problem didn't occur. It is a slightly newer version, though,
so it doesn't prove anything. But the Gentoo is my production machine,
so I guess I'
On Oct 11, 2005, at 14:04 , CSN wrote:
I was thinking about the types in the C code behind
PostgreSQL, rather than types in PG itself. Been a
long time since I coded in C but I thought it had
unsigned ints and maybe data types could be mapped as
so (pardon my ignorance about C/PG's inner workin
Terence wrote:
Marc G. Fournier wrote:
Stupid question, but what does MySQL bring to the equation? Why not
just use PostgreSQL in the first place?
Simplicity.
Simplicity is in the eye of the beholder. Which of a dozen or so
different storage engines should I use for table X? If I mix an
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> CSN <[EMAIL PROTECTED]> writes:
> > If integer's range is -2147483648 to +2147483647,
> why
> > is serial's range only 1 to 2147483647 instead of
> 1 to
> > about 4294967294?
>
> How are you going to stuff 4294967294 into an
> integer field, which as
> y
Chris Browne wrote:
> [EMAIL PROTECTED] ("Uwe C. Schroeder") writes:
> > On Saturday 08 October 2005 21:07, Chris Browne wrote:
> >> 2. The code base was pretty old, pretty creaky, and has a *really*
> >> heavy learning curve.
> >>
> >> It was pretty famous as being *really* difficult t
Marc G. Fournier wrote:
>
> Stupid question here, but how susceptible is Oracle to "monopolistic
> practices", similar to what M$ is going through with the DoJ in the US?
> This seems to be *very* close to the line, if it isn't over it ... no?
>
One big issue is that MS has the DOJ watching ov
[EMAIL PROTECTED] wrote:
> What is Oracle after? Small DB technology? They already have rdb.
> Firebird, back in the Groton Database Corporation days, was built to be
> compatible with rdb. Marrying those technologies through modification of
> existing gateways makes more technological sense tha
Marc G. Fournier wrote:
Stupid question, but what does MySQL bring to the equation? Why not
just use PostgreSQL in the first place?
Simplicity. A huge user base. No one is questioning that pg is a
superior product :)
http://www.mysql.com/why-mysql/marketshare/ *
*with a pinch of salt
CSN <[EMAIL PROTECTED]> writes:
> If integer's range is -2147483648 to +2147483647, why
> is serial's range only 1 to 2147483647 instead of 1 to
> about 4294967294?
How are you going to stuff 4294967294 into an integer field, which as
you just stated has an upper limit of 2147483647?
If we had an
If integer's range is -2147483648 to +2147483647, why
is serial's range only 1 to 2147483647 instead of 1 to
about 4294967294?
CSN
__
Yahoo! Music Unlimited
Access over 1 million songs. Try it free.
http://music.yahoo.com/unlimited/
---
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> I have thought about that, however I would at least at some level want a
> blessing. For example, if we did that would we do it with
> pgFoundry bug tracking? Or would we use Trac? Or Bugzilla?
I think the main thing that's killed previous proposals
Excuse me, How? I try to find the way but not found.>>> Douglas McNaught <[EMAIL PROTECTED]> 10-Oct-05 20:07:57 pm >>>"Premsun Choltanwanich" <[EMAIL PROTECTED]> writes:> The lib I use is call lo_in and lo_out for manage BLOB.> I understand that lo_unlink be related with lo_import and lo_export so
Marc G. Fournier wrote:
On Mon, 10 Oct 2005, Joshua D. Drake wrote:
IIRC the last time this was brought up it was violently shot-down on
-hackers (and the fact that bugzilla didn't directly support PostgreSQL
back then had nothing to do with it).
Yep, but you never know. Someday it just m
On a side note, have you considered submitting a case study about the
work you're doing? One place where MySQL AB and it's zealots likes to
beat PostgreSQL over the head is with it's list of clients. It'd be nice
to be able to say that the Mayo Clinic is using PostgreSQL.
On Mon, Oct 10, 2005 at 0
On Mon, 10 Oct 2005, Joshua D. Drake wrote:
IIRC the last time this was brought up it was violently shot-down on
-hackers (and the fact that bugzilla didn't directly support PostgreSQL
back then had nothing to do with it).
Yep, but you never know. Someday it just may happen. The community g
On 10/10/2005 1:32 PM, Dann Corbit wrote:
From:
http://www.filmsite.org/whof4.html
Valiant: Come on. Nobody's gonna drive this lousy freeway when they can take
the Red Car for a nickel.
Doom: Oh, they'll drive. They'll have to. You see, I bought the Red Car so I
could dismantle it.
I don't t
IIRC the last time this was brought up it was violently shot-down on
-hackers (and the fact that bugzilla didn't directly support PostgreSQL
back then had nothing to do with it).
Yep, but you never know. Someday it just may happen. The community got
Linus to
stop using his email box for pat
On Mon, 10 Oct 2005, Joshua D. Drake wrote:
J B wrote:
Guys,
I was interested in researching a few items regarding bug reports in
PostgreSQL, but I can't seem to find what the project uses as a bug
tracker. I see the web form and mailing list, but I can't imagine
they're not captured in some
On Mon, Oct 10, 2005 at 05:20:13PM -0700, Joshua D. Drake wrote:
> J B wrote:
>
> >Guys,
> >
> >I was interested in researching a few items regarding bug reports in
> >PostgreSQL, but I can't seem to find what the project uses as a bug
> >tracker. I see the web form and mailing list, but I can't i
On Mon, Oct 10, 2005 at 07:59:16PM -0400, J B wrote:
> Guys,
>
> I was interested in researching a few items regarding bug reports in
> PostgreSQL, but I can't seem to find what the project uses as a bug
> tracker. I see the web form and mailing list, but I can't imagine
> they're not captured in
J B wrote:
Guys,
I was interested in researching a few items regarding bug reports in
PostgreSQL, but I can't seem to find what the project uses as a bug
tracker. I see the web form and mailing list, but I can't imagine
they're not captured in some central repository.
Could someone point me in
What's the datatype on naamvrouw? Notice that it's being casted to text,
which means an index on that column won't be used.
On Mon, Oct 10, 2005 at 11:29:38AM +0200, [EMAIL PROTECTED] wrote:
>
> Tom, Oleg, Yonathan,
>
> thanks for the suggestions.
> Indeed, upping the statistics from 10 to 100 h
On Mon, Oct 10, 2005 at 09:51:48AM -0500, Scott Marlowe wrote:
> Actually, the same could be said of Samba and Apache. I'll take one Tom
> Lane or Jan Wieck or (all the other postgresql hackers go here) over
> 1,000 MySQL hackers.
>
> I wonder what kind of result we would get if we compared somet
Guys,
I was interested in researching a few items regarding bug reports in
PostgreSQL, but I can't seem to find what the project uses as a bug
tracker. I see the web form and mailing list, but I can't imagine
they're not captured in some central repository.
Could someone point me in the right dir
Check the TODO, I'm 99% certain it's on there.
On Mon, Oct 10, 2005 at 02:02:32PM +0200, Csaba Nagy wrote:
> On Mon, 2005-10-10 at 13:34, Lincoln Yeoh wrote:
> [snip]
> > It's actually quite surprising how many people get this wrong and don't
> > realize it (I wonder how many problems are because
Martijn van Oosterhout writes:
> On Mon, Oct 10, 2005 at 05:28:17PM -0400, Tom Lane wrote:
>> But people were a bit worried about what
>> might break.
> In catalog/heap.c there already is a SystemAttributeByName() to do the
> legwork. Seems to me all you'd need to do is check just as you're about
On Mon, Oct 10, 2005 at 05:28:17PM -0400, Tom Lane wrote:
> I recall having proposed that we stop storing explicit pg_attribute
> entries for system columns, which would make this sort of change easier
> to make, and would save a pretty considerable amount of space in
> pg_attribute too. (In the p
Dick Kniep <[EMAIL PROTECTED]> writes:
> We have a user 'x' that is member of group 'a'
> there is a sequence where
> Grant all on table schema.sequence to group 'a'
> But still I get a permission denied when I try to access the sequence as user
> 'x'.
Works fine for me, so you've omitted some
On Mon, 2005-10-10 at 16:37, Dick Kniep wrote:
> Hi list,
>
> I have a weird problem with grants. Probably I am forgetting something, but I
> simply don't understand it.
>
> We have a user 'x' that is member of group 'a'
> there is a sequence where
> Grant all on table schema.sequence to group
Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Mon, Oct 10, 2005 at 04:28:57PM -0400, Tom Lane wrote:
>> It's really highly annoying that we can't see the contents of the
>> infomasks for the rows.
> Any particular reason there isn't an infomask system column?
(a) inertia
(b) lack of desire to ad
Hi list,
I have a weird problem with grants. Probably I am forgetting something, but I
simply don't understand it.
We have a user 'x' that is member of group 'a'
there is a sequence where
Grant all on table schema.sequence to group 'a'
But still I get a permission denied when I try to access t
On Mon, Oct 10, 2005 at 04:28:57PM -0400, Tom Lane wrote:
> It's really highly annoying that we can't see the contents of the
> infomasks for the rows.
Any particular reason there isn't an infomask system column?
--
Michael Fuhr
---(end of broadcast)-
On Mon, 2005-10-10 at 15:51, CSN wrote:
> I don't have a compiler on this machine. If somebody
> can point me to a copy of pg_filedump for Windows (I
> didn't see any using Google) I'd be happy to use it.
> Or perhaps I could compile it under cygwin.
>
> The hard drive is a Western Digital 200GB J
I don't have a compiler on this machine. If somebody
can point me to a copy of pg_filedump for Windows (I
didn't see any using Google) I'd be happy to use it.
Or perhaps I could compile it under cygwin.
The hard drive is a Western Digital 200GB JD (SATA),
if that can be used to determine how badl
CSN <[EMAIL PROTECTED]> writes:
> oid | ctid| xmin | cmin | xmax | cmax | id
> +---+-+--+-+--+-
> 125466 | (2672,11) | 1445346 |0 | 1481020 |0 | 985
> 125466 | (2745,50) | 1481020 |0 | 1682425 |2 | 985
Hmm. The fact tha
[EMAIL PROTECTED] ("Marc G. Fournier") writes:
> Stupid question here, but how susceptible is Oracle to "monopolistic
> practices", similar to what M$ is going through with the DoJ in the
> US? This seems to be *very* close to the line, if it isn't over it
> ... no?
No. The market for databases i
On Mon, Oct 10, 2005 at 06:43:25PM +0300, Ivan Pavlov wrote:
> I have a store procedure which returns a record; the query is defined as:
>
> select * from spec_proc.view_empl_1('bg',2) AS (f1 varchar, f2 varchar,
> f3 date, f4 varchar, f5 varchar,f6 varchar,f7 varchar, f8 varchar, f9
> int, f10 va
--- Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Sun, Oct 09, 2005 at 12:46:51PM -0700, CSN wrote:
> > select * from table1 where id=586;
> > 586|a|b|c|d
>
> Do you get different results from the following
> queries?
>
> SET enable_seqscan TO on;
> SET enable_indexscan TO off;
> SELECT * FROM t
On Mon, 2005-10-10 at 13:53, Qingqing Zhou wrote:
> "Scott Marlowe" <[EMAIL PROTECTED]> wrote
> >
> > Under no circumstances should you do this with a database that has any
> > data in it that you value. pg_dump / pg_restore / psql are the
> > preferred way of doing this.
> >
>
> Oh yeah, sorry f
"Scott Marlowe" <[EMAIL PROTECTED]> wrote
>
> Under no circumstances should you do this with a database that has any
> data in it that you value. pg_dump / pg_restore / psql are the
> preferred way of doing this.
>
Oh yeah, sorry for the miss leading information. My method is dangerous and
can
On Mon, Oct 10, 2005 at 11:29:24AM -0700, Dann Corbit wrote:
> Consider what happened to Stak verse MS. Stak won the court case
> but still went out of business.
My point exactly ;)
Cheers,
D
>
> > -Original Message-
> > From: David Fetter [mailto:[EMAIL PROTECTED]
> > Sent: Monday, Oct
Consider what happened to Stak verse MS.
Stak won the court case but still went out of business.
> -Original Message-
> From: David Fetter [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 10, 2005 11:17 AM
> To: Marc G. Fournier
> Cc: Dann Corbit; snacktime; pgsql-general@postgresql.org
>
On Mon, Oct 10, 2005 at 02:47:31PM -0300, Marc G. Fournier wrote:
>
> Stupid question here, but how susceptible is Oracle to "monopolistic
> practices", similar to what M$ is going through with the DoJ in the
> US? This seems to be *very* close to the line, if it isn't over it
> ... no?
It may w
Marc G. Fournier wrote:
Stupid question here, but how susceptible is Oracle to "monopolistic
practices", similar to what M$ is going through with the DoJ in the
US? This seems to be *very* close to the line, if it isn't over it ...
no?
They are not... too many competitors... MS suffers bec
I think it kind of depends on how they treat with MySQL. If they expect
MySQL to pay them $10,000 per installation, and MySQL was paying Heiki
$100 per installation, then that would be predatory. OTOH, if they
charge the same rate, or some small incremental increase over what
innobase charges now
> > Gregory Youngblood <[EMAIL PROTECTED]> writes:
> >> I've been using SuSE and PostgreSQL for a fairly long time.
> >> Recently (last 12 months), I've noticed that the 9.x (9.2 and
> >> 9.3 specifically) versions of SuSE do not include PostgreSQL on
> >> the CD install -- only on the DVD. At firs
Stupid question here, but how susceptible is Oracle to "monopolistic
practices", similar to what M$ is going through with the DoJ in the US?
This seems to be *very* close to the line, if it isn't over it ... no?
On Mon, 10 Oct 2005, Dann Corbit wrote:
From:
http://www.filmsite.org/whof4.htm
From:
http://www.filmsite.org/whof4.html
Valiant: Come on. Nobody's gonna drive this lousy freeway when they can take
the Red Car for a nickel.
Doom: Oh, they'll drive. They'll have to. You see, I bought the Red Car so I
could dismantle it.
I don't think Oracle has any interest in InnoDB other
On 10/10/05, Greg Sabino Mullane <[EMAIL PROTECTED]> wrote:
>
> A good question. I think one answer is the MySQL name. Many open-source
> advocates seem enamored of MySQL, but you can never pin them down about
> exactly what it is they love so much about it. Maybe we can rebrand
> PG as "MiSQL" or
On 10/7/05, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
http://lnk.nu/prnewswire.com/4dv.pl--Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]Pervasive Software
http://pervasive.comwork: 512-231-6117vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461--
Tom Lane wrote:
> [EMAIL PROTECTED] writes:
>> After upgrading to 8.0.3 I see very poor performance on several indexes.
>> ...
>> Database was recently analyzed. Clearly, something has to be tuned that
>> didn't
>> need tuning on 7.4.3 ? (Main table has about 1.7 million records).
>
> No, there'
On Mon, 2005-10-10 at 10:59, [EMAIL PROTECTED] wrote:
>
>
> Hi All,
> I am sorry if this was already discussed. I am new to the world of
> postgressql and was experincing a problem for which I need help of an
> expert in this lists.
> We have devloped a site(asp.net 1.1) for which we have used po
Marc G. Fournier wrote:
>Stupid question, but what does MySQL bring to the equation? Why not just
>use PostgreSQL in the first place?
really.
to my mind, the best thing the PostgreSQL community can do for the
MySQL community is provide simple, easy to use migration tools
and documentation.
che
[EMAIL PROTECTED] wrote on 10/09/2005 08:16:22 AM:
> >
> > This is the first time I can think of where software being GPL'd might
> > actually hurt the open-source community.
The MySQL license has been modified so that it is, IMHO, not compatible
with the GPL. The basic tenet of the GPL is tha
Venki,
Postgres is using a thread per _realized_ connection, and reserves some
memory per _configured_ connection. So setting the configured connection
count too high is not free even if normally you won't have that many
connections actually open. And of course at peak load the number of
connectio
first of all, your clients are closing connections??
yo should use a pool connection.
2005/10/10, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
>
>
>
>
> Hi All,
> I am sorry if this was already discussed. I am new to the world of
> postgressql and was experincing a problem for which I need help of an
>
I have a store procedure which returns a record; the query is defined as:
select * from spec_proc.view_empl_1('bg',2) AS (f1 varchar, f2 varchar,
f3 date, f4 varchar, f5 varchar,f6 varchar,f7 varchar, f8 varchar, f9
int, f10 varchar, f11 varchar, f12 varchar, f13 int, f14 varchar, f15
date, f16 da
Hi All,
I am sorry if this was already discussed. I am new to the world of
postgressql and was experincing a problem for which I need help of an
expert in this lists.
We have devloped a site(asp.net 1.1) for which we have used postgresql 7.4
as the backend database. When the number of connectio
Hello,
Having freshly installed a PG database (8.0.3), I have difficulties in
tracing exceptions in my PL/pgSQL functions. All my functions
implement a BEGIN-EXCEPTION-END block in which exceptions must be
traced :
BEGIN
-- Some stuff
EXCEPTION
WHEN OTHERS THEN
-- trace
END;
I would l
Sim Zacks <[EMAIL PROTECTED]> writes:
> The version (from select version()) is
> PostgreSQL 8.0.1 on i686-pc-linux-gnu, compiled by GCC i686-pc-linux-gnu-gcc
> (GCC) 3.3.5 (Gentoo Linux 3.3.5-r1, ssp-3.3.2-3, pie-8.7.7.1)
Gentoo eh? When you run a bleeding-edge distribution, sometimes you get
n
> Just for the sake of completeness, there are exactly two differences:
> * PRIMARY KEY implies NOT NULL on the key columns; UNIQUE doesn't.
> * PRIMARY KEY creates a default target for foreign key references,
> ie, if you've declared a primary key then you can later just say
> "REFERENCES myta
Martijn van Oosterhout writes:
> On Mon, Oct 10, 2005 at 04:44:54PM +0200, David Pradier wrote:
>> i'd like to know if it is better to use a primary key made of a couple
>> columns, than to use a constraint UNIQUE() on this couple columns,
>> regarding the sake of postgresql.
> In PostgreSQL, bot
On Mon, Oct 10, 2005 at 09:51:48AM -0500, Scott Marlowe wrote:
> I'll take one Tom Lane or Jan Wieck or (all the other postgresql
> hackers go here) over 1,000 MySQL hackers.
Likewise. They probably don't hear it enough, so I hope they're
aware that some of us have a great deal of respect for bot
qry_Customers_Country is a view.
There is no row in pg_class with relfilenode=7973197 either when it
works or after I get the error.
The version (from select version()) is
PostgreSQL 8.0.1 on i686-pc-linux-gnu, compiled by GCC i686-pc-linux-gnu-gcc
(GCC) 3.3.5 (Gentoo Linux 3.3.5-r1, ssp-3.3.2-3,
> In PostgreSQL, both primary keys and UNIQUE constraints are implemented
> via UNIQUE indexes, ergo there is no difference...
Thanks Martijn, it's exactly what i wanted to know.
Best regards,
David
--
David Pradier -- Directeur Technique de Clarisys Informatique -- Chef de projet
logiciels li
"Sim Zacks" <[EMAIL PROTECTED]> writes:
> I am receiving the following error and cannot understand what it means.
> Please let me know if this makes sense to you.
> ERROR: could not open relation 1663/3364852/7973197: No such file or
> directory
> CONTEXT: SQL statement "create temporary table t
On Mon, 10 Oct 2005 09:53:17 -0500
Dan Armbrust <[EMAIL PROTECTED]> wrote:
> The fact that PostgreSQL is NOT released under GPL is the reason that
> people like me are here - MySQL's license drove us away from them.
> Their change of the driver licensing prevents us from shipping new
> drivers
On Mon, Oct 10, 2005 at 04:44:54PM +0200, David Pradier wrote:
> Hi everybody,
>
> i'd like to know if it is better to use a primary key made of a couple
> columns, than to use a constraint UNIQUE() on this couple columns,
> regarding the sake of postgresql.
In PostgreSQL, both primary keys and U
Brent Wood wrote:
>Two? I haven't used Firebird, but have heard lots of positive comments
>from users. Firebird/Postgres/MySQL together maybe? Or with all the
>embedded SQLlite users out there, perhaps all four :-)
i can't think of a single good reason why anyone in the PostgreSQL
community wo
On Fri, 2005-10-07 at 21:34, Qingqing Zhou wrote:
> <[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 wa
Greg Sabino Mullane wrote:
The other answer may be the license: plugging PG into the MySQL system
(which is about as technically feasible trying to breed a porpoise
and an elephant) keeps MySQL GPL, which is another reason many people
like it.
The fact that PostgreSQL is NOT released under GP
On Thu, 2005-10-06 at 17:42, Mark Cave-Ayland wrote:
> Hi everyone,
>
> I've just got back from LinuxWorld in London and seeing this thread thought
> I would share my experience of the MySQL stand - if you are of a delicate
> dispostion, please look away now. I basically asked them straight up why
Hi everybody,
i'd like to know if it is better to use a primary key made of a couple
columns, than to use a constraint UNIQUE() on this couple columns,
regarding the sake of postgresql.
For example, i've got these two tables, 'buyer' and 'purchaser' and i
want to make an association table buyer_p
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> Stupid question, but what does MySQL bring to the equation? Why
> not just use PostgreSQL in the first place?
A good question. I think one answer is the MySQL name. Many open-source
advocates seem enamored of MySQL, but you can never pin them d
I am receiving the following error and cannot understand what it means.
Please let me know if this makes sense to you.
ERROR: could not open relation 1663/3364852/7973197: No such file or
directory
CONTEXT: SQL statement "create temporary table tmpcust as select a.* from
qry_Customers_Country a"
On Sun, 9 Oct 2005, CSN wrote:
>
> Maybe this is a crazy idea, I don't know how
> technically or legally feasible it is, but I really
> like the idea of the two open-source communities
> uniting to battle Oracle.
>
Two? I haven't used Firebird, but have heard lots of positive comments
from user
"Premsun Choltanwanich" <[EMAIL PROTECTED]> writes:
> The lib I use is call lo_in and lo_out for manage BLOB.
> I understand that lo_unlink be related with lo_import and lo_export so I
> don't think that it work.
It's exactly what you want--it removes a LO with the specified OID
from the large ob
On Mon, 2005-10-10 at 13:34, Lincoln Yeoh wrote:
[snip]
> It's actually quite surprising how many people get this wrong and don't
> realize it (I wonder how many problems are because of this). The SQL spec
> should have had a PUT/MERGE decades ago. The insert vs update format being
> different i
Actually I think the uniqueness constraint (due to the primary key) is the
one handling it. There's nothing special about that function that will
prevent duplicates.
Try running it without the primary key specifications in two separate
concurrent transactions. Then commit both transactions.
Tom, Oleg, Yonathan,
thanks for the suggestions.
Indeed, upping the statistics from 10 to 100 helped.
But order by did not:
palga=# explain analyze select rapnaam from udps where geboortedatum =
'1966-01-01' and naamvrouw like 'vos%' order by geboortedatum;
Hello.
I have found README file, and tried to install pg_autovacuum as Windows
service, by a batch file:
@echo off
set ODREDISTE=C:
echo target disc is %ODREDISTE%
cd %ODREDISTE%\Program Files\PostgreSQL\8.0\bin
pg_autovacuum.exe pgsql-8.0.4 -I -N postgres_service -W postgres_service
"postgres
I found loid column in pg_catalog.pg_largeobject. I try to match loid with any numbers in oid column and lo column but I cannot found some that matched.
What think I do that wrong? Please advise>>> Moises Alberto Lindo Gutarra <[EMAIL PROTECTED]> 07-Oct-05 18:40:12 pm >>>try: delete from pg_c
The lib I use is call lo_in and lo_out for manage BLOB.
I understand that lo_unlink be related with lo_import and lo_export so I don't think that it work.
>>> Douglas McNaught <[EMAIL PROTECTED]> 07-Oct-05 20:13:36 pm >>>Moises Alberto Lindo Gutarra <[EMAIL PROTECTED]> writes:> try: delete fr
On 09.10.2005 08:48, andrew wrote:
A very usual and smart approach is to use clases in PEAR::DB.
Well, IMHO PEAR::DB is one of the worst classes of PEAR. Besides its
ugly code it's worth nothing. This is some incomplete "abstraction
layer" for kiddies, to make it easy for people coming from s
> > Go the installation directory and try
> > #make uninstall - > if it doesn't work then do the following
> >
> > # make clean
> > # make dist clean
> > and remove the directory manually
> >
>
> I think he wants to know how to uninstall the files that were
> installed with 'make install', not th
On 10/6/05, suresh ramasamy <[EMAIL PROTECTED]> wrote:
> On 10/6/05, Ly Lam Ngoc Bich <[EMAIL PROTECTED]> wrote:
> > I am using Linux Fedora 3 . I've installed Postgres with
> > postgresql-8.0.3.tar.gz package , so there is no rpm package when I
> > check with
> > rpm -qa|grep postgresql
> >
> >
92 matches
Mail list logo
