Bruce Momjian wrote:
I just checked and pg_dump -d _doesn't_ place the INSERT's in a
transsaction. Seems it should, and perhaps add a:
SET autocommit TO 'on'
as well. Of course, that SET would fail when restoring to prior
releases, but they don't have autocommit off anyway so it
Hi all,
I had this with me to submit as a bug report for a misleading error message. Is
this the place I send this or I need to send it to someplace else?
Shridhar
--- Forwarded message follows ---
Date sent: Thu, 26 Dec 2002 12:39:59 +0530
From: Rajesh
Hi everyone,
Just came across a reference to a new Open Source database test suite by
IBM that supports DB2, Oracle, Sybase, PostgreSQL, and MySQL:
http://sourceforge.net/project/showfiles.php?group_id=3382release_id=115190
It's part of the Linux Test Project and only supports Linux, but it
On Mon, Jan 27, 2003 at 21:23:01 -0800,
Stephan Szabo [EMAIL PROTECTED] wrote:
On Tue, 28 Jan 2003, Christopher Kings-Lynne wrote:
I just noticed you can do this:
create table blah (
a not null references test on delete set null
)
Should that be prevented? It shouldn't be
On Tue, 28 Jan 2003, Bruno Wolff III wrote:
On Mon, Jan 27, 2003 at 21:23:01 -0800,
Stephan Szabo [EMAIL PROTECTED] wrote:
On Tue, 28 Jan 2003, Christopher Kings-Lynne wrote:
I just noticed you can do this:
create table blah (
a not null references test on delete set null
Bruce Momjian [EMAIL PROTECTED] writes:
I just checked and pg_dump -d _doesn't_ place the INSERT's in a
transsaction. Seems it should,
I think this is a bad idea. If one were after speed, one would have
used the COPY format in the first place. If one uses INSERTs, there
may be a reason for
I just completed a replication talk for the Japanese PostgreSQL Users
Group. Can folks eyeball it in the next few hours and let me know if
there are any improvements to be made?
ftp://candle.pha.pa.us/pub/postgresql/replication.pdf
Thanks.
--
Bruce Momjian|
Sailesh Krishnamurthy writes:
sailesh:datafix~/work/postgres/doc/src/sgml: gmake admin.html
/usr/bin/perl /usr/share/sgml/docbook//bin/collateindex.pl -f -g -t 'Index' -o
bookindex.sgml -N
Can't open perl script /usr/share/sgml/docbook//bin/collateindex.pl: No such file
or directory
gmake:
1. the following query is so slow, after 12 hours,
I kill it -
delete from doc where cdi in (select cdi from doc_b1);
doc_b1 records = 4
doc records = 500
cdi are indexed in both table.
2. I rewrite the above task in plpgsql, it
takes 10 secs to finish.
why psql subquery is not smarter
I'm looking for people who want to join OLE DB Provider project. It is
partially finished. I'm looking for people who want to help.
--
Marek Mosiewicz [EMAIL PROTECTED]
***r-e-k-l-a-m-a**
Chcesz oszczedzic na kosztach obslugi bankowej ?
mBIZNES - konto dla firm
Bruce Momjian writes:
Due to my error, log_min_error messages went into 7.3.X with the wrong
default, and the wrong listed options.
This fixes the bug in CVS current and 7.3.X. Patch attached.
Why does panic mean off? If you set it to panic don't you still get
the panic messages? I'm sure
Peter Eisentraut wrote:
Bruce Momjian writes:
Due to my error, log_min_error messages went into 7.3.X with the wrong
default, and the wrong listed options.
This fixes the bug in CVS current and 7.3.X. Patch attached.
Why does panic mean off? If you set it to panic don't you still
Dave Cramer says it is needed for the jdbc spec, somehow. It seems kind
of odd so I don't want to make too complex an implementation.
---
Peter Eisentraut wrote:
Bruce Momjian writes:
My idea on this after chat with
Bruce Momjian writes:
My idea on this after chat with Dave was to add a GUC option that puts
the schema.table.column name as the default column label, rather than
just the column name.
Can someone explain why this is needed at all? There is a reason why the
SQL standard does not provide for
Could someone point me to this standard? Is that the standard for SQL
syntax? I wasn't aware there was a standard for RDBMS functionality. I
always assumed the features provided by the RDBMS were up to the
implementers.
Reggie
-Original Message-
From: Peter Eisentraut [mailto:[EMAIL
What is needed, at least from my perspective, is a way to determine
proper meta data for a given column. Is it updatable? Is it nullable?
Is it part of a primary key or index? Without either the base table
name or attrelid,indrelid of the table, I can't get this info.
Reggie
-Original
I wrote:
Michiel Lange [EMAIL PROTECTED] writes:
It is, somehow, not possible to connect as a user which name is completely
numeric.
I muttered nonsense! to myself, but darned if you're not right:
regression=# create user 12345;
CREATE USER
regression=# \q
$ psql -U 12345 regression
Bruce Momjian [EMAIL PROTECTED] writes:
Dave Cramer says it is needed for the jdbc spec, somehow.
Does the JDBC spec really require the database to provide functionality
that's not in the SQL spec? I kinda doubt that.
regards, tom lane
---(end
[EMAIL PROTECTED] (Peter Eisentraut - PostgreSQL) writes:
The code that checks for the 64-bit int type now gives more reasonable
results when cross-compiling: In that case we just take the compiler's
information and trust that the arithmetic works. Disabling int64 is too
On Tue, 28 Jan 2003, Tom Lane wrote:
I wrote:
Michiel Lange [EMAIL PROTECTED] writes:
It is, somehow, not possible to connect as a user which name is completely
numeric.
I muttered nonsense! to myself, but darned if you're not right:
regression=# create user 12345;
CREATE USER
The method in question is
ResultSetMetaDate.getTableName(int column)
and while were at it
ResultSetMetaData.getSchemaName(int column)
and FWIW, the return value if not applicable is
Dave
On Tue, 2003-01-28 at 17:21, Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Dave Cramer says
On Tue, 28 Jan 2003, Bruce Momjian wrote:
Peter Eisentraut wrote:
Bruce Momjian writes:
Due to my error, log_min_error messages went into 7.3.X with the wrong
default, and the wrong listed options.
This fixes the bug in CVS current and 7.3.X. Patch attached.
Why does panic
Here is Vixie's original comments on integrating Bind for IPv6. We
still need to make those customizations of display that we agreed to for
IPv4.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard
Curtis Faith wrote:
Hannu Krosing asked:
Does anyone know how MySQL and interbase/firebird do it ?
From the MySQL web site for version 4.0:
The Windows binaries use the Cygwin library. Source code for the
version of Cygwin we have used is available on this page.
I think this offers a very
On 23 Jan 2003, Rod Taylor wrote:
RTOn Wed, 2003-01-22 at 08:09, Olleg Samoylov wrote:
RT Hi!
RT
RT What about adding new function:
RT pg_uid()
RT pg_session_uid()
RT
RT as reference to internal function GetUserId() and GetSessionUserId().
RT
RT These can help useful, for instance in row based
On Mon, Jan 27, 2003 at 10:26:53AM -0500, Tom Lane wrote:
The preproc code doesn't need to be thread-safe does it?
You're right of cause.
Michael
--
Michael Meskes
Email: [EMAIL PROTECTED]
ICQ: 179140304
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!
I've trimmed this query down as much as possible (started out much
larger), it no longer causes the error.
PREPARE pg_psql_dd2(text,text) AS
SELECT true
FROM (
SELECT true
FROM pg_catalog.pg_proc p,
pg_catalog.pg_name_pattern( $2 ) AS (schpat text, propat text)
WHERE p.prorettype
So currently the only way to specify a row type is by using a table,
right? E.g.:
CREATE TABLE t2_retval (
value1 int NOT NULL DEFAULT -1,
value2 int NOT NULL,
value3 int
);
Are there plans to add another way of declaring this sort of thing so
that I don't have
On Mon, 2003-01-27 at 10:44, Reggie Burnett wrote:
Well, certainly the driver could parse the sql and extract what it
thinks is the table name. It just seems quite foreign to me to have a
database engine go through the motions of determining column location
and have ready access to all the
29 matches
Mail list logo
