Tom Lane wrote:
> Well, it's not an optional larger project: there just isn't any way ATM
> to define a composite type that's not linked to a pg_class entry. The
> only way to show fields of a composite type is through pg_attribute
> entries, and pg_attribute entries are bound to pg_class entries
> Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> > BTW, for the problem I reported, what about checking
> > IsTransactionState returns true before accessing database to find out
> > conversions?
>
> The $64 problem here is *what do you do before you can access the database*.
> Detecting whether you c
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> BTW, for the problem I reported, what about checking
> IsTransactionState returns true before accessing database to find out
> conversions?
The $64 problem here is *what do you do before you can access the database*.
Detecting whether you can access the
[EMAIL PROTECTED] (Neil Conway) writes:
> On Thu, Jul 18, 2002 at 03:12:53PM -0700, Joe Conway wrote:
>> Maybe the function should take a boolean parameter to indicate whether
>> or not to show locks on objects in pg_* schema?
> I had thought about that, but it occurs to me that the DBA can
> eff
Joe Conway <[EMAIL PROTECTED]> writes:
> Christopher Kings-Lynne wrote:
>> Out of interest - why do SRFs need to have a table or view defined that
>> matches their return type? Why can't you just create the type for the
>> function and set it up as a dependency?
> The only current way to create
Christopher Kings-Lynne wrote:
> Out of interest - why do SRFs need to have a table or view defined that
> matches their return type? Why can't you just create the type for the
> function and set it up as a dependency?
>
The only current way to create a composite type (and hence have it for
th
> > Rather than adding another SHOW command, I think using a table
> > function is a better idea. That's because the information returned by
> > the lock listing code will often need to be correlated with other
> > information in the system catalogs, or sorted/aggregated in various
> > ways (
I have completed the trivial TODO item:
* -HOLDER/HOLDERTAG rename to PROCLOCK/PROCLOCKTAG (Bruce)
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Ch
> I'm getting the warnings below from current cvs. My configure line looks
> like:
Don't worry. As I already posted, there are some encodings need to
addressed for CREATE CONVERSION. Theses functions are in the process
of migration. I will #ifdef out to avoid confusion.
--
Tatsuo Ishii
> Hannu Krosing <[EMAIL PROTECTED]> writes:
> > On Thu, 2002-07-18 at 18:57, Tom Lane wrote:
> >> The problem is not just there. The real problem is that with this patch
> >> installed, it is impossible to report startup errors of any kind,
> >> because the client communication mechanism now depe
On Thu, Jul 18, 2002 at 03:12:53PM -0700, Joe Conway wrote:
> Neil Conway wrote:
> > Also, should locks on special relations (e.g. pg_xactlock) or on
> > system catalogs be shown?
>
> Maybe the function should take a boolean parameter to indicate whether
> or not to show locks on objects in pg_*
On Fri, 2002-07-19 at 03:21, Tom Lane wrote:
> Hannu Krosing <[EMAIL PROTECTED]> writes:
> > On Thu, 2002-07-18 at 18:57, Tom Lane wrote:
> >> The problem is not just there. The real problem is that with this patch
> >> installed, it is impossible to report startup errors of any kind,
> >> becaus
I have completed this TODO item with the following patch, patch applied:
* Merge LockMethodCtl and LockMethodTable into one shared structure
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard dr
Wow. I think I will hold for a while.
---
Peter Eisentraut wrote:
> Bruce Momjian writes:
>
> > Oh, so you are saying let most uses of src/port use the *.o files that
> > are in the directory, and it isn't needed to have
Bruce Momjian writes:
> Oh, so you are saying let most uses of src/port use the *.o files that
> are in the directory, and it isn't needed to have other directories use
> the link trick. Just let me know what people want.
What I want is this:
In configure.in, call
AC_REPLACE_FUNCS([inet_aton
Joe Conway <[EMAIL PROTECTED]> writes:
> I'm getting the warnings below from current cvs.
I see the same.
> gcc -O2 -g -Wall -Wmissing-prototypes -Wmissing-declarations
> -I../../../../src/include -c -o conv.o conv.c -MMD
> conv.c:41: warning: `euc_kr2mic' defined but not used
> conv.c:67: wa
Hannu Krosing <[EMAIL PROTECTED]> writes:
> On Thu, 2002-07-18 at 18:57, Tom Lane wrote:
>> The problem is not just there. The real problem is that with this patch
>> installed, it is impossible to report startup errors of any kind,
>> because the client communication mechanism now depends on hav
Neil Conway wrote:
> I've been working on the TODO list item "Add SHOW command to display
> locks". The code is basically finished, but I'd like to make sure the
> user interface is okay with everyone before I send it in to -patches
> (if you're interested, the patch is attached).
>
> Rather
I'm getting the warnings below from current cvs. My configure line looks
like:
./configure --enable-integer-datetimes --enable-locale --enable-debug
--enable-cassert --enable-multibyte --enable-syslog --enable-nls
--enable-depend
Joe
=
On Thu, Jul 18, 2002 at 02:35:42PM -0400, Neil Conway wrote:
> I've been working on the TODO list item "Add SHOW command to display locks". The
> code is basically finished, but I'd like to make sure the user interface is okay
> with everyone before I send it in to -patches (if you're interested,
On Thu, 2002-07-18 at 15:36, Richard Tucker wrote:
> Sorry, I didn't delimit my comments correctly before.
> I'm offering our pg_copy/roll forward implementation to PostgreSQL.org if it
> finds it an acceptable contribution. Progress/Multera would hand over all
> rights to any code accepted.
>
>
Your patch has been added to the PostgreSQL unapplied patches list at:
http://candle.pha.pa.us/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---
Magnus Naeslund(f) wrote:
> Hello, i noticed t
Progress/Multera would release the hot backup/roll forward work to the
PostgreSQL Development group.
-regards
richt
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of J. R. Nield
Sent: Thursday, July 18, 2002 2:34 PM
To: [EMAIL PROTECTED]
Cc: Bruce Momjian;
Richard:
I can't quite follow this; maybe you sent a draft by accident. If you
want to post a patch against 7.2.1, or even better against HEAD in CVS,
that would be great. Or if you'd rather point me to your source online,
that would be good too.
I just want to clarify though: is this work relea
I've been working on the TODO list item "Add SHOW command to display locks". The
code is basically finished, but I'd like to make sure the user interface is okay
with everyone before I send it in to -patches (if you're interested, the patch
is attached).
Rather than adding another SHOW command, I
I have been looking at an example of the "no one parent tuple found"
VACUUM error provided by Mario Weilguni. It appears to me that VACUUM
is getting confused by a tuple that looks like so in pg_filedump:
Item 4 -- Length: 249 Offset: 31616 (0x7b80) Flags: USED
OID: 0 CID: min(240) max(
On Thu, 2002-07-18 at 18:57, Tom Lane wrote:
> Hannu Krosing <[EMAIL PROTECTED]> writes:
> > Why can't we just open the listening socket _after_ the database has
> > completed starting up phase ?
>
> The problem is not just there. The real problem is that with this patch
> installed, it is impos
Tom Lane wrote:
> [EMAIL PROTECTED] (Neil Conway) writes:
> > Running CVS HEAD from this morning, 'make check' fails due to an
> > initdb failure when initializing pg_depend:
>
> Did you do a full recompile after your last update? I notice Bruce
> has arbitrarily renumbered expression nodes ...
If I understand correctly, I tried specifying the target and even casting
all of the smallint's, but it still is a slow estimate. Perhaps, this is
just due to a large amount of data, but my gut is telling me that I have
something wrong here.
db02=# explain select distinct area from center_out
Hannu Krosing <[EMAIL PROTECTED]> writes:
> Why can't we just open the listening socket _after_ the database has
> completed starting up phase ?
The problem is not just there. The real problem is that with this patch
installed, it is impossible to report startup errors of any kind,
because the c
Tom Lane wrote:
> [EMAIL PROTECTED] (Neil Conway) writes:
> > Running CVS HEAD from this morning, 'make check' fails due to an
> > initdb failure when initializing pg_depend:
>
> Did you do a full recompile after your last update? I notice Bruce
> has arbitrarily renumbered expression nodes ...
On Thu, 2002-07-18 at 06:55, Tatsuo Ishii wrote:
> I have faced a problem with encoding conversion while the database is
> starting up. If postmaster accepts a connection request while in the
> state, it issues a fatal message "The database system is starting
> up". Then the encoding conversion sy
[EMAIL PROTECTED] (Neil Conway) writes:
> Running CVS HEAD from this morning, 'make check' fails due to an
> initdb failure when initializing pg_depend:
Did you do a full recompile after your last update? I notice Bruce
has arbitrarily renumbered expression nodes ...
reg
Running CVS HEAD from this morning, 'make check' fails due to an
initdb failure when initializing pg_depend:
initializing pg_depend...
/home/nconway/pgsql/src/test/regress/./tmp_check/install//data/pgsql/bin/initdb:
line 718: 31128 Segmentation fault (core dumped) "$PGPATH"/postgres
$PGSQL_O
On Thu, 18 Jul 2002 23:05:05 +0900 (JST), Tatsuo Ishii
<[EMAIL PROTECTED]> wrote:
>TRAP: Failed Assertion("!(!((tp.t_data)->t_infomask & (0x4000 |
>0x8000))):", File: "heapam.c", Line: 1315)
Tatsuo, this is unrelated to *your* work. It is a bug introduced with
my heap tuple header changes. Tom
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> While implementing DROP CONVERSION [CASCADE|RESTRICT], I'm facing
> a strange problem. When I tries to delete a tuple from pg_depened, I
> got an assertion failure:
This is the bug I complained of in Manfred's HeapTupleHeader patches.
He's sent in a patc
Hi,
While implementing DROP CONVERSION [CASCADE|RESTRICT], I'm facing
a strange problem. When I tries to delete a tuple from pg_depened, I
got an assertion failure:
TRAP: Failed Assertion("!(!((tp.t_data)->t_infomask & (0x4000 |
0x8000))):", File: "heapam.c", Line: 1315)
This means that HEAP_MO
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> Does anyone know how I should modify MergeAttributes to support dropped
> columns?
I think you could get away with just ignoring dropped columns from the
parent. There's no assumption that column numbers are the same in
parent and child.
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> I have faced a problem with encoding conversion while the database is
> starting up. If postmaster accepts a connection request while in the
> state, it issues a fatal message "The database system is starting
> up". Then the encoding conversion system tri
Hello, i noticed that win32 native stopped working/compiling after the SSL merge.
So i took the opportunity to fix some stuff:
1. Made the thing compile (typos & needed definitions) with the new pqsecure_* stuff,
and added fe-secure.c to the win32.mak makefile.
2. Fixed some MULTIBYTE compil
> > AND part.name LIKE '%green%'
>
> It's difficult for the planner to produce a decent estimate for the
> selectivity of an unanchored LIKE clause, since there are no statistics
> it can use for the purpose. We recently changed FIXED_CHAR_SEL in
> src/backend/utils/adt/selfuncs.c from 0.04 to
Bruce wrote:
> Actual error code numbers/letters. I think the new elog levels will
> help with this. We have to decide if we want error numbers, or some
> pneumonic like NOATTR or CONSTVIOL. I suggest the latter.
Since there is an actual standard for error codes, I would strongly suggest
to
42 matches
Mail list logo
