Can we get the BIT type working now that 7.1 is branched?
I did some work on the BIT types a couple months ago. According to
my notes, the following issues are still outstanding before they
can be said to work at all:
Bit and hexstring literals are not handled in a reasonable fashion;
the
Can someone comment on this?
> It seems the truncate command deletes all rows from a table even it is
> referenced by another tables. TRUNCATE is not in the standard any way,
> so I would not claim this is a bug. However, sometimes it would be
> helpful for a user to let him notice that the table
On Mon, 2 Oct 2000, Peter Eisentraut wrote:
> Has anybody been getting pgsql-committers messages the last few days?
I have.
Vince.
--
==
Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net
128K IS
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Has anybody been getting pgsql-committers messages the last few days?
Coming through fine for me (at least when hub.org isn't wedged
completely, which it was several times over the weekend...)
regards, tom lane
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Is this something worth addressing?
Yes, but not when we're already overdue for beta. We've been around
on the question of type promotion rules several times, and no one has
yet put forward a solution that everyone else liked. I don't expect
to see a
I always telnet into hub to run autoconf. I have a little script in my
~momjian/bin directory called pgautoconf that does that, and cvs commits
the changes.
> I have noticed that some operating system distributors ship custom-patched
> versions of Autoconf. That is pretty brain-dead because so
My idea was to implement the large object API on top of TOAST.
> Bruce Momjian wrote:
> > Seems the whole large object per file is going away in 7.1. Can someone
> > confirm this?
>
> Not the whole one in 7.1.
>
> The TOAST stuff will lower the need for large objects alot,
> but
Is this something worth addressing?
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > Bruce Momjian writes:
> >> Can someone give me a TODO summary for this issue?
>
> > * make 'text' constants default to text type (not unknown)
>
> > (I think not everyone's completely convinced on this issue,
Can someone comment on this?
> Bruce Momjian wrote:
> >
> > Seems this was already done in 7.1, right?
> [thread on puts() and fprintf(stderr and printf instead of tprintf or
> replacement truncated]
>
> There are still scads of fprintf(stderr, "some error message from
> postmaster or backend")
I have noticed that some operating system distributors ship custom-patched
versions of Autoconf. That is pretty brain-dead because some of the
changes make things work worse on other systems.
Therefore I would recommend that everybody install the original
autoconf-2.13.tar.gz from GNU and not us
Magnus Hagander wrote:
> If you do decide to prefix DEBUG, please consider prefixing at least ERROR
> as well. It produces a lot of warnings when compiling on Win32 (ERROR is
> already defined as part of the standard windows headers). It's just
> warnings, though.
>
> //Magnus
>
> > Do other peop
Can someone comment on this?
> Bruce Momjian wrote:
>
> > Can we get the BIT type working now that 7.1 is branched?
> >
>
> Yep. We never quite finished the discussions before the 7.0 release. The
> outstanding issues were
>
> 1) should bit operations be allowed between bit strings of differen
At 03:43 PM 10/2/00 -0400, Jim Mercer wrote:
>
>i need to query some oracle tables from a freebsd system.
>
>is there a lightweight method to do this, or do i have no choice but to
>put in the Oracle Linux stuff and use their API's?
Oracle knows ODBC, no?
- Don Baccus, Portland OR <[EMAIL PROT
I have absolutely no idea how well it works, but I think Perl/DBI has a
"pass thru" module that can do this sort of thing...
not sure if that helps much...
-philip
On Mon, 2 Oct 2000, Jim Mercer wrote:
>
> i need to query some oracle tables from a freebsd system.
>
> is there a lightweight m
This time I'm pretty sure I caught the initial crash during an update:
I disabled the vacuum analyze and still got table corruption with a crash:
two crashdumps of 7.0.2+somepatches
*$Header: /home/pgcvs/pgsql/src/backend/access/common/heaptuple.c,v 1.6
2 2000/04/12 17:14:36 momjian Ex
Hi Peter,
I'm getting COMMITTERS OK but last week I noticed I wasn't getting HACKERS
any more.
Try sending a "show [EMAIL PROTECTED]" in the body of a message to
[EMAIL PROTECTED] to see if you're still subscribed.
Keith.
--
I think it's against the Oracle license to run it under any kind of
emulation (which is what you would have to do with FreeBSD, run it under
Linux emulation).. All that's void if they support FreeBSD natively now
(which I don't think they do)..
Wouldn't this be a better question for an Oracle lis
Has anybody been getting pgsql-committers messages the last few days?
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> If we were to sort this out, then I think we'd need to change
> PQsetdbLogin() to take empty arguments uniformly "as is", and make the
> change to make Unix sockets also with an empty host parameter, as
> proposed. Then you could use psql -h '' to re
i need to query some oracle tables from a freebsd system.
is there a lightweight method to do this, or do i have no choice but to
put in the Oracle Linux stuff and use their API's?
--
[ Jim Mercer [EMAIL PROTECTED] +1 416 410-5633 ]
[ Reptilian Research --
Tom Lane writes:
> > The current behaviour of libpq is to use Unix sockets whenever the host
> > parameter (PGHOST or setdbLogin argument) is NULL/unset.
> > Could we extend that to also use Unix sockets if the parameter is set but
> > empty?
> Seems reasonable, since the current behavior in that
I tried to apply this patch to the current tree, but unfortunately,
changes made in permission handling prevent it from being applied.
Seems we were too far into testing to apply this long ago, and now we
are too far away from the original patch to apply it now. If you are
still intersted, we wo
>
> On Mon, 2 Oct 2000, Bruce Momjian wrote:
>
> > The only fix is to do
> >
> > http://www.cz.postgresql.org/index.html
>
> It's returns still same a *bad* result.
No, sorry, use:
http://www.postgresql.org/index.html
The index.html prevents the redirect.
>
> >
> > This preve
On Mon, 2 Oct 2000, Karel Zak wrote:
>
> On Mon, 2 Oct 2000, Bruce Momjian wrote:
>
> > The only fix is to do
> >
> > http://www.cz.postgresql.org/index.html
>
> It's returns still same a *bad* result.
This will bypass the redirect:
http://www.postgresql.org/index.html
Vince.
>
I've been looking at UNION/INTERSECT/EXCEPT with an eye to making them
work in views and subselect-in-FROM (same thing really ;-)). I had first
thought that some marginal hacking on the parsetree representation might
be enough, but after study I am realizing just how broken this code really
is.
On Mon, 2 Oct 2000, Bruce Momjian wrote:
> The only fix is to do
>
> http://www.cz.postgresql.org/index.html
It's returns still same a *bad* result.
>
> This prevents mirror use. The old mirror should be fixed or removed.
^^
Sur
Thanks. Also, main server is backup now.
>
>
> Removed from redirect.
>
> Vince.
>
>
> On Mon, 2 Oct 2000, Karel Zak wrote:
>
> >
> >
> > What happen with www.postgresql.org? My browser is always redirected
> > to http://www.cz.postgresql.org/.
> >
> > But I haven't some terrible mir
The only fix is to do
http://www.cz.postgresql.org/index.html
This prevents mirror use. The old mirror should be fixed or removed.
>
>
> What happen with www.postgresql.org? My browser is always redirected
> to http://www.cz.postgresql.org/.
>
> But I haven't some terrible mirror
I have committed this patch. It offers a speed up to ecpg.
>
> Michael Meskes <[EMAIL PROTECTED]> wrote:
>
> > On Sat, Jun 03, 2000 at 11:22:19AM +0900, SAKAIDA Masaaki wrote:
> > > The following patch could solve the next error cases in 6.5.3-ecpglib.
> > >
> > > case 1.
> > >strcpy(str
On Sun, 1 Oct 2000, Peter Eisentraut wrote:
> Stephan Szabo writes:
>
> > With that, I do have a general question though. Are referential actions
> > supposed to be limited by the permissions of the user executing the query?
> > So, if you for example have write access on the pk table, but not
Removed from redirect.
Vince.
On Mon, 2 Oct 2000, Karel Zak wrote:
>
>
> What happen with www.postgresql.org? My browser is always redirected
> to http://www.cz.postgresql.org/.
>
> But I haven't some terrible mirror (with last change "July 1999"),
> I want nice and native PG's web! :
Tom Lane <[EMAIL PROTECTED]> writes:
> Louis-David Mitterrand <[EMAIL PROTECTED]> writes:
> > Fresh from /var/log/postgres.log:
> > postgres localhost www-data auction SELECT: ../iconv/skeleton.c:297: gconv:
>Assertion `outbufstart == ((void *)0)' failed.
>
> ?? Anyone recognize that?
>
> A fe
Louis-David Mitterrand <[EMAIL PROTECTED]> writes:
> Fresh from /var/log/postgres.log:
> postgres localhost www-data auction SELECT: ../iconv/skeleton.c:297: gconv:
>Assertion `outbufstart == ((void *)0)' failed.
?? Anyone recognize that?
A few seconds with glimpse shows that there is no file n
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> The current behaviour of libpq is to use Unix sockets whenever the host
> parameter (PGHOST or setdbLogin argument) is NULL/unset.
> Could we extend that to also use Unix sockets if the parameter is set but
> empty?
Seems reasonable, since the curren
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> On a related note, does anyone know why the on_proc_exit and on_shmem_exit
> hooks use a second argument of type `caddr_t' rather than, say, void*,
> char*, Datum, ...? This artifact is the cause of about two thirds of the
> compile errors in the ped
Fresh from /var/log/postgres.log:
postgres localhost www-data auction SELECT: ../iconv/skeleton.c:297: gconv: Asse
rtion `outbufstart == ((void *)0)' failed.
Server process (pid 27393) exited with status 6 at Mon Oct 2 09:01:43 2000
Starting a new postmaster seems to cure the problem.
--
Loui
"Martin A. Marques" wrote:
>
> Hi,
>
> I would like to know if postgres comes with some kind of backup application?
> I mean something that would do database backup and restore, something like
> informix's ontape and logical logs.
Take a look at pg_dump and pg_dumpall
-
Hannu
Hi,
I would like to know if postgres comes with some kind of backup application?
I mean something that would do database backup and restore, something like
informix's ontape and logical logs.
Thanks
--
"And I'm happy, because you make me feel good, about me." - Melvin Udall
-
The current behaviour of libpq is to use Unix sockets whenever the host
parameter (PGHOST or setdbLogin argument) is NULL/unset.
Could we extend that to also use Unix sockets if the parameter is set but
empty? That could avoid a bunch of shell contortions; e.g., you can't
portably un-export vari
* Peter Eisentraut <[EMAIL PROTECTED]> [001002 02:51] wrote:
> The file "postgres.h" (or "c.h" or "config.h", whatever is used) needs to
> be the very *first* file included by each source file. Next time you
> touch a source file, please check that this is the case.
>
> The obvious failure mode
The file "postgres.h" (or "c.h" or "config.h", whatever is used) needs to
be the very *first* file included by each source file. Next time you
touch a source file, please check that this is the case.
The obvious failure mode is that if config.h redefines const, volatile, or
inline then it will c
At 22:27 9/29/00 -0400, you wrote:
>Jeroen, not sure if you were involved in this, but standard deviation is
>in the current development tree, and will be released in 7.1 in a few
>months.
Yes, I noticed. And I'm happy to see it has been implemented without my
help, as I'm desperately running ou
What happen with www.postgresql.org? My browser is always redirected
to http://www.cz.postgresql.org/.
But I haven't some terrible mirror (with last change "July 1999"),
I want nice and native PG's web! :-)
Karel
PS. Exist some check what happen at PostgreS
43 matches
Mail list logo
