Thomas Lockhart <[EMAIL PROTECTED]> writes:
> If it doesn't work, and will not be made to work, then let's remove it
> from the tree.
I tend to agree with Peter's slightly less drastic proposal: remove it
from the installed fileset and disable its man page, without necessarily
'cvs remove'ing all
> > > Since pg_upgrade will not work for 7.1, should its installation be
> > > prevented and the man page be disabled?
> > Probably. I am not sure it will ever be used again now that we have
> > numeric file names.
> Perhaps we should leave it for 7.1 because people will complain when
> they can
I just returned from vacation and identified the problem.
We'll fix it.
Regards,
Oleg
On Sun, 18 Mar 2001, Tom Lane wrote:
> I wrote:
> > I did this, also reinstalled the include-file changes I had made, and
> > then spent several fruitless hours trying to find why the "i
Hello All!
I have found the PostgreSQL - JDBC driver from the site
http://www.retep.org.uk/postgres/.
But, Iam not finding any tutorial for the same.
Can anybody tell me the name of the site where I can find both the
PostgreSQL driver and tutorial containing the examples .
With regards,
Sourabh Di
Jan Wieck <[EMAIL PROTECTED]> writes:
> Just to get some evidence at hand - could some owners of
> different platforms compile and run the attached little C
> source please?
> (The program tests how much data can be stuffed into a pipe
> or a Sys-V message queue befo
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> In 7.0.3, is it safe to drop a check constraint by simply deleting it from
> the pg_relcheck table?
You'll need to adjust the relchecks count in the table's pg_class entry
as well.
regards, tom lane
Peter,
I'll give it a try, and send the stuff to you directly, so you can
say something like "that isn't what I meant!".
>Nat Howard writes:
>
>> Not sure if this counts as *major*, but this jdbc1 compile
>> problem is presumably still there:
>>
>> http://www.postgresql.org/mhonarc/pgsql-bugs/
OK, I notice I have to decrement the reltriggers field in the pg_class
directory as well, but other than that is there any problem?
Chris
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Christopher
> Kings-Lynne
> Sent: Monday, March 19, 2001 10:53
Doh! Not reltriggers - I meant relchecks...
Chris
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Christopher
> Kings-Lynne
> Sent: Monday, March 19, 2001 10:53 AM
> To: Hackers
> Subject: [HACKERS] Dropping CHECK constraints
>
>
> In 7.0.3, is it
In 7.0.3, is it safe to drop a check constraint by simply deleting it from
the pg_relcheck table?
Chris
--
Christopher Kings-Lynne
Family Health Network (ACN 089 639 243)
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please s
At 19:10 14/03/01 -0500, Tom Lane wrote:
>It might even make
>sense for an ArchiveEntry to store both forms of the name, and then
>using code could just select the form wanted instead of calling
>fmtId repeatedly. Not sure.
>
>BTW, making the -t switch compare to the unquoted name would probably
I wrote:
> I did this, also reinstalled the include-file changes I had made, and
> then spent several fruitless hours trying to find why the "intbig" index
> operators fail selftest here (on HP-PA). I suppose it's a portability
> problem, since presumably they pass for Oleg ... but I don't see it
Larry Rosenman <[EMAIL PROTECTED]> writes:
> I can get the code compiled, but don't have the skills to generate
> a test case worthy of anything
contrib/pgbench would do as a first cut.
regards, tom lane
---(end of broadcast)--
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> I only saw that the Makefile is back to how it looked at rev 1.1 before I
> did some work on it. AFAICT the Makefile should be reverted back to the
> previous revision, since the code change does not require any changes to
> the Makefile.
I did this
* Larry Rosenman <[EMAIL PROTECTED]> [010318 14:17] wrote:
> * Tom Lane <[EMAIL PROTECTED]> [010318 14:55]:
> > Alfred Perlstein <[EMAIL PROTECTED]> writes:
> > >> Just by making a thread call libc changes personality to use thread
> > >> safe routines (I.E. add mutex locking). Use one thread fea
* Tom Lane <[EMAIL PROTECTED]> [010318 14:55]:
> Alfred Perlstein <[EMAIL PROTECTED]> writes:
> >> Just by making a thread call libc changes personality to use thread
> >> safe routines (I.E. add mutex locking). Use one thread feature, get
> >> the whole set...which may not be that bad.
>
> > Ac
Alfred Perlstein <[EMAIL PROTECTED]> writes:
>> Just by making a thread call libc changes personality to use thread
>> safe routines (I.E. add mutex locking). Use one thread feature, get
>> the whole set...which may not be that bad.
> Actually it can be pretty bad. Locked bus cycles needed for
jreniz <[EMAIL PROTECTED]> writes:
> So, when I run this trigger there is a mistake:
> ''there is no operator '=$' for types 'int4' and 'int4'
> (My system is 6.5.3)
This is an old bug. Update to 7.0.3.
It might work to add spaces around the '=' signs in your trigger
function, but an update w
Nat Howard writes:
> Not sure if this counts as *major*, but this jdbc1 compile
> problem is presumably still there:
>
> http://www.postgresql.org/mhonarc/pgsql-bugs/2001-03/msg3.html
>
> as the referenced source file hasn't been updated. If I recall
> right, Peter was waiting for a java 1 S
* William K. Volkman <[EMAIL PROTECTED]> [010318 11:56] wrote:
> The Hermit Hacker wrote:
> >>
> > But, with shared libraries, are you really pulling in a "whole
> > thread-support library"? My understanding of shared libraries (altho it
> > may be totally off) was that instead of pulling in a w
Peter Eisentraut <[EMAIL PROTECTED]> writes:
>> which is clearly not giving the postmaster enough time to remove or
>> rewrite the pidfile. Shouldn't we put a "sleep 1" in there before
>> the "if"?
> This is probably the best we can do.
Actually, the whole thing should only happen if we found a
On Fri, Mar 16, 2001 at 05:25:24PM -0500, Jan Wieck wrote:
> Jan Wieck wrote:
...
> Just to get some evidence at hand - could some owners of
> different platforms compile and run the attached little C
> source please?
...
> Seems Tom is (unfortunately) right. The pipe blo
Not sure if this counts as *major*, but this jdbc1 compile
problem is presumably still there:
http://www.postgresql.org/mhonarc/pgsql-bugs/2001-03/msg3.html
as the referenced source file hasn't been updated. If I recall
right, Peter was waiting for a java 1 SDK to be installed.
---
The Hermit Hacker wrote:
>>
> But, with shared libraries, are you really pulling in a "whole
> thread-support library"? My understanding of shared libraries (altho it
> may be totally off) was that instead of pulling in a whole library, you
> pulled in the bits that you needed, pretty much as yo
Hi friends!
I'm working in a trigger and I need to put the result
of a query into a variable.
That's very easy- apparently!
The query has a aggregate function like this:
select sum(field) into variable ...
and I'm sure that field and variable are int4 type.
So, when I run this trigger there
Alexander Klimov writes:
> There are many way to solve the problem:
> the easy -- copy (or link) libz.so to /usr/lib
> the clean -- avoid using LD_LIBRARY_PATH, use -R for linking instead
Our makefiles are set up to use '-R' for linking. Does this not work as
designed?
--
Peter Eisentraut
Bruce Momjian writes:
> I see change of += in CFLAGS (harmless),
Not.
> movement of #include
> , and removal of // comments, which don't appear anymore in
> the code.
I only saw that the Makefile is back to how it looked at rev 1.1 before I
did some work on it. AFAICT the Makefile should be r
Tom Lane writes:
> eval '$po_path' '$POSTOPTS' $logopt '&'
>
> if [ -f $PIDFILE ];then
> if [ "`sed -n 1p $PIDFILE`" = "$pid" ];then
> echo "$CMDNAME: cannot start postmaster" 1>&2
> echo "Examine the log output." 1>&2
> exit 1
> fi
> fi
>
>
At a minimum, you should do a test, and if it does not yet exist, do a
sleep, then the test again.
> Cyril VELTER <[EMAIL PROTECTED]> writes:
> > pg_ctl output when no shm segments left
>
> > pg_ctl: It seems another postmaster is running. Trying to start postmaster
> > anyway.
> > pg_ctl: can
Cyril VELTER <[EMAIL PROTECTED]> writes:
> pg_ctl output when no shm segments left
> pg_ctl: It seems another postmaster is running. Trying to start postmaster
> anyway.
> pg_ctl: cannot start postmaster < not true !!!
> Examine the log output.
> DEBUG: database system was interrupted
Hi all
On Fri, 16 Mar 2001, Martin A. Marques wrote:
> ld.so.1: /dbs/postgres/bin/postmaster: fatal: libz.so: open failed: No such
> file or directory
>
> Now, libz.so is in the LD_LIBRARY_PATH of the postgres user, so why is it
> that Solaris doesn't load the .profile in the postgres director
From: Bryan Wu <[EMAIL PROTECTED]>
Subject: Urgent Question on Postgresql
Date: Sun, 18 Mar 2001 04:39:36 -0800 (PST)
Message-ID: <[EMAIL PROTECTED]>
> Hi tatsuo Ishii,
>
> I learn from postgresql mailing list that you are
> concerning the problem the UTF8 support in Postgresql.
> Currently I wa
32 matches
Mail list logo
