Lamar Owen <[EMAIL PROTECTED]> writes:
> Tom, try out a PPC build on this one. I know of one problem that I have
> to fix -- postgresql-perl fails dependencies for libpq.so (I backed out
> the patch to Makefile.shlib).
The backend seems to build OK, but the build fails in interfaces/perl5
becaus
Bruce Momjian <[EMAIL PROTECTED]> writes:
> In one of the emails I deleted from my mailbox, the person stated they
> are identical, except in price.
That's what I kinda suspected, but I'd like to see an authoritative
statement. Who was this person?
regards, tom lane
In one of the emails I deleted from my mailbox, the person stated they
are identical, except in price.
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Here are the URL's for the SQL standards. Where should these go? Are
> > they legal?
>
> > http://www.ansi.org
> > http://www.contrib.andrew.cm
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Here are the URL's for the SQL standards. Where should these go? Are
> they legal?
> http://www.ansi.org
> http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt
> ftp://gatekeeper.dec.com/pub/standards/sql
> ftp://jerry.ece.umassd.edu/isowg3/x3h2/
Here are the URL's for the SQL standards. Where should these go? Are
they legal?
http://www.ansi.org
http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt
ftp://gatekeeper.dec.com/pub/standards/sql
ftp://jerry.ece.umassd.edu/isowg3/x3h2/Standards/
ANSI PDF $20
ISO PDF $310
--
Bruce M
Travis Bauer <[EMAIL PROTECTED]> writes:
> I have attached a simple change to src/pl/plperl/plperl.c to
> enable the :bash_math opcodes. Currently plperl.c only
> enables the :default opcodes. This leave out about five of six
> math functions including sqrt().
This seems like a reasonable chan
I have attached a simple change to src/pl/plperl/plperl.c to
enable the :bash_math opcodes. Currently plperl.c only
enables the :default opcodes. This leave out about five of six
math functions including sqrt().
It might be worth considering allowing the user's to enable
other packages on the
Restated in TODO:
* Allow [INSERT/UPDATE] ... RETURNING new.col or old.col (Philip)
> At 09:14 8/07/00 -0400, Bruce Momjian wrote:
> >> hi,
> >>
> >> threre are a postgresql/mysql comparative.
> >> You can get something for the TODO:
> >>
> >> http://www.phpbuilder.com/columns/tim20
e
> know that suffering produces perseverance; perseverance, character;
> and character, hope.
> -- Romans 5:3-4
> http://www.heartlight.org/cgi-shl/todaysverse.cgi?day=20010118
> ===
> Created by Mail2Sig - http://pdunford.godzone.net.nz/software/mail2sig/
>
>
Done and applied.
> As long as we're cleaning things up, I would suggest that all the ports
> that use gcc assembler be made to declare it uniformly, as
>
> __asm__ __volatile__ ( ... );
>
> As I read the GCC manual, there's some risk of the asm sections getting
> moved around in the prog
As long as we're cleaning things up, I would suggest that all the ports
that use gcc assembler be made to declare it uniformly, as
__asm__ __volatile__ ( ... );
As I read the GCC manual, there's some risk of the asm sections getting
moved around in the program flow if they are not marked
Patrick Welche <[EMAIL PROTECTED]> writes:
>> From http://www.postgresql.org/devel-corner/docs/admin/charset.htm
>Once you have chosen a set of localization rules this way you must
>keep them fixed for any particular database cluster. That means that
>the locales that were active when
In looking at the VAX ASM problem, I realized that the ASM in s_lock.h
is all formatted differently, making it even more confusing. I have
applied the following patch to s_lock.h to try and clean it up.
The new standard format is:
/*
* Standard __asm__ format:
*
Added to TODO:
* Add SHOW command to see locale
> Barry Lind <[EMAIL PROTECTED]> writes:
> > I meant to ask this the last time this came up on the list, but now is a
> > good time. Given what Tom describes below as the behavior in 7.1
> > (initdb stores the locale info), how do you dete
Barry Lind <[EMAIL PROTECTED]> writes:
> I meant to ask this the last time this came up on the list, but now is a
> good time. Given what Tom describes below as the behavior in 7.1
> (initdb stores the locale info), how do you determine what locale a
> database is running in in 7.1 after initdb?
It seems for me your test program do same thing as PostgreSQL backend
does. So I would say if the program worked well, why not PostgreSQL
works?
What do you think Oleg?
From: Maneerat Sappaso <[EMAIL PROTECTED]>
Subject: Program test strcoll().
Date: Thu, 18 Jan 2001 19:52:39 -0700 (GMT)
Message
I meant to ask this the last time this came up on the list, but now is a
good time. Given what Tom describes below as the behavior in 7.1
(initdb stores the locale info), how do you determine what locale a
database is running in in 7.1 after initdb? Is there some file to look
at? Is there some
Added to TODO:
* Add conversion function from text to inet
> > Is this a TODO item?
>
> Yup. Somehow there is a conversion from inet to text, but not the other
> way around.
>
> - Thomas
>
--
Bruce Momjian| http://candle.pha.pa.us
[EMA
Rob van Nieuwkerk <[EMAIL PROTECTED]> writes:
> Checking whith ps and looking in /proc reveiled that postmaster indeed
> had LANG set to "en_US" in its environment. I disabled the system script
> that makes this setting, restarted postgres/postmaster and reran my tests.
> The problem query retur
> Is this a TODO item?
Yup. Somehow there is a conversion from inet to text, but not the other
way around.
- Thomas
I've completed a paper design for the reimplementation of DeadLockCheck.
Notes attached, in case anyone wants to kibitz. (This will appear in
storage/lmgr/README when I commit the code.)
regards, tom lane
-
"Stefan Waidele jun." wrote:
>At 13:37 18.01.2001 -0500, Tom Lane wrote:
>>"Stefan Waidele jun." <[EMAIL PROTECTED]> writes:
>> > How can I tell Postgres to return an interval value in an format like
>> hhh:mm?
>>
>>See to_char(),
>>http://www.postgresql.org/devel-corner/docs/postgr
Tom Lane writes:
> Gene and I looked into this, and the cause of the misbehavior is this:
> gcc on this installation is set to search /usr/local/lib (along with the
> usual system library directories). libz.so and libreadline.so are
> indeed in /usr/local/lib, so configure's tests to see if they
Rob van Nieuwkerk <[EMAIL PROTECTED]> writes:
> I know very little about this LANG, LOCALE etc. stuff.
> But for our application it is very important to support "weird" characters
> like "éõåÊ ..." etc. for names. Basically we need all letter symbols
> in ISO-8859-1 (Latin 1).
en_US is latin1
Zeugswetter Andreas SB writes:
> > You don't need to put this check into configure, you can just
> > do the check after mktime() is used.
>
> No, we need that info for the output functions that only use localtime.
> The intent is, to not use DST before 1970 on platforms that don't have
> mktime f
Tom Lane wrote:
> > I don't think I'm running postmaster in a non-ASCII locale.
> > At least I did not explicitly do anything to accomplish it.
>
> Did you have LANG, LOCALE, or any of the LC_xxx family of
> environment variables set when you started the postmaster?
> Some Linux distros tend to
On Wed, Jan 17, 2001 at 10:34:45PM +0100, Emmanuel Charpentier wrote:
> Nathan Myers wrote:
> > Not true. There are Debian source packages,
> Where are they ? I'm *quite* interested !
> > and taking the source
> > package from Debian 2.x, x>2 (woody
Hi Mark,
I just checked: the "demo.dump" file does not contain any characters
above 0x7F; it's just plain ASCII. So that can't be the reason.
greetings,
Rob van Nieuwkerk
> Rob van Nieuwkerk wrote:
Ehm .., *you* wrote this ! :-)
> I tried to reproduce this bug on 7.0.2 and
> I don't think I'm running postmaster in a non-ASCII locale.
> At least I did not explicitly do anything to accomplish it.
Did you have LANG, LOCALE, or any of the LC_xxx family of
environment variables set when you started the postmaster?
Some Linux distros tend to set those in system profile s
Rob van Nieuwkerk wrote:
I tried to reproduce this bug on 7.0.2 and 7.0.3 with both 8K and 32K block
sizes, and could not reproduce the error.
I am running RedHat 6.2 kernel 2.2.16.
I don't know enough to even be close, but I wonder if there are any subtle
differences between the way characters
Aditya Damle <[EMAIL PROTECTED]> writes:
> Then i went ahead reindexed the table: I recieved the error:
> Cannot create unique index. Table contains non-unique values.
Curious. When you say "reindexed" do you mean you used the REINDEX
command? That's new in 7.0.* and possibly not fully debugged
Tom Lane wrote:
>
> [EMAIL PROTECTED] (Rob van Nieuwkerk) writes:
> > The problem is that a SELECT with a certain LIKE condition in combination
> > with a GROUP BY does not find the proper records when there is an index on
> > the particular column present. When the index is removed the SELECT *
[EMAIL PROTECTED] (Rob van Nieuwkerk) writes:
> The problem is that a SELECT with a certain LIKE condition in combination
> with a GROUP BY does not find the proper records when there is an index on
> the particular column present. When the index is removed the SELECT *does*
> return the right an
On Thu, 18 Jan 2001, Rod Taylor wrote:
> create table example (
> original_oid oid REFERENCES table(oid)
> ON UPDATE CASCADE
> ON DELETE SET NULL
> );
> --
> ERROR: UNIQUE constraint matching given keys for reference table "table" not found
>
> Postgresql 7.1beta3. I'd consid
>From http://www.postgresql.org/devel-corner/docs/admin/charset.htm
Once you have chosen a set of localization rules this way you must
keep them fixed for any particular database cluster. That means that
the locales that were active when you ran initdb must be kept the same
when you s
On Mon, Oct 09, 2000 at 04:11:20PM -0300, The Hermit Hacker wrote:
> On Sun, 8 Oct 2000, Tom Lane wrote:
...
> > Also, we not long ago went through the exercise of making sure that all
> > committers were standardized on the same version of Autoconf, ie, 2.13.
> > Now it emerges that hub.org is r
Doesn't appear
that you can use OLD.oid in triggers (actually does more, =but thats good
enough):CREATE FUNCTION history_update_delete() RETURNS OPAQUE AS
'DECLARE v_tablename
varchar(40); v_history_tablename
varchar(48); v_operation
varchar(6);BEGIN v_operation :=3D
TG_OP;
Just tried it for the first time:
% cd src/test/locale
% gmake all
gmake: Circular test-pgsql-locale <- all dependency dropped.
cd: can't cd to pgsql-locale
gmake: *** [test-pgsql-locale] Error 2
I think the next stage is gmake test-koi8..
Cheers,
Patrick
Hello,
I've selected postgresql 7.0.3 for our (critical) application and while
doing my first experiments I've found a bug which makes me worry very
much.
The problem is that a SELECT with a certain LIKE condition in combination
with a GROUP BY does not find the proper records when there is an i
Michael Meskes <[EMAIL PROTECTED]> writes:
> Could anyone please tell me what changed in some of the include files. I
> just noticed that ecpg won't compile anymore.
It was building for me as of last night (last cvs update Jan 18 00:03 EST).
Did someone break something since then?
Hello. Hopefully, this is the right mailing list to send
this type of question too.
System:
I am running the newest 7.03 build on a dual 866 Pentium III
with a 128M raid card.
I have found an error that is quite odd.
I have a table that is supposed to keep a map between
urls and ids. Each url in
mlw <[EMAIL PROTECTED]> writes:
> I think I know what the problem is:
> I have a couple indexes created with a "lower" function to index on
> lowercase.
Ah. You're correct, functional indexes leak memory in existing PG
releases. The memory is reclaimed at end of statement, which is not
soon eno
> Fixed in current sources. (I think there is still one unused-var
> complaint left in the XLOG code; I've been waiting on Vadim to do
> something about it, because it looks like there is code still to be
> written there.)
Just commented out for now.
Vadim
> > Could anyone please tell me what changed in some of the include files. I
> > just noticed that ecpg won't compile anymore.
>
> I haven't been able to update my cvs sources for a few days, but on my
> machine preproc.y produces 321 shift/reduce errors. Does it still, or is
> that patched up?
I wish there was, but no gateway exists yet.
[ Charset ISO-8859-1 unsupported, converting... ]
> Hi,
>
> I am working on a project that will integrate data from an Oracle database
> with data from a Postgresql database. Is there a gateway to Oracle from
> Postgresql? I know that in Oracle ther
"Martin A. Marques" <[EMAIL PROTECTED]> writes:
> I'm compiling beta 1 of 7.1 and I have a par of questions.
> analyze.c: In function `transformInsertStmt':
> analyze.c:425: warning: unused variable `resnode'
Fixed in current sources. (I think there is still one unused-var
complaint left in th
Is this a TODO item?
>
> I scanned the archives, and one person asked it back in July, but there
> doesn't appear to be any followup ...
>
> Is it possible to go from text->inet in v7.0.3? if not, is it in v7.1?
>
> the following doesn't work:
>
> template1=# select '216.126.84.1'::text::ine
It is in 7.1beta, and is not documented yet.
it> Does anyone know if this feature exists? If so, what version or where
> can a patch be obtained?
>
> Thanks
>
> --- Forwarded message follows ---
> Date sent:Mon, 15 Jan 2001 08:44:46 +0100
> From: "J.H.M. D
Emmanuel Charpentier wrote:
>Oliver Elphick seems awfully busy and once said that 7.1 required a
>*lot* of packaging ... Better not bug him right now ...
I'm working on it at the moment.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight
That is strange. It is all compiling here.
> Could anyone please tell me what changed in some of the include files. I
> just noticed that ecpg won't compile anymore.
>
> Also I think we have yet to agree on the libpq/ecpg problem, or did I miss a
> mail yet again?
>
> Michael
> --
> Michael M
Hi,
I am working on a project that will integrate data from an Oracle database
with data from a Postgresql database. Is there a gateway to Oracle from
Postgresql? I know that in Oracle there are gateways to other database such
as DB2.
Thanks for the help.
Wenjin Zheng
The Hermit Hacker wrote:
>
> I scanned the archives, and one person asked it back in July, but there
> doesn't appear to be any followup ...
>
> Is it possible to go from text->inet in v7.0.3? if not, is it in v7.1?
>
> the following doesn't work:
>
> template1=# select '216.126.84.1'::text::
Nathan Myers wrote:
>In fact, it seems likely that a 2.2 (potato) packaging of 7.1 should be
>available from somebody else anyhow. Oliver, do you plan to make the
>woody 7.1 package depend on any other package versions not in potato?
It will automatically depend on whatever is in my ma
Nathan Myers wrote:
[ ... ]
> Not true. There are Debian source packages,
Where are they ? I'm *quite* interested !
> and taking the source
> package from Debian 2.x, x>2 (woody/sid), you can easily build it
> on Debian 2.2 (potato).
>
> In fact,
> I'm trying to compile postgres on a Solaris 7 SPARC machine
> and I get this error:
> gcc -g -Wall -Wmissing-prototypes -Wmissing-declarations -fPIC
> -I../../../src/include -I../../../src/interfaces/libpq -c pgtcl.c -o pgtcl.o
> In file included from pgtcl.c:19:
> libpgtcl.h:19: tcl.h: No
how hard would it be to rectify before beta4 is put out? i'm doing a
manual dump/restore to get my data from text->inet ... not elegant, but it
works ... ::)
On Thu, 18 Jan 2001, Thomas Lockhart wrote:
> > Is it possible to go from text->inet in v7.0.3? if not, is it in v7.1?
>
> Seems to not
> Could anyone please tell me what changed in some of the include files. I
> just noticed that ecpg won't compile anymore.
I haven't been able to update my cvs sources for a few days, but on my
machine preproc.y produces 321 shift/reduce errors. Does it still, or is
that patched up?
I'm trying to compile postgres on a Solaris 7 SPARC machine and I get this
error:
make[4]: Leaving directory
`/space/pruebas/postgresql-7.1beta1/src/interfaces/libpq'
gcc -g -Wall -Wmissing-prototypes -Wmissing-declarations -fPIC
-I../../../src/include -I../../../src/interfaces/libpq -c pgtc
> Is it possible to go from text->inet in v7.0.3? if not, is it in v7.1?
Seems to not be in 7.1 either.
- Thomas
I scanned the archives, and one person asked it back in July, but there
doesn't appear to be any followup ...
Is it possible to go from text->inet in v7.0.3? if not, is it in v7.1?
the following doesn't work:
template1=# select '216.126.84.1'::text::inet;
ERROR: Cannot cast type 'text' to 'i
Could anyone please tell me what changed in some of the include files. I
just noticed that ecpg won't compile anymore.
Also I think we have yet to agree on the libpq/ecpg problem, or did I miss a
mail yet again?
Michael
--
Michael Meskes
[EMAIL PROTECTED]
Go SF 49ers! Go Rhein Fire!
Use Debian
I think I know what the problem is:
I have a couple indexes created with a "lower" function to index on
lowercase.
To return a lowercase text object, I use the "lower" function, as copied
from the postgres source (Oddly enough varchar does not work):
text * lower(text *string)
{
text
I'm compiling beta 1 of 7.1 and I have a par of questions.
First I see things like this in the compilation output:
gcc -g -Wall -Wmissing-prototypes -Wmissing-declarations -Wno-error
-I/usr/local/ssl//include -I../../../src/include -c analyze.c -o analyze.o
analyze.c: In function `transformIns
Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
stage=# alter table dartists add column dar
Zeugswetter Andreas SB writes:
> The down side is, that I did not do a configure test, and did not
> incooperate IRIX, since I didn't know what define to check.
>
> The correct thing to do instead of the #if defined (_AIX) would be
> to use something like #ifdef NO_NEGATIVE_MKTIME and set th
Hi.
Does any one know if getCrossReference (jdbc
method) works with postgresql 7.0 ?
I`m using jdbc V 7.0-1.2
any example ?
Thanks.
Felipe Diaz Cardona
> > > I do not have the original thread where Andreas describes
> the behavior
> > > of mktime() on his machine. Andreas, can you suggest a
> simple configure
> > > test to be used?
> >
> > #include
> > int main()
> > {
> > struct tm tt, *tm=&tt;
> > int i = -5000;
> > tm = loc
67 matches
Mail list logo
