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;
ALTER TABLE --- Here I think the server shall complain about
Yeah,
Barry S [EMAIL PROTECTED] writes:
* The table contains one index: P1_NRN_ROAD_V (v, sobjid) (The index
includes the column sobjid because the query projects this col, and its
inclusion in the index allows it to be serviced without accessing the
underlying table)
(Unlike Oracle) Postgres
Alvaro Herrera [EMAIL PROTECTED] writes:
On Mon, Jul 26, 2004 at 02:22:21AM +0200, Gaetano Mendola wrote:
In the release not I can read:
This allows columns to contain arbitrary composite types
like rows from other tables. [SNIPPED]
Wasn't this alread true on 7.4 ?
No, this is a new
CREATE TYPE test (a int4, b int4);
COMMENT ON COLUMN test.a IS 'A column';
Seems harmless, but should we allow it?
Actually, currently it's bad because such comments will not be dumped by
pg_dump. Shall I fix pg_dump?
Chris
---(end of
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
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 visiting
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 optimization
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
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
Suresh Tri wrote:
snip
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
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.
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
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
-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;
|ALTER
-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 ]
|
|
|Is
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
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
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).
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 ...
but those
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 applications.
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 |
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 Oracle
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.
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
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
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:
Simon
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 BINARY
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
[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, that
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,
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,)
(1 row)
Omg.
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 once I have
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
---+
~ 1 |
[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
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 refcount
-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 | b
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
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 this
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 refcount
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.1) shows
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 it to fail
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 fail if bar
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 support
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.
Maybe he was
Patrick Welche wrote:
snip
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
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 :(
Anyone
[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,
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
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,
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 fire
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
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, connection
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,
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 one
54 matches
Mail list logo
