Just a reminder that this is taken care of. It only WARNs in cases
where we suspect they really made a mistake.
test=> select * from pg_class s where pg_class.oid =34;
NOTICE: Adding missing FROM-clause entry for table pg_class
> Bruce Momjian <[EMAIL PROTECTED
() -- backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally
> before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.
>
>
> alex
>
>
--
Bruce Momjian
HJhjaJ023J19KJAqp'
>
> It is not currently possible to alias EMPLOYEES
> so that the test can become
>
> E.EMPLOYEE_ID = UU.EMPLOYEE_ID
>
> Do the guru's think that this would be hard to add? Also,
> is it desirable?
> --
>
> table, per-table sequence values look like a better bet.
>
> Somebody (urgently) needs to tell all of the above to Bruce
> Momjian (I've cc'd him); his book-in-the-making points up
> OID's as a convenient and universal way to identify and link
> tuples (chapter 7
gt; > > method, then there isn't really a problem even if I do
> > use
> > > OIDs as a primary index. None of my OIDs still in use
> > will
> > > be touched.
> >
> >
> > No, it uses all oids, and can create duplicates.
>
&
t; and data management solutions (415) 436-9166
>for law firms, small businesses fax 436-0137
> and non-profit organizations. pager 338-4078
> San Francisco
>
--
Bruce Momjian| http://candle.ph
eve there is an item on the
> TODO list about upgrading the regexp parser to something more modern
> ... feel free to hop on that project if it's bugging you ...
I bug Henry Spencer regularly. His new code is in TCL/TK, but has not
been released into any other code.
--
Bru
; More code
>
> -Josh
>
> --
> __AGLIO DATABASE SOLUTIONS___
> Josh Berkus
>Complete information technology [EMAIL PROTECTED]
> and data management solutions (415) 436-9166
>
Net yet.
[ Charset ISO-8859-15 unsupported, converting... ]
> Hi,
>
> Just out of curiousity, does Postgres support nested transactions?
>
>
> - Bernie
Content-Description: Card for Bernie Huang
[ Attachment, skipping... ]
--
Bruce Momjian
gt; http://www.postgresql.org/lists/mailing-list.html
>
> Dunno how to get there from the site toplevel...
>
> regards, tom lane
>
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
e (developer
> and user). Don't get too attached to the url below, it will be going
> away very soon.
Oh, I see it now. Thanks.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive,
IF FOUND
> THEN
> RETURN ''f'';
> ELSE
> INSERT INTO USERS(username,password)
> values(USR,PWORD);
> RETURN ''t'';
> END IF;
>
> END;'
> LANGUAGE 'plpgsql';
>
> Regards.
> Najm
>
>
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup.| Drexel Hill, Pennsylvania 19026
sample || '%');
> > ERROR: parser: syntax error at or near "||"
>
> I seem to recall that || (and most other operators) wasn't
> considered associative by the grammar way back when.
> Try a fully parenthesized expression:
Yes || had strange problems in t
rporate support is mostly for serious PostgreSQL
users, not new people.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup.| Drexel Hill, Pennsylvania 19026
Utah State University
> Space Dynamics Laboratory Web Developer
> USU Free Software & GNU/Linux Clubhttp://fslc.usu.edu
> My home page - http://www.brasileiro.net/roberto
>
>
> ________
> Get yo
ique index on that column.)
I assume the user is concerned about non-balanced btrees. Ours are
auto-balancing.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup.| Drexel Hill, Pennsylvania 19026
; May be version 7.0.3 will give a better result.
The larger problem is that count(*) doesn't use the index at all. It
just does a sequential scan of the heap table.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
gt; Thanx,
> Mike Diehl.
>
>
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup.| Drexel Hill, Pennsylvania 19026
nce ... but I thought the
> Award was definitely up there already ...
Looks OK here. Maybe a bad mirror. Do:
http://www.postgresql.org/index.html
to avoid any mirrors.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 8
gt; frustrating!
Sure, chapter 9 has it. See the online version. There is a huge table,
though currval is mentioned in the sequences chapter because it is not
like normal functions.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 85
t; from ver. 6.5.
It does, or only the standard SQL functions? Do they have
PostgreSQL-specific stuff.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup.| Drexel Hill, Pennsylvania 19026
tement but I can't recall it... Help me please before I get
> myself get fired -:).
> Regards, Najm
>
>
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe A
> Hello,
>
> I do not see how it puts the Postgres community in a bad light, although I
> do see how the author is a moron.
Many of use fell is puts Linux in a bad light. :-)
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED]
> Hello,
>
> I am the Webmaster of the LDP... What should I know?
OK, just read a little bit of it. After you stop laughing, come on back
and we can talk. :-)
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-300
ers
him from the 386BSD Usenet groups.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup.| Drexel Hill, Pennsylvania 19026
---
> > > >Name: my2pg.pl
> > > >my2pg.plType: Perl Program (application/x-perl)
> > > >Encoding: base64
> > >
> > >
> > > thats cool!!
> > &
ng, supports MySQL ENUMs, near the end
> are SET emulation. Please help me to test.
>
> Max Rudensky.
>
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
> Is it possible to use the statements INNER JOIN, OUTER JOIN, LEFT JOIN
> and RIGHT JOIN in the new version of PostgreSQL 7.1 ?
Yes in 7.1beta. See FAQ 'outer' entry for a short description.
--
Bruce Momjian| http://candle.pha.pa.us
r than 6.5.3.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup.| Drexel Hill, Pennsylvania 19026
sgml file, and this example query is
no longer in the file. Not sure why it was removed, but it will not
appear in 7.1.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup.| Drexel Hill, Pennsylvania 19026
rly documented, the only way i found to figure out
> its capabilities were to scour the mailing lists, the openacs code, and the
> plpgsql implementation source. any attempt to better this documentation would
> IMO, be a worthwhile effort.
I have added PL/PgSQL to the open 7.1 docs li
erl, PL/Tcl?
> >How do variable scopes work in PL/PGSQL?
> >Can I output variables from a function to the command line for debugging
>purposes?
> >How to debug PL/PGSQL?
> >Various examples for each of the statements
>
>
no information whether
> the query succeeded.
>
> Is someone maintaining the C++ interface and its documentation?
>
>
> Thanks,
>
> Volker Paul
>
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup.| Drexel Hill, Pennsylvania 19026
there is no guarantee which rows will be returned. You may get
the rows you want, or you may not. Without the ORDER BY, the backend
can return any five rows it wishes.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
do "col > 12" you may get
it in index order by the column indexes, or you may not, depending on
the constant, the size of the table, vacuum, vacuum analyze, etc.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
m.ropnum = l.ropnum
> and m.inum = l.inum
> and m.minum = l.minum
> and m.bminum = l.bminum) as lquant,
> (select p.base||'('||p.parm||')' from prd_part_v_base p where
> p.pnum = m.pnum) as pname,
>
eries section titled
"NOT IN and Subqueries with NULL Values".
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup.| Drexel Hill, Pennsylvania 19026
bad idea for any subselect on
> medium-large tables.
FAQ item mentions this, and section 8.2 shows eqivalency at the end of
the section.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, |
http://fslc.usu.edu
> My home page - http://www.brasileiro.net/roberto
>
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup.| D
lect random();
random
---
0.896045367650709
(1 row)
However:
test=> select * from pg_class order by random();
does return some output. Is it random, and if so, how?
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED]
Network for Strategic Missions
> [EMAIL PROTECTED] 1732 South Park Court
> http://www.strategicnetwork.org Chesapeake, VA 23320, USA
> Reality Check e-zine: [EMAIL PROTECTED]
> ____
> Law: Never retreat. Never surrender. Never cut a deal with a dr
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> >> Jelle Ouwerkerk <[EMAIL PROTECTED]> writes:
> > Also, is there a way to randomize the order of a result set?
> >>
> >> There's always
> >> SELECT * FROM foo ORDER BY random();
>
&
Yes.
> On Mon, Mar 05, 2001 at 04:07:57PM -0500, Bruce Momjian allegedly wrote:
> > Have you tried VACUUM ANALYZE and CLUSTER?
>
> I assume CLUSTER still drops all indexes except the one you're clustering
> on?
>
> Mathijs
> --
> It's not that pe
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > But random returns a random value from 0-1, right? How does that work
> > in ORDER BY?
>
> What's the problem? Each row gets a different random value, then we
> sort.
Oh, I see. Nifty. I am used to seeing
>
>
> there is one in contrib
>
> as well there is some through freshmeat.net
There are two in /contrib. One from pgsql.com, and another from
freshmeat.net:
http://ziet.zhitomir.ua/~fonin/code/
I would like to see these merged someday.
--
> Is it default higher in 7.0?
Yes.
>
> What is the most stable 7.X release?
7.0.3
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Ch
> On Wed, Mar 14, 2001 at 10:33:49AM -0500, Bruce Momjian wrote:
> > It is hard to test this without the table schema, but I think you are
> > missing some END IF's in the code above. Those are not elif's, but
> > actual new IF's that need their own END IF, I
up_artifact_id=new.group_artifact_id;
> END IF;
> END IF;
>END IF;
>RETURN NEW;
It is hard to test this without the table schema, but I think you are
missing some END IF's in the code above. Those are not elif's, but
actual new IF's that need their own END IF
> Bruce Momjian writes:
>
> > There is a PL/PgSQL HowTo that we are trying to integrate into the docs
> > for 7.1. Anyone have a URL or status on that?
>
> It's not a PL/pgSQL Howto, it's just a documentation how to port from
> Oracle's PL/SQL. T
erfect format for learning/cut & paste.
I am told that the cookbook has been merged into the 7.1beta docs.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
that it's worth it... it seems to inconvenience some
> people either way. I may soon be moving a moderately complex system
> from MySQL to Postgres and it wouldn't be the end of my world if
> I had to reverse all the LIMITs.
>
> Richard
>
> ---(
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Is this a TODO item? Seems we should match MySQL, seeing as we took the
> > feature syntax from them.
>
> Question is, will more people be inconvenienced if we change it than if
> we leave it alone? Seems like s
Daryl Herzmann
>
>
> ---(end of broadcast)-------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
--
Bruce Momjian| http://candle.pha.pa.us
to the person as well as CC to the list when the
> person is on the list anyhow?
Good question. They get the reply faster by sending it to them and the
list, and if someone later wants to reply only to the poster, they have
the email address right there.
--
Bruce Momjian
mode. Reply to
user goes only to the poster, while reply-to group goes to both.
At least that is how I understand the issue.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard
(eNTP) | what's for dinner.
>
> ---(end of broadcast)-------
> TIP 4: Don't 'kill -9' the postmaster
>
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610
]
I personally think we could do better on the wording of that error
message, at least until we get it fixed.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Chri
at serial is implemented in such a way that race conditions between
> DB connections can't happen.
>
> Is this true?
Safe. See FAQ item. currval is for your backend only.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] |
p of my head, you might try a view with a select rule,
> > although I'm not completely clear what your objectives are.
> >
> > - Richard Huxton
> >
> >
> > ---(end of broadcast)---
> > TIP 1: subscribe
FYI, I am always looking for additional examples that I should add in
the next edition.
> Yes: good example! I keep a printed copy on my desk... :-)
>
> > -Original Message-
> > From: Bruce Momjian [SMTP:[EMAIL PROTECTED]]
> > Sent: Tuesday, March
t; the empty row.
>
> Thanks, it is getting clearer
You really can't use sequences with no gaps. Sequence numbers are not
_held_ until commit because it would block other backends trying to get
sequence numbers.
--
Bruce Momjian| http://candle.pha.p
members of a class.
That is on the TODO list, so I think we want it to happen.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ c
> Does PostgreSQL currently support something like savepoints in Oracle?
No, sorry, but we know we need them.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Ave
---(end of broadcast)---
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3
test=> set enable_seqscan to off;
SET VARIABLE
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your back
>
It will appear in 7.1.1, to be released soon.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup.
moderately complex system
> from MySQL to Postgres and it wouldn't be the end of my world if
> I had to reverse all the LIMITs.
>
Added to TODO. If we took the feature from MySQL, seems we should match
it. This will require a clear notice in the release notes:
* Change LIMI
7293
> for law firms, small businessesfax 621-2533
> and non-profit organizations. San Francisco
>
> ---(end of broadcast)-------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister Your
appropriate
> subscribe-nomail command to [EMAIL PROTECTED] so that your
> message can get through to the mailing list cleanly
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830
ng the idea of ORDER BY in a view until someone suggested
LIMIT and ORDER BY, at which point we had to enable it. I think Tom did
the work.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard driv
> Josh - if I try and do OFFSET at the same time (presumably it's the same
> change) do you fancy acting as a sanity test site?
>
Both LIMIT and OFFSET seem to have that restriction. I will add this to
the TODO list.
--
Bruce Momjian| http://ca
f the loop, if a certain
> condition is met but I do not want to exit the loop all together. There
> doesn't seem to be functionality for that right now.
You want C 'continue' statement. Is that for Pl/pgSQL?
--
Bruce Momjian| http://candle.pha.pa.us
r for the string.
>
>
>
> ---(end of broadcast)-----------
> TIP 4: Don't 'kill -9' the postmaster
>
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853
ast for English
> words) than soundex, and levenshtein offers an entirely different and
> interesting approach. Any interest in having all three of these in the
> backend?
Sure.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610
>
See /contrib/soundex.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup.| Drexel Hill, Pennsylvania 19026
--
x27; || to_char(12,'x000') || ']';
> ?column?
> --
> [x 012]
>
> If you're running the current version, might be worth posting a bug report.
> You can work around it with something like:
>
> ... substr(to_char(t.tnumber,&#x
(1 row)
>
> The 'FM' removes the space.
So the FM is the correct way to do this, right? There is no bug?
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
nsubscribe commands go to [EMAIL PROTECTED]
>
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup.| Drexel Hill, Pennsylvania 19026
the logical place, right? I
don't see a huge advantage of putting it in memory. We could prevent
WAL writes for temp tables. That would help.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your li
> Could you help me?
>
> Thanks for your attention.
>
> Marcia Cunha
> Belo Horizonte , Brasil.
>
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Bly
hack) to get the oid the newly
> > inserted tuple will receive?
>
> Just set t_data->t_oid = newoid() - this is what backend does
> in heapam.c:heap_insert().
Does that work? Doesn't that get overwritten when the actual INSERT
happens?
--
Bruce Momjian
; "Table xxx with oid xxx doesn't exist"
Just name your temporary table the same name in every session. Why
bother with a view.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a
?"
>
> Thanks a lot.
>
> --
> green
> [http://www.extrasy.net]
>
> ---(end of broadcast)---
> TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
>
--
Bruce Momjian| http
My spam filter was misconfigured and I bounced back some messages I
shouldn't have. Sorry.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ c
> >>>>> "BM" == Bruce Momjian <[EMAIL PROTECTED]> writes:
>
> BM> CHAR() is best when storing strings that are usually the
> BM> same length. VARCHAR() is best when storing variable-length strings,
> BM> but you want to li
than duplicating the information.
>
> Frank
>
> At 08:56 AM 10/16/01 -0400, you wrote:
> >> >>>>> "BM" == Bruce Momjian <[EMAIL PROTECTED]> writes:
> >>
> >> BM> CHAR() is best when storing strings that are usually the
>
> Bruce Momjian wrote:
> >
> > > Hi
> > > I have simple question: How to create view on a temporary table?
> > > I need this, because pl/pgsql function returns data via temporary table.
> > >
> > > View created on a temporary table is usefu
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > Bruce Momjian writes:
> >> * Allow views on temporary tables to behave as temporary views
>
> > I don't think this is a good idea. Especially since our temp tables are
> > allowed to shadow persistent
> Bruce Momjian wrote:
> >
> > We can handle the temp views thing two ways, either allow views to map
> > to temp tables by name, or allow temp views to map to temp tables that
> > exist at creation time and drop the views on session exit. The original
> >
> Hello!
>
> I vaguely remember that someone said somewhere that
> EXISTS runs faster than IN:
>
> SELECT * FROM table1 where field1 EXISTS (SELECT
> field4 FROM table2)
Move field1 into the subquery and join it to table2. See the FAQ for an
example.
> -- a developer.
> --
> -- Regards,
> -- Baldvin
> --
>
>
>
> ---(end of broadcast)---
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to [EMAIL PROTECTED] so that your
> message can get thr
same length. VARCHAR() is best when storing variable-length strings,
but you want to limit how long a string can be. TEXT is for strings
of unlimited length, maximum 1 gigabyte. BYTEA is for storing
binary data, particularly values that include NULL bytes.
--
Bruce Momjian
Jan Wieck wrote:
> Bruce Momjian wrote:
> >
> > Wei Weng wrote:
> > > Between Using Limit P, S or using a cursor to start from FETCH ABSOLUTE
> > > S and FETCH NEXT for P times, which one is faster?
> >
> > LIMIT is faster because it doesn't
sure if it is the right number or not. Have you tried taking the
square root and see if that number is correct.
The docs say:
The variance is the square of the standard deviation. The
supported data types and result types are the same as for
standard deviation.
--
essages localization in 7.2. Not sure how to enable
it.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup.| Drexel H
gt; Can I do this in postgres?
>
> I'm using version 7.2 on a redhat server...
Sorry, you can't do cross-db queries with PostgreSQL. Take a look at
/contrib/dblink as an option.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (61
f an emergency, my ass can be used as a flotation
> device. - Bender
>
>
>
> ---(end of broadcast)---
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to [EMAIL PROTECTED] so that
It works, but only in CVS, not in 7.2.X. Marking something as done in
TODO only means it is done and will be in the _next_ release. Sorry.
---
Mark Frazer wrote:
>
>
> Bruce Momjian <[EMAIL PROTECTED]>
ql.org).
7.3 will have better docs on using it but you can see them now in the
developers docs:
http://developer.postgresql.org/docs/postgres/plpgsql-cursors.html
See the bottom of that page for examples.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL P
the cached function contents
still point to the old temporary table. The solution is to use
EXECUTE for temporary table access in PL/PgSQL. This
will cause the query to be reparsed every time.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED]
1 - 100 of 326 matches
Mail list logo
