Has this been resolved and patched?
---
Tom Lane wrote:
> "Zeugswetter Andreas SB SD" <[EMAIL PROTECTED]> writes:
> > Tom Lane <[EMAIL PROTECTED]> writes:
> >> Michael seems to feel that the tuple count should be nonzero if
I've just committed changes to include an SQL99 feature list as an
appendix in the User's Guide. While preparing that I noticed a feature
or two which would be trivial to implement, so we now have LOCALTIME and
LOCALTIMESTAMP function calls per spec (afaict; the spec is very vague
on the behaviors
On Thu, 2002-06-13 at 16:39, Chris McCormick wrote:
...
> THE BACKGROUND - I am creating a web site where people can study the
> humanities. They can upload, discuss, and peer-review information.
> They can also create, edit, approve, and delete records in a postgresql
> db, using web forms.
Tom Lane wrote:
> There are various paths of control in md5_crypt_verify that do
>
> if (passwd)
> pfree(passwd);
> if (valuntil)
> pfree(valuntil);
>
> Isn't this now pfree'ing part of the saved pre-parsed pg_pwd data?
Oop
On Fri, 14 Jun 2002, Mike Mascari wrote:
> That is what I want to do, except by extending the grammar. I must admit
> to actually being surprised that a TEMP table created inside a
> transaction lived after the transaction completed. That's when I looked
> at the standard and saw that PostgreSQL'
> > I think that when SERIAL is used, the sequence should be tied
> > inextricably to the table which created it, and it should be
hidden from
> > use for other purposes (perhaps similar to the way a toast table
is). If
> > you *want* to use a sequence across several tables, then you don't
use
> >
On Thu, Jun 13, 2002 at 11:39:55 -0400,
Chris McCormick <[EMAIL PROTECTED]> wrote:
> Thanks for reading. A few disclaimers:
>
> MY PROBLEM - Because this site deals with, among other things, ancient
> art, acheaology, and anthropology, I need a way to handle dates as
> specific as a single d
Matthew Tedder wrote:
>Question:
>
>How feasible would it be to create this functionality in PostgreSQL:
>
>One creates a test version of a database that initially consists of
>read-links to the production version of the same database. Any code he/she
>then writes that reads from a table r
Bruce Momjian wrote:
>
> Tom Lane wrote:
> > Mike Mascari <[EMAIL PROTECTED]> writes:
> > > ... Would it be possible to have either a GUC setting or a grammar
> > > change to allow TEMPORARY tables to be dropped at transaction commit?
> >
> > This seems like a not unreasonable idea; but the lack
Thanks for reading. A few disclaimers:
1. I am a newbie. I program for a living, but my work in pg has so far
been at the "devoted hobby level," using pg and PHP. For an example of
what I have done with pg, you can visit www.the-athenaeum.org, a site I
one day hope to make into a business.
I have just tested this on the latest code using the following
Connection con = JDBC2Tests.openDB();
try
{
// transaction mode
con.setAutoCommit(false);
Statement stmt = con.createStatement();
stmt.execute("select 1/0");
Tom Lane wrote:
David Ford <[EMAIL PROTECTED]> writes:
Tom, if you block everyone on cable, dialup, dsl, and adsl, then you're probably blocking a lot of legitimate mail.
David, let me explain this in words of one syllable: I am currently
rejecting upwards of 2000 spam m
Question:
How feasible would it be to create this functionality in PostgreSQL:
One creates a test version of a database that initially consists of
read-links to the production version of the same database. Any code he/she
then writes that reads from a table reads from the production data
There are various paths of control in md5_crypt_verify that do
if (passwd)
pfree(passwd);
if (valuntil)
pfree(valuntil);
Isn't this now pfree'ing part of the saved pre-parsed pg_pwd data?
reg
Tom, Bruce,
Back in 7.1.0, we had a problem where no index could be used on ORDER
BY ... DESC statements. Has this been fixed? I'm writing an article
on indexing.
-Josh Berkus
---(end of broadcast)---
TIP 6: Have you searched our list archives?
Tom Lane wrote:
> Mike Mascari <[EMAIL PROTECTED]> writes:
> > ... Would it be possible to have either a GUC setting or a grammar
> > change to allow TEMPORARY tables to be dropped at transaction commit?
>
> This seems like a not unreasonable idea; but the lack of other responses
> suggests that
Thomas,
> So, a question: should I list all features in the same table, with
> the
> comment field indicating if something is not (yet) supported, or
> should
> I split the features into two tables for supported and unsupported
> features? The former keeps all of the information together if someo
As you probably know, SQL99 has dropped the rather useless
categorizations of "basic", "intermediate", and "advanced" SQL
compliance and instead lists a large number of labeled features. I've
put these into an appendix for the docs (not yet committed to cvs).
The list is organized as a (for now)
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]]
> Sent: 14 June 2002 14:49
> To: Dave Page
> Cc: PostgreSQL-development
> Subject: Re: [HACKERS] Language Comments
>
>
> "Dave Page" <[EMAIL PROTECTED]> writes:
> > What is the preferred method (if there even is one) fo
David Ford <[EMAIL PROTECTED]> writes:
> Which btw has a curious grant/revoke bug. create foo; grant select on
> foo to bar; results in all rights being granted. You must revoke and
> grant again in order to get the correct rights set.
I see no bug.
test72=# select version();
"Dave Page" <[EMAIL PROTECTED]> writes:
> What is the preferred method (if there even is one) for modifying the
> comment on a language?
There isn't one. Certainly LANCOMPILER was *never* meant as a place to
store comments.
I suppose a COMMENT ON LANGUAGE facility could be added, but I can't g
pg_auth=# select version();
version
PostgreSQL 7.2 on i686-pc-linux-gnu, compiled by GCC 3.0.2
Which btw has a curious grant/revoke bug. create foo; grant select on
foo to bar; resu
What is the preferred method (if there even is one) for modifying the
comment on a language?
I vaguely remember it being documented that it was stored in
pg_language.lancompiler and specified using the LANCOMPILER option to
CREATE LANGUAGE or by updating the record directly. pgAdmin has done it
On Thu, 13 Jun 2002, Mike Mascari wrote:
>
> CREATE TEMPORARY TABLE
> ...
> ON COMMIT DROP;
>
> pseudo-compatible with the SQL-standard of:
>
> ON COMMIT { DELETE | PRESERVE } ROWS;
>
> so one day PostgreSQL's grammar would look like:
>
> ...
> ON COMMIT { DROP | { DELETE | PRESERVE } ROWS
On Fri, 2002-06-14 at 02:10, David Ford wrote:
> ... while talking to sss.pgh.pa.us.:
>
> >> MAIL From:<[EMAIL PROTECTED]>
> >>>
> >>>
> <<< 550 5.7.1 Probable spam from 68.9.71.221 refused - see
>http://www.five-ten-sg.com/blackhole.php?68.9.71.221
> 554 5.0.0 Service unavailable
>
>
25 matches
Mail list logo