I'm moving this to GENERAL. Whomsoever replies there please delete the
pgsql-hackers cc entry.
On Thu, 5 Jun 2003, Rasmus Resen Amossen wrote:
> Does Postgres garantee repeatable-read (RR) during transactions? And does it
> implement ARIES/KVL?
>
> If so, why is the following possible?
>
> T
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > That is one thing I liked about the initdb mention --- it clearly told
> > them to watch out for something they might not have been looking for.
>
> Only if they read the message, though. People who are running RPM
> installations pr
I wrote:
> Now I finally understand why the spec has all that strange verbiage
> about outer references in set-function arguments. This is the case
> they're talking about. (I don't much like their restriction to a single
> outer reference ... seems like it would be appropriate to allow multiple
>
(moving to HACKERS)
Bruno Wolff III wrote:
The CVS server seems to be working again, but logging in with an empty
password doesn't work. The web interface to anonymous CVS doesn't
work either.
[EMAIL PROTECTED] bruno]$ cvs -d :pserver:[EMAIL PROTECTED]:/projects/cvsroot login
(Logging in to [EMAIL
Tom Lane wrote:
Bruce Momjian <[EMAIL PROTECTED]> writes:
When we considered outervar1 as a constant, we could do the aggregate in
the subquery using computations, but when SUM(outervar1) is computed in
an above query, combining that with anything that is part of different
query level makes no sens
Jan Wieck <[EMAIL PROTECTED]> writes:
> What is SUM(up1levelvar + up2levelsvar) considered to be? Would that be
> the same as SUM(localvar + outervar) one level up?
Exactly. The spec says that SUM(up1levelvar) is the same as
SUM(localvar) one level up, so this seems a natural generalization.
It
On Thursday 05 June 2003 16:08, Andrew Overholt wrote:
> Darko Prenosil once said:
> > I have noticed that after "/etc/init.d/postgresql restart", postmaster is
> > no longer writes to "serverlog". (RedHat 9).
> > Here is fixed "restart" section.
> >
> > restart)
> > echo -n "Restarting Postgre
On Wed, Jun 04, 2003 at 11:05:03PM -0400, Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > That is one thing I liked about the initdb mention --- it clearly told
> > them to watch out for something they might not have been looking for.
>
> Only if they read the message, though. Peo
> T1: begin;
> T1: select * from table;
>(notice the row with id = X)
> T2: begin;
> T2: delete from table where id = X;
> T1: select * from table;
>(notice the row with id = X suddenly is gone)
You'll need to SELECT ... FOR UPDATE to lock the row, or use the
SERIALIZABLE transaction more
On Thu, 5 Jun 2003, Rasmus Resen Amossen wrote:
> Does Postgres garantee repeatable-read (RR) during transactions? And does it
> implement ARIES/KVL?
>
> If so, why is the following possible?
>
> T1: begin;
> T1: select * from table;
>(notice the row with id = X)
> T2: begin;
> T2: delete fro
On Wed, 4 Jun 2003, Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > That is one thing I liked about the initdb mention --- it clearly told
> > them to watch out for something they might not have been looking for.
>
> Only if they read the message, though. People who are running R
Does Postgres garantee repeatable-read (RR) during transactions? And does it
implement ARIES/KVL?
If so, why is the following possible?
T1: begin;
T1: select * from table;
(notice the row with id = X)
T2: begin;
T2: delete from table where id = X;
T1: select * from table;
(notice the row wit
Wow, a subselect in HAVING. Where do they think up these things. :-)
Yes, it would be nice to support it, though I am not surprised no one
has asked for this feature yet. :-)
---
Tom Lane wrote:
> Some of the Red Hat guy
Tom Lane wrote:
Some of the Red Hat guys have been trying to work through the NIST SQL
compliance tests. So far they've found several things we already knew
about, and one we didn't:
-- TEST:0434 GROUP BY with HAVING EXISTS-correlated set function!
SELECT PNUM, SUM(HOURS) FROM WORKS
G
> Which ones are missing, and should we really be looking at creating a
> pg_definition_schema instead?
Missing:
Database, schema, table, domain, cast, conversion, function...
Maybe a definition schema might be better.dunno...it would need to use
the pg_get_*def functions anyway methinks.
C
Bruce Momjian <[EMAIL PROTECTED]> writes:
> That is one thing I liked about the initdb mention --- it clearly told
> them to watch out for something they might not have been looking for.
Only if they read the message, though. People who are running RPM
installations probably never get to see what
Hello:
> Sounds like you are sending junk following the Parse message.
You are right thanks very much, but now i have another problem, i don't
get response from the postgresql server, hummm this is what i'm sending
for test:
Byte1 ('P')
Int32 (40)
String ('')
String ('SELECT
Carlos Guzman Alvarez <[EMAIL PROTECTED]> writes:
> You are right thanks very much, but now i have another problem, i don't
> get response from the postgresql server, hummm this is what i'm sending
> for test:
Your Parse message looks fine, but the server will not actually send its
ParseComplete
Some of the Red Hat guys have been trying to work through the NIST SQL
compliance tests. So far they've found several things we already knew
about, and one we didn't:
-- TEST:0434 GROUP BY with HAVING EXISTS-correlated set function!
SELECT PNUM, SUM(HOURS) FROM WORKS
GROUP BY PNUM
Added to TODO.
---
Rod Taylor wrote:
-- Start of PGP signed section.
> Bruce, the TODO list should probably link the SQL99 unsupported feature
> list as a source of more items.
>
> http://developer.postgresql.org/docs/postg
Hello:
Your Parse message looks fine, but the server will not actually send its
ParseComplete response until you send a Sync or Flush message. The idea
is that Parse is usually going to be part of a series of operations, and
you don't want a separate network packet coming back for each operation
Peter Eisentraut wrote:
> Bruce Momjian writes:
>
> > Peter, I assume SET CONSTRAINTS can't control a domain's constraints ---
> > it isn't actually a data object in the transaction. Am I right?
>
> No. SET CONSTRAINTS on a domain constraint should affect all constraints
> on columns that use t
Peter Eisentraut wrote:
> Bruce Momjian writes:
>
> > How are people going to know to use these special LIKE indexes?
>
> The same way they presumably find out about anything else: RTFM. A couple
> of more cross-references and index entries need to be added, though.
Well, this isn't one of thos
Tommi Maekitalo wrote:
Hi,
There was a german article in heise news. See
http://www.heise.de/newsticker/data/hps-23.05.03-000/.
MySQL gets stored procedures and transactions and all the nice features, you
need for a real database (and postgresql already has) by throwing the code
away an replac
On Wed, 2003-06-04 at 14:55, Christopher Browne wrote:
> Rod Taylor wrote:
> > Note the first timezone change is taken, but the second one is ignored.
> > rbt=3D# set time zone est;
> > SET
> > rbt=3D# select * from t;
> > col
> >
> > 2003-06-03 18:30:25+00
> > (
Hello:
> Sounds like you are sending junk following the Parse message.
You are right thanks very much, but now i have another problem, i don't
get response from the postgresql server, hummm this is what i'm sending
for test:
Byte1 ('P')
Int32 (40)
String ('')
String ('SELECT
Rod Taylor <[EMAIL PROTECTED]> writes:
> Note the first timezone change is taken, but the second one is ignored.
Neither of them are being taken, I think. In CVS tip I get
ERROR: unrecognized timezone name "udt"
ERROR: unrecognized timezone name "est"
but until recently we made
Bruce Momjian wrote:
You are going to love the answer to this question --- it already does
compression of any long fields when it is stored in the TOAST table.
Well, sort of. The compression algorithm is extremely poor compared to
anything Christopher mentioned. It was choosen because it's free (n
Note the first timezone change is taken, but the second one is ignored.
rbt=# select * from t;
col
2003-06-03 14:30:25-04
(1 row)
rbt=# set time zone udt;
SET
rbt=# select * from t;
col
2003-06-03 18:30:25+00
(1 row)
rbt=#
29 matches
Mail list logo