With today's CVS code (originally noticed with 8.2beta3), on a PC where
INT_MAX=0x7FFF=2147483647
postgres=# select version();
version
I know that it doesn't matter as configure is in CVS, so there is no
need for mere mortals to regenerate it, but why is
RCS file: /projects/cvsroot/pgsql/configure.in,v
revision 1.538
date: 2007/11/26 12:31:07; author: petere; state: Exp; lines: +2 -2
Require a specific Autoconf version
Given the following trivial trigger example:
-- create language plpgsql;
create table foo (a integer, b text, c timestamp);
create function foo_insert() returns trigger as $$
begin
raise notice '%', new;
return null;
end;
$$ language plpgsql;
create trigger foo_ins bef
On Sat, Feb 09, 2008 at 12:29:10PM -0500, Tom Lane wrote:
> Patrick Welche <[EMAIL PROTECTED]> writes:
> > I am surprised to see
>
> > NOTICE: (1,two,"Sat 09 Feb 16:47:44.514503 2008")
>
> This is the expected formatting for a composite type. Read
>
On Thu, May 02, 2002 at 01:14:34PM -0300, Marc G. Fournier wrote:
> On 2 May 2002, Hannu Krosing wrote:
...
> > BTW, I think PostgreSQL does _not_ need any mission statement.
>
> Nope, it doesn't ... never did before, don't know why it does suddenly ...
> do any other open source projects have on
On Thu, Aug 15, 2002 at 12:09:00AM -0400, Neil Conway wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
...
> > integrate or remove new libpqxx
> > integrate or add to gborg Pg:DBD
> >
> > Seems like gborg is the place for these.
>
> Yes, but I'd also like to see libpq++, perl5, and po
I just cut and pasted someone's mac address:
patrimoine=# update ethernet set mac='00-00-39-AB-92-FO' where id=623;
UPDATE 1
patrimoine=# select mac from ethernet where id=623;
mac
---
00:00:39:ab:92:0f
(1 row)
Note the typo "O" instead of "0". I can see how tha
On Thu, Nov 14, 2002 at 06:13:56PM +, Patrick Welche wrote:
> On Wed, Nov 13, 2002 at 07:53:00PM +0100, Peter Eisentraut wrote:
> > Tom Lane writes:
> >
> > > We can't just wait around indefinitely for port reports that may or may
> > > not ever a
Believe it or not, I'm trying to compile today's cvs pgsql on a
Debian 2.2.19 system. Compilation dies while compiling pg_dump with
../../../src/interfaces/libpq/libpq.so: undefined reference to `atexit'
In the mail archives there is a mention of upgrading libc to
libc6-dev_2.2.5-3_i386.deb. As f
On Wed, Nov 13, 2002 at 07:53:00PM +0100, Peter Eisentraut wrote:
> Tom Lane writes:
>
> > We can't just wait around indefinitely for port reports that may or may
> > not ever appear. In any case, most of the "<7.3" entries in the list
> > seem to be various flavors of *BSD; I think it's unlikely
On Thu, Nov 14, 2002 at 08:55:22PM +, Patrick Welche wrote:
> Believe it or not, I'm trying to compile today's cvs pgsql on a
> Debian 2.2.19 system. Compilation dies while compiling pg_dump with
>
> ../../../src/interfaces/libpq/libpq.so: undefined reference to `at
On Thu, Nov 14, 2002 at 09:06:01AM -0500, Tom Lane wrote:
> "Magnus Naeslund(f)" <[EMAIL PROTECTED]> writes:
> > OK OK, before anyone rubs my nose in it, i see the fork() failures :)
>
> > I'll see what's causing the fork() problems...
>
> Too low processes-per-user limit, likely.
Success for
P
On Tue, Nov 19, 2002 at 10:53:59AM -0500, Tom Lane wrote:
> Patrick Welche <[EMAIL PROTECTED]> writes:
> > [remove this:]
> > -geometry/.*-netbsd=geometry-positive-zeros
>
> > as this acorn32 is running on a StrongARM processor, so has nothing to do
> > with li
On Tue, Nov 19, 2002 at 06:22:08PM +0100, Peter Eisentraut wrote:
> He was testing 7.4devel. That's not the right one.
What's the difference? (Do I really want to wait another day while this
ancient box compiles it given that the chances of it working under
7.4devel and not under 7.3rcN are small
On Wed, Nov 20, 2002 at 06:48:15PM +0100, Peter Eisentraut wrote:
> Tom Lane writes:
>
> > AFAIK, all modern hardware claims compliance to the IEEE floating-point
> > arithmetic standard, so failure to print minus zero as minus zero is
> > very likely to be a software issue not hardware. That sug
On Wed, Nov 20, 2002 at 01:21:47PM -0500, Tom Lane wrote:
> Patrick Welche <[EMAIL PROTECTED]> writes:
...
> > NetBSD 1.5 has revision 1.32, NetBSD 1.6 has revision 1.42
>
> Ah-hah, so it is a version issue --- we could make the resultmap line
> something like
>
On Wed, Nov 20, 2002 at 01:51:28PM -0500, Tom Lane wrote:
> Patrick Welche <[EMAIL PROTECTED]> writes:
> > On Wed, Nov 20, 2002 at 01:21:47PM -0500, Tom Lane wrote:
> >> Ah-hah, so it is a version issue --- we could make the resultmap line
> >> something l
On Wed, Nov 20, 2002 at 09:33:41AM -0500, Bruce Momjian wrote:
> Patrick Welche wrote:
> > On Tue, Nov 19, 2002 at 06:22:08PM +0100, Peter Eisentraut wrote:
> > > He was testing 7.4devel. That's not the right one.
> >
> > What's the difference? (Do I re
On Wed, Nov 20, 2002 at 09:33:41AM -0500, Bruce Momjian wrote:
> Patrick Welche wrote:
> > On Tue, Nov 19, 2002 at 06:22:08PM +0100, Peter Eisentraut wrote:
> > > He was testing 7.4devel. That's not the right one.
> >
> > What's the difference? (Do I re
Just tried a make runcheck with source from Dec 4 15:13 GMT, and:
Core was generated by `postgres'.
Program terminated with signal 11, Segmentation fault.
#0 ExecGetTupType (node=0x8453978) at execProcnode.c:744
744 slot =
hashjoinstate->jstate.cs_ResultTuple
(gdb) print *((HashJoin *) node)->hashjoinstate
$4 = {jstate = {type = T_HashJoinState, cs_OuterTupleSlot = 0x0,
cs_ResultTupleSlot = 0x84527cc, cs_ExprContext = 0x8453e60,
cs_ProjInfo = 0x84546e0, cs_TupFromTlist = 0 '\000'}, hj_HashTable = 0x0,
hj_CurBucketNo = 0, hj_CurTuple = 0x0,
I must have had an old object file in the build tree... It's all happy
now.
Sorry for the noise,
Patrick
(geometry fails just because of the ordering of the rows in "twenty")
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to
transatlantic=# select '23:59:59.72'::time(0) without time zone;
time
--
24:00:00
(1 row)
So dumping a table with times derived from the timestamp then fails on the
reload with:
psql:transatlantic.dat:43681: ERROR: copy: line 5818, Bad time external
representation '24:00:00'
psql
I have a program which worked merrily under 1.3b1, but with 1.4devel
I get the first query working (so connection OK), and the second query,
which may well be wrong, getting me:
DEBUG: reaping dead processes
DEBUG: child process (pid 13025) was terminated by signal 11
LOG: server process (pid 1
Using cvs source of Dec 4 15:13:
test=# \d amount
Table "public.amount"
Column | Type | Modifiers
+-+
id | integer | not null default nextval('p
On Tue, Feb 11, 2003 at 11:20:14AM -0500, Tom Lane wrote:
...
> We could retarget to try to stay under SHMMAX=4M, which I think is
> the next boundary that's significant in terms of real-world platforms
> (isn't that the default SHMMAX on some BSDen?).
...
Assuming 1 page = 4k, and number of pages
On Thu, Feb 13, 2003 at 10:25:52AM -0500, Tom Lane wrote:
> Patrick Welche <[EMAIL PROTECTED]> writes:
> > The sad thing is that my readline wrapper for libedit doesn't wrap
> > replace_history_entry,
>
> Well, is that a bug in your wrapper? Or must we add a conf
The sad thing is that my readline wrapper for libedit doesn't wrap
replace_history_entry, so I could use readline up until now, the tests
for readline succeed as the functions tested for exist, but
command.o: In function `do_edit':
/usr/src/local/pgsql/src/bin/psql/command.c:1652: undefined refere
Did we decide that "most NetBSD/i386 users have fpus" in which case Marko's
patch should be applied?
Cheers,
Patrick
(just checked, it isn't in today's cvs)
On Thu, Mar 22, 2001 at 10:27:44PM +0200, Marko Kreen wrote:
> On Thu, Mar 22, 2001 at 07:58:04PM +,
On Fri, Apr 13, 2001 at 01:25:45PM +, Thomas Lockhart wrote:
> > Did we decide that "most NetBSD/i386 users have fpus" in which case Marko's
> > patch should be applied?
>
> I'm unclear on what y'all mean by "i386 + fpu", especially since NetBSD
> seems to insist on calling every Intel proces
On Mon, Apr 09, 2001 at 11:41:55AM -0700, Henry B. Hotz wrote:
> At 1:50 AM -0400 4/6/01, Tom Lane wrote:
...
> >What version of libreadline do you have installed, and how does it
> >declare completion_matches()?
>
> I have whatever is standard on NetBSD 1.5. I noticed that configure
> found a
I just upgraded PostgreSQL from 21 March CVS (rc1?) to May 19 16:21 GMT CVS.
I found that all my cgi/fcg scripts which use libpq++ stopped working in
the vague sense of apache mentioning an internal server error. Relinking
them cured the problem (had to do this in haste => unfortunately no more
in
On Sat, May 12, 2001 at 08:00:42PM -0400, Tom Lane wrote:
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > * Translation: If we want to use gettext I can get started. I don't
> > think I'm interested in using any other interface.
>
> I have no objection to the gettext API, but I was and sti
On Mon, May 14, 2001 at 09:36:56PM +0200, Peter Eisentraut wrote:
> Patrick Welche writes:
>
> > > I have no objection to the gettext API, but I was and still am concerned
> > > about depending on GNU gettext's code, because of license conflicts.
> > >
On Sat, May 19, 2001 at 08:03:50PM -0400, bpalmer wrote:
> On OBSD from cvs source, clean checkout:
>
> gcc -O2 -pipe -Wall -Wmissing-prototypes -Wmissing-declarations
> -I../../../../src/include -DLIBDIR=\"/usr/local/pgsql/lib\
> " -DDLSUFFIX=\".so\" -c -o dfmgr.o dfmgr.c
> dfmgr.c: In functi
On Thu, Jul 12, 2001 at 12:04:25PM +0900, Tatsuo Ishii wrote:
> > Has it ever been considered to (optionally) use the iconv interface for
> > character set conversion instead of rolling our own? It seems to be a lot
> > more flexible, has pluggable conversion modules (depending on the
> > impleme
On Thu, Jul 26, 2001 at 04:55:14PM +0700, Zudi Iswanto wrote:
> I am developing application with c++
...
> /tmp/ccy63XDd.o(.text+0x70): undefined reference to `PQsetdbLogin'
> /tmp/ccy63XDd.o(.text+0x91): undefined reference to `PQstatus'
> /tmp/ccy63XDd.o(.text+0xc4): undefined reference to `PQe
gcc -O2 -pipe -g -Wall -Wmissing-prototypes -Wmissing-declarations
-I../../../src/include -c -o hba.o hba.c
hba.c: In function `ident_unix':
hba.c:923: sizeof applied to an incomplete type
hba.c:960: dereferencing pointer to incomplete type
hba.c:965: dereferencing pointer to incomplete type
gm
On Fri, Sep 07, 2001 at 10:14:27AM -0400, Tom Lane wrote:
> Patrick Welche <[EMAIL PROTECTED]> writes:
> > hba.c: In function `ident_unix':
> > hba.c:923: sizeof applied to an incomplete type
>
> > Now, the problem is sizeof(Cred), typedef struct cmsgcred Cr
On Fri, Sep 07, 2001 at 04:05:58PM -0400, Bruce Momjian wrote:
...
> OK, I have modified the CVS CREDS code to work on FreeBSD and BSD/OS,
> and hopefully NetBSD. I talked to Jason at Linuxworld and I think this
> code should work. Please test the CVS version and let me know. OpenBSD
> doesn't
On Wed, Sep 12, 2001 at 02:45:10PM +0200, Peter Eisentraut wrote:
> Thomas Lockhart writes:
>
> > Keep in mind that he is a mathematician, and I'll guess that he won't
> > have much patience with folks who expect a result for a factorial of a
> > fractional number ;)
>
> Real mathematicians will
On Wed, Sep 19, 2001 at 10:14:44AM -0400, Marc G. Fournier wrote:
>
> :pserver:[EMAIL PROTECTED]:/projects/cvsroot
While trying a cvs update, I get
? ChangeLogs/libecpg.so.3.1.1
? ChangeLogs/HTML
? ChangeLogs/GTAGS
? ChangeLogs/GPATH
? ChangeLogs/GRTAGS
? ChangeLogs/GSYMS
? ChangeLogs/libpqpp.h
On Fri, Sep 21, 2001 at 07:27:10PM +0200, Horák Daniel wrote:
...
> but still I am getting
>
> > cannot create_adm_p /tmp/cvs-serv24877/ChangeLogs
> > Permission denied
Me Too!
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
On Mon, Sep 24, 2001 at 10:22:28AM -0400, Marc G. Fournier wrote:
>
> okay, somehow you have two different CVSROOT's configured?
> /home/projects/pgsql/cvsroot was the old server, /projects/cvsroot is the
> new one
Any hints? I had done a (csh)
cd /usr/src/local/pgsql
find . -name Root -pri
On Mon, Sep 24, 2001 at 06:04:17PM +0100, Patrick Welche wrote:
...
> and CVSROOT is not set as an environment variable... Also odd that it
> appears there and there is no sign of "home" anywhere..
Got it: had /home/... in pgsql/src/backend/access/heap/CVS/Repository (!)
All
On Sat, Sep 22, 2001 at 08:15:11PM -0500, Dominic J. Eidson wrote:
> On Sat, 22 Sep 2001, Marc G. Fournier wrote:
>
> > anoncvs: :pserer:[EMAIL PROTECTED]:/projects/cvsroot
> > - passwd is blank, but postgresql should work just as well
>
> I can confirm that this works.
Still no good for me
On Mon, Oct 23, 2000 at 10:26:39AM -0400, Tom Lane wrote:
>
> Could you dig into it a little further and try to determine where the
> NULL is coming from?
All clear now! (I did do another cvs update in the meantime, but either way,
I can't now repeat the previously repeatable core dump)
Cheers,
On Sat, Dec 23, 2000 at 08:42:43AM -0800, Alfred Perlstein wrote:
>
> FreeBSD has a freely available library called 'libedit' that could
> be shipped with postgresql, it's under the BSD license.
>
> If you have access to a FreeBSD box see the editline(3) manpage,
> or go to:
>
>http://www.free
On Sat, Dec 30, 2000 at 02:34:24AM +0100, Peter Eisentraut wrote:
>
> If libedit could be used as an alternative to readline depending on your
> operating system setup then there's nothing wrong with that. NetBSD
> already went the other way around and made libedit compatible with
> readline.
I
On Sun, Dec 31, 2000 at 01:06:40PM +0100, Peter Eisentraut wrote:
>
> I've removed the statement for now, since it was being used incorrectly
> anyway, but for the future I suggest that NetBSD catch up, if it wants to
> stay compatible.
Thank you, and Jaromir tells me he'll commit a fix to NetBS
Posting again as even though I receive mail from hackers I am apparently
not a member (registered correctly as [EMAIL PROTECTED] - from will say
[EMAIL PROTECTED] - setting reply-to to [EMAIL PROTECTED] used to get
around it..)
psql: FATAL 1: cannot open /usr/local/pgsql/data/global/pg_dat
Please ignore last 2 messages re
psql: FATAL 1: cannot open /usr/local/pgsql/data/global/pg_database: No such file or
directory
- I had another old postmaster running...
Cheers,
Patrick
psql: FATAL 1: cannot open /usr/local/pgsql/data/global/pg_database: No such file or
directory
and it's true..
% ls /usr/local/pgsql/data/global
1260126112621264126917127 17130
pg_control
source from Jan 3 15:59 GMT
configure --enable-lo
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
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
>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 Fri, Jan 19, 2001 at 12:46:53AM +0100, Peter Eisentraut wrote:
> 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 librea
On Fri, Jan 19, 2001 at 12:03:58PM -0500, Bruce Momjian wrote:
>
> Tom, did we ever test this? I think we did and found that it was the
> same or worse, right?
(Funnily enough, I just read that message:)
To: Bruce Momjian <[EMAIL PROTECTED]>
cc: [EMAIL PROTECTED]
Subject: Re: [HACKERS] Possibl
On Fri, Jan 19, 2001 at 08:52:13PM +0100, Peter Eisentraut wrote:
> Patrick Welche writes:
>
> > Just tried it for the first time:
> > % cd src/test/locale
> > % gmake all
> > gmake: Circular test-pgsql-locale <- all dependency dropped.
> > cd: can't c
On Sat, Jan 20, 2001 at 08:06:51PM -0500, Tom Lane wrote:
> What I've done to solve the immediate C++ problem is to take the
> declaration of sys_nerr out of c.h entirely, and put it into the
> two C modules that actually need it. However, I'm still wondering
> whether we should not drop the rang
rfb=# insert into person (id,surname) values (2274,'Unknown!');
ERROR: Relation 'subject' does not exist
Correct - where does subject come from?!
rfb=# \d person
Table "person"
Attribute | Type | Modifier
---+---+--
id| bigint|
By comparing backups, I found
CREATE CONSTRAINT TRIGGER "" AFTER INSERT OR UPDATE ON "person" NOT
DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins"
('', 'person', 'subject', 'UNSPECIFIED', 'subjectid', 'id');
Don't know where that came from, but probably operat
On Mon, Jan 22, 2001 at 05:46:09PM -0500, Tom Lane wrote:
...
> Are there any BSD-license locale and/or timezone libraries that we might
> assimilate in this way? We could use an LGPL'd library if there is no
> other alternative, but I'd just as soon not open up the license issue.
The "Citrus P
On Mon, Jan 22, 2001 at 03:09:03PM -0800, Nathan Myers wrote:
...
> Posix systems include a set of commands for dumping locales in a standard
> format, and building from them. Instead of shipping locales and code to
> operate on them, one might include a script to run these tools (where
> the
On Thu, Jan 25, 2001 at 10:13:29PM -0500, Tom Lane wrote:
> Frank Joerdens <[EMAIL PROTECTED]> writes:
> > I just did that and ran make check 4 times. 3 times went completely
> > smoothly, once I had random fail. This is the same behaviour that I saw
> > when running make installcheck (76 successf
On Wed, Feb 28, 2001 at 08:53:31AM +0900, Hiroshi Inoue wrote:
...
> I think I've fixed this bug at least for MS-Access.
> You could get the latest win32 driver from
> ftp://ftp.greatbridge.org/pub/pgadmin/stable/psqlodbc.zip .
> Please try it.
How can I just install that file? (ie., M$ Access
Trying example from:
http://www.postgresql.org/devel-corner/docs/user/functions-datetime.html
patrimoine=# SELECT EXTRACT(EPOCH FROM TIMESTAMP '2001-02-16 20:38:40');
ERROR: parser: parse error at or near "epoch"
patrimoine=# select version();
version
On Fri, Mar 09, 2001 at 03:48:33PM -0500, Tom Lane wrote:
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > Well, SQL defines these. Do we want to make our own list? However,
> > numeric codes also have the advantage that some hierarchy is possible.
> > E.g., the "22" in "2200G" is actually the
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
Just a data point on the geometry test under NetBSD/i386 issue:
/etc/ld.so.conf by default now contains:
libm.so.0 machdep.fpu_present 1:libm387.so.0,libm.so.0
which means that if the sysctl machdep.fpu_present returns 1, load the
shared library libm387 to make use of the fpu.
If you
On Thu, Mar 22, 2001 at 12:49:39PM -0500, Tom Lane wrote:
> The Hermit Hacker <[EMAIL PROTECTED]> writes:
> >> These are parallel tests right? What's the failure diffs?
>
> > same as last time:
>
> > dragon:/home/centre/marc/src/postgresql-7.1RC1/src/test/regress> more
> > results/opr_sanity.ou
On Thu, Mar 22, 2001 at 10:27:44PM +0200, Marko Kreen wrote:
> On Thu, Mar 22, 2001 at 07:58:04PM +0000, Patrick Welche wrote:
> >
> > AFAIK geometry-positive-zeros works for all NetBSD platforms - the
> > above difference is only for i386 + fpu.
>
> Seems that foll
On Fri, Mar 23, 2001 at 06:25:50AM +1100, Giles Lean wrote:
>
> > PS: AFAIK geometry-positive-zeros-bsd works for all NetBSD platforms - the
> > above difference is only for i386 + fpu.
>
> It doesn't on NetBSD-1.5/alpha -- there geometry-positive-zeros is
> correct.
Sorry, that should have rea
On Sat, Feb 15, 2003 at 03:10:19PM -0600, Ross J. Reedstrom wrote:
> On Fri, Feb 14, 2003 at 11:32:02AM -0500, Tom Lane wrote:
> > Patrick Welche <[EMAIL PROTECTED]> writes:
> > > On Thu, Feb 13, 2003 at 10:25:52AM -0500, Tom Lane wrote:
> > >> Well, is that a
On Wed, Feb 19, 2003 at 07:31:35AM -0500, Dave Cramer wrote:
> Bruce,
>
> Can you chime in with your support here?
>
> Dave
>
> I have a large customer who is converting from informix to postgres and
> they have made extensive use of
>
> update table set (col...) = ( val...)
>
> as a first pa
On Thu, Jun 12, 2003 at 10:10:02PM -0400, Bruce Momjian wrote:
> Tom Lane wrote:
> > Bruce Momjian <[EMAIL PROTECTED]> writes:
> > > You have to love that swap + 1/2 ram option --- when you need four
> > > possible options, there is something wrong with your approach. :-)
> >
> > I'm still wonder
I'm getting far too many errors while trying to compile gram.c in the
backend/parser, that I must be missing something.. Story so far
gmake distclean
cvs update
configure --enable-debug --enable-cassert
gmake
gmake[3]: Entering directory `/usr/src/local/pgsql/src/backend/parser'
gcc -O2 -pipe -g -
On Tue, Jul 15, 2003 at 11:21:51AM -0400, Tom Lane wrote:
> Patrick Welche <[EMAIL PROTECTED]> writes:
> > I'm getting far too many errors while trying to compile gram.c in the
> > backend/parser, that I must be missing something.
>
> I think you need to forc
On Tue, Jul 15, 2003 at 12:42:45PM -0400, Tom Lane wrote:
> Patrick Welche <[EMAIL PROTECTED]> writes:
...
> > What string constant?! Will try again later...
>
> Which flex version are you using? You need 2.5.4 --- the most recent
> versions have broken backwards compatib
On Wed, Jul 16, 2003 at 11:58:01PM +0900, [EMAIL PROTECTED] wrote:
> could you try lex/scan.l 1.13 i just committed?
Yes, that fixed it!
Cheers,
Patrick
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
cvs server: Updating src/bin/scripts/po
cvs server: failed to create lock directory for
`/projects/cvsroot/pgsql-server/src/bin/scripts/po'
(/projects/cvsroot/pgsql-server/src/bin/scripts/po/#cvs.lock): Permission denied
cvs server: failed to obtain dir lock in repository
`/projects/cvsroot/pgsq
On Wed, Jul 23, 2003 at 11:34:04AM -0300, The Hermit Hacker wrote:
>
> try it now ... I think its a pathing problem with a cron entry ... just
> fixed that, so should be okay now ...
...
> > cvs [server aborted]: read lock failed - giving up
Yup - that's all fine thanks!
> > On a different note
On Wed, Jul 23, 2003 at 12:53:34PM -0400, Tom Lane wrote:
> Patrick Welche <[EMAIL PROTECTED]> writes:
> > On a different note, I also wonder about:
> >
> > M src/backend/parser/gram.c
> >
> > It seems that you checkout the source with no gram.c. Build it,
On Wed, Jul 30, 2003 at 12:38:54AM -0400, Bruce Momjian wrote:
>
> [ CC to Kurt and Steven on bsdi list.]
>
> Guys, I just replied to this email on the BSDi email list. The issue is
> that someone found that some(most?) IDE drives have write cache enabled,
> though the drives do not preserve the
On Mon, Sep 15, 2003 at 08:09:22PM +0200, Peter Eisentraut wrote:
> Neil Conway writes:
>
> > On Thu, 2003-09-04 at 13:14, Kurt Roeckx wrote:
> > > > > tablecmds.c: In function `validateForeignKeyConstraint':
> > > > > tablecmds.c:3546: warning: dereferencing type-punned pointer will break
> > > >
There was a thread on missing pg_clog files caused due to dodgy practices in
glibc *last year*. I am seeing something similar *now* with a server
PostgreSQL 7.4beta1 on i386-unknown-netbsdelf1.6X, compiled by GCC 2.95.3
accessed by a similar client and a client
PostgreSQL 7.4devel on i686-pc-l
On Mon, Sep 22, 2003 at 10:50:22AM -0400, Tom Lane wrote:
> Patrick Welche <[EMAIL PROTECTED]> writes:
> > select * from olddata02_03vac offset 2573719 limit 1;
> > ERROR: could not access status of transaction 1664158221
> > DETAIL: open of file "/usr/local/pgs
On Mon, Sep 22, 2003 at 11:33:30AM -0400, Tom Lane wrote:
> Patrick Welche <[EMAIL PROTECTED]> writes:
> > I hope I guessed the right syntax...
> > % pg_filedump -R 71716 data/base/17148/283342
>
> Yes, but this doesn't give all the available info. Add -i and -f
&
On Mon, Sep 22, 2003 at 02:21:43PM -0400, Alvaro Herrera wrote:
> On Mon, Sep 22, 2003 at 05:03:28PM +0100, Patrick Welche wrote:
> > On Mon, Sep 22, 2003 at 11:33:30AM -0400, Tom Lane wrote:
> > > Patrick Welche <[EMAIL PROTECTED]> writes:
> > > &g
Is this a bug, or don't I understand coalesce()?
create table test (a int, b int);
insert into test values (1,null);
insert into test values (2,1);
insert into test values (2,2);
select * from test; -- returns:
select sum(b) from test where a=1; -- null
sel
On Tue, Dec 12, 2006 at 03:33:04PM +, Heikki Linnakangas wrote:
> BTW: This type of questions really belong to pgsql-general or
> pgsql-novice, this list is for discussing development of PostgreSQL itself.
^^
Indeed - I am truly feeling like a novice now...
Cheers,
Patrick
---
On Mon, Apr 18, 2005 at 08:58:01PM -0400, Bruce Momjian wrote:
>
> Would you modify this so it can go in /contrib or pgfoundry? Is there
> general interest for this?
I was about to sit down and write the same function yesterday, when as if
by magic this appeared. In my case it is to loop over ip
I just ran pg_dumpall from today's CVS against a 14 April server - I got:
pg_dumpall: query failed: ERROR: type "e" does not exist
pg_dumpall: query was: SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS
spcowner, spclocation, spcacl FROM pg_catalog.pg_tablespace WHERE spcname NOT
LIKE E'
On Mon, Jul 18, 2005 at 03:01:31PM -0400, Tom Lane wrote:
> Andrew - Supernews <[EMAIL PROTECTED]> writes:
> >>> "WHERE spcname NOT LIKE E'pg\\_%'");
>
> > It's not even correct as it stands - if you want to match a literal _
> > using LIKE then you would need E'pg_%' there.
>
> Good point!
>
On Mon, Jul 26, 2004 at 06:13:30PM +1000, Justin Clift wrote:
> + An SNMP agent to report on PostgreSQL's status and allows remote
> control of the PostgreSQL daemon. From an Oracle perspective, this
> would be the equivalent of "Oracle Intelligent Agents", part of the core
> features of the O
On Fri, Sep 26, 2003 at 02:49:30PM -0300, Marc G. Fournier wrote:
...
> if we are talking two computers sitting next to each other on a switch,
> you'd expect those to be low ... but if you were talking about two
> seperate geographical locations (and yes, I realize you are adding lag to
> the mix
Today's cvs doesn't compile. I think it is due to
cvs diff -r1.7 -r1.8 src/interfaces/ecpg/include/datetime.h
I have dtime_t defined in my sys/types.h. The old version of datetime.h used
#define dtime_t timestamp, the new one uses a typedef. Is there actually
a reason to keep dtime_t, or would just
On Mon, Sep 29, 2003 at 08:08:01PM +0200, Michael Meskes wrote:
> On Mon, Sep 29, 2003 at 06:41:48PM +0100, Patrick Welche wrote:
> > Today's cvs doesn't compile. I think it is due to
>
> Forgot one question. WHich platform do you use?
NetBSD - to quote cvs blame:
1.42
On Mon, Sep 29, 2003 at 11:50:23PM +0200, Peter Eisentraut wrote:
> Tom Lane writes:
>
> > At the very least we need to set a strings freeze soon, so the
> > translators can catch up. Peter, are you getting close to done with the
> > message revisions you've been making?
>
> Yes, I think we're r
On Fri, Oct 03, 2003 at 12:59:19PM +0200, Michael Meskes wrote:
> On Mon, Sep 29, 2003 at 06:41:48PM +0100, Patrick Welche wrote:
> > Today's cvs doesn't compile. I think it is due to
> > cvs diff -r1.7 -r1.8 src/interfaces/ecpg/include/datetime.h
> > I have dtime_t
1 - 100 of 128 matches
Mail list logo
