From: Kurt Roeckx <[EMAIL PROTECTED]>
Subject: Re: [HACKERS] PostgreSQL 7.4devel - LOG: PGSTAT: socket() failed:
Date: Tue, 8 Jul 2003 22:25:44 +0200
;;; > ;;; On Sun, Jul 06, 2003 at 06:30:04PM +0200, Kurt Roeckx wrote:
;;; > ;;; > Try the attached patch instead.
;;; > ;;;
;;; > ;;; Oops, that o
On my 7.3 server:
australia=# \dp exercise_activities
Access privileges for database "australia"
Schema |Table|Access privileges
+-+-
public | exercise_
Has anyone looked at this problem? I have delved into the source code, but
I can't for the life of me see where to make the change. I think there are
actually a few possible solutions:
* Dump all foreign key constraints as a superuser
* Prevent changing ownership of tables that have foreign keys
I would referrer dump that gar.xxg, and put PG on Linux,
but this is not up to me.
Thanks for the help.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 3:58 PM
To: Maksim Likharev
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [GENERAL] PG
"Maksim Likharev" <[EMAIL PROTECTED]> writes:
> On failure, strxfrm() returns (size_t)-1.
Not according to the Single Unix Specification, Linux, or HP-UX;
I don't have any others to check. But anyway, that is not causing
your problem, since palloc(0) would complain not dump core.
> I am on
Interesting. The compiler doesn't do x86_64 by default --- you have to
enable it in the compile.
Any idea how to handle this in our builds? It doesn't seem like a
property of the OS as much as a property of the compiler --- we
already do 64-bit on some platforms without flags.
What is the full
The s_lock.h change will be in 7.4.
---
Tom Lane wrote:
> "Martin D. Weinberg" <[EMAIL PROTECTED]> writes:
> > I didn't change the source tree at all. I used:
>
> > env CFLAGS='-O3 -m64' LD='/usr/bin/ld -melf_x86_64' ./con
What do you think about :
1. OPTION RETURNS NULL ON NULL INPUT (when function is created) change to
RETURNS ON NULL INPUT ???
2. CREATE TYPE .. with INHERITS (..) like in CREATE TABLE
but type should be normaly with including base type
create type A AS (A INT,B INT);
and
create type
On Tue, Jul 08, 2003 at 12:34:19PM +0900, Kenji Sugita wrote:
> From: Kurt Roeckx <[EMAIL PROTECTED]>
> Subject: Re: [HACKERS] PostgreSQL 7.4devel - LOG: PGSTAT: socket() failed: Invalid
> argument
> Date: Sun, 6 Jul 2003 18:44:35 +0200
>
> ;;; On Sun, Jul 06, 2003 at 06:30:04PM +0200, Kurt Roeck
>> !if error happend, xfrmlen will be (size_t)-1
>No it won't; see the man page for strxfrm.
RETURN VALUES
Upon successful completion, strxfrm() returns the length of
the transformed string (not including the terminating null
byte). If the value returned is n or more
"Maksim Likharev" <[EMAIL PROTECTED]> writes:
> ! I would say very interesting aproach,
> ! why not just
> xfrmsize = strxfrm(xfrmstr, NULL, 0);
strxfrm doesn't work that way (and if it did, it would give back a
malloc'd not a palloc'd string).
Hi, I have very interesting suspicion:
See my comments !
convert_string_datum
...
!this is my case
if (!lc_collate_is_c())
{
/* Guess that transformed string is not much bigger than
original */
xfrmsize = strlen(val) + 32;/* arbitrary pa
After upgrade on 7.3.3 we have following:
signal 11
#0 0x254f38 in pfree ()
#1 0x1fde44 in convert_to_scalar ()
#2 0x1faafc in scalarineqsel ()
#3 0x1fd574 in mergejoinscansel ()
#4 0x14fec8 in cost_mergejoin ()
#5 0x16b820 in create_mergejoin_path ()
#6 0x155048 in sort_inner_and_outer ()
hi,
Iam working on project that deals with analyzing the locking mechanism in postgresql.
I started a transaction in postgresql with 'begin work;' and noticed that even though no locks have been taken yet, there still exists data in LockData datastructures that indicates that the transaction i ju
Hi there,
I've managed to write IntDict dictionary for tsearch2 using
dictionary template generator Gendict. Please, take a look
on http://www.sai.msu.su/~megera/oddmuse/index.cgi?Gendict
Spelling corrections and wording improving are welcome.
I still hope someone write clear documentation about
Then mirrors here don't work anymore, and I have to restart apache here,
meanning that web mirror wont come back until I notice domain is here et
restart again.
Marc, can you dol something?
On Tue, 8 Jul 2003, Larry Rosenman wrote:
> Date: Tue, 08 Jul 2003 08:57:27 -0500
> From: Larry Rosenman <
looks like it's not in yesterday's zone:
$ grep fr postgresql.org
10800 ; refresh (3 hours)
news.us CNAME news.pyrenet.fr.
$ more postgresql.org
$ head -20 postgresql.org
$ORIGIN .
$TTL 300; 5 minutes
postgresql.org IN SOA ns.
Hi all,
Is there a dns problem at hub.org?
my mirror www.fr.postgresql.org (and I guess ftp.fr.postgresql.org) does
not resolve any more...
Regards
--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
6, Chemin d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE
Do I save memory using a cursor from a SPI-connected procedure ?
I'm working on a table containing geometric objects and I'd like
to keep a geometry in memory just for the time it is needed, and
one at time, otherwise my machine is in permanent swapping.
--strk;
---(end o
Hi everybody,
I created a db with encoding 'SQL-ASCII'. And I
wrote a JSP application to manipulate corporate information which including both
Traditional/Simplified Chinese characters. However, I can read both
Traditional/Simplified Chinese information from my MS Access (OS: TChinese
Win2
Hi,
just try to compile newly updated 7.4-devl version on a AIX 4.4.3 box,
(just checkouted about 24 hours)
but seems got problem:
8<---
make[3]: Entering directory
`/home/
Hello:
No, it should just work. Can you give a test case? Do you see similar
problems with other utility commands, or is it only CREATE DATABASE?
I have a litlle test more and i have it working now, i have made change
for send a Sync message instead of a Flush message after execute the
comma
22 matches
Mail list logo
