To answer your question, wouldn't numeric(30,0) be the correct?
-alex
On Thu, 18 Jan 2001, The Hermit Hacker wrote:
>
> hrrmm ... ignore this ... I'm suspecting that what I did was copied in
> sum() data from an old table that had bytes declared as int4, without
> cas
Just to clarify for stupid me: you want to remove it and forbid catalog
updates or remove it and allow catalog updates? (I hope its latter :)
On Tue, 23 Jan 2001, Tom Lane wrote:
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > While I'm at it and before I forget the 76 places one needs to edi
On Fri, 2 Feb 2001, tomasz konefal wrote:
> could someone please clarify what "Allow Java
> server-side programming" actually means? what are the
> limitations of using java and jdbc with pgsql?
It means to embed Java interpreter inside postgres, and allow writing
stored procedures and trigge
ible, I think both of these bindings are
two-way (you can go perl-java-perl-java). Might be worth a quick try?
-alex
post the rest of the traceback.
0x40* is the address inside some shared library, most likely libc.
full traceback will show what happened before it got to libc
-alex
On Mon, 5 Feb 2001, Mathieu Dube wrote:
> So...
> If after recompiling postgres with -g in the CFLAGS and still g
On Thu, 8 Feb 2001, Alex Pilosov wrote:
> Great! :)
>
> It might also clean up something that I've been fighting against for
> awhile: when I include files needed for SPI, it drags also a lot of other
> garbage in, which conflicts with other things (namely, tryin
On Thu, 8 Feb 2001, Tom Lane wrote:
> Alex Pilosov <[EMAIL PROTECTED]> writes:
> > when I include files needed for SPI, it drags also a lot of other
> > garbage in, which conflicts with other things (namely, trying to get a
> > file to simultaneously include SPI and
nditionally on that being
defined.
-alex
On Thu, 8 Feb 2001, Tom Lane wrote:
> I have been looking at making a split between client-side and server-side
> include files as we discussed earlier this week (pghackers thread
> "Include files for SPI are not installed", if you miss
On Wed, 7 Mar 2001, Mikheev, Vadim wrote:
> But what can be done if fsync returns before pages flushed?
No, it won't. When fsync returns, data is promised by the OS to be on
disk.
-alex
---(end of broadcast)---
TIP 6: Have you searched
references to Zend.
Additionally, I grepped through source only to realize that "direction"
is used a lot. So I used the following find :
[goro:~/postgresql-7.3.1] alex% find . -type f -exec egrep -il
'directio[^Nn]' {} \;
And also didn't find anything. The manpage for directi
On Tue, 13 Feb 2007, Marc Munro wrote:
> On Mon, 2007-12-02 at 00:10 -0500, Tom Lane wrote:
> > Marc Munro <[EMAIL PROTECTED]> writes:
> > > Consider a table C containing 2 child records C1 and C2, of parent P.
> > > If transaction T1 updates C1 and C2, the locking order of the the
> > > records w
27;
Error: could not initialize database directory; delete failed as well
detail : failing system command was : cp -r '/var/postgresql/data/base/1' '/var/postgresql/data/base/17147'
please anyone 'master' here help , my deadline is near.. please.
alex
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
Postgres has an 'ascii' function that converts
characters to ascii, values, but it appears to be a
one way street. I can't find a way to convert ascii
values to characters, like 'chr' in Oracle. Anyone
know how to do this?
-Alex
__
Best,
Alex
--- Tom Lane <[EMAIL PROTECTED]> wrote:
>
> New proposal: forget ichar(), give the function two
> entries chr() and
> char().
>
> regards, tom lane
__
Do You Yahoo!?
Yahoo! Mail - Free email
Hi,
How can I convert char* to Datum to pass a string to the SPI_modifytuple function?
regards,
Alex
...
-alex
On Tue, 12 Sep 2000, Bruce Momjian wrote:
> Sounds like people want it. Can you polish it off, add SGML docs and
> send it over?
>
> > -BEGIN PGP SIGNED MESSAGE-
> >
> > Last week I created a patch for the Postgres client side libraries to allow
&
Suppose I have table a and b (b inherits a).
Then I do select * from a*;
Now, I'd like to know which table this particular row came from (a or b).
Is this possible? Or do I have to have a column where I'd store what kind
of object this is?
-alex
Can I do following?
create table foo (
x int4 references bar*
)
Or, since 7.1 will have bar* as default for bar, will using 'references
bar' do what I want?
-alex
other hand, locking of that kind will be unnecessary for postgres, so it
can return fd of some file in /tmp...
There's an attempt to do this at http://www.is.kiruna.se/~goran/ldap/arkiv/
but its very raw and not configurable.
-alex
exception in plpgsql? [I would
assume that depends on SPI ability to trap exceptions...]
These features are really needed for people who do serious
database-backend scripting, to compete with sybase (who has multilevel
transactions) and oracle (who has very good exception handling).
Thank you
-alex
ds to be done: on alter table, update tgargs in pg_trigger table
-alex
y
fmgr. Is there a way to declare functions 'not-cacheable-ever'? If there
is, such should be applied to now().
-alex
Strangely, the same thing does not happen when I do timenow() instead of
time(). This is very counter-intuitive, if this is the way it is supposed
to work, at least docs should be saying that.
Also, I checked, and its probably not the fmgr cache, since now() is set
to be noncacheable...
-alex
called from some outer statement, so
> advancing now() within the function would violate the spec constraint
> with respect to the outer statement.
Postgres doesn't have an idea of what a 'top-level' statement is? I.E.
statement as submitted by a client (libpq)?
-alex
.
What causes this? I'm having a feeling that it has to do with referential
integrity (the table in question is referenced by almost every other
table), and with [possibly] a leak of reference counts?
This is all with pg7.0.2 on i386.
-alex
I think this happens after I create/modify tables which reference this
table. This is spontaneous, and doesn't _always_ happen...
Anything I could do next time it craps up to help track the problem down?
-alex
CREATE TABLE "customers" (
"cust_id&q
On Mon, 23 Oct 2000, Tom Lane wrote:
> when done, but it will deadlock if SELECT does not release that lock.
>
> That's annoying but I see no way around it, if we are to allow
> concurrent transactions to do schema modifications of tables that other
> transactions are using.
I might be in above
On Mon, 23 Oct 2000, Alex Pilosov wrote:
> On Mon, 23 Oct 2000, Tom Lane wrote:
>
> > when done, but it will deadlock if SELECT does not release that lock.
> >
> > That's annoying but I see no way around it, if we are to allow
> > concurrent transactions t
but it will deadlock if SELECT does not release that lock.
Probably a silly question, but since this is the same transaction,
couldn't the lock be 'upgraded' without a problem?
Or postgres doesn't currently have idea of lock upgrades...?
-alex
when I start straightening out my
network equipment tables...;)
-alex
On Fri, 27 Oct 2000, Larry Rosenman wrote:
> and network(cidr) should print ONLY the octets, not the mask...
Agreed. There's a function to get the mask size, and the network should
just return the network. Otherwise, it is impossible to use.
-alex
, but I really need to have more
flexibility or we are going to (read: I will be tasked with) be writing
our own.
Sorry for the terseness -- and I haven't had a chance to go over the
whole thread; we're moving from 7.3.2 to 7.4.2 on "the big database"
this week.
Alex
--
[
were just if it was ready, and how or if it should change when it goes in.
It is very simple code, I'm not sure what is "not ready" about it. If
people don't want to use it, they don't have to. Many databases can go
days to weeks without vacuuming.
alex
--
[EMAIL PROTECT
ven found the \df macro.
However, the C stuff was beyond my ability. Hopefully, this is a direct
"clone \df" item. I really think this would be useful for people who
haven't yet becomes familiar with postgres' (very rich) function base.
Hm. On second thought, \qf is a bad n
ses.
Duplication of help systems that are never going to be used is a waste of
everyone's time.
Alex
--
[EMAIL PROTECTED]
Alex J. Avriette, Unix Systems Gladiator
"Shut down some of the bullshit the government is spending money on and use it
to buy all the Microsoft stock. If we did tha
in psql. I'm just unable to
actually do the C part myself. If somebody would step up to the plate,
we could see this in the next release. I haven't heard anyone say they
didn't like it.
alex
--
[EMAIL PROTECTED]
Alex J. Avriette, Windows Systems Defenestrator
"Obj
't have any particular allegiance to the forward slash over anything
else. My chief concern is that what we're abstracting here are macros, and
as such, they should not be treated as sql. Because they aren't sql. If
you want to find out how to show the databases in sql, use psql -E.
ht* with those extensions. You can't become a PostgreSQL guru without
> being a newbie first. I vote we make it easier for newbies.
What really frightens me here is that I know of several applications (shudder,
"LAMP" applications) which use the output of "show tables"
ip4 address. However, I'm aware that many
people don't even realize this is a valid address. As such, I won't
lose any sleep over it, but I thought I'd mention it, since it
surprised me today.
Thoughts?
Alex
--
[EMAIL PROTECTED]
Alex J. Avriette, Solaris Frobnosticator
7;d really like to hear from others what their opinions on this are.
alex
--
[EMAIL PROTECTED]
Alex J. Avriette, Shepherd of wayward Database Administrators
"We are paying through the nose to be ignorant." - Larry Ellison
---(end of broadcast)
On Tue, Jan 06, 2004 at 11:38:44PM -0500, Tom Lane wrote:
> AFAICS, Alex is quite far out in left field to believe that this is a
> standard notation. The fact that some BSD platforms have accepted it
How did I know you'd say that, Tom?
By "standard," I mean, "many
luded in the
next release. I don't feel that having zero documentation on this
subject is acceptable.
Thanks for your time,
alex
--
[EMAIL PROTECTED]
Alex J. Avriette, Unix Systems Gladiator
"You cannot invade the mainland United States. There would be a rifle behind each
blade of g
hopes that we can discuss both the
best way to support very large scale databases, as well as how to
handle them presently.
Thanks again for your time.
alex
--
[EMAIL PROTECTED]
Alex J. Avriette, Solaris Systems Masseur
"I ... remain against the death penalty because I feel that eternal bor
load balancing (eg rotors or similar) and updates between
postmasters, it would be (it seems to me) possible to drastically
increase the available capacity of a database installation through the
addition of more nodes. This has the added benefit of allowing us to
distribute network resources.
A
yone would be opposed to this, however. I'm happy to
write the document and provide a patch for inclusion if we can come to
agreeance on some basic policies. The reason I posted the original
message in this thread is I wanted to know what others felt were
appropriate policies, and to suggest
also think most
of us would agree that the current "graft-on" replication methods are
sub-ideal.
alex
--
[EMAIL PROTECTED]
Alex J. Avriette, Unix Systems Gladiator
The Emperor Wears No Clothes.
http://www.drugsense.org/wodclock.htm
---(end of broadcast)---
TIP 8: explain analyze is your friend
On Sun, Feb 08, 2004 at 09:20:07PM -0500, Rod Taylor wrote:
> On Sun, 2004-02-08 at 21:01, Alex J. Avriette wrote:
> > On Sun, Feb 08, 2004 at 08:01:38PM -0500, Rod Taylor wrote:
> >
> > > Replication won't help if those are all mostly write transactions. If a
&
stions via google first. If the
docs were included on techdocs, google would find them soon enough. I
suppose, also, anyone who was interested in securing their database
would look a little further than the included documentation.
Opinions?
Alex
--
[EMAIL PROTECTED]
Alex J. Avriette, Shepherd of
> I don't intend going this far, however.
Perhaps now would be a good time to bring up my directio on Solaris question
from a year or so back? Is there any interest in the ability to use raw
disk?
Alex (who is overjoyed to hear discussion of tablespaces again)
--
[EMAIL PROTECTED]
Alex
I'm very glad to hear tablespaces mentioned again and see
what looks like work being done on it.
Thanks!
Alex
--
[EMAIL PROTECTED]
Alex J. Avriette, Solaris Artillery Officer
"Among the many misdeeds of the British rule in India, history will look upon the act
of depriving a whole nation
e" schema
and the schema in cvs at work. This was a really painful process, and it
occurred to me that it wouldn't be terribly hard to write a perl program
to do it (I wound up using vim and diff). Is there interest in such a tool?
I could probably have one written within a day or two.
Alex
--
[
;d like to avoid the dogmatic
jihad by not submitting a perl tool if the eventual goal is to be
end-to-end C (or java or tcl or whatever).
Alex
--
[EMAIL PROTECTED]
Alex J. Avriette, Unix Systems Gladiator
"Something seems to have happened to the life support system , Dave.
gui if need be). It seems to me, that until the postmaster has some
kind of native replication, all replication efforts will be based on
external programs. As such, they should be configured externally, and
be treated as any other daemon would be.
Alex
--
[EMAIL PROTECTED]
Alex J. Avriette, U
nobody actually come to a conclusion on what that "last msec" was from?
Alex
--
[EMAIL PROTECTED]
Alex J. Avriette, Unix Systems Gladiator
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.pos
601 - 654 of 654 matches
Mail list logo
