On Fri, 24 Jan 2003, Olleg Samoylov wrote:
> On 23 Jan 2003, Rod Taylor wrote:
> Nope. CURRENT_USER and SESSION_USER return username. Sometimes need uid,
> it's key usesysid in table pg_shadow, for instance, for row based
> permissions. Explain in example:
>
> create table role {
>role smalli
On Wednesday 29 Jan 2003 3:34 am, you wrote:
> I wrote:
> The reason this was done was to avoid the need to do catalog lookups
> when restoring a prior setting during error recovery. That's still a
> valid concern, so right offhand I don't see an easy fix. Any ideas?
Document it as a bug and rec
On Thu, 23 Jan 2003, David Kennedy wrote:
> This weekend I will be building a couple of new postgres database servers
> under RH7.3, and I am currently deciding between 2 different configuration
> options. The new servers feature hot-swappable RAID w/ 3 hard drives in
> each.
It depends on what y
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
I wanted to update everyone on what I am doing. Things went very well
last week at the training class in Atlanta. We had 13 people, and the
Big Nerd Ranch ran a first-class event, very well organized. The
classes went smoothly and everyone got a lot out of it.
I am heading to Tokyo in 9 hours,
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 to
> - Original Message -
Bruce Momjian replied
> > Are there no already-written converters from Makefile to VC project
> > files?
The only ones I've seen convert from Unix make files to Windows NMAKE
make files. This does not really do everything you want for several
reasons:
1) Building w
On Sat, Jan 25, 2003 at 09:55:25PM -0500, Bruce Momjian wrote:
> Lamar Owen wrote:
> > We'll see how it pans out, I guess.
> >
> > Red Hat certainly thought it was worth spending some time on; reference their
> > back porting of the fixes to versions as old as 6.5.3.
>
> If we can get them all,
>> After some looking, it appears the culprit is
>> assign_session_authorization() in commands/variable.c, which is assuming
>> that a numeric-looking parameter string should be taken as a numeric
>> user sysid, rather than an actual user name.
>>
>> The reason this was done was to avoid the need
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
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!
---
On 23 Jan 2003, Rod Taylor wrote:
RT>On 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 instan
Hello all,
I realise this is a little off-topic, however I have been unable to find a
more
suitable newsgroup aside from linux.postgres which is basically dead.
This weekend I will be building a couple of new postgres database servers
under RH7.3, and I am currently deciding between 2 different c
I'm about to start implemention streaming of queries to the server in the
pgsql jdbc drivers when PreparedStatement is used with setBinaryStream...
but before I get started, since I've never contributed before, I wanted to
run it by everyone.
I'm planning on making the following changes:
1. In Qu
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 offer
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 d
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
http:
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
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.
> >
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
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 "123
[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
>
"Nigel J. Andrews" <[EMAIL PROTECTED]> writes:
> How about throwing an error if an all digit user name is given to create
> user as already alluded to?
I do *not* want to do that; that's creating a user-visible restriction
for the convenience of one very small part of the implementation. I
think
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
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
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 Me
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:[EMAI
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 fo
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
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"
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
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
>
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| h
> "Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> > I just noticed you can do this:
> > create table blah (
> > a not null references test on delete set null
> > )
>
> > Should that be prevented?
>
> It already does. Or did you mean disallow the declaration? I can't see
> anything in
On Wednesday 22 January 2003 11:49, Hannu Krosing wrote:
> On Wed, 2003-01-22 at 15:34, Curtis Faith wrote:
> > tom lane writes:
> > > You think we should drive away our existing unix developers
> > > in the mere hope of attracting windows developers? Sorry, it
> > > isn't going to happen.
> >
> >
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 te
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
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 fo
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=3382&release_id=115190
It's part of the Linux Test Project and only supports Linux, but it
l
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 Fo
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 s
41 matches
Mail list logo
