FYI on the witting a batch script to run on Windows 2003 R2 server with
no install of postgresql or pgadmin III
This will create a new file every time the backup is run with the Name
then the date followed with the extension .backup
I would have added it to the postgresqldocs.org webstie
select version()
Markova, Nina wrote:
Hi,
Is there any way to check the exact current version without issuing
'psql' command?
Say, 8.2.1 or 8.2.9?
Thanks,
Nina
Thisis the same problempostgresql has whendoing sorting when runonwindows vs.
linux. Postgresql relies on the OS tohandlecollating aka sort orders.
to Quote
PostgreSQL uses the standard ISO C and POSIX locale facilities provided by the
server operating system
Ow Mun Heng wrote:
-Original Message-
From: Scott Marlowe [EMAIL PROTECTED]
If you throw enough drives on a quality RAID controller at it you can
get very good throughput. If you're looking at read only / read
mostly, then RAID5 or 6 might be a better choice than RAID-10. But
RAID
Bob Pawley wrote:
I haven't been able to find much information on Fetch for Update. Does
8.3 support this command??
If so, could someone please point out my error in the following?
Bob
BEGIN
SELECT count (p_id.pid.process_id) INTO Proccount
FROM p_id.p_id
WHERE process_id =
Alvaro Herrera wrote:
Bruce Momjian escribió:
Dan Dascalescu wrote:
I'd like to submit a correction for question 2.1) How do I setup a
datasource? in the FAQ. The existing text reads:
For Windows, use the ODBC Administrator in Control Panel. Here you
can add, modify, or delete data
aravind chandu wrote:
Hi,
My question is
Microsoft sql server 2005 cannot be shared on multiple systems
i,e in a network environment when it is installed in one system it
cannot be accessed one other systems.
This don't make any sense. Are your taking about sharing the actual mdb
? Software
patents are a menace, I'm afraid. And this is still just one portion.
IBM is also into this line of work.
Nix.
- Original Message
From: Dave Page [EMAIL PROTECTED]
To: Justin Clift [EMAIL PROTECTED]
Cc: Jonathan Bond-Caron [EMAIL PROTECTED]; A. Kretschmer
[EMAIL PROTECTED]; pgsql
of complaining about how wrong
the system is and the need to change it is. Use the system to protect
the project.
Interesting..
Martin
- Original Message -
*From:* Justin mailto:[EMAIL PROTECTED]
*To:* Nikola Milutinovic mailto:[EMAIL PROTECTED] ;
pgsql-general
KaiGai Kohei wrote:
Tom Lane wrote:
Right --- if in fact PG's rules infringe, then the patent is invalid
because we are prior art.
After scanning the claims, though, most of this is about access-rights
enforcement; which is something that rules *could* be used for but it's
not their
Ram Ravichandran wrote:
Hi,
I am deciding between MySQL and Postgres. I'm leaning towards Postgres
mainly due the widely publicized speed when using transactions.
Everything except for a couple of actions in Postgresql are wrapped in
transactions and can be rollback, you can not turn it
you want with one
query instead of looping through multiple queries (very important if your
tree gets big).
http://www.sai.msu.su/~megera/postgres/gist/ltree/
Justin Pasher
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
glene77is wrote:
On May 14, 3:27 pm, [EMAIL PROTECTED] (Sam Mason) wrote:
On Wed, May 14, 2008 at 02:08:47PM -0400, Justin wrote:
Sam Mason wrote:
What doesfoxprouse for storing numbers? or is it just that you never
pushed it hard enough for the abstractions to show through
Pavan Deolasee wrote:
On Thu, May 15, 2008 at 3:48 PM, Semi Noob [EMAIL PROTECTED] wrote:
I set max_connections is 200.
What error message you get when you try with more than 64 clients ?
I have the max connection set 50. You want to be careful with this
setting if theres
Scott Marlowe wrote:
On Thu, May 15, 2008 at 11:08 AM, Shane Ambler [EMAIL PROTECTED] wrote:
Semi Noob wrote:
My CPU is 2CPU: Intel(R) Xeon(TM) CPU 3.20GHz. Disk: disk system is
RAID-5;
Early versions of postgresql had issues with P4 HT CPU's but I believe they
have been
Tom Lane wrote:
Justin [EMAIL PROTECTED] writes:
From every thing i have read about Hyper Threading, it should be just
turned off.
Depends entirely on what you're doing. I usually leave it turned on
because compiling Postgres from source is measurably faster with it
than without
Craig Ringer wrote:
Justin wrote:
[Since] PostgreSql is not multi-threaded but a single thread
application which spawns little exe's how is hyper threading
helping Postgresql at all ??
Multiple threads and multiple processes are two ways to tackle a
similar problem - that of how to do
= 1;
double d ; //= a * b;
for( int i = 1 ; i 10 ; i++)
{
d = pow(a,i)+ c ;
printf(%.10f\n, d);
d = d-c ;
printf(%.10f\n, d);
}
return 0;
}
Sam Mason wrote:
On Tue, May 13, 2008 at 02:36:18PM -0400, Justin wrote
Sam Mason wrote:
On Wed, May 14, 2008 at 11:47:52AM -0400, Justin wrote:
I have forgotten how much i hate C++
What we're talking about doesn't have much to do with C++, it's floating
point maths in general.
Its not doing what you say it would but it did do other odd ball
things
Sam Mason wrote:
On Wed, May 14, 2008 at 02:08:47PM -0400, Justin wrote:
Sam Mason wrote:
What does foxpro use for storing numbers? or is it just that you never
pushed it hard enough for the abstractions to show through.
I know i pushed it. Foxpro for the most has only 4
Andy Anderson wrote:
On Wed, May 14, 2008 at 02:08:47PM -0400, Justin wrote:
My problem is we calculate resistance of parts in a Foxpro app that we
want to move because we want to bring all the custom apps into one
framework and single database.
Take this calculation (0.05/3* 1.0025
Andy Anderson wrote:
Sam Mason wrote:
If you mean FoxPro, I think this is another case of MS screwing up.
On May 14, 2008, at 4:08 PM, Justin wrote:
Foxpro normally did not suffer form other MS screw ups.
That's because MS bought it from a third-party developer.
(And so, of course
Tomasz Ostrowski wrote:
On 2008-05-12 20:49, Justin wrote:
We take (List Price * discount Percent) * Number of Pieces = net
price.
This is wrong. You should do in Excel:
( price * amount ) * discount
As otherwise any small error in representation of price*discount would
be multiplied
Thanks to Andy's C code here is the pl/pgSQL function which does the
same thing.
I added a tiny bit so instead of returning a numeric value with 20
trailing zeros it returns a value with the desired precision.
-Begin Code -
create or replace function
Tomasz Ostrowski wrote:
On 2008-05-13 17:29, Justin wrote:
Tomasz Ostrowski wrote:
On 2008-05-12 20:49, Justin wrote:
We take (List Price * discount Percent) * Number of Pieces = net
price.
This is wrong. You should do in Excel:
( price * amount ) * discount
, but it hides it very well. :-P
Tomasz Ostrowski wrote:
On 2008-05-13 19:21, Justin wrote:
I change it to double problem goes away.
No, it does not. It only hides it deeper. double is also a floating
point type and has the same problems.
Regards
Tometzky
--
Sent via pgsql-general mailing
I have very annoying problem that i would like to get a work around in
place so the data entry people stop trying to kill me.
Normally people give quotes out of the price book which was done in
Excel like 15 years ago and just has been updated over the years. the
problem is excel is
is almost always
0.01 to 0.015 pennies higher. Net result the invoices are almost always
lower than Quoted price. (yet customers still through a fit.)
-- Andy
On May 12, 2008, at 1:48 PM, Justin wrote:
I have very annoying problem that i would like to get a work around
in place so the data
Lincoln Yeoh wrote:
At 01:48 AM 5/13/2008, Justin wrote:
I have very annoying problem that i would like to get a work around
in place so the data entry people stop trying to kill me.
Normally people give quotes out of the price book which was done in
Excel like 15 years ago and just has
thats how i loaded the price list to start with. The problems with
sales orders are entered and the automatic pricing kicks in ( the
discounts are calculated * the number or pieces ordered) it goes to
down the tubes.
I could just rewrite the pricing stored procedures to call a rounding
Craig Ringer wrote:
Justin wrote:
No floating point is being used every variable is declared as numeric
on the Postgresql side and in the C++ which is the UI side
everything is double.
`double' in C++ refers to double precision floating point. `double' is
subject to all the usual fun
As i'm playing around with rounding and the numeric field precision ran
into a odd set of results i don't understand
here is the sql i wrote the first four inserts are calculations we run
everyday and they make sense but if division is used the results are
not right or am i missing something
Anderson wrote:
I would guess the issue is that 9/10 is an integer calculation, with
result 0. Use instead 9./10 or 9/10. or 9./10. with result 0.9.
-- Andy
On May 12, 2008, at 5:09 PM, Justin wrote:
As i'm playing around with rounding and the numeric field precision
ran into a odd set
its numeric and everything else is assumed to be integer if it
does not contain a decimal point.
Craig Ringer wrote:
Justin wrote:
I tried casting them to numeric and it was still wrong
How do the results differ from what you expect? You've posted a bunch
of code, but haven't explained
and we start having major problems.
Sam Mason wrote:
On Mon, May 12, 2008 at 06:37:02PM -0400, Justin wrote:
I guess i have not been very clear.
lets take this
select (9/10), (9/10)::numeric, (9::numeric/10::numeric), (9./10),
(9*.1)
With the given select statement i expected
Craig Ringer wrote:
Justin wrote:
WE have several columns in table defined with numeric (20,10) thats is
just insanity.
Not necessarily. I have a few places where a monetary value is
mulitiplied by a ratio quantity. For some of the historical data
imported from another system
We noticed that several records which have a time stamp column have
the same time stamp which i can understand given the time stamps have 1
microsecond resolution.
generail this don't hurt us but we have some needs with data coming from
manufacturing testing applications that needs to keep
Q Master wrote:
Hello,
I had postgresql 7.4 on ubuntu and over one year ago I moved to 8.2
Till now I was backing up my db via pgadmin remotely from windows but
now I want to do it from the ubuntu server.
When I run the command pgdump it said that the database is 8.2 but the
tool is 7.4 -
Dirk Verleysen wrote:
Hi,
I have been running a Postgres (8.2.4) on a Windows XP for over 3
months. Last week this machine died and I bought a new Vista machine
today. Installed everything on it and a Postgres (8.2.7). The problem
is that I cannot start the Postgres service. I keep
this new keyboard has problems, or i can't type ;-) .
it should be off not of
Justin wrote:
Dirk Verleysen wrote:
Hi,
I have been running a Postgres (8.2.4) on a Windows XP for over 3
months. Last week this machine died and I bought a new Vista machine
today. Installed everything
in Vista... For the
first month or so I tried to cope with it, hoping that I'd get used to
it, but it keeps coming in the way so much that I had to finally turn
it off... now life's much easier.
Best regards,
On Tue, Apr 22, 2008 at 5:17 AM, Justin [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED
Have a select statement with a where clause using datestamp with
timezone column compared to a date
Select * from sometable where DateStampColumn '2008-03-31'
this returns records that are equal 2008-03-31
but when the query includes casting to date
Select * from sometable where
Daniel Verite wrote:
Justin wrote:
Another option is use SQL pass through to append records from ACCESS
table into Postgres table that is open in Access.
http://support.microsoft.com/kb/303968
http://msdn2.microsoft.com/en-us/library/bb208861.aspx
the command would look something like
Pettis, Barry wrote:
Hi,
I'm fairly new to DBMS's and PostGre SQL in particular. Most
of my experience is with MS Access. I've created MS Access to
retrieve data from PostGre by linking tables and have done so without
error. However, I am now in need of being able to update a
Edward Blake wrote:
The table I have in MySQL is similar to below:
0 SET FOREIGN_KEY_CHECKS=0;
1 CREATE TABLE products (
2 product_id integer(11) not null auto_increment,
3 product_name varchar(255) not null,
4 product_descrition varchar(255) not null,
5 class_id
Joshua D. Drake wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 21 Mar 2008 12:38:49 -0500
Justin [EMAIL PROTECTED] wrote:
Any ideas?
Another way to do auto increment fields is create your own sequences.
I would not suggest that.
Why
Joshua D. Drake wrote:
I am not sure about 8.3 but certainly earlier releases of PostgreSQL
would have specific dependency issues when a sequence was applied to a
a column after the fact, versus using the serial or bigserial
psuedo-types.
Sincerely,
Joshua D. Drake
- --
The PostgreSQL
Cursor manipulation with select statements
This is something i did in foxpro and wonder if it is at all possible in
pl/pgSQL. I would create a cursor in foxpro then populate it with
Inserts then after all that was done use a Select statement to do more
manipulation if need be
the Foxpro
Tom Lane wrote:
Greg Smith [EMAIL PROTECTED] writes:
On Fri, 14 Mar 2008, Tom Lane wrote:
Yeah, -s is only meaningful when given with -i. Maybe someday we ought
to fix pgbench to complain if you try to set it at other times.
You have to pass -s in to the actual run if
Tom Lane wrote:
Justin [EMAIL PROTECTED] writes:
I was wondering why the -s would not rescale the data?
That would involve re-initializing the table contents.
If that's what you want, use -i.
regards, tom lane
thanks
Greg Smith wrote:
On Fri, 14 Mar 2008, Justin wrote:
I was wondering why the -s would not rescale the data?
First, you don't know how to rescale the data if someone is passing in
a custom script. More importantly, people don't expect the benchmark
tool to change things in tables unless
thanks
it now takes 806 ms
Martijn van Oosterhout wrote:
On Mon, Mar 10, 2008 at 10:01:47AM -0500, Justin wrote:
i wish that could work but need to keep track of the individual weights
as its a percentage of the total amount of the weight.
Unless you have a different meaning
you need to strip the string apart using either regex which is
difficult to use or split_part()
http://www.postgresql.org/docs/8.3/interactive/functions-string.html
The update will look something like this...
Update customer set custfirstname = split_part(Name, ' ', 1) ,
custmiddlename =
Tom Lane wrote:
Scott Marlowe [EMAIL PROTECTED] writes:
I'm really hoping Sun will put a stop to such behavior, but wonder if
they'll do anything at all.
Sadly, the worst problem with the behavior re mysql releases is that
it trains DBAs to NOT install updates. In fairness, I
into the
detail to see if it affects my install if not i'll skip it.
this is just my personal experience with patches for other software.
Scott Marlowe wrote:
On Tue, Mar 11, 2008 at 7:33 PM, Justin [EMAIL PROTECTED] wrote:
I view updates/patches of any kind like this, if ain't broke
i wish that could work but need to keep track of the individual weights
as its a percentage of the total amount of the weight.
I would never have thought the performance of the Array would suck this
bad.
Martijn van Oosterhout wrote:
On Sun, Mar 09, 2008 at 11:40:47AM -0500, Justin wrote
. I swear like a sailor in person, but it reads *very* badly in
email. There are a lot of people on this list who might take offense,
since it is their hard work that means that arrays work at all for
you...
* Please don't topquote.
On Mon, Mar 10, 2008 at 8:01 AM, Justin [EMAIL PROTECTED] wrote
to the Array which has a performance hit as the array
gets bigger and bigger ?
[EMAIL PROTECTED] wrote:
Richard Broersma wrote:
On Tue, Mar 4, 2008 at 8:44 AM, Justin [EMAIL PROTECTED] wrote:
I searched the archive of the mail list and did not find anything
Search the documentation
If i use two arrays how do i append new entries into these arrays.
array_append only allows for 1 dimension.
what other methods are there to add new entries to the array.
dmp wrote:
Array appends are usually a performance hit, as you said. I'm not sure
though with
PostgreSQL. Why not try
DMP you did give me an idea on how to call the append array
sfunc looks like this
create or replace function wcost_average_sf (numeric[], numeric, numeric)
returns numeric[] as
$Body$
begin
return array_append(array_append($1, $2), $3);
end;
$Body$
LANGUAGE 'plpgsql' VOLATILE;
function working i will add it to
the comment section or post it back here. Sense it will be a more
complicated aggregate function that what is listed here with sfunc and
ffunc calls
[EMAIL PROTECTED] wrote:
Richard Broersma wrote:
On Tue, Mar 4, 2008 at 8:44 AM, Justin [EMAIL PROTECTED] wrote
The help is not real clear nor can i find examples how to write an
aggregate function.
I searched the archive of the mail list and did not find anything
I need to write Weighted Average function so the need to keep track of
multiple variables between function calls is must?
I see how the
Il giorno 24/feb/08, alle ore 04:53, justin tocci ha scritto:
In its most basic form a great tool would just start as a pl/pgsql
or pl/perl function that could be used to call a table and have it
output a batch of records to an editable html form or a colored pdf
for nice reports
.
Anyone know of anything like this?
Best Regards,
Justin Tocci - www.unirev.com
7813 Harwood Road, North Richland Hills, TX 76180
cell 817-988-7758 - land 817-503-9545
--
I am curious to know if there is anything sort of like APEX or Html DB
in the Oracle world
Godoy wrote:
Em Thursday 21 February 2008 18:37:47 Justin escreveu:
Now i could write a function to do this or do it in C++ program that
creates query with all kinds of unions. I'm wondering if there is a way
to create this in a single select statement??
I can't think of a way to do
need to write a query for sales order table where we get the qty order *
price for all line items by week then average then create a moving
Average past 10 weeks of entered sales orders line items.
So what will happen is some one will enter a date range going back 6
month from the present
,
the relacl column is of type aclitem[], so you can't update it in the
same way. Newer versions of Postgres (8.1) will completely prevent you
from deleting the user if anything is still linked to it, but I'm
confused exactly how to get this older permission information cleared out.
Thanks.
--
Justin
Erik Jones wrote:
On Jan 15, 2008, at 3:59 PM, Justin Pasher wrote:
PostgreSQL 7.4.17
My situation is basically like the one states in the archives:
http://archives.postgresql.org/pgsql-sql/2005-10/msg00165.php
We have some tables that used to be owned by a user (user id 117
Erik Jones wrote:
On Jan 15, 2008, at 4:53 PM, Justin Pasher wrote:
Erik Jones wrote:
On Jan 15, 2008, at 3:59 PM, Justin Pasher wrote:
PostgreSQL 7.4.17
My situation is basically like the one states in the archives:
http://archives.postgresql.org/pgsql-sql/2005-10/msg00165.php
We have
situation, the time consuming part would be the initial
creation of the script to get the SQL files in the correct order. After
that is done, it's just a matter of proper maintenance to keep it working.
Justin
---(end of broadcast)---
TIP 2: Don't
List of relations
Schema | Name | Type | Owner
+--+--+---
(0 rows)
However... using SELECT statments on tables that I remember are present
still works...
--
Justin Michael Joseph Wozniak
---(end of broadcast)---
TIP 1
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 17, 2007 12:51 AM
To: Justin Pasher
Cc: 'Richard Huxton'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Fixing broken permissions for deleted user
Justin Pasher [EMAIL PROTECTED] writes:
OK
-Original Message-
From: Richard Huxton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 16, 2007 4:56 AM
To: Justin Pasher
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Fixing broken permissions for deleted user
Justin Pasher wrote:
I have a PostgreSQL 7.4.14 database
and I'd like to avoid downtime if possible.
Thanks.
Justin Pasher
---(end of broadcast)---
TIP 6: explain analyze is your friend
SET DEFAULT '#RFF';
This worked fine and I didn't notice it until I added arecord to the
users table and got the error:
ERROR: value too long for type character(7).
This behavior seems undesirable to me. Is this a known bug or is there
a reason for this?
Regards,
Justin Dearing
Hello, I currently store html color codes in that database with the
following DOMAIN:
CREATE DOMAIN html_color AS char(7) CHECK (VALUE ~ '^#[A-Fa-f0-9]{6}$');
Has anyone created a custom type that has additional functionality (eg
format the input or output to other formats, retrieve red, green
Hello,
I need a way to sync a postgres view with a table on a Windows CE device.
The table will be read only on the mobile device. I am seeking to replace an
access database that syncs a table with a pocket pc table via active sync. I
would really like to use postgres for the desktop side of
worried about, since you are
going to have some data/time overlap on the server after the change is
made. Are there any known issues with this situation in Postgres? Should
everything be shutdown prior to the change, then restarted again?
Thanks.
Justin Pasher
---(end
.
If this is not possible, is there some alternative way to do
this? I am trying to translate what was done in a ms sql database.
Justin
-Original Message-
From: Sven Willenberger [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 01, 2006 2:13 PM
To: Justin Pasher
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Best way to handle table trigger on update
On Tue, 2006-01-31 at 13:45 -0600, Justin Pasher
is the ideal solution. Thanks.
Justin Pasher
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
the case of NEW.position
OLD.position, because if I go the opposite route (UPDATE menu_items SET
position = 3 WHERE id = 1), the comparison in the trigger would fail and
nothing would update right.
Justin Pasher
-Original Message-
From: Jim C. Nasby [mailto:[EMAIL PROTECTED]
Sent
' by that much, the rest would work
by virtue of a seperate UPDATE trigger.
This seems possible, but I will have to cogitate on it for a while :-)
On the face of it it seems I will have to implement the cascading DELETE
myself, and keep track of how many DELETE's I am doing.
- Justin
to update rows further up
the tree to reflect the fact there are now less replies.
I can't see any particular flaw in my method so I'd really like to get
to the heart of why this doesn't work.
- Justin
--
Justin Hawkins | [EMAIL PROTECTED]
| http://hawkins.id.au
:
justin= delete from post where id = 3002;
NOTICE: deleting any that have a parent of 3002 so I can delete 3002
NOTICE: deleting any that have a parent of 3003 so I can delete 3003
NOTICE: deleting any that have a parent of 3004 so I can delete 3004
NOTICE: deleting any that have a parent of 3005 so I
I'm running postgresql 8.03 under Gentoo Linux and find that all actions
take at least a MINUTE (even dropdb and createdb). During this time, the
posgres account is locked up to the extent that one cannot even su to
it. (The su suceeds when the db operation completes.)
I assume something is
[] to int2vector
Any help here would be appreciated.
justin tocci
fort worth, tx
---(end of broadcast)---
TIP 8: explain analyze is your friend
to post the program and got denied for size. Its 72 lines.Is there an appropriate place to post such a thing?justin toccifort worth, texas
.
- Justin
- --
Justin Hawkins Email: [EMAIL PROTECTED] (W)
Systems Programmer/DBA Email: [EMAIL PROTECTED](H)
Internode Systems Pty Ltd Phone: +61-8-82282999
Sometimes I can hardly see the mirrors for the smoke
-BEGIN PGP SIGNATURE-
Version
that made the
difference. Thanks for identifying them for me.
The triggers work properly in both server now.
--
Justin Kennedy
Systems Analyst I
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send
On Sun, 20 Mar 2005, Andrew J. Kopciuch wrote:
On Thursday 17 March 2005 17:55, you wrote:
The short question is why does this:
select to_tsvector('default', coalesce(name, '') ||' '||
coalesce(description, '') ||' '|| coalesce(keywords,'')) from link_items;
give different results
without
upgrading the server to 8.0.0? We will upgrade in a few months, but we
can't take the server offline now because we have too many websites that
depend on it.
--
Justin Kennedy
Systems Analyst I
---(end of broadcast)---
TIP 3: if posting
? We will upgrade in a few months, but we
can't take the server offline now because we have too many websites that
depend on it.
--
Justin Kennedy
HEADLINE: GAY GUY NOT AROUSED BY UGLY, BITCHY GIRLS
-ram
---(end of broadcast)---
TIP 1: subscribe
Miles Keaton wrote:
Is there a simple way to list fieldnames in a table, from PHP?
When on the command-line, I just do \d tablename
But how to get the fieldnames from PHP commands?
---(end of broadcast)---
TIP 3: if posting/reading through Usenet,
subscribe
---(end of broadcast)---
TIP 8: explain analyze is your friend
before the upgrade, now however, any year before 70 gets inserted
as 20xx and not 19xx.
My question is between which versions did this behaviour change, and is
there any way for me to force the old behaviour?
Regards
Justin Wyer
---(end of broadcast
://www.varlena.com/varlena/GeneralBits/Tidbits/matviews.html
Hope that helps.
Regards and best wishes,
Justin Clift
Steve
Steve wrote:
Hi,
I've been running postgres on my server for over a year now and the
tables have become huge. I have 3 tables that have data over 10GB each
and these tables are read
Thomas LeBlanc wrote:
How to I run PostgreSQL on an Intel machine with Windows?
Hi Thomas,
This is probably the page you want:
http://techdocs.postgresql.org/guides/Windows
:-)
Regards and best wishes,
Justin Clift
---(end of broadcast)---
TIP 1
PL/pgSQL doesn't. I'd prefer not to have to load
further PL's into the database, but it's worth looking at anyway.
:)
Regards and best wisehs,
Justin Clift
Hope this helps,
---(end of broadcast)---
TIP 8: explain analyze is your friend
way to do this kind of thing for triggers with PL/pgSQL at
present?
Regards and best wishes,
Justin Clift
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
201 - 300 of 366 matches
Mail list logo