Hey all.
Playing around, and pg_dumpall -c does delete from pg_shadow as
part of the role cleanup?
Our friendly psql complains that pg_shadow is a view:
psql::11: ERROR: cannot delete from a view
HINT: You need an unconditional ON DELETE DO INSTEAD rule.
And then:
psql::13: ERROR
[EMAIL PROTECTED] (Alvaro Herrera) writes:
> Or, slightly different, what are people's most wanted features?
- Vacuum Space Map - Maintain a map of recently-expired rows
This allows vacuum to target specific pages for possible free
space without requiring a sequential scan.
- Deferrable
Hi everybody,
I would like to add query sampling support to postgresql (atleast as a part of
my project, if someone feels strongly against checking it in the main branch).
I have been going over the code and I do see a lot of sampling stuff
in backend/commands/analyze.c. However, I plan to add s
On Sat, 27 Aug 2005, Tom Lane wrote:
Michael Fuhr <[EMAIL PROTECTED]> writes:
On Sat, Aug 27, 2005 at 10:28:30AM -0400, Tom Lane wrote:
Can you provide a self-contained test case? The backtrace is
interesting but it's not enough information to find the bug.
Here's a simple test case based
Just when you thought it was safe to go back in the water ...
According to my reading of the MIPS documentation, that architecture
requires explicit "sync" instructions to guarantee ordering of memory
accesses, just like PowerPC does. We have a "sync" now in the tas()
inline code that grabs a spi
Michael Fuhr <[EMAIL PROTECTED]> writes:
> Running EXPLAIN on a view that has an aggregate and uses an index
> results in the error "bogus varno: 5".
I've committed a fix for this --- it was a bug in the recently added
code that eliminates useless SubqueryScan nodes.
regar
Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Sat, Aug 27, 2005 at 10:28:30AM -0400, Tom Lane wrote:
>> Can you provide a self-contained test case? The backtrace is
>> interesting but it's not enough information to find the bug.
> Here's a simple test case based on what I think Oleg is doing.
I
Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes:
> well not sure if that counts as "really works" :-)
> http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=lionfish&dt=2005-08-27%2006:33:05
Nope, apparently the example I looked at was wrong about how to write
constants in MIPS assembler. Sigh. New
"Andrew Dunstan" <[EMAIL PROTECTED]> writes:
>>> * support for Tutorial D as an alternative to SQL. It would be great
>>> for educational purposes.
> This strikes me as something that belongs in a research project, not in the
> core, at least for now.
For better or worse, Postgres is a SQL engi
On Sat, Aug 27, 2005 at 10:28:30AM -0400, Tom Lane wrote:
> Oleg Bartunov writes:
> > I finally narrow down my problem with postmaster crashing 8.1dev
> > (today's CVS):
>
> Can you provide a self-contained test case? The backtrace is
> interesting but it's not enough information to find the bu
Martijn van Oosterhout writes:
> Tom Lanes patch[2] looks like it may work, but would a mechanism to
> allow user-defined types to have a typmod function be accepted?
> [2] http://archives.postgresql.org/pgsql-hackers/2004-06/msg00932.php
Well, the question still stands: are we going to paint our
Oleg Bartunov writes:
> I finally narrow down my problem with postmaster crashing 8.1dev
> (today's CVS):
Can you provide a self-contained test case? The backtrace is
interesting but it's not enough information to find the bug.
regards, tom lane
---
On Sat, Aug 27, 2005 at 05:21:46PM +0400, Oleg Bartunov wrote:
> This query works as expected:
> # select name_qualified from place
> where fts_index @@ to_tsquery('moscow');
>
> This query (essentially the same as above) crashes:
> # select name_qualified from place, to_tsquery('moscow') as que
We definitely need to allow user-types to use typmod. If we don't
support this, it needs to be a TODO. Added to TODO:
* Allow user-defined types to specify a type modifier at table creation
time
---
Martijn van Oosterh
Hi there,
I finally narrow down my problem with postmaster crashing 8.1dev
(today's CVS):
This query works as expected:
# select name_qualified from place
where fts_index @@ to_tsquery('moscow');
This query (essentially the same as above) crashes:
# select name_qualified from place, to_tsqu
Michael Glaesemann said:
>
> On Aug 27, 2005, at 2:45 AM, Heikki Linnakangas wrote:
>
>>
>> * support for Tutorial D as an alternative to SQL. It would be great
>> for educational purposes.
>
> ++
>
I disagree.
This strikes me as something that belongs in a research project, not in the
core, at
[Please CC any replies, thanks]
Hi,
I've got a situation were I'd really like to be able to have a typmod
for a user-defined type. In particular, I'd like to make use of the
coerce_to_target_type()/coerce_type_typmod() chain. This only works if
you have a typmod != -1.
Even if you set the typmod
On Fri, 26 Aug 2005, Heikki Linnakangas wrote:
> * support for Tutorial D as an alternative to SQL. It would be great for
> educational purposes.
Hmm... we could call it POSTQUEL :-).
Gavin
---(end of broadcast)---
TIP 4: Have you searched our lis
Tom Lane wrote:
> I wrote:
>
>>Can anyone spot the problem? If not I fear we'll have to revert this.
>
>
> After a bit of reading MIPS documentation, I found out that the proposed
> patch is exactly backward: it returns 1 if it gets the lock and 0 if the
> lock is already held :-(
>
> Because
19 matches
Mail list logo
