On Mon, Dec 07, 2009 at 10:49:13AM +, Dave Page wrote:
> On behalf of the core team, I'm pleased to announce that the
>
> Congratulations!
>
+1 Congrats to you all, and thanks for the contributions, both past and
future.
As an aside, this sort of thing is one of the best signs to an external
On Fri, Mar 16, 2001 at 10:17:33AM -0800, Barry Lind wrote:
>
> My feeling is that postgres has misinterpreted the SQL92 spec in this
> regards. But I am having problems finding an online copy of the SQL92
> spec so that I can verify.
>
> What I would expect the syntax to be is:
>
> table as
On Fri, Sep 29, 2000 at 11:41:51AM -0500, Jeff Hoffmann wrote:
> Bryan White wrote:
> >
> > I am thinking that
> > instead I will need to pipe pg_dumps output into gzip thus avoiding the
> > creation of a file of that size.
>
> sure, i do it all the time. unfortunately, i've had it happen a few
; "distinct"'...
Right, that's the error you get from doing this in 6.5.x. The original
poster has already been advised to upgrade to 7.0.2.
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
r can probably run on either of the quoted OSs. If it was run on NT,
we might be seeing the linux vs. NT effect.
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
being absolutely sure what the sequence name _is_.
In short, don't worry about it: the developer's go to a lot of trouble
to _not_ break backwards compatability, and if they must, make sure
there's a simple upgrade path.
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBR
27; sorting properly. Having a 'NaN' in there
breaks sorting however. That's a current, live bug. Could be fixed
by treating 'NaN' as a different flavor of NULL. Probably a fairly deep
change, however. Hmm, NULL in a float8 sorts to the end, regardless of
ASC or DESC,
lem, but since it's non standard SQL
anyway, writing your own sequence that uses a numeric counter gives you
potentially infinite serials.
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
On Thu, Jul 13, 2000 at 04:58:54PM -0400, Tom Lane wrote:
> Ed Loehr <[EMAIL PROTECTED]> writes:
> > Can anyone point me to a list of changes and bug-fixes *by release* for
> > 7.0.1 and 7.0.2 over 7.0?
>
> The only really accurate info is in the CVS logs. Bruce usually
> prepares a summary for
33 of Bruce's book, at:
http://www.postgresql.org/docs/aw_pgsql_book/node52.html
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
those docs have been freely
available until the standard is actually accepted. Perhaps these are
working drafts for the next version? OR someone slipped up, and forgot
to remove them when the standard was voted on? Is the voting done? Has
ANSI voted? Will Lassie find Jimmy in the well?
Ro
omething like this will get what
you want:
select adsrc from pg_class c, pg_attribute, pg_attrdef where
adrelid=c.oid and attrelid=c.oid and attnum=adnum and relname ='employee'
and attname= 'employee_id';
Oh, a hint: if you used the 'serial' type to create the id, the seq
w do I do the same in
> > PostgreSQL.
>
> In psql "\i tablename". Check out \? or the documentation for all the
> different backslash commands. You might want \z for access
> permissions as well.
Actually, it's "\d tablename". The rest is right, though.
R
Uh, I cut & pasted the transcript in two pieces to get the selects in
the same order, and messed up. The error happens _after_ connecting as
anonymous, not before.
Ross
On Wed, May 24, 2000 at 01:09:58PM -0500, Ross J. Reedstrom wrote:
>
> idas=> select count(*) from urls;
&
onymous
idas=> select count(*) from urls_p;
count
-
23
(1 row)
idas=>
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
cat my_file | sed 's/","/|||/g' | sed 's/^"//g'| sed 's/"$//g'| sed \
's/,/\,/g'| sed 's/|||/,/g' >newfile
Sort of ugly, but it should work. If you can get your other DB to dump
in a delimited format, instead of a quoted CSV
ot;sqlcrypt" (text,text ) RETURNS text AS '/usr/local/lib/sqlcrypt
.so' LANGUAGE 'C';
CREATE FUNCTION "sqlcrypt" (text ) RETURNS text AS 'select sqlcrypt($1,'''')' LA
NGUAGE 'SQL';
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL
n 8k in most tuples?
Currently, more than one tuple can be stored in a block, it's just that
any one tuple cannot be stored in more than one block: i.e. tuples cannot
span blocks, so the BLKSZ sets the maximum tuple size. Clear?
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
N
--
>
> The second instance gave me the results I wanted, but why did the first
> instance fail? If anything, I would have expected permission denied on the
> root owner. I have had the same results on other ocassions.
>
> What am I missing?
That t
This is mostly a problem for the space
recovery aspect of vacuum, since each updated or deleted tuple causes
a update/delete to the index, as space is compacted.
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Ins
variable
'file' to the lo, expecting it to be a null terminated string. I'm not sure how you're
supposed to get binary data in there. Is 'file' by any chance, the name of your file,
not the contents?
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
agree it supports your argument that "even today's SQL
systems" (I can hear their academic disdain in that, can't you?) support
an "ad hoc" form of transaction nesting, which postgresql does not.
Hmm, on further reflection, I'm going to come over to your si
h the dead tuple going live,
with a duplicate field, after some NOTICES about buffer leaks.
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
On Sat,
development, but
Jan has recently released a snapshot, so it's past the initial planning
stages. For now, we'll all have to make do with lo or external file store,
but there is hope on the horizon...
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scie
ot really an encryption expert, but what your looking for is a
reversible encryption algorithm. Some suggestions of the top of my head:
SHA, Blowfish, Hmm, can't think of any more. Note my caveat above,
about what's on the wire. You _really_ want the client app to do the
encryptin
or that, we check logins as
so:
SELECT * FROM "Personnel" WHERE "PerUsername" = 'RJReedstrom' AND
"PerPassword" = sqlcrypt('password',substr("PerPassword",1,2))
That will only return results if the password hashes match. It does expose
the
Ah, I forget to mention how to compile the code I sent. I use:
gcc -fPIC -shared -I /usr/local/pgsql/include -L /usr/local/pgsql/lib
-o sqlcrypt.so sqlcrypt.c
then move the sqlcrypt.so file into my pgsql storage space. This is
on Linux, if it matters.
Ross
--
Ross J. Reedstrom, Ph.D
was a bug)
So, in current stable, no you can't do it in one query. In the coming stable,
you sure can!
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
olumntype
Has been a feature since version 6.5.X, at least.
> So only way is:
> DROP TABLE and then again CREATE TABLE with all the fields
> you need.
>
This is still needed for DROP COLUMN but not ADD COLUMN.
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI R
doing that I perform a vacuum.
> vacuumdb foodb
>
> Please tell me I'm doing something I really shouldn't be doing.
>
O.K. - you're doing something you really shouldn't be doing. ;-)
No, seriously, why do you need to simultaneously vacuum? can't you v
On Sun, Mar 12, 2000 at 09:40:43PM -0500, Alex Pilosov wrote:
> now() is a function, and you should use it as now()
>
> -alex
also, the magic constant 'now' might work: it needs the tics as well.
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Rese
) ?
Nope, DATETIME is not an SQL92 type, it's a class of types. Here's a
snip from the standard:
::=
DATE
| TIME []
[ WITH TIME ZONE ]
| TIMESTAMP []
[ WITH TIME ZONE ]
So the three SQL92 datetime types are DATE, TIME, and
x27;)
INSERT INTO my_table (my_id,somethng,otherthng) VALUES ($newID, $some, $other)
or equivalent, so you've already got the ID in hand.
Personally, I use the SELECT curval('seq_name') construct.
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
gt;
I'd say, if it's a sort answer (like this one ;-), post it as well. If it's
long and detailed, go ahead and send email, but if you want, post a brief
reply to the list, usually just quoting the question, and saying "Answered
in private email"
Ross
P.S. Watch your lin
ating parity bits in hardware for RAID 5 had got
to be a win, doesn't it?
As it turns out, I'm speccing a similar machine right now, myself,
and I've been running into statements like yours re: software RAID that
surprised me.
> setup, same machine, same OS, were net'ng me so
s there a
major commercial DB with sequence objects that gets this wrong?
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
On Thu, Dec 09, 1999 at
nts is
the _definition_ of a transaction: all together, or nothing at all. This
isn't just an arbitrary rule: the validity of the relational calculus
depends on transactional semantics.
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and I
hat automatically sets the sequence value to the current max in the table.
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
--
2|some other text
1|some text, and text added later
(2 rows)
test=>
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
e "Extending SQL" sections on functions,
operators, and interfacing them to indices.
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
ng this tool, which looks promising. The
> search engine for the mailing list archives at
> www.postgresql.org appeared broken as of a couple of
> days ago and I don't have the URL to the page, but an
> upsizing tool does, indeed, exist.
>
--
Ross J. Reedstrom, Ph.D., <[EMA
username= '#name_entered#' and
password=sqlcrypt('#pass_entered#',substr(password,1,2))
--8<
/* sqlcrypt functions: wrapper around standard unix crypt call.
* Copyright 1999, Ross J. Reedstrom ([EMAIL PR
field to a particular value, it's good
to reset the sequence, to make sure you don't get errors, like so:
select setval('mynames_nameid_seq',max(nameid)) from mynames;
I need to do this sort of thing when I recreate a sequence, or sometimes
after deleting a lot of test record
function upper(char16) does not exist
> >
> > How can I get uppercase output of my_field
> >
> >
> > Safa Pilavc?
> >
> >
> >
>
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
SELECT to have two levels of target list
So Sam, I think it's a bug. The work around is to what Brett suggests,
SELECT INTO temp_losses GROUP BY ..., then
INSERT INTO losses SELECT * from temp_losses;
Ross
--
J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Pro
and it's not even in the dump.
>
> Someone mentioned recently that primary key enforces nulls as unique
> whereas unique index doesn't.
>
Actually, I belive it enforces NOT NULL on primary keys, which it also
dumps in the pg_dump output.
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PRO
template1 &1
then in the pager, search for ERROR
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
On Thu, Jul 01, 1999 at 03:43:27PM +0200, Anja Speerforck wrote:
> At 11:24 01.07.99 +0100, you wrote:
> >I'm not sure that I understand exactly what you are trying to do. I'm
> >guessing (and I mean guessing) that the tables are something like:
> >
> >ansprechpartner: private owner
> >kunden: cl
On Wed, Jun 30, 1999 at 01:44:05PM -0700, Stephen Boyle wrote:
>
> Subject: Postgres Upsizing Tool for MSAccess 97
>
>
> I have today set up a web page to allow download of pgupt. The tool written in
>Access 97 provides the following functionality:
>
A little digging around reveals the cor
beside src
(were the core of postgresql lives). It's pgsql/contrib, if you
do a CVS checkout. I'm not sure where it ends up in various binary
packages. (/usr/lib/postgresql/contrib on my Debian Linux install,
for example, has parts of it, but not the whole thing.)
Ross
--
Ross J. Re
; I want to select a field as the concatenation of the chromosome and the arm...
>
> cgh=> select chromosome || arm as locus from experiment;
> ERROR: There is more than one possible operator '||' for types 'varchar'
> and 'b
> pchar'
> You
;
> 'categoryname/subcategoryname/someotherinformation/012345'
>
> all I want in this field is that last bit of information after the last
> '/' ie: '012345'
>
> I'd like to either replace this field with this number alone or insert
> into another newly created field.
>
> Any suggestions would be appreciated.
>
-
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
Hmm, Ross needs to break for lunch - his brain is runing out of glucose!
Ross J. Reedstrom wrote:
>
> No, as Herouth pointed out, currval is multiuser-safe: it returns the
> last value given in the current session, and every user get's their own
gets
> session. I just tried i
nimations into their
PostgreSQL db via MS-Access) Perhaps for the limited case (not millions
of records above 8k, just a few), the existing implementation is
sufficent.
Ross (parenthetically speaking this morning, for some reason)
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Re
Stuart Rison wrote:
>
> Hello,
>
> Found this snippet in a postgreSQL GENERAL posting:
>
> >Ross J. Reedstrom <[EMAIL PROTECTED]> wrote
> >
> >[PostGreSQL does] support views, has for
If you could afford it would you rather
> be using oracle? I can afford oracle as i'm not going to be
> paying, but 2000 just seems unresonable. I don't want to
> pay for suits and corporate planes, i just want to run software.
>
> Any help, comments, advice would
nction, etc. that will should up in a
> /dd comment in psql?
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
base prysm_shreveport3 does not exist in pg_database
Could not connect to new database. exiting
$
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
---
> Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103
> VP/Mac Tech | 333 Texas St #619| FAX:318.221.6612
> [EMAIL PROTECTED]| Shreveport, LA 71101 | http://www.shreve.net
>
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
n of the *whole* rest of the
> table check all the rest of the entries for regex matching, so it takes a long
> time, and returns the two entries detailed above, it will take almost as long
> as the previous query.
>
> What it should do is stop as soon as the leftmost part of the reg
60 matches
Mail list logo