to explain how
> to do this and that, and I think I am a bit spoiled by the easy working
> of the mysql replication :-)
>
Hmm almost sounds like what you really want is mammoth replicator... lower
level than slony, built into the db, can handle ddl (iirc) not oss
though.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
p,
PostgtreSQL has a list of users here: http://www.postgresql.org/about/users
Some limits are in the FAQ: http://www.postgresql.org/docs/faqs.FAQ.html
And anecdotaly I've run systems that maintained 1000+ simultaneous connections
on fairly modest hardware as far back as 7.3,
)
Felix, in case your still watching, a (in theory) more up to date link would
be found at http://www.postgresql.org/docs/techdocs.3. Oh, and please don't
crosspost across 3 different lists in the future, it just creates noise for
the rest of us.
--
Robert Treat
Build A Brighter LAMP :
. Unofficially that will
probably be sometime in November. HTH.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
su
the wordpress guys have basically said they do not want to support postgres,
which is mainly why we swapped to s9y on planetpg. you can read some more
info here:
http://people.planetpostgresql.org/xzilla/index.php?/archives/13-One-Good-Port.html
Robert Treat
On Saturday 21 October 2006 23:31
?/archives/133-Getting-faster-database-restores-on-postgresql-8.1.html
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
proposal or patch. Depending on what your doing there are ways to simulate
those things with more standard sql.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 9: In versions below 8.0,
On Saturday 28 October 2006 19:47, Nicolas Barbier wrote:
> 2006/10/28, Robert Treat <[EMAIL PROTECTED]>:
> > On Tuesday 10 October 2006 15:19, stig erikson wrote:
> >> Are there any plans to implement CUBE, ROLLUP and/or GROUPING SETS in
> >> future PostgreSQL ve
n read, which sounds rather tricky (when compared to doing this at
a higher level anyway). I think your best bet for learning how WAL files
work is to read the backend code and maybe take a look at
http://pgfoundry.org/projects/xlogviewer/
> This is a call for advice, as we're surely no
into postgresql. Then step by step will try to improve/change queries.
>
If you have made use of a lot of built in mysql functions, make sure to check
out the mysql compat project: http://pgfoundry.org/projects/mysqlcompat/
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware
.1 topics... 8.1 was in development at the
time of the writing, so some things are mentioned, but a lot of 8.1 didn't
really apply to PHP programmers. For example, I mention tuning
max_prepared_transactions, but the recommendation is simply to set it to 0,
since there is almost n
any view that only has a single table in it's
dependency tree. (I've really no idea if this would work, so if you try it
and it succeeds please post a note or some code back to the group!)
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
same thing, but it appears the trade-off is disk
space/update speed (GiST) vs. query times (Gin). Magnus had a couple of nice
posts in his blog you might want to check out:
http://people.planetpostgresql.org/mha/
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
believe have some pointers
to afew scripts. (Right click and save to file any pdf docs you run across)
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Good morning all! I'm a newbie to PGSQL here so thought I would ask my
first question since I joined this list this morning...
Is it possible to run Postgresql and MySQL together on the same machine?
--
Robert Wolfe, Linux and Network Admin
net261.com | http://www.net261.com:85
[
t should I look for? I am used to running PostgreSQL on our BSD boxes
and have this setup for a customer.
--
Robert
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your j
On Tue, 2007-01-16 at 20:00 -0600, Adam Rich wrote:
> Robert,
> Open "Computer Management" and find the postgres service.
> There should be an item saying "Run As". You want that to be
> a non-privledged account. Typically, postgres asks you what account
> to
On Wed, 2007-01-17 at 14:13 +, Dave Page wrote:
> Raymond O'Donnell wrote:
> > Robert Fitzpatrick wrote:
> >
> >> Thanks, yes, I verified the services has 'postgres' as the account being
> >> used under the Log On tab of the PostgreSQL service.
--
> > regards,
> > Jaime Casanova
> >
> > "Programming today is a race between software engineers striving to
> > build bigger and better idiot-proof programs and the universe trying
> > to produce bigger and better idiots.
> > So far, the universe is winn
zilla/index.php?/archives/169-Is-lastval-evil.html
:-)
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
ral months of
development in the new. Any docs or other helpful info is welcome, just
looking for some advise.
Thanks in advance,
--
Robert
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscr
th. I'm sure there are still corner cases, but you should give it
> a try:
>
> http://gborg.postgresql.org/project/mysql2psql/projdisplay.php
>
Thanks, but my project has to do with Microsoft SQL server.
--
Robert
---(end of broadcast)
ve not had an opportunity to see how
> it performs in a production setting, so YMMV.
Yeah, so far, time has not been the main concern, more of a concern that
they have lots of options going forward and scalability and availability
using any browser.
--
Robert
---(end of broadcast)---
TIP 6: explain analyze is your friend
It appears to me that there is some inconsistency in the date
calculations for my PostgreSQL install (version 8.0 on Win32).
January 07 of 2007 is a Sunday. Based on the documentation I would
expect that date to be the first day of the second week of the year
2007. That's not what I'm getting. Whe
stent. Or,
did someone else run into this problem and solve it before me?
rjsjr
PS - Coming from an MS-SQL Server background I *love* the date
functionality in PostgreSQL.
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 23, 2007 5:40 P
postgresql. Not sure if anything like this exists but I
would like to see it if it does.
Thanks,
Robert
---(end of broadcast)---
TIP 6: explain analyze is your friend
Thanks for moving this to the correct list
Any ideas? Requested info is below.
>To begin with, what gcc version are you using?
I am using the GCC packaged by
http://aixpdslib.seas.ucla.edu/packages/gcc.html
My AIX level is
# oslevel -s
5200-09-03
# gcc -v
Using built-in specs.
Target: po
You might take a look at index anding for speeding up your selects
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Richard Huxton
Sent: Tuesday, February 06, 2007 7:24 AM
To: roopa perumalraja
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Storing
ted). If you running an any 8.x version, you need to be on the
most current corresponding 8.x.y release.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
I will be out of the office starting 09/02/2007 and will not return until
19/02/2007.
I will respond to your message when I return.
If you enquiry is regarding Norgren-i please contact Helen Jayne Walker.
Regards,
---(end of broadcast)---
TIP 2:
n there are a lot more tables and constraints involved or
(b) introduce race conditions.
Thanks,
...Robert
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
?
--
Robert
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
athranow | 4 | 1
repjan feb mar apr may jun etc...
-+-+-+-+-+-+-+-
aespinal4 3
asmith 1
athranow5 1 2 1
Thanks for the help!
--
Robert
---(end of broadcast)--
| jan | feb | mar | apr | may | jun | jul | aug | sep |
oct | nov | dec
--+-+-+-+-+-+--+-+-+-+-+-+--+-
aespinal | units | 10 | 9 | 8 |7 | 6 | 5 | 4 | 3 | 2 |
1 |2 |3
aespinal | revenue | 500 | 100 | 250 | 1000 | 500 | 250 | 300 | 150 | 100 |
250 | 5000 | 2500
--
Robert
---
it would be.
Still, I'd love to see it in the TODO file, too.
...Robert
-Original Message-
From: Joris Dobbelsteen [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 22, 2007 8:03 AM
To: Robert Haas; elein
Cc: pgsql-general@postgresql.org
Subject: RE: [GENERAL] complex referential inte
The idea here is that a wolf can attack a sheep, or a wolf can attack
another wolf, but sheep can't attack anything. I suppose I could list
each wolf in both the predator and prey tables, but that seems a bit
duplicative (and causes other problems).
...Robert
-Original Message-
ven a few of them. It is exponentially harder to write a
constraint of this type than it is to write a simple foreign key
constraint.
...Robert
-Original Message-
From: Joris Dobbelsteen [mailto:[EMAIL PROTECTED]
Sent: Monday, February 19, 2007 5:59 AM
To: elein; Robert Haas
Cc: pgsql-ge
Actually, what would be really nice is if there were just a button I
could push that would make all of my data automatically correct. Can
that go into 8.3? Thanks, ...Robert
-Original Message-
From: Alvaro Herrera [mailto:[EMAIL PROTECTED]
Sent: Friday, February 23, 2007 9:35 AM
To
tunately, it's too much work to do it everywhere it would be nice
to have, so I'm just doing it in some really critical cases and hoping
that the others don't break.
Thanks,
...Robert
-Original Message-
From: Alban Hertroys [mailto:[EMAIL PROTECTED]
Sent: Friday, February 23,
_pick1_data.rep, view_pick1_data.nyear, months."month"
FROM view_pick1_data, months
ORDER BY view_pick1_data.rep, view_pick1_data.nyear, months."month";
Thanks for any help in advance!
--
Robert
---(end of broadcast)-
onstraints on that data as I may see fit to define. I don't want to
have to select things out of system tables to find out attack
probabilities. Also, as a practical matter, I suspect that such a setup
would result in an absurdly complex constraint language.
...Robert
-Original Message---
cks
query in the last field. If you could return fields, which I see you
cannot, it would look like this:
return next 'units', dateval."date", picks.units
The final objective is a crosstab based on the return of this function.
--
Robert
---(end of b
();
version
-
PostgreSQL 8.1.5 on i686-pc-linux-gnu, compiled by GCC
i686-pc-linux-gnu-gcc (GCC) 4.1.1 (Gentoo 4.1.1)
regards,
Robert
[EMAIL PROTECTED
> > not sure I follow - pgpool will simply replay the queries to each
> > backend-server that are going through it.
>
> I guess I'm comparing it to Slony, which has a clear delineation between
> master and slave. With pgpool, you don't have the failover procedure
>
There are several logging parameters in the postgresql.conf, including
log_duration. Logging to a file also has a bonus that you can feed it into a
query analyzing program like pgfouine or pqa.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
-
ve me "the good link"?
The main issue against using temp tables involve bloat of some of the system
catalogs, but it's no worse than doing create/drop cycles with standard
tables, and better because they don't suffer as much i/o load.
--
Robert Treat
Build A Bright
ed by other users.
>
you could try to match CURRENT_USER with the information in pg_stat_activity,
but be aware there is a reason why this functionality was made for
superusers...
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of
k at the samples database project on pgfoundry:
http://pgfoundry.org/projects/dbsamples/
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
ould be using wikipgedia, I'm sympathetic
to those who might still be stuck on it for some reason, so if you guys can
produce a patch against the wikipgedia cvs, I'd be happy to apply it.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
instances
connecting back into PostgreSQL and the results I had have been flakey at
best.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ
m you're seeing?
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
I see in all the docs to run VACUUM ANALYZE periodically. My host told me
that in Postgres 8.2 this is not needed as it is done automatically.
Is that true? How can I see the results of the automatic vacuum analyze? Or
configure them?
I'd like to run pg_dump on a database that I have full
read/write/create/drop access to, but am not running as psql.
I'm getting this error:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: permission denied for relation
pg_ts_dict
pg_dump: The command was: LOCK TABLE public
I see in all the docs to run VACUUM ANALYZE periodically. My host told me
that in Postgres 8.2 this is not needed as it is done automatically.
Is that true? How can I see the results of the automatic vacuum analyze? Or
configure them?
> table is just two or three integers, and the PK is a multi-part key
> > of all fields, it makes sense not to store the data twice.
> > However, in Pg you can't do that since visibility is only stored in
> > the data, not the index.
>
You can achieve the same effect wit
:-P
http://sqlmanager.net/en/products/postgresql/dbcomparer
And I think there are some others floating around...
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 4: Have you
st it in your environment.
IMHO YMMV
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
to provide patches implementing such features. Assuming that's the
case, when would the appropriate time be?
Thanks,
...Robert
---(end of broadcast)---
TIP 6: explain analyze is your friend
ission
Currently only the owner can TRUNCATE a table because triggers are not
called, and the table is locked in exclusive mode.
It was easy, so I can update the patch as necessary until it can be
submitted.
Thanks,
...Robert
---(end of broadcast)--
dated / recompiled against newer versions as well. HTH.
--
Robert Treat
Database Architect
OmniTI Technology Firm
http://www.omniti.com/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
ome
projects at OmniTI at least.
I've got some gin/gist information up as well at
http://people.planetpostgresql.org/xzilla/index.php?/archives/278-PostgreSQL-full-text-search-testing.html,
also be sure check the trackback links... and also I think magnus had a post
on gin/gist wrt the postgresql.org website.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
The Postgres docs are great. Unfortunatelty, at 1600 pages, my printer is a
little weary. Are bound & printed editions available? If not, has anyone
had any good experience printing them via any of the online services? (The
ones I contacted said it was too big for them to print...)
Also: woul
uery? If I have a variable
called 'myfields' and try to place that in my SELECT query, it thinks
there is a field named myfields, of course. Maybe a way to evaluate the
comman sepeated list? Thanks in advance for any help! Or suggestion for
a better way to develop user saved s
Excellent!
Two questions:
1. Might it be better to include the index and TOC (in both volumes), and do
something like this:
http://www.postgresql.org/files/documentation/pdf/8.2/postgresql-8.2.1-US.pdf
Vol I: 1-621, 1674-end
Vol II: 1-38, 622-1395, 1672-end
(Dropped some other things, I think...)
Is there anyway to tell if the records in a union came from the 1st query or
the second?
Can I modify the individual queries to let me know this?
Is there anyway to install contrib (fuzzystr) so it's available to all
databases (even ones created previously)?
thanks
an include a list of what exactly is included in each
volume - (Example: Volume II is TOC, Reference, and Index, pages 1-35,
503-912, and 1651-end of http://postgresql.org/...original.pdf)
http://www.lulu.com/iharding
Now in 3 Volumes!
On 5/17/07, Robert James <[EMAIL PROTECTED]> wrote
1. Is there anyway to give a role privs on a certain table, delete that
table, recreate it, and have those privs persist?
2. Is there anyway to give a role privs to all tables in a database, without
having to name each one individually? Can I use this to apply to tables
created later on?
Anyone have an implementation of the Jaro Winkler fuzzy string matching algo
for Postgres?
* http://en.wikipedia.org/wiki/Jaro-Winkler
* http://forums.oracle.com/forums/thread.jspa?threadID=385950&tstart=0
It's rumored to (sometimes?) work better than the Levenshtein algo included
in contrib/fuz
I use a set of DDL scripts to automatically create the database for an app.
I need to create certain functions (from contrib), if they're not there
already. If they are there, I don't want to DROP or REPLACE them, since
they may be used in certain indexes and triggers.
Is there a way to only CR
tyTag.fldcontactnumber = b.fldcontactnumber AND
tblClientActivityTag.fldcontactactivitytag like 'A%' AND
b.fldcontactnumber in (select fldcontactnumber from tblclientcomments where
tblclientcomments$
A.fldEnable = 't' AND B.fldEnable = 't'
ORDER BY A.fldClientName, B.
On Sat, 2007-05-19 at 17:05 -0400, Tom Lane wrote:
> Robert Fitzpatrick <[EMAIL PROTECTED]> writes:
> > I am running the following query on a linux server with comparable
> > processor and memory as the windows server.
>
> Show us the table definitions and the EXP
analysis! It is my first migration from another
SQL database.
--
Robert
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
tactinfo"
USING btree ("fldcontactcity");
CREATE INDEX "ix_tblcontactinfo_fldcontactstate" ON "public"."tblcontactinfo"
USING btree ("fldcontactstate");
CREATE INDEX "ix_tblcontactinfo_fldperscomments" ON "public"
On Tue, 2007-05-22 at 17:21 +0100, Richard Huxton wrote:
> Robert Fitzpatrick wrote:
> > I have developed a view in pgsql that takes over 160K ms to execute, but
> > when copied into MS SQL against the old database (with syntax mods of
> > course), runs in a few seconds.
>
ing mssql db. The query comes
back with results using MS SQL Enterprise Manager in seconds and the
same query in pgadmin takes super long. I just tried running the query
now and it is still going with over 200K ms clocked. If I stop the
query, remove all references to tblcont
On Tue, 2007-05-22 at 13:10 -0400, Tom Lane wrote:
> Robert Fitzpatrick <[EMAIL PROTECTED]> writes:
> > On Tue, 2007-05-22 at 17:21 +0100, Richard Huxton wrote:
> >> Your query seems to produce 41.8 million rows. Are you sure MS-SQL is
> >> returning that man
fers
32MB, no defaults changed except listen_addresses. How can I check
work_mem and effective_cache_size?
--
Robert
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
On Tue, 2007-05-22 at 14:30 -0400, Robert Fitzpatrick wrote:
> On Tue, 2007-05-22 at 19:03 +0100, Richard Huxton wrote:
> >
> > Hmm... How much of your machine is PG getting to use vs. MS-SQL? What
> > are your shared_buffers, work_mem, effective_cache_size (and how much
On Tue, 2007-05-22 at 20:13 +0100, Richard Huxton wrote:
> Robert Fitzpatrick wrote:
> > I did some googling and came up with some ideas, I have it now with
> > these settings and after restarting PG, no help.
> >
> > work_mem = 5MB
>
> My last post missed yo
too much.
--
Robert
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
o many rows. Of course, I will not want all those rows,
but I can't get it to respond to queries. Meanwhile, I can create a view
with just the comments table joined to clients, while the count is over
1 million records, select statements execute quickly.
Is TSearch for me? Thanks
On Wed, 2007-05-23 at 19:48 -0400, Robert Fitzpatrick wrote:
> On Wed, 2007-05-23 at 18:53 -0400, Ericson Smith wrote:
> > Yeah, we've used Tsearch with joins and searches on other fields on
> > the tsearch table no problem. Tsearches are just another part of a
> > WHERE
le
'%'.
I was hoping not to have to test every field in the table.
--
Robert
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
On Fri, 2007-05-25 at 11:17 -0400, Robert Fitzpatrick wrote:
> But if they use an asterisk in any combination
> with other fields
I meant to say 'But if they use an asterisk in any combination with
other *values* in the field...'. For instance, if they enter '*test*',
On Fri, 2007-05-25 at 12:00 -0400, Alvaro Herrera wrote:
> Robert Fitzpatrick wrote:
> > How can I reference any NEW field in an insert/update trigger function?
> > When someone inserts or updates any field with a single asterisk (*), I
> > need it to become '%%%'.
On Fri, 2007-05-25 at 13:45 -0400, Alvaro Herrera wrote:
> Robert Fitzpatrick wrote:
>
> > But still, how would I reference all fields using the pl/perl? Can I
> > specify column numbers versus names as in '$_TD->{new}{1}' for the first
> > column and loop or
them...
http://cc.uoregon.edu/cnews/spring2000/outliers.html
--
Robert
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
eeds... though I
should say that PostgreSQL has tremendous ability to scale up even
without getting into all the buzzword friendly schemes.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
ausing the need for it since I spent many hours to finally find the
answer. No one on the PHP list seemed to know.
--
Robert
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail comman
IRCLE
A| 7815/7817 SOCIAL CIRCLE
A| 7825/7827 SOCIAL CIRCLE
A| 7833/7835 SOCIAL CIRCLE
I would like all those on the same street grouped together. Is there any
tricks to getting the street names sorted first, possibly where numbers
and strings separ
I searched through the net quickly and the list archives, but could not
find anything doing this. Is it possible? There is a Perl module for
doing this, but I guess cannot use modules for security reasons.
--
Robert
---(end of broadcast)---
TIP 2
: ""
> >
> > My input file has the timestamp value like
> >
> > 2004-09-30 11:31:00.000
> >
What about the ".000" on the end? I am not able to enter that format in
a timestamp field in 7.4.5, it is invalid.
--
Robert
--
s of the software in the past, and would not presume to know when
others won't want them in the future. We keep a link to "latest" in the
main directory, and I'm willing to believe most people are capable of
figuring out which is the latest 7.3.x branch on their own (at least
u
I missed the original post, but I think you both might want to do some
googling on nested set.
Robert Treat
On Tue, 2004-11-09 at 11:40, Garris, Nicole wrote:
> We've actually implemented this kind of thing in a different DBMS. The
> physical design consists of a single "org
What does it mean when you drop a database and then recreate with the
same name and all the objects are still there. I want to wipe out the db
and put back from pg_restore. After I re-create the db, all the old
tables are back before I run pg_restore.
--
Robert
---(end
On Thu, 2004-11-11 at 14:03, Doug McNaught wrote:
> Robert Fitzpatrick <[EMAIL PROTECTED]> writes:
>
> > What does it mean when you drop a database and then recreate with the
> > same name and all the objects are still there. I want to wipe out the db
> > and put ba
ecific questions if you have
any, there are a number of oracle converts floating about.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
R: cannot update a view
HINT: You need an unconditional ON UPDATE DO INSTEAD rule.
Thanks,
--
Robert
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
On Wed, 2004-11-17 at 11:49, Michael Fuhr wrote:
> On Wed, Nov 17, 2004 at 11:20:41AM -0500, Robert Fitzpatrick wrote:
>
> > I have a view that used union all to merge three tables together. I was
> > hoping to create a rule, one for each table using the WHERE condition
701 - 800 of 1119 matches
Mail list logo
