Oliver Jowett wrote:
> This is not true if you happen to be using Java on the client side,
> which has no idea (unless you grot around in the guts of the JVM) what
> the native byte order is.
>
The method java.nio.ByteOrder.nativeOrder() will tell you what the
native byte order is.
> This actuall
On Tue, Jul 27, 2004 at 12:42:51AM -0300, Marc G. Fournier wrote:
> # Tabstop used to expand tabs in colored diffs. If undefined then
> # tabs are always expanded to 8 spaces.
> #
> $tabstop = 4;
Apparently the plain files (as opposed to diffs) do not honour this
setting. At least I still see on
On Tue, 27 Jul 2004, Marc G. Fournier wrote:
'k, if someone knows how to fix this, I'm all ears ... the OS conf file
examples all have the following set (with PostgreSQL switched for the OS):
$ENV{'RCSLOCALID'} = 'PostgreSQL=Id';
Since I'm not sure example where in cvsweb you guys are looking, ca
> How do you then audit a TRUNCATE performed by somebody else (who, for
> "political" reasons, has superuser access)? Such actions aren't limited to
> attacks - but may simply be the result of "I thought it was a good idea at
> the time". :-(
Easily enough, have the logs record the pid, connecti
On Mon, 26 Jul 2004, Alvaro Herrera wrote:
On Mon, Jul 26, 2004 at 01:00:43PM -0300, Marc G. Fournier wrote:
just upgraded to 3.0.1 ... it has a neat 'graphing' function:
http://developer.postgresql.org/cvsweb.cgi/pgsql-server/COPYRIGHT?graph=1
but, I seem to have lost the colors the old on
G'day folks,
Tom Lane wrote:
> Daniel Baldoni <[EMAIL PROTECTED]> writes:
>> Forgive this if it's totally "out there" but I was wondering why
>> there's no support for triggers on a TRUNCATE operation.
>
> Because the entire point of TRUNCATE is not to scan the table contents.
>
> If you want to
Hannu Krosing <[EMAIL PROTECTED]> writes:
> Btw, does the right to TRUNCATE come with GRANT DELETE, or must one be a
> superuser to TRUNCATE ?
You have to own the table (or be superuser of course). This implies the
right to drop its triggers, so TRUNCATE could be seen as dropping
triggers, DELETE
> Looks good ... I wonder if it can be configured to show tabs as 4
> spaces, to match Postgres current practice? Also, as Tom already
> pointed out, the $PostgreSQL$ header is not honored.
I bet you the $PostgreSQL$ header can be configured into it -- it seems
to accommodate $FreeBSD$ and other
> [EMAIL PROTECTED] writes:
>> Lastly, the vast majority of machines in use today are intel. Meaning
>> that
>> they are small endian. Except in a very rare circumstance, two machines
>> that would normally be able to communicate in native byte order, will
>> ALWAYS have to convert data.
>
> Quite
On Mon, Jul 26, 2004 at 01:00:43PM -0300, Marc G. Fournier wrote:
> just upgraded to 3.0.1 ... it has a neat 'graphing' function:
>
> http://developer.postgresql.org/cvsweb.cgi/pgsql-server/COPYRIGHT?graph=1
>
> but, I seem to have lost the colors the old one had in the process :(
> Anyon
Patrick Welche wrote:
Is there more to "remote control" than setting GUC variables? Tell me more!
Sure:
+ starting/restarting/stopping the database server software
+ the normal DBA type work - creating/altering/dropping databases,
users, functions, languages, permissions (etc)
+ Remote backup
On E, 2004-07-26 at 17:59, Tom Lane wrote:
> Daniel Baldoni <[EMAIL PROTECTED]> writes:
> > Forgive this if it's totally "out there" but I was wondering why there's no
> > support for triggers on a TRUNCATE operation.
>
> Because the entire point of TRUNCATE is not to scan the table contents.
May
Gaetano Mendola <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
> | It shouldn't work --- the ALTER TABLE code should reject it. Looks like
> | there are a few holes to be plugged here ...
> The SQL standard forbid it ? I was believing that was a pretty cool feature!
> :-)
I don't think we can sup
On Mon, 26 Jul 2004 16:32:33 -0700 (PDT), Stephan Szabo
<[EMAIL PROTECTED]> wrote:
> On Tue, 27 Jul 2004, Ian Barwick wrote:
>
> > Apologies if this has been covered previously.
> >
> > Given a statement like this:
> > SELECT * FROM foo WHERE id IN (SELECT id FROM bar)
> > I would expect it to f
On Tue, 27 Jul 2004 01:33:44 +0200, Andreas Joseph Krogh
<[EMAIL PROTECTED]> wrote:
> On Tuesday 27 July 2004 01:15, Ian Barwick wrote:
> > Apologies if this has been covered previously.
> >
> > Given a statement like this:
> > SELECT * FROM foo WHERE id IN (SELECT id FROM bar)
> > I would expect
On Tuesday 27 July 2004 01:15, Ian Barwick wrote:
> Apologies if this has been covered previously.
>
> Given a statement like this:
> SELECT * FROM foo WHERE id IN (SELECT id FROM bar)
> I would expect it to fail if "bar" does not have a column "id". The
> test case below (tested in 7.4.3 and 7.4
On Mon, 26 Jul 2004, Brian Hirt wrote:
> I'm working on a new machine, and i think it's got possible bad
> hardware, since that seems more likely than a bug in postgresql. I'm
> wondering if someone has any idea what kind of hardware failure might
> cause this message:
>
> WARNING: buffer refcou
On Tue, 27 Jul 2004, Ian Barwick wrote:
> Apologies if this has been covered previously.
>
> Given a statement like this:
> SELECT * FROM foo WHERE id IN (SELECT id FROM bar)
> I would expect it to fail if "bar" does not have a column "id". The
> test case below (tested in 7.4.3 and 7.4.1) shows
Apologies if this has been covered previously.
Given a statement like this:
SELECT * FROM foo WHERE id IN (SELECT id FROM bar)
I would expect it to fail if "bar" does not have a column "id". The
test case below (tested in 7.4.3 and 7.4.1) shows this statement
will however appear succeed, but pro
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
| Greg Stark <[EMAIL PROTECTED]> writes:
|
|>Gaetano Mendola <[EMAIL PROTECTED]> writes:
|>
|>>kalman=# insert into test values (1 ,(2,(3,(4,(5,(6, null));
|>>INSERT 33639 1
|>>kalman=# select * from test;
|>>~ a |
Brian Hirt <[EMAIL PROTECTED]> writes:
> I'm working on a new machine, and i think it's got possible bad
> hardware, since that seems more likely than a bug in postgresql. I'm
> wondering if someone has any idea what kind of hardware failure might
> cause this message:
> WARNING: buffer refc
[EMAIL PROTECTED] wrote:
The only use case network byte order fixes is a BINARY COPY between
different machine types, but in doing that, it forces anyone trying to add
value to postgresql or create a utility that uses COPY to reimplement all
the data type handlers outside of the database, even if t
Greg Stark <[EMAIL PROTECTED]> writes:
> Gaetano Mendola <[EMAIL PROTECTED]> writes:
>> kalman=# insert into test values (1 ,(2,(3,(4,(5,(6, null));
>> INSERT 33639 1
>> kalman=# select * from test;
>> ~ a | b
>> ---+
On Mon, 2004-07-26 at 19:10, Marc G. Fournier wrote:
> On Mon, 26 Jul 2004, Simon Riggs wrote:
>
> > On Mon, 2004-07-26 at 16:34, Marc G. Fournier wrote:
> >> Working on it ... it was a *really* old version, and from pgfoundry, I
> >> imagine it has some issues with the newer CVS ... will post onc
Gaetano Mendola <[EMAIL PROTECTED]> writes:
> kalman=# insert into test values (1 ,(2,(3,(4,(5,(6, null));
> INSERT 33639 1
> kalman=# select * from test;
> ~ a | b
> ---+
> ~ 1 | (2,"(3,""(4,(5,(6,)
I'm working on a new machine, and i think it's got possible bad
hardware, since that seems more likely than a bug in postgresql. I'm
wondering if someone has any idea what kind of hardware failure might
cause this message:
WARNING: buffer refcount leak: [424] (freeNext=425, freePrev=423,
re
[EMAIL PROTECTED] writes:
> Lastly, the vast majority of machines in use today are intel. Meaning that
> they are small endian. Except in a very rare circumstance, two machines
> that would normally be able to communicate in native byte order, will
> ALWAYS have to convert data.
Quite honestly, th
On Mon, 26 Jul 2004, Simon Riggs wrote:
On Mon, 2004-07-26 at 16:34, Marc G. Fournier wrote:
Working on it ... it was a *really* old version, and from pgfoundry, I
imagine it has some issues with the newer CVS ... will post once I have a
new one in place that appears to work ...
On Mon, 26 Jul 2004
OK, I wrote a utility for 7.3 that takes the output of a select command in
a Binary cursor and creates a binary "COPY" file.
The premise of the utility is to take the results of two or more selects
from external databases and create a single unified table.
Here are the issues:
In 7.3, COPY BINAR
On Mon, 2004-07-26 at 16:34, Marc G. Fournier wrote:
> Working on it ... it was a *really* old version, and from pgfoundry, I
> imagine it has some issues with the newer CVS ... will post once I have a
> new one in place that appears to work ...
>
>
> On Mon, 26 Jul 2004, Tom Lane wrote:
>
> >
just upgraded to 3.0.1 ... it has a neat 'graphing' function:
http://developer.postgresql.org/cvsweb.cgi/pgsql-server/COPYRIGHT?graph=1
but, I seem to have lost the colors the old one had in the process :(
Anyone used/configured cvsweb before? I can't seem to find an option to
enable the
Working on it ... it was a *really* old version, and from pgfoundry, I
imagine it has some issues with the newer CVS ... will post once I have a
new one in place that appears to work ...
On Mon, 26 Jul 2004, Tom Lane wrote:
Simon Riggs <[EMAIL PROTECTED]> writes:
Click "download" and it fails co
Daniel Baldoni <[EMAIL PROTECTED]> writes:
> Forgive this if it's totally "out there" but I was wondering why there's no
> support for triggers on a TRUNCATE operation.
Because the entire point of TRUNCATE is not to scan the table contents.
If you want to fire triggers, just use "DELETE FROM foo"
On Mon, Jul 26, 2004 at 06:13:30PM +1000, Justin Clift wrote:
> + An SNMP agent to report on PostgreSQL's status and allows remote
> control of the PostgreSQL daemon. From an Oracle perspective, this
> would be the equivalent of "Oracle Intelligent Agents", part of the core
> features of the O
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> It's bizarre how you can comment on columns in composite types!
> CREATE TYPE test (a int4, b int4);
> COMMENT ON COLUMN test.a IS 'A column';
And not only that, but:
regression=# \d+ test
Composite type "public.test"
Column | Type | Desc
"Scott Marlowe" <[EMAIL PROTECTED]> writes:
> On Sun, 2004-07-25 at 22:23, Tom Lane wrote:
>> I don't think
>> it's either practical or interesting to try to introduce an equivalent
>> layering into Postgres.
> I can possibly see a use for a row locking storage system, i.e. non MVCC
> for some app
Simon Riggs <[EMAIL PROTECTED]> writes:
> Click "download" and it fails consistently with the error:
Hm, you're right; I hadn't tried that lately but it does fail for me
too. Weird. I'd not have thought that "download" would make a
different request to CVS than the "revision 1.n" link does ...
b
Simon Riggs wrote:
On Mon, 2004-07-26 at 05:57, Tom Lane wrote:
Simon Riggs <[EMAIL PROTECTED]> writes:
CVS web interface has not been working for a few days. Not important
right now, but something to fix soon-ish.
It works okay for me (modulo $PostgreSQL$ issue, see other thread)
Suresh Tri wrote:
Hi all,
I am currently trying to estimate the effort required
to implement Oracle type stored procedure in
PostgreSQL. As I understood Oracle supports both
functions and procedures, but postgres only functions.
ALso there are no OUT parameter in postgres.
I got some info from
htt
> I was just looking around the net to see exactly what Oracle's PL/SQL
> syntax is. It doesn't seem too unreasonable syntax-wise:
>
> BEGIN
> ... controlled statements ...
> EXCEPTION
> WHEN exception_name THEN
> ... error handling s
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
| Gaetano Mendola <[EMAIL PROTECTED]> writes:
|
|>Tom Lane wrote:
|>| I was just looking around the net to see exactly what Oracle's PL/SQL
|>| syntax is. It doesn't seem too unreasonable syntax-wise:
|>| [ snip pl/sql syntax ]
|
|
|>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
| Gaetano Mendola <[EMAIL PROTECTED]> writes:
|
|>kalman=# create table test ( a integer, b integer );
|>CREATE TABLE
|>kalman=# create table test1 ( c integer , d test );
|>CREATE TABLE
|
|
|>kalman=# alter table test drop column b;
|>A
In 7.4.3, my workmate came across the following situation he thought was
odd.
Basically, we want to know why the group by and order by in the outer
query get their variables from the inner query and not the select
parameters in the outer query?
Ah, don't worry - I get it now :)
Chris
--
G'day folks,
Forgive this if it's totally "out there" but I was wondering why there's no
support for triggers on a TRUNCATE operation. I note that a COPY IN fires
an INSERT trigger (if defined).
The only real use I can see for a TRUNCATE trigger would be for automatic
audit trail generation - I
Thanks Peter for your reply,
we will investigate further into your comments. We
understand that postgresql is already
enterprise-level. But as our observation many of the
propriety databse users in the enterprise level are
reluctant to switch to postgresql. We wanted to to
bridge the gap.
Thanks
Suresh Tri wrote:
> All your sugestions are welcome. Please help us to
> implement these features.
> Our aim is to make postgresql enterprise level.
Hi Suresh,
From reading your post, I feel your team is approaching the goal of
making PostgreSQL "Enterprise Level" in a non-optimal way.
With the
In 7.4.3, my workmate came across the following situation he thought was
odd.
Basically, we want to know why the group by and order by in the outer
query get their variables from the inner query and not the select
parameters in the outer query?
Chris
-- shouldn't the first SELECT query perform
Hi all,
I am currently trying to estimate the effort required
to implement Oracle type stored procedure in
PostgreSQL. As I understood Oracle supports both
functions and procedures, but postgres only functions.
ALso there are no OUT parameter in postgres.
I got some info from
http://www.compiere.
Suresh Tri wrote:
> 2. Core functionality add-ons to postgresql :-
> -Table joins
Already done.
> -Java stored procedures
Already done.
> -Backup and recovery (incremental backup/restore)
Will appear in next release.
> -Query optimization
> * Indexing techniques
> * Star query optimizatio
On Mon, 2004-07-26 at 05:57, Tom Lane wrote:
> Simon Riggs <[EMAIL PROTECTED]> writes:
> > CVS web interface has not been working for a few days. Not important
> > right now, but something to fix soon-ish.
>
> It works okay for me (modulo $PostgreSQL$ issue, see other thread).
> What URL are you
Hi,
I am already a member of hackers group and I get all
the messages posted to the group. In fact I get 2
copies of each!! I think I subscribed twice. But I am
unable to send messages to the group.
Here are the feature list which we are planning to
implement. This list is obtained by comparing t
51 matches
Mail list logo
