I noticed this in the FreeBSD 5.1 release notes:
"A new DIRECTIO kernel option enables support for read operations that
bypass the buffer cache and put data directly into a userland buffer. This
feature requires that the O_DIRECT flag is set on the file descriptor and
that both the offset and leng
On Mon, 16 Jun 2003, Oleg Bartunov wrote:
> I thought I could specify different encodings
> for different databases and these encodings will be used in text operations
> (sort, upper,lower), not just for conversion.
En encoding does not imply any sort order. UTF-8 can be used to store
strings in
> Seems like a good idea to me --- we've been trying to reduce pg_dump's
> knowledge of backend nitty-gritty, and this would be another small step
> in the right direction.
>
> > Also, it doesn't format them as nicely as the current pg_dump code...
>
> That's fixable no? I guess you might want to
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> Is there any point using pg_get_triggerdef in pg_dump to generate trigger
> definitions? We'd still have to keep the old code so that we can dump pre
> 7.4, but it might mean we don't have to touch that code again if we add
> triggers on colu
Is there any point using pg_get_triggerdef in pg_dump to generate trigger
definitions? We'd still have to keep the old code so that we can dump pre
7.4, but it might mean we don't have to touch that code again if we add
triggers on columns or something...
Also, it doesn't format them as nicely as
> Tatsuo,
>
> recently I tried to understand why I can't get sorting works properly
> with cyrillic characters in UTF8 datbase. I figure out the
> reason of my confusion - I thought I could specify different encodings
> for different databases and these encodings will be used in text operations
>
Folks,
I've re-ordered postgresql.conf.sample per our discussions here.
However, the changes in postgresql.conf.sample need to be reflected in the
initdb script's generation of the LC_* variables.
Can someone help me with the requisite modification to initdb?
Thanks.
--
-Josh Berkus
Aglio D
Tom Lane wrote:
> Is it worth trying to provide some sort of backwards-compatibility mode?
> We could imagine adding a GUC variable to select binary or decimal
> precision, but I really don't want to. It would increase the amount of
> work needed by more than an order of magnitude, and this proble
Fernando Nasser of Red Hat pointed out to me that we are not quite
spec-compliant on the FLOAT(p) datatype notation. We interpret P as
the number of decimal digits of precision, and hence translate
P = 1..6 => float4 (a/k/a REAL)
P = 7..15 => float8 (a/k/a DOUBLE PRECISION)
Does the following patch fix the problem? It doesn't use sa_family_t
anymore.
---
Kurt Roeckx wrote:
> On Mon, Jun 16, 2003 at 02:23:31PM -0500, Bruno Wolff III wrote:
> > On Mon, Jun 16, 2003 at 11:47:58 -0500,
> > Brun
On Mon, Jun 16, 2003 at 02:23:31PM -0500, Bruno Wolff III wrote:
> On Mon, Jun 16, 2003 at 11:47:58 -0500,
> Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> > I get the errors below when compiling on a RH 6.1 system.
> > I used the following config paramters:
> > ./configure --prefix=/usr/local/pgsq
On Mon, Jun 16, 2003 at 03:36:55PM -0400, Bruce Momjian wrote:
>
> I am working on this now. The missing typedef for sa_family_t is really
> just used for structure alignment, so I am working on a fix to define a
> char array and #define to be the same length as the native ss_family,
> because on
No, it will not run in the client process, and probably never will.
---
Yurgis Baykshtis wrote:
> Bruce, thank you for the information.
>
> May I ask you one more question?
> Will it be feasible to run the native Windows ve
Bruce, thank you for the information.
May I ask you one more question?
Will it be feasible to run the native Windows version of Postgres
in-process (that is in client's process)?
Thanks.
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PROTECTED]
Sent: Monday, June 16, 2003 9:37 AM
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> The SQL standard does not allow functions to have domains as arguments.
> Semantically, they have a point.
I don't think they do. Declaring a domain as the input type seems a
very natural way of asserting that the function only works over a subset
of
I am working on this now. The missing typedef for sa_family_t is really
just used for structure alignment, so I am working on a fix to define a
char array and #define to be the same length as the native ss_family,
because on my system sa_family_t is:
sys/sockettypes.h:11:typedef u_char s
On Mon, Jun 16, 2003 at 11:47:58 -0500,
Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> I get the errors below when compiling on a RH 6.1 system.
> I used the following config paramters:
> ./configure --prefix=/usr/local/pgsql --enable-integer-datetimes --with-pgport=5433
>
> hba.c: In function `pa
I just did an upgrade of Unixware to 7.1.3 up1 with the upgrade pack, to
the best of
my knowledge.
I need to look further at it.
--On Monday, June 16, 2003 21:00:44 +0200 Peter Eisentraut
<[EMAIL PROTECTED]> wrote:
Larry Rosenman writes:
> Where did getopt_long() come from and why is there
Larry Rosenman writes:
> > Where did getopt_long() come from and why is there no header file to go
> > along with it?
> I haven't had a chance to find this, I'll try tonight. You are welcom to
> use
> your peter_e account on lerami.lerctr.org if you'd like.
I'm more interested to know how you go
It seems that there are still a few problems with the resolution of
functions that have domains as arguments.
Take these two domains:
create domain testdomain1 as int;
create domain testdomain2 as int;
Take these two functions:
create function foofunc(testdomain1) returns int as 'select 1' lang
Tom Lane writes:
> ENUMs do seem to have some advantages in convenience though. And
> providing them or something closely comparable would ease porting
> from MySQL ... which is an important consideration in our plan for
> world domination ;-)
Now that domains have check constraints, I think enu
Tatsuo,
recently I tried to understand why I can't get sorting works properly
with cyrillic characters in UTF8 datbase. I figure out the
reason of my confusion - I thought I could specify different encodings
for different databases and these encodings will be used in text operations
(sort, upper,
On Sun, Jun 15, 2003 at 04:54:21PM +0100, deststar wrote:
> On cygwin sa_family_t was undeclared, adding the following line:
> typedef unsigned short sa_family_t;
> to both:
> src/port/getaddrinfo.c
> src/include/libpq/pqcomm.h
Isn't the attached or fixing Cygwin itself a better approach?
> seeme
Seems multi-table indexes are the only solution for various inheritance
problems, and I seem to remember even a non-inheritance case that could
use it, but I can't remember what it was.
---
Benjamin Minshall wrote:
> Greetin
Don't break BeOS support.
A new version of BeOS will be released very soon.
http://www.yellowtab.com
http://www.yellowtab.com/board/
http://www.yellowtab.com/support/
Regards,
Yves
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Palle Girgensohn" <[EMAIL PROTECTED]>
Cc: <
Currently I am able to do ...
SELECT dblink_oraconnect('scott/[EMAIL PROTECTED]');
SELECT * FROM dblink_ora('SELECT ename, sal FROM emp')
AS (ename text, sal text);
The problem is: If I wanted to do a
SELECT * FROM dblink_ora('SELECT * FROM emp');
It won't work because dblink_ora returns
Greetings Hackers-
I have an interest in developing better OO support in PostgreSQL, and have
done some preliminary research in the archives and TODO list. It appears
that this topic hasn't gotten much traffic in a while, so I thought I'd test
the waters. What do the gurus here think of implemen
On Friday 13 June 2003 17:28, Roland Glenn McIntosh wrote:
> This is my solution / bug report / RFC cross-posted from [GENERAL]
> regarding insertion of hexadecimal characters from the command line.
> ---
>
> Okay. I have NO IDEA why this works. If someone could en
I get the errors below when compiling on a RH 6.1 system.
I used the following config paramters:
./configure --prefix=/usr/local/pgsql --enable-integer-datetimes --with-pgport=5433
hba.c: In function `parse_hba':
hba.c:590: structure has no member named `ss_family'
hba.c:659: structure has no memb
Yurgis Baykshtis wrote:
>
> We have a similar question about upcoming Windows "native" release:
>
> Is it going to be multithreaded or one process per connection like on
> cygwin?
One connection per process. The only multithreaded Win32 is SRA's
commercial product.
--
Bruce Momjian
We have a similar question about upcoming Windows "native" release:
Is it going to be multithreaded or one process per connection like on
cygwin?
-Original Message-
From: P.M [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 11:10 PM
To: PostGreSQL mailing list
Subject: [HACKERS
On Fri, Jun 13, 2003 at 12:41:28PM -0400, Bruce Momjian wrote:
> Of course, if you exceed swap, your system hangs.
Are you sure? I ran out of swap once or came damn close, due to a cron
job gone amuck. My clue was starting to see lots of memory allocation
errors. After I fixed what was blocking a
On Thu, Jun 12, 2003 at 10:10:02PM -0400, Bruce Momjian wrote:
> Tom Lane wrote:
> It is bad to hang the system, but if it reports swap failure, at least
> the admin knows why it failed, rather than killing random processes.
I wonder if it might be better to suspend whatever process is trying to
Greetings Hackers-
I have an interest in developing better OO support in PostgreSQL, and have
done some preliminary research in the archives and TODO list. It appears
that this topic hasn't gotten much traffic in a while, so I thought I'd test
the waters. What do the gurus here think of implemen
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> In the old protocol there used to be support for more then one error
> arriving, in which case they were concatenated. What is happening with
> that?
That still works with respect to libpq's internally-generated errors,
which is as far as I know the
--On Monday, June 16, 2003 16:51:04 +0200 Peter Eisentraut
<[EMAIL PROTECTED]> wrote:
Where did getopt_long() come from and why is there no header file to go
along with it?
I haven't had a chance to find this, I'll try tonight. You are welcom to
use
your peter_e account on lerami.lerctr.org i
Tom Lane writes:
> * Access to individual fields of an error/notice result; also some setting to
> determine how verbose PQerrorMessage is
>
> char *PQerrorField(conn, char fieldcode)
> char *PQresultErrorField(const PGresult *res, char fieldcode)
>
> fieldcode is as per the protocol s
Where did getopt_long() come from and why is there no header file to go
along with it?
Larry Rosenman writes:
>
> --On Saturday, June 07, 2003 10:42:31 -0500 Larry Rosenman <[EMAIL PROTECTED]>
> wrote:
>
> > cc -O -g -I../../../src/interfaces/libpq -I../../../src/include
> > -I/usr/local/include
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> On Thu, Jun 12, 2003 at 06:23:12PM -0400, Tom Lane wrote:
>>> Even stuff like
>>> drop and rename should be protected by versioning, no?
>>
>> No. System-catalog changes are always READ COMMITTED mode.
> Yeah, so the catalog changes shouldn't be visi
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> MySQL made up ENUMs out of whole cloth...they
> should copy our way, not us theirs...
ENUMs do seem to have some advantages in convenience though. And
providing them or something closely comparable would ease porting
from MySQL ... which is
Dennis Björklund writes:
> However, if you want to produce a utf-8 file, how should that work with
> respect to gettext()? If the message catalog is in latin1 then we need to
> know that and convert that into utf-8.
I don't think all gettext implementations support automatic character set
convers
Dennis Björklund writes:
> Why do we have SQL_ASCII?
It gives a simple default behavior for people who don't want to deal with
character set issues.
> I could understand it if we only could store 7-bit strings there. But
> SQL_ASCII lets you store 8-bit values. Should I understand SQL_ASCII
> si
Christopher Kings-Lynne wrote:
1. Do we want to someday allow groups to have groups as members? (Seems
reasonable to me.)
I agree.
I think the other requirement of roles is that they are able to own objects.
ie. we need to allow groups to own objects.
This would also solve the prob
On Mon, Jun 16, 2003 at 01:17:38 -0500,
"Jim C. Nasby" <[EMAIL PROTECTED]> wrote:
>
> Yeah, so the catalog changes shouldn't be visible to anyone until after
> the ALTER is complete, right? Even if a transaction is set to read
> uncommitted, I assume it will always read only committed data from
44 matches
Mail list logo
