Peter Harvey wrote:
>
> Great progress today on my Reverse Engineering efforts. However; I have
> some comments.
>
> 1. How can I switch databases (where I would normally use USE)?
You just open another connection .
If you mean psql jou do
\c otherdatabasename
> 2. How do I determine the Acc
Great progress today on my Reverse Engineering efforts. However; I have
some comments.
1. How can I switch databases (where I would normally use USE)?
2. How do I determine the AccessMethod specified when an index was
created?
3. It would be cool if the catalog objects had comments on them in
p
you're right. nothing special.
Oleg
On Wed, 22 Aug 2001, Tom Lane wrote:
> Teodor <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> ... on my machine "inf" appears to be the correct result. Is this a
> >> platform dependency, or just a lack of synchronization somewhere else?
>
> > On
Approved with Tom's suggested changes.
Your patch has been added to the PostgreSQL unapplied patches list at:
http://candle.pha.pa.us/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
> Hi,
>
> There are two problems when compiling libpq.dll and psql.exe
> on Windows.
Mikhail Terekhov <[EMAIL PROTECTED]> writes:
> There are two problems when compiling libpq.dll and psql.exe
> on Windows. I'm not sure it is the best way to fix them
> (see patch below.) Comments?
The first should probably be conditional on HAVE_UNIX_SOCKETS,
not on WIN32. The second change look
Teodor <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> ... on my machine "inf" appears to be the correct result. Is this a
>> platform dependency, or just a lack of synchronization somewhere else?
> On my box FreeBSD4.3 it looks as 'Inf'. Very similar that this is
> platform dependency.
I'm in
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I am getting presistant requests from people asking why their patches
> > haven't appeared on the patches list yet. I have had it happen to me.
>
> I believe part of the problem is that pgsql-patches has the same size
> limit (40K IIRC) as all the
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I am getting presistant requests from people asking why their patches
> haven't appeared on the patches list yet. I have had it happen to me.
I believe part of the problem is that pgsql-patches has the same size
limit (40K IIRC) as all the other lists
I am getting presistant requests from people asking why their patches
haven't appeared on the patches list yet. I have had it happen to me.
This is pretty serious because when you add another day of delay in
email delivery to the 1-2 days the patch sits in the patch queue, things
are getting ou
Tom Lane wrote:
>
> Oleg Bartunov <[EMAIL PROTECTED]> writes:
> > Teodor finally made patches to current CVS, please review and apply them asap
> > to be in sync with development (last time it was kind of problem)
>
> Checked and committed. Note I did not commit your change to the cube
> regr
Lamar Owen <[EMAIL PROTECTED]> writes:
> Egads! An Internet where people don't remember Kibo...
Yup, I do. I think he gave up years ago, though.
I useta be a small-time kibozer myself --- back in the early days of
JPEG, when a lot of people didn't really understand the format, I had
a little p
Hi,
There are two problems when compiling libpq.dll and psql.exe
on Windows. I'm not sure it is the best way to fix them
(see patch below.) Comments?
Regards,
Mikhail Terekhov
Index: bin/psql/prompt.c
===
RCS file: /home/projects/p
On Tue, 21 Aug 2001, D. Hageman wrote:
> On Tue, 21 Aug 2001, Vince Vielhaber wrote:
>
> >
> > In the seemingly hundreds of thousands of messages on the bug database
> > topic I think I've come up with the following..
> >
> > Solution..
> >
> > Is implementing yet another bugtool going to be the
> > Actually, the 'multi-day' delay is generally related to posts from ppl
> > that aren't subscribed to the lists that I have to approve manually ...
>
> I have been getting delayed duplicates from people (ie, Tom Lane)
addressed
> to only the hackers list (which I know he's subscribed to). Up t
Oh, one other comment --- the rtree_gist code had a bunch of functions
declared like
GISTENTRY * gbox_compress(PG_FUNCTION_ARGS);
BOX *gbox_union(PG_FUNCTION_ARGS);
GIST_SPLITVEC * gbox_picksplit(PG_FUNCTION_ARGS);
bool gbox_consistent(PG_FUNCTION_ARGS);
float * gbox_penalty(PG_FUNCTION_ARGS);
bo
Oleg Bartunov <[EMAIL PROTECTED]> writes:
> Teodor finally made patches to current CVS, please review and apply them asap
> to be in sync with development (last time it was kind of problem)
Checked and committed. Note I did not commit your change to the cube
regression test:
*** ./contrib/cube/
Peter Eisentraut wrote:
> Tom Lane writes:
>
> > I think this is fairly irrelevant, because a not-yet-backend should
> > have a fairly short timeout (a few seconds) before just shutting
> > down anyway, so that malfunctioning clients can't cause denial of
> > service; the particular case you menti
On Wed, 22 Aug 2001, Tom Lane wrote:
> Looking at the revised version of initGISTstate, I am thinking that
> I missed a step in updating the main indexing code for the new
> pg_opclass definition. It seems to me that if opckeytype is not 0,
> that datatype ought to be used to declare the index c
On Tuesday 21 August 2001 17:51, Vince Vielhaber wrote:
> On Tue, 21 Aug 2001, Lamar Owen wrote:
> > > > > I disagree. Unless you are omniscient,
> > We need someone willing to be a kibo. Or is that too arcane a reference?
> Gotta admit, I haven't heard that in a while.
Egads! An Internet whe
Oleg Bartunov <[EMAIL PROTECTED]> writes:
> if you look into previous patch we sent (patch_72_systbl.gz)
> you could find patch for ./src/backend/catalog/index.c which
> is exact implementation of what 'seems to you' :-)
So you did. I'm not sure why I thought that was a bad idea when I
was revie
Tom Lane writes:
> I think this is fairly irrelevant, because a not-yet-backend should
> have a fairly short timeout (a few seconds) before just shutting
> down anyway, so that malfunctioning clients can't cause denial of
> service; the particular case you mention is just one scenario.
I have a
OK. You may apply patches to contrib modules (from the last patch)
and new btree module. Teodor will sent patch to core tomorrow.
Oleg
On Wed, 22 Aug 2001, Tom Lane wrote:
> Oleg Bartunov <[EMAIL PROTECTED]> writes:
> > if you look into previous patch we sent (patch_72_systbl.gz)
> > y
Looking at the revised version of initGISTstate, I am thinking that
I missed a step in updating the main indexing code for the new
pg_opclass definition. It seems to me that if opckeytype is not 0,
that datatype ought to be used to declare the index column type from
the beginning. Then initGISTs
It has come to our attention that many applications which use libpq
are vulnerable to code insertion attacks in strings and identifiers
passed to these applications. We have collected some evidence which
suggests that this is related to the fact that libpq does not provide
a function to escape st
Tom Lane writes:
> What I'm thinking is that if we hard-wired usesysid = 1 for the
> superuser, it'd be possible to arrange for standalone backends to fire
> up with that sysid and superuserness assumed, and not consult pg_shadow
> at all. Then you'd have a platform in which you could do CREATE
Tatsuo Ishii writes:
> I don't understand why you object the idea giving PostgreSQL the
> ability to turn off the locale support in configuration/compile
> time. In that way, there's no inconveniences for "many users".
I don't mind at all the ability to turn it off. My point is that the
compile
Lamar Owen <[EMAIL PROTECTED]> writes:
> On Tuesday 21 August 2001 19:45, Marc G. Fournier wrote:
>> Actually, the 'multi-day' delay is generally related to posts from ppl
>> that aren't subscribed to the lists that I have to approve manually ...
> I have been getting delayed duplicates from peop
On Tuesday 21 August 2001 19:45, Marc G. Fournier wrote:
> Actually, the 'multi-day' delay is generally related to posts from ppl
> that aren't subscribed to the lists that I have to approve manually ...
I have been getting delayed duplicates from people (ie, Tom Lane) addressed
to only the hack
Matthew T. O'Connor volunteered:
> I don't know what a kibo is, but I would be willing to put in some time
> helping maintaing a bug reporting system. One of the helpful things with
> bugzilla setup with some other big projects is that the bug gets assigned
to
> a developer and the bug submitter
Jan Wieck said:
> > Has anyone thought of using Bugzilla? (It is MySQL based, of course) but
it
> > might answer the bug database issues. (If you guys want a bug database)
>
> Bug tracking software that doesn't use transactions and
> referential integrity in a multiuser environment?
> -Original Message-
> From: Peter Eisentraut
>
> Hiroshi Inoue writes:
>
> > If your solution is short-lived, your change would be not
> > only useless but also harmful. So I expect locale-aware
> > people to confirm that we are in the right direction.
>
> I am a bit confused here. We ha
Your patch has been added to the PostgreSQL unapplied patches list at:
http://candle.pha.pa.us/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
> Tom,
>
> Teodor finally made patches to current CVS, please review and apply them asap
> to be in sync with development (
Tom,
Teodor finally made patches to current CVS, please review and apply them asap
to be in sync with development (last time it was kind of problem)
gistpatch.gz
1. gistpatch.gz - core GiST changes, all gist contrib modules were fixed reflecting
all changes. Added linear-time split algorith
Hi people!.I developed a work for an university course, which I wish to share with
you.
I extended the foreign key clause in the create table in order to permit insertions
and updates on a referencing table (a table with foreign key
attributes) with all kind of actions (the existing ones plus
I think it'd be not so difficult to extend our mailware
(fts.postgresql.org) to handle bug-list. Actually,
mailware has much more features, it's already has search/read,
track features. Adding post is trivial. Developers (who actually
fix a bugs) usually read mailing lists and reply's to BUG, whic
Jan Wieck wrote:
>
> mlw wrote:
> > Has anyone thought of using Bugzilla? (It is MySQL based, of course) but it
> > might answer the bug database issues. (If you guys want a bug database)
>
> Bug tracking software that doesn't use transactions and
> referential integrity in a multi
Hi!
I have to migrate application from Delphi/MSSQL to Kylix/.
One of things used in this app is INSERTED/DELETED tables in triggers.
It's something like NEW and OLD records, but may contain multiple rows.
My questions are:
How difficult would it be to implement such a feature in PostgreSQL?
Wha
> DBMS should be independent from the OS settings as far as
> possible especially in the handling of data. Currently we
> could hardly judge if we are running on a locale or not from
> the dbms POV and it doesn't seem a dbms kind of thing in the
> first place. I'm a dbms guy not an OS guy and real
38 matches
Mail list logo
