for which the identifier is
assigned. ISO, for instance, is willing to re-use country codes (even
though the specification never suggested they were). So if you expect
to use the ISO 2-letter codes over time, you may get a nasty surprise.
(For an example, in 2003 "CS" became historically am
lease?
A really really long time. You might actually be better off to dump
the table and restore it from that.
A
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
http://www.commandprompt.com/
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscript
On Fri, Apr 11, 2008 at 07:23:04PM +0200, Nacef LABIDI wrote:
> Hi all,
>
> I was wondering if postgres can return the last ID inserted for a table
> which the primary key is autoincremented. I need to retrieve this ID in my
> code to continue processing on that inserted row.
Use select currval()
On Tue, Feb 26, 2008 at 05:05:01PM +0100, Shavonne Marietta Wijesinghe wrote:
> Thank you. I tried as you said. But i get a ERROR: syntax error at or near
> "INSERT" at character 9
> I don't see anything wrong with the code..
Well, except that there's no "EXCEPTION" statement in SQL? I think
On Mon, Jan 07, 2008 at 12:51:19PM -0500, Chris Browne wrote:
> I have heard that Gabriel has, at different conferences at different
> times, taken and argued opposite positions on this; he has both argued
> "Worse is Better" and that "Worse isn't Better."
Yes. That history is actually outlined b
On Mon, Jan 07, 2008 at 05:02:27PM +0100, Peter Kovacs wrote:
> I just wanted to give my cheers for DISTINCT ON. It is a great
> feature, I've just found a really good use for it. I am just wondering
> why it didn't make it into the standards.
Likely because neither Oracle Corp nor IBM nor (at the
On Tue, Dec 11, 2007 at 11:05:25AM -0600, Ertel, Steve wrote:
> is wrapped in quotes. Is there a setting to allow upper case and mixed
> case names for database tables, fields, etc, without having to wrap each
> in quotes?
No, sorry. The always-one-case rule for unquoted identifiers is ANSI
con
t's zlib, if I recall correctly. So probably not.
A
--
Andrew Sullivan
Old sigs will return after re-constitution of blue smoke
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscrib
t; insert) on the backup 7.4 database?
You can do this with Slony, assuming nothing else needs to be written
(on the replicated tables) into the 7.4 system.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Never get involved in litigation. Your hair will fall out, your bones
will turn to sand. And it wi
on the way into the
import step.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
"The year's penultimate month" is not in truth a good way of saying
November.
--H.W. Fowler
---(end of broadcast)---
TIP 9: In versions
datecreated > '2007-10-02';
Note the quotes.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook definition of Postmodernism.
--Brad Holland
---
sibility from the DNS labels, and it's sometimes
terrifically important not to make that mistake.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The plural of anecdote is not data.
--Roger Brinner
---(end of broadcast)---
TIP 6: explain analyze is your friend
field that does not get used very much,
you have to pay the I/O for it every time you look at that row, even
if it's not used. Also, it sounds like it might not be used by every
row? In that case, normalization calls for it to be pushed out too.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Howeve
ecome
> very large. Should I take this in to
> consideration when deciding whether to split the tables? In terms of
> searching speed that is.
I'd put it in its own table, probably, unless you're going to use it
frequently.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Everyt
re you add a CHECK constraint where !(col1
IS NULL and col2 IS NULL).
A
--
Andrew Sullivan | [EMAIL PROTECTED]
I remember when computers were frustrating because they *did* exactly what
you told them to. That actually seems sort of quaint now.
--J.D. Baldwin
-
because the message is in spanish)
You _must_ call nextval() before a currval(). This is documented
behaviour.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The whole tendency of modern prose is away from concreteness.
--George Orwell
---(end of broadcast)--
ndant objects
> - FKeys, views, functions etc).
It doesn't allow this, but you could cause it to happen anyway on the
replica using a trigger. You have to use STORE TRIGGER to make this
work.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The whole tendency of modern
> differ?
I _believe_ [local] means UNIX domain socket. As to your other
question, either ps or pg_stat_activity is your friend.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The very definition of "news" is "something that hardly ever happens."
--Bruce Schneier
You _might_ be able to get this to work by installing whatever extra
bits the YAST installation tool offers (probably something with -dev-
or -src- in it).
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Users never remark, "Wow, this software may be buggy and hard
to use, but at least there
hat
the requirement _really_ is, and then you won't have to implement
what sounds like a bad idea.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
However important originality may be in some fields, restraint and
adherence to procedure emerge as the more significant virtues in a
great many oth
nce or whatever for your ORDER BY clause, and not store data
that you actually don't care about.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The plural of anecdote is not data.
--Roger Brinner
---(end of broadcast)---
TIP 9:
for each typ, then? If
they're just there to preserve order, one sequence will work just
fine. Otherwise, I think you have a normalisation problem.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
A certain description of men are for getting out of debt, yet are
against all taxes for rai
Is there a way to select data using EXECUTE?
You missed the opening sentence of the previous paragraph:
The INTO clause specifies where the results of a SELECT
command should be assigned.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The whole tendency of modern prose is away fr
ther'::text as c UNION
SELECT a::text, b::text, c::text FROM sometable WHERE [criteria]
The casts might not be needed, of course.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The plural of anecdote is not data.
--Roger Brinner
---(end of broadcast)
perly, because I
think you want ot set up a PHP array with values from your table,
without using PHP. Which would of course make no sense. Do you
mean, how do you populate an array data type with data from individual
database columns?
A
--
Andrew Sullivan | [EMAIL PROTECTED]
However important
2 0 0
I think this should be possible with the "crosstab" functionality
delivered in Joe Conway's tablefunc package, in contrib/.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
I remember when computers were frustrating because they *did* exactly what
you told them
On Mon, Jun 25, 2007 at 04:20:37PM -0300, Fernando Hevia wrote:
> when <> then return variable;
> when <> then <> ;
> when <> then <> ;
Check out the FOUND variable in the documentation for the first two,
and the "trapping errors" section
On Tue, Jun 19, 2007 at 02:02:46PM -0400, John Gunther wrote:
> Well, Andrew, you're certainly right but I made an exception because of
> the data needs.
Ah, well, in that case, you'll need something other than SQL for
sure. A function as suggested is probably your friend
very normal-form thing to do,
because the data has been broken into pieces dependent on the data
itself, rather than the kind of data it is.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook de
est possible Monday.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
When my information changes, I alter my conclusions. What do you do sir?
--attr. John Maynard Keynes
---(end of broadcast)---
TIP 6: explain analyze is your friend
x27;s a fundamental reason, no. But why couldn't you
change your query to issue the SRF directly, with the parameter:
SELECT * FROM some_srf(param1, param2)?
A
--
Andrew Sullivan | [EMAIL PROTECTED]
"The year's penultimate month" is not in truth a good way of saying
at. The same thing is
true of a function, which will have its plan prepared the first time
you execute it. (I could be wrong about this; I suppose the only way
would be to try it.)
A
--
Andrew Sullivan | [EMAIL PROTECTED]
However important originality may be in some fields, restraint and
adhere
uld
> work but would definitely be ugly. Can someone think of a better way to
> do that ?
I sort of don't see how that hack would be any different from a SRF.
You'd lose the planner benefits anyway, I think, because you'd have
to plan for the generic case where the data co
er that SQL returns in is not determined until the data has come
back. Are you doing this all in one serialisable transaction,
though? If not, what guarantee will you have that new data won't
mess up your row numbering from query to query?
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The plur
o do the DROP, you just ROLLBACK.
I think there's some nifty way to get generate_series to do this too,
but I don't know it offhand (generating row numbers sounds to me like
a bad idea, so I don't do it).
A
--
Andrew Sullivan | [EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
n the
table? I'm not surprised it takes a long time -- you have to join
the whole table to itself and then do a lot of counting. Are you
just trying to get the "row number" for your query answer? You can
do this with a temporary sequence, among other approaches, more
cheaply
?
> if yes then how?
> plz. help me.
This depends. Does the record have a serialno field? If not, you
can do it with a temporary sequence. But you should be aware that
this "serial number" as you call it changes from result to result in
that case.
A
--
Andrew Sullivan | [EMAIL PR
spyware
> protection.
> http://new.toolbar.yahoo.com/toolbar/features/norton/index.php
>
> ---(end of broadcast)---
> TIP 5: don't forget to increase your free space map settings
--
Andrew Sullivan | [EMAIL PROTECTED]
I remember when computers
creasing the stats sample, and see if that helps.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well.
--Dennis Ritchie
---(end of broadcast)-
ecause of a failed
foreign key? If so, you can end up with dead tuples. I'd look at
the output of VACUUM VERBOSE to make sure you don't have a lot of
dead tuples. That said, I wonder if fiddling with the statistics on
your tables might help.
A
--
Andrew Sullivan | [EMAIL PROTECTE
annot figure out why the optimizer is
> looking at these differently. In fact, the table the branch_id comes from
> has the exact same indices and foreign keys on both schemas.
Different data? Different statistics? Different numbers of
(possibly dead) rows?
A
--
Andrew Sullivan
orks, but is instead
some sort of veneer over the face of it? In that case, why not just
write some user-space application that takes this (IMO useless) TML
and translates it into proper SQL? You don't need to make any
changes to Postgres at all, it seems.
A
--
Andrew Sullivan | [EMAIL PROTE
or
Perl. That doesn't mean they can get away without learning a bit
about XML, Perl, and Pg.pm.
Anyway, I've said enough on this topic. When you have the start of a
user library that implements your proposal, perhaps you can post it
to -hackers for the response you'll get there.
A
.2 release.
But I have doubts that your program design is right if this is the
approach you're trying to take (it's not impossible that it's the
right way, just that this is often a workaround for a dodgy data
model in the first place). What is the conflict you're trying to
avoi
eSQL back end), then
write that. Don't bollocks up the back end and change the syntax of
SQL to achieve what is, IMNVHO, a really bad idea.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Users never remark, "Wow, this software may be buggy and hard
to use, but at least there is a lot of cod
big problem. (One quick primer that can help you understand this
is at <http://www2.hursley.ibm.com/decimal/decifaq1.html>.)
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The whole tendency of modern prose is away from concreteness.
--George Orwell
---
d lose precision).
> The question is: how accurate is floating point numbers in Postgres. We
As accurate as they are in the underlying C implementation, which is
to say "not accurate enough for financial data".
A
--
Andrew Sullivan | [EMAIL PROTECTED]
A certain description of men are
n-place storage management that
EnterpriseDB contributed was both somewhat controversial and somewhat
limited in its application.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well.
On Fri, Apr 13, 2007 at 07:49:19AM -0400, Andrew Sullivan wrote:
> On Fri, Apr 13, 2007 at 09:02:58AM +0800, John Summerfield wrote:
> > 1. For the first day or so, my observation was that the disk was not
> > particularly busy.
>
> That's completely consistent with
do those
things? SQL is not so fantastically hard that you can't learn it.
Indeed, I'm pretty sure that if someone as foolish as I can learn it,
anyone can.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
If they don't do anything, we don't need their acronym
's current capabilities,
> but by itself it doesn't make what I'm trying to do unreasonable.
No, it's not unreasonable, but it happens to be a pessimal case under
Postgres.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
"The year's penultimate month" is not in truth a g
ll the column name correctly. Or don't
quote the identifier when you create the table.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
A certain description of men are for getting out of debt, yet are
against all taxes for raising money to pay it off.
--Alexander Hamilton
//www.powerpostgresql.com/Downloads/annotated_conf_80.html
Also
http://varlena.com/varlena/GeneralBits/Tidbits/perf.html
And the -performance list will probably help you more than this one.
Hope this helps.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Users never remark, "Wow, this softw
You can
probably bump a little in this case. Your other config seems ok to
me. But I don't think this is your problem -- the update pattern is.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
If they don't do anything, we don't need their acronym.
--Josh Hamilton, on
the fact it uses so little RAM suggests it doesn't do
> that at all).
What do you have configured as your shared buffers? If you haven't
given very much, there won't be much in the way of buffers used, of
course. Note that there's a much earlier diminishing return on the
size of sh
s a good thing. (I'm not actually
convinced even of that. The whole point of SQL was to move away from
the hierarchical model, and so grafting a lot of hierarchy back onto
it suggests to me that the OP has picked the wrong technology for the
problem at the outset.)
A
--
Andrew Sullivan | [
?
What does this do that inheritance doesn't already do? I don't think
I see anything.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Everything that happens in the world happens at some place.
--Jane Jacobs
---(end of broadcast)--
experience with a table that was updated _very
very_ often. The answer turned out to be to update less often.
Aggregating queries that could use an index over a large number of
"expired" rows worked better than seqscans over large numbers of dead
tuples.)
A
--
Andrew Sullivan | [EMAIL P
> For each record, I update a non-key field in another table; the source
> data for that other table is less than a megabyte.
this is a real issue. Basically, you're constrained at the rotation
speed of your disk, because for each record, you have to first find
then update one row
equences are
designed with that requirement explicitly excluded, and you might be
better to try another method.)
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Everything that happens in the world happens at some place.
--Jane Jacobs
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
nnections
could be using it. I'd lock the table in question while you did all
this.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Unfortunately reformatting the Internet is a little more painful
than reformatting your hard drive when it gets out of whack.
uery is running??
> here is the query i've ran
48 million records is a lot. You oughta see activity with iostat or
something.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
When my information changes, I alter my conclusions. What do you do sir?
--at
g for "like 'blahblah%' or " ~ 'blahblah.*'",
they're AFAIK about the same. When you have a more complicated RE,
though, it might turn out to be a win.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Information security isn't a technologica
; ORDER BY history.stock, history.day DESC
>
>
> How can I speed this up?
>
>
> --
>
>
> Regards,
>
> Tarlika Elisabeth Schmitz
>
> ---(end of broadcast)---
> TIP 3: Have you checked our extensive FAQ?
>
&
On Tue, Mar 13, 2007 at 11:52:17PM +, T E Schmitz wrote:
> Also, it's nopt happy about the date format : 2007/02/09
You may need to fiddle with your date style. It works for me on 8.1:
SELECT '2007/02/09'::date;
date
2007-02-09
(1 row)
A
--
Andrew
ows. How big a percentage of the
table is that?
Also, what does EXPLAIN ANALYSE say about this?
A
--
Andrew Sullivan | [EMAIL PROTECTED]
If they don't do anything, we don't need their acronym.
--Josh Hamilton, on the US FEMA
---
topic for the manuals for that environment.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
"The year's penultimate month" is not in truth a good way of saying
November.
--H.W. Fowler
---(end of broadcast)---
TIP 3
you have to pick one style,
and be absolutely certain to use it consistently. If you mix the
styles, you'll get surprises.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The whole tendency of modern prose is away from concreteness.
--George Orwell
-
if not, if the team has plan to introduce
> it on PostgreSQL.
What is the problem you're trying to solve? Md5 is probably good
enough for many cases, but for long-term use, you're right that sha-1
is what you need. Actually, you need sha-256, quite frankly.
a
--
Andrew Sulliva
everything to lower().
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The plural of anecdote is not data.
--Roger Brinner
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
t sort of match are you doing? If you're doing left-anchored
searches (LIKE 'blah%') then your standard btree is good. If you're
doing unanchored searches (LIKE '%blah%' or similar) you're best doing
tsearch. If it's right-anchored, you can do an in
ussion of rules in the manual (views
are basically just an automatic application of certain rules).
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Information security isn't a technological problem. It's an economics
problem.
--Bruce Schneier
---(
On Wed, Feb 28, 2007 at 10:02:38AM -0300, Ezequias Rodrigues da Rocha wrote:
> Hi list,
>
> it is possible to use case with character (1) ?
>
> I am having problems to formate the SQL statement.
Your example looked like it worked.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Use
forget, or you'll end up in the same place next time.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
When my information changes, I alter my conclusions. What do you do sir?
--attr. John Maynard Keynes
---(end of broadcast)---
TIP
for this. See the docs.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
I remember when computers were frustrating because they *did* exactly what
you told them to. That actually seems sort of quaint now.
--J.D. Baldwin
---(end of broadcast)--
On Mon, Feb 19, 2007 at 04:22:06PM +0100, Shavonne Marietta Wijesinghe wrote:
> Hello
>
> In my PostgreSQL database i have records inserted in Uppercase.
> For example: VIA SENATO
>
> What i want is to change them to "Via Senato".
Have a look at the initcap
unc(name) might do something that alters it,
no? All things considered, it's a pretty good _bet_ it will be
ordered as you wish, though.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The whole tendency of modern prose is away from concreteness.
--George Orwell
--
On Thu, Feb 08, 2007 at 03:13:16PM -0200, Ezequias Rodrigues da Rocha wrote:
>
> Any suggestion instead of change my max_stack_depth ?
Well, I suppose you could put the numbers in a temp table an NOT IN
on that.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The fact that technology doesn&
definition
> of a table.
an easy way to do this is "CREATE TABLE name AS SELECT . . . WHERE
1=0". You get a table with no rows. (WHERE FALSE and similar
constructs all work equally well.)
A
--
Andrew Sullivan | [EMAIL PROTECTED]
In the future this spectacle of the midd
the value of the sequence. There's no
race condition there unless you are sharing a pooled connection (and
if transactions mean anything to you, you'd better not be doing).
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The fact that technology doesn't work i
n't gotten there yet, but I'm also wondering if the
> SCOPE_IDENTITY() method is going to work or not.
I doubt it. What does it do?
A
--
Andrew Sullivan | [EMAIL PROTECTED]
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end
>
> ps: I just think postresql could make this easyly. Don't you think ? Any
> function or anything else.
What's hard about the self-join? That's how SQL works.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
When my information changes, I alter my conclusi
ot; violates the SQL-92 Specification.
I don't want to put words in his mouth, but I think you missed the
bit where Peter said "the result is not what some people expect".
Hint: 'somevalue = NULL' is not a violation of SQL in that you don't
get an ERROR.
A
--
Andr
ot a race condition; see the
docs.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Information security isn't a technological problem. It's an economics
problem.
--Bruce Schneier
---(end of broadcast)---
TIP 9: In versions below
ent or the employee or agent
> responsible for delivering it to the intended recipient, you are hereby
> notified that any use, dissemination or copying of this email transmission is
> strictly prohibited by the sender. If you have received this transmission in
> error, please de
ry limitation on every program at compile time. There are some
hints about this in the FAQ_AIX.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
When my information changes, I alter my conclusions. What do you do sir?
--attr. John Maynard Keynes
---(end of
7;ll see the COMMIT as
the thing that caused the error.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Unfortunately reformatting the Internet is a little more painful
than reformatting your hard drive when it gets out of whack.
--Scott Morris
-
cs/8.2/static/runtime-config-logging.html
A
--
Andrew Sullivan | [EMAIL PROTECTED]
If they don't do anything, we don't need their acronym.
--Josh Hamilton, on the US FEMA
---(end of broadcast)---
TIP 7: You can help su
'
in it, and been surprised. Or at least, I think it's like that. I
do recall hearing a lot about how stupid Postgres was because it
didn't like something that worked "perfectly well" on Oracle, which I
was assured was the most SQL-compliant system on the planet.
Happil
be integers?) the same thing,
whereas of course ' ' and NULL are not. But since I'm not an Oracle
user, people should feel free to ignore me :)
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Everything that happens in the world happens at some place.
QL, as far as I know. If you want to use the empty string, you need
WHERE ean = ''
If you want instead ean to be NULL, use the traditional \N to signify
NULL on your way in, or define null some other way.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Users
7.4 series. 7.4.2 was a long
time ago, and I dimly remember something about data corruption early
in the 7.4 series. It could be the source of your problem.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
This work was visionary and imaginative, and goes to show that visionary
and imaginative wor
to be able to RIGHT OUTER JOIN the table you
just LEFT JOINed to to the next table using a different column.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Information security isn't a technological problem. It's an economics
problem.
--Bruce Schneier
he temp table and EXECUTE the statement. The
problem is that the plan is cached for later re-use. Since the
cached plan has the id of a table that no longer exists, you get this
error. See the PL/pgSQL part of the manual for more on this.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Unfortunately
se where it was five. Yes, the application needed
rewriting. But it was normalised :)
A
--
Andrew Sullivan | [EMAIL PROTECTED]
A certain description of men are for getting out of debt, yet are
against all taxes for raising money to pay it off.
--Alexander Hamilton
-
ing about is not a real
primary key, but an artificial one. The OP already has a real
primary key. SQL purists think artificial primary keys mean that you
haven't done enough normalisation. I'm going to remain silent on
that topic, though, so that we don't get a Thread That
8.1/interactive/functions-info.html#FUNCTIONS-INFO-ACCESS-TABLE
A
--
Andrew Sullivan | [EMAIL PROTECTED]
When my information changes, I alter my conclusions. What do you do sir?
--attr. John Maynard Keynes
---(end of broadcast)---
TIP
correct, although maybe no faster).
The reason it isn't repeated, I bet, is that your connection is
persistent, so the information gets cached.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Everything that happens in the world happens at some place.
--Jane Jacobs
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
les to
appear in the WHERE condition and the update expressions.
a
--
Andrew Sullivan | [EMAIL PROTECTED]
Users never remark, "Wow, this software may be buggy and hard
to use, but at least there is a lot of code underneath."
--Damien Katz
---(
right, you should _never_ have to VACUUM FULL.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
When my information changes, I alter my conclusions. What do you do sir?
--attr. John Maynard Keynes
---(end of broadcast)---
TIP 7: You can h
1 - 100 of 272 matches
Mail list logo
