On Wed, 13 Dec 2000, mlw wrote:
> I propose we modify C functions for 7.2.
Too simple imagine anything, but often difficult do it :-)
> (1) C functions should be able to return multiple values.
for 7.2 / 7.3 are planned functions return tuples, but do it
is really diffucult. See the curre
Hi,
I have just tried using the ILIKE function in 7.0.3. I assume that it is
just a case-insensitive version of LIKE. (Please correct me if I am wrong
on this assumption.)
This is my example test case:
usa=# select 'test' LIKE '%es%';
?column?
--
t
(1 row)
usa=# select 'test' ILIKE
I propose we modify C functions for 7.2.
( I'll volunteer to do as much as I can figure out ;-)
(1) C functions should be able to return multiple values.
(2) A setup and breakdown function should be able to be called
surrounding the query set in which a function is called. This allows
construc
[EMAIL PROTECTED] (Nathan Myers) writes:
> I don't know if you get the point of the fixed-size comment field.
> The idea was that a comment could be poked into an existing COPY
> image, after it was written.
Yes, I did get the point ...
> A variable-size comment field in an
> already-written
mlw <[EMAIL PROTECTED]> writes:
> I just have to find where I call the exit function.
That will be the hard part.
FmgrInfo is not currently considered a durable data structure, and I
think you will be in for grief if you try to make any guarantees about
what will happen when one disappears. If
O
> > Always remember that a psotgres data base on the harddisk can be
> > manipulated accidentally / maliciously without postgres even running.
> > These are the cases where you need row level CRCs.
>
> "There is no security without physical security." If somebody can
> change the row contents,
Hi,
I am trying to emulate MySQL's SET type, by creating a new postgresql type.
However, is it possible to create a type that has different parameters
wherever it is used.
For instance - the varchar type takes as a parameter the max characters in
the field. Although there is only one varchar t
As a lurker on the list this post caught my eye somewhat. I think this
would be excellent functionality to have in postgres, i was considering
doing something like this in a non intruse manner, by manipulating
_init() and _fini functions of shared libraries. But what you have
described below is
Vincent AE Scott wrote:
>
> As a lurker on the list this post caught my eye somewhat. I think this
> would be excellent functionality to have in postgres, i was considering
> doing something like this in a non intruse manner, by manipulating
> _init() and _fini functions of shared libraries. Bu
On Tue, Dec 12, 2000 at 05:28:46PM -0500, Bruce Momjian wrote:
> > On Sun, Dec 10, 2000 at 06:53:11PM -0500, Bruce Momjian wrote:
> > > > I appreciate your comments and would like to respond to your
> > > > concerns. The API I sketched in my earlier e-mail is borrowed
> > > > heavily from Rogue Wa
Tom Lane wrote:
>
> mlw <[EMAIL PROTECTED]> writes:
> > btw anyone trying this query should use: "attdispersion"
>
> Sorry about that --- I just copied-and-pasted the query from some notes
> that are obsolete as of 7.1...
>
> > cdinfo=# explain select * from ztitles where artistid = 10220 ;
On Mon, Dec 11, 2000 at 11:32:17PM -0500, Tom Lane wrote:
> The Hermit Hacker <[EMAIL PROTECTED]> writes:
> > worst case, we pull it out afterwards ...
>
> No, worst case is that we release a seriously broken 7.1, and don't
> find out till afterwards.
>
> There are plenty of new features on my t
On Sun, Dec 10, 2000 at 08:51:52PM -0500, Tom Lane wrote:
> [EMAIL PROTECTED] (Nathan Myers) writes:
> > I'd like to see a timestamp for when the image was created, and a
> > 128-byte comment field to allow annotations, even after the fact.
>
> Both seem like reasonable options. If you don't mi
I'm having trouble with like et.al. as there is no single character
in et_EE locale (on linux at least) that is bigger than all the others.
I would like to modify my locale definition files so that char(255)
would always sort after all others but I can't find docs on modifying
the locales
So
> On Sun, Dec 10, 2000 at 06:53:11PM -0500, Bruce Momjian wrote:
> > > I appreciate your comments and would like to respond to your concerns.
> > > The API I sketched in my earlier e-mail is borrowed heavily from
> > > Rogue Wave's dbtools.h++ library. I think it can be a very clean and
> > > ele
On Sun, Dec 10, 2000 at 06:53:11PM -0500, Bruce Momjian wrote:
> > I appreciate your comments and would like to respond to your concerns.
> > The API I sketched in my earlier e-mail is borrowed heavily from
> > Rogue Wave's dbtools.h++ library. I think it can be a very clean and
> > elegant way o
mlw <[EMAIL PROTECTED]> writes:
> btw anyone trying this query should use: "attdispersion"
Sorry about that --- I just copied-and-pasted the query from some notes
that are obsolete as of 7.1...
> cdinfo=# explain select * from ztitles where artistid = 10220 ;
> NOTICE: QUERY PLAN:
> Seq S
On Sat, Dec 09, 2000 at 12:03:52AM +1100, Horst Herb wrote:
> AFAIK the thread for "built in" crcs referred only to CRCs in
> the transaction log.
We have been discussing checksums for both the table blocks and for
the transaction log.
> Always remember that a psotgres data base on the harddisk
On Thu, Dec 07, 2000 at 07:36:33PM -0500, Tom Lane wrote:
> [EMAIL PROTECTED] (Nathan Myers) writes:
> > 2. I disagree with way the above statistics were computed. That eleven
> >million-year figure gets whittled down pretty quickly when you
> >factor in all the sources of corruption, e
Thanks for the vote of confidence. I'm looking forward to doing it. I've
got most of the classes needed laid out. Once I'm done this step, I'll
post what I have for more comments, crticism, suggestions.
Cheers,
Randy
On Sun, 10 Dec 2000, Bruce Momjian wrote:
> > I appreciate your comments
"Martin A. Marques" <[EMAIL PROTECTED]> writes:
> It occurs either because system limit for the maximum number of
> semaphore sets (SEMMNI), or the system wide maximum number of
> semaphores (SEMMNS), would be exceeded. You need to raise the
> respective kernel parameter. Look into the PostgreS
> >> What is the default commit delay now?
>
> > As before 5 * 10^(-6) sec - pretty the same as sleep(0) -:)
> > Seems CommitDelay is not very useful parameter now - XLogFlush
> > logic and fsync time add some delay.
>
> There was a thread recently about smarter ways to handle shared fsync
> of
You'll need to make a unique index/unique constraint on the fields
of child you wish to constrain. The unique constraint check wasn't
checked in 7.0, and also unique constraints are not inherited so
it has to be on the actual table you want to reference.
Stephan Szabo
[EMAIL PROTECTED]
On Wed,
Jonathan Ellis wrote:
>
> > I went to fix this and then realized I still don't have an adequate spec
> > of how Oracle defines these functions. It would seem logical, for
> > example, that lpad might truncate on the left instead of the right,
> > ie lpad('abcd', 3, 'whatever') might yield 'bcd'
Arno A. Karner writes:
> when i compile on linux i get shared libs, on sco with udk, or sdk just
> get static libs
> can some on point me to the config files to hack to get both static, and
> shared libs
Try the patch below. I don't actually have SCO, but it's what I
constructed from the docume
> I take it from the smiley that you're not serious, but actually it seems
> like it might not be a bad idea. I could see appending a CRC to each
> tuple record. Comments anyone?
Let's not get paranoid. If you compress the output the file will get checksummed
anyway. I am against a CRC in bina
This problem with foreign keys has been reported to me, and I have confirmed
the bug exists in current sources. The DELETE should succeed:
---
CREATE TABLE primarytest2 (
col1 INTEGER,
Hi,
I have been using Postgres-7.0.2 on Solaris 8 for the past few months, and
was about to upgrade to 7.1-test, and after following carefully the docs, I
get this:
postgres@ultra31:~ > /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
IpcSemaphoreCreate: semget(key=5432004, num=17, 0360
I think the newC function idea is pretty good, however, what would be
great is just one more step of protocol, perhaps an API verson 2 or 3:
One thing than makes writing a non-trivial function a bit problematic,
and perhaps even less efficient, is that the function does not know when
it is first
On Sunday 10 December 2000 17:35, you wrote:
> > 1.) A CRC is _not_ stronger than a hash. CRC is a subset of the hash
> > domain, defined as "a fast error-check hash based on mod 2 polynomial
> > operations" which has typically no crypto strength (and does not need it
> > either for most purposes
I am also trying to port PostgreSQL to Dynix/ptx
4.4.5. I have GNU gcc 2.95.2.
I also have errors when trying to configure and make
the application and I am not particularily well
qualified to sort them out. I would however be pleased
to help where I can.
Barry
___
Ooops, sorry, error in this example:
> The following example worked in previous versions (7.0.2 was the last I
> tested), but not in 7.1 any more:
>
> create table parent (
> global_id serial
> );
>
> create table child (
> anything text
> ) inherits (parent);
>
> create table foreign (
> fk_id in
Philip Warner <[EMAIL PROTECTED]> writes:
> How about a CRC? ;-P
I take it from the smiley that you're not serious, but actually it seems
like it might not be a bad idea. I could see appending a CRC to each
tuple record. Comments anyone?
You seemed to like the PNG philosophy of using feature f
Philip Warner <[EMAIL PROTECTED]> writes:
> More a matter of not thinking it was important enough to worry about, and
> not really wanting to drag the MD5/MD4/CRC64/etc debate into this one.
I'd just as soon not drag that debate in here either ;-) ... but once we
settle on an appropriate CRC meth
At 19:55 8/12/00 -0500, Tom Lane wrote:
>Philip Warner <[EMAIL PROTECTED]> writes:
>> How about a CRC? ;-P
>
>I take it from the smiley that you're not serious, but actually it seems
>like it might not be a bad idea. I could see appending a CRC to each
>tuple record. Comments anyone?
More a mat
Tom,
Hope this helps
>From the Oracle manual:
Purpose
Returns char1, left-padded to length n with the sequence of characters
in char2; char2 defaults to a single blank. If char1 is longer than n,
this function returns the portion of char1 that fits in n.
The argument n is the total length of th
well im trying to get apache + php4 + pgsql 7.0.3 running on sco
givin up on the udk on sco openserver 5.0.5 now using sdk on sco open
server 5.0.4
i can compile all the stuff static, but php4 wants to used shared
libpq.so i get undefined symbold on php4 module load unresolved symbol
PQfinish
whe
At 01:27 8/12/00 -0500, Tom Lane wrote:
>Recovering the data on a machine
>of different endianness is a project for future data archeologists.
It's frightening to think that in 1000 years time people will be deducing
things about our society from the way we stored data.
>
>Tell you the truth, I
"Ross J. Reedstrom" wrote:
>Here's the current set of Debian packages derived from the main postgresql
>source, with their descriptions:
...
>
>the -pl package contains both plpgsql and pltcl. The descripton there
>needs updating.
This is a mistake, and the dependencies aren't right.
> I see it, yes. Was this an intended change ? I am quite sure, that it was
> attdisbursion in 7.0 ?
Yes, I couldn't spell dispersion in the past. :-)
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is
The following example worked in previous versions (7.0.2 was the last I
tested), but not in 7.1 any more:
create table parent (
global_id serial
);
create table child (
anything text
) inherits (parent);
create table foreign (
fk_id int4 references parent(global_id) on update cascade on delete
> btw anyone trying this query should use: "attdispersion"
>
I see it, yes. Was this an intended change ? I am quite sure, that it was
attdisbursion in 7.0 ?
Andreas
Tom Lane wrote:
>
> mlw <[EMAIL PROTECTED]> writes:
> > cdinfo=# explain select * from ztitles where artistid = 0 ;
> > NOTICE: QUERY PLAN:
>
> > Index Scan using ztitles_artistid_ndx on ztitles (cost=0.00..5915.01
> > rows=3163 width=296)
>
> > When postmaster is started without "-o -fs" I g
> I have an index on group_id, one on
> (group_id,status_id) and one on (group_id,status_id,assigned_to)
As an aside notice: you should definitely only need the last of the
three indices, since it can perfectly work on group_id
or group_id + status_id only restrictions.
Andreas
44 matches
Mail list logo
