In the docs it is mentioned for datistemplate that
If true then this database can be used in the TEMPLATE clause of
CREATE DATABASE to create the new database as a clone of this one.
However, one can create a database using as template another DB that has
datistemplate set to false.
In this
There has been some previous discussion of changing the FE/BE protocol
in 7.4, in order to fix several problems. I think this is worth doing:
if we can resolve all these issues in a single release, it will lessen
the upgrade difficulties for users.
Here are a couple of other changes you might
b) Send a decoded version of atttypmod - specifically, decode the
precision and scale for numeric types.
I want decode type,length,precision and scale
Type is returned by PQftype(), length is returned by PQfsize(). Precision
and scale are encoded in the return value from PQfmod() and you
, you'll have to look at the bytes one at a time using something like %02X.
-- Korry
of the conditions listed in the NO DATA category. (At least through 8.0 rc1 - I haven't checked in later versions).
-- Korry
On Sat, 2005-01-01 at 14:10 -0500, Tom Lane wrote:
Korry [EMAIL PROTECTED] writes:
It seems you cant trap every condition listed in errocodes-
appendix.html; in particular, you cant trap SUCCESSFUL_COMPLETION, any
of the conditions listed in the WARNING category, or any of the
conditions
before - if you can point me to a document
that covers the information I'm looking for, that would be very helpful).
-- Korry
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http
I asked this question about a half year ago or so, and got:
http://archives.postgresql.org/pgsql-hackers/2005-05/msg00331.php
Thanks James, that's just what I was looking for.
-- Korry
---(end of broadcast)---
TIP 9
you would suffer, but you wouldn't have to
change your application at all that way. Perhaps a private mount so that
only the postgresql process tree could see the decrypted bits?
-- Korry
---(end of broadcast)---
TIP 3: Have you
be stored in the same encrypting
filesystem.
-- Korry
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
of the database would
obviously have the decrypt password for the encrypting filesystem. That
admin (but not other admins) can change the pg_hba.conf file.
-- Korry
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please
folly.
Agreed - that would be a much better (easier and more secure) solution where
practical.
-- Korry
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
that the postmaster is still running? At first blush, that seems more reliable than checking for a (possibly recycled) process ID.
-- Korry
On Wednesday 24 May 2006 21:03, korry wrote:
I'm sure there's a good reason for having it the way it is, having so
many smart knowledgeable people working on this project. Could someone
please explain the rationale of the current solution to me?
We've ignored Andreas' original
is portable to all Unix/Linux systems that I've seen (that way, you can lock a region of a file before you grow the file).
-- Korry
On Wed, 2006-05-24 at 16:34 -0400, Alvaro Herrera wrote:
korry wrote:
The Win32 API for locking seems mighty strange to me.
Linux/Unix byte locking is advisory (meaning that one lock can block
another lock, but it can't block a read).
No -- it is advisory meaning that a process
holding a byte-range lock in addition to the is there some process with the right pid? check might be a little more bullet resistant :-)
-- Korry
is brain-dead on NFS, then relying solely on a lock is unacceptable.
-- Korry
We already have two platforms that don't use the SysV semaphore
interface, and even on ones that have it, I wouldn't want to assume they
all support SEM_UNDO.
Which platforms, just out of curiousity? I assume that Win32 is one of them.
But aside from any portability issues, ISTM this
that I think about it, SMB locking is very unreliable so Win32 would be an issue too.
-- Korry
on either of those (until now).
I hope you enjoy the rest of the book.
-- Korry
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
always exactly the same, but in most cases they are.
Obviously you're now writing 12 extra bytes of overhead to each AllocChunkData (__FILE__, __LINE__, and callCount) and 4 bytes to each AllocSetContext (callCount).
-- Korry
WaitForMultipleObjectsEx() returns. That disassociates the socket from the Event (it will get re-associated the next time pgwin32_waitforsingleselect() is called.
I ran into this problem working on the PL/pgSQL debugger and I haven't gotten around to posting a patch yet, sorry.
-- Korry ([EMAIL
in.
Thanks for your help.
-- Korry
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
robably, but let's fix the API to hide this, so we don't have to commit
now.
Cool.
-- Korry
Time units is easy:
1h = 60min = 3600s = 360ms
We don't need anything larger than seconds at the moment.
Except for log_rotation_age perhaps?
-- Korry
RACE is good,
and so is pg_trace.h. (But invoking it as utils/trace.h would be ok.)
How about the obvious DTRACE( ) or some similar variant?
-- Korry
Sorry to poke - but I'd like to get a patch submitted next week. Any
more comments? Thanks.
-- Korry
Thanks
for the quick feedback.
1) I think the most straightforward way to load an instrumentation
plugin is to define a new custom GUC variable (using
debugger client to a target server and to set global breakpoints.
I'll be posting more information as we get closer to releasing this stuff.
-- Korry
---(end of broadcast)---
TIP 4: Have you searched our list archives
to require that
all plugins live in $libdir?)
-- Korry
intercept those messages. And those
messages will often get lost - many client applications don't have
useful stderr streams (think GUI application on Win32).
-- Korry
--
Korry Douglas [EMAIL PROTECTED]
EnterpriseDBhttp://www.enterprisedb.com
--
Sent via pgsql-hackers mailing list
OF foo was somehow related to the function arguments.
-- Korry
--
Korry Douglas [EMAIL PROTECTED]
EnterpriseDBhttp://www.enterprisedb.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
a command that
exercises your code.
-- Korry
--
Korry Douglas [EMAIL PROTECTED]
EnterpriseDBhttp://www.enterprisedb.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
having to copy
it into place first.
postgres --check-config=myFilenameGoesHere -D $PGDATA
-- Korry
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
and then look through the valgrind output file for that process.
-- Korry
--
Korry Douglas [EMAIL PROTECTED]
EnterpriseDBhttp://www.enterprisedb.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http
case variants) refer to some number of bytes.
If a user wants to specify a variable in terms of bits, he would have
to spell out the units completely, as in 4 gigabits, 20 kilobits,
or 16 megabits.
-- Korry
--
Sent via pgsql-hackers mailing list (pgsql-hackers
{ $$ = list_make2($3, $1); }
| FROM a_expr { $$ = list_make1($2); }
| a_expr{ $$ =
list_make1($1); }
Am I missing something?
-- Korry
.
-- Korry
---
Korry Douglas
Senior Database Dude
EnterpriseDB Corporation
The Enterprise Postgres Company
Phone: (804)241-4301
Mobile: (620) EDB-NERD
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes
to the Makefile.
-- Korry
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
as of (at least
AIX 5.3).
aix.c was required long ago because AIX did not offer the popular
dlopen(), dlsym(), dlclose(), and dlerror() functions - you had to
write them yourself.
-- Korry
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org
r, portnum, conn->pgunixsocket); in the header
comment at the top of fe-connect.c).
-- Korry
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
connect
functions, not by async state machine. But I decided to publish patch
without these improvements to get feedback from community.
A bit of testing on this turns up a problem.
Consider a connection string that specifies two hosts and a read/write
connection:
postgresql://korry@127.0.0.1
connect
functions, not by async state machine. But I decided to publish patch
without these improvements to get feedback from community.
A bit of testing on this turns up a problem.
Consider a connection string that specifies two hosts and a read/write
connection:
postgresql://korry@127.0.0.1
43 matches
Mail list logo