On Thu, 2010-05-20 at 09:21 -0700, Giancarlo Boaron wrote:
> Hi Jim.
>
> I think it depends on each server configuration but I checked in my server
> and I don't have the 'pgsql.so' and 'psql.ini' files and neither the 'www'
> directory.
>
> My Apache version is 2.2.15 and my root directory is
On 15 Mar 2007, at 00:21, Tom Lane wrote:
Temp tables stay in RAM until they are bigger than temp_buffers.
If you
need them to be big and quick, maybe it would be appropriate to use
indexes (note these count towards temp_buffers), ANALYZE, etc.
You do need to realize that creation of a tem
cedure that we can call directly
from application code. The project is urgent, the aforementioned
developer is now on holiday, and so my non-developer boss is
scrabbling to learn PL/pgsql and I am forced to bombard the list with
inane questions. Thanks for your pa
FROM results WHERE (some condition involving results);
some_value = SELECT value FROM results WHERE (etc);
and so on...
All of which is easy with table variable, but I can't see how to
translate it to PL/pgsql. Is there any way to manipulate result sets
in a set-based manner like this
I can't see any way to query the result set like a
table. Can anyone offer any hints/links?
Thanks
Ashley
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joinin
Thx.
I suppose a nasty way would be with something like
ORDER BY CASE "Name" WHEN 'Other' THEN 'z' ELSE "Name" END
But this might work well enough if you've only got a few rows in the
table
Ashley
---(end o
;t mean that MySQL literally inspired features of PHP (maybe it
did?) - just that the clean, elegant nature
of PHP seems taken from MySQL.
Ashley
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
phy of Postgres, whereas PHP's design
rigour seems to be inspired by MySQL.
If you are interested in Rails-based blogging engines, check out
Mephisto ( http://www.mephistoblog.com/ ), which seems to be the best.
Ashley
---(end of broadcast)---
On Aug 13, 2006, at 2:16 pm, Thomas Kellerer wrote:
I do agree that this might be a problem of universty education
which focuses too much on theory and not on real-world problems.
From what I've seen, a bigger problem is universities that focus on
neither!!!
A
point. How well this is received - and how long
my job lasts afterwards :) - remains to be seen.
Ashley
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
t will only used for internal testing anyway.
Thank you both for your time reading my very cryptic question :)
Ashley
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
classes in my app to use to load the test data,
but that would involved poring over the Rails source to see how
everything works. I was hoping there would be a nice simple (oh I
laugh now) way of doing things in Postgres itself. Right now, I
don't know which a
nal ON INSERT DO INSTEAD rule.
Which suggests that what I want to do is impossible. Does anyone
know of a way to do this? If I can do it in the database I can
probably save hours of hacking the unit tests in Rails.
Thanks
Ashley
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
On Tuesday 28 March 2006 10:05, Martijn van Oosterhout wrote:
> That's because it's decribed in the SQL standard. UNION ALL just joins
> the results of the two queries. UNION removes duplicates which usually
> means sorting and comparing the tuples. UNION ALL is faster and usually
> what you want a
planation of UNION ALL. How does it differ
from UNION?
Ashley
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
depends on which table the data came
from. I think views are probably easier but I've never actually used table
inheritance.
Ashley
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
x27; and cmod_code=1234". Failing that
I will have to include a vehicle_type column in each of the underlying
tables, but I want to avoid anything that complicates the import procedure
(which is already very slow).
I'd be very grateful for any advice
Cheers
Ashley Moran
-
ementing
oracl type binding?
Ala
http://groups.google.com.au/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&th=5cc63a569577d024#link2
With the new FE/BE changes, how easy would it be to implement? (I
mentioned it the FE/BE discussions)
Ashley Cambrell
-
er to kept the structure
as generic as possible. Is it possible in PostgreSQL to construct a blank
record without specifying a list of fields and values in an INSERT statement
(so I can perform a collection for UPDATEs to populate the blank record)?
Ashley
---(end of
should also be saved:
data/pg_hba.conf
Does the WAL requiring backup as well? Are there other config files which
require backup?
Thanks
Ashley
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users
Occasionally and without warning I get this from my daily vacuum
cronjob:
NOTICE: RegisterSharedInvalid: SI buffer overflow
NOTICE: InvalidateSharedInvalid: cache state reset
I don't understand what these mean. Should I be concerned about them
and what do they signify?
--
creaky halls
PGP
* Tom Lane in "Re: VACUUM is hanging" dated 2001/05/04 22:05 wrote:
> > I also seem to have found the culprit. I have Apache::DBI set up
> > and it's holding something open. Restarting Apache let the vacuum
> > finish normally.
>
> Try not to leave open transactions hanging around in your Apache
Maybe someone will know what's going on here.
I'm running 7.1 and vacuuming the db regularly at 4am each day. But
these last few days as it vacuums it hangs reaping dead processes.
2001-05-04 04:00:09 [27285] DEBUG: --Relation personnel--
2001-05-04 04:00:09 [27285] DEBUG: Pages 0: Changed 0
ame from builders where name like 'A%' or name
like 'B%';
NOTICE: QUERY PLAN:
Index Scan using builders_name_key, builders_name_key on builders
(cost=0.00..10.25 rows=16 width=12)
EXPLAIN
Does the similarity of these numbers to the first ones above have any
significance or is it just c
I've come up with this example and I want to know why it does what it
does.
-- snip --
You are now connected to database template1.
CREATE DATABASE
You are now connected to database testing.
psql:test2.sql:11: NOTICE: CREATE TABLE/UNIQUE will create implicit
index 'subdivs_name_key' for table 's
rhter suggestions appreciated.
Thanks
Ashley
ve very limited experience with
postgresql, though I am told mysql has no problem I am just considering
options beyond filemaker on a mac server.
Thanks-you
Ashley
* Tom Lane in "Re: [GENERAL] Can this be done?" dated 2000/11/15 00:42
* wrote:
> Ashley Clark <[EMAIL PROTECTED]> writes:
> > Can I defer constraint checking on unique indexes?
>
> No, not at present. Consider restructuring your UPDATE into
> sequential ste
n
rgt + (droprgt - droplft + 1)
when (rgt > droprgt) and (rgt < newpos) then
rgt - (droprgt - droplft + 1)
else rgt end;
end;
' language 'plpgsql';
--
ashley clark
PGP signature
Well, I'll answer your questions and help you a little too, or at least
try...
* Alvaro Herrera in "[GENERAL] Does this table exist?" dated 2000/11/02
* 17:44 wrote:
> Now, I'm building a database to hold customer data that needs to be
> organized in a one-table-per-customer manner. No, I don't
* Frank Miles in "[GENERAL] newbie debugging pl/pgsql : better way?"
* dated 2000/10/24 11:56 wrote:
> I have a simple function that isn't working. I've enabled debugging,
> but the error message is still mystifying. My function is as
> follows:
>
>
> CREATE FUNCTION proj_name
31 matches
Mail list logo