Thank you for your reply, the procedure code (which I posted in the original
post) already utilizes the Execute statment.
Here is the weirdest thing. The error only occurs in the query window
that I originally wrote the code in. If I open another query window
(I'm using PGAdmin III), I can run th
On Sat, 15 Oct 2005, Joshua D. Drake wrote:
This is what Lubet, former Oracle sales mistress, has
to say about that: "I'm pretty sure, as an ex-Oracle
employee, that the sentence in the release about
'We'll certainly be happy to renew the contract,' that
it was written by Larry and that he wa
[EMAIL PROTECTED] writes:
> Postgres 7.2.1 (Debian woody)
This bug has been fixed since 7.2.2 ...
2002-06-15 14:38 tgl
* src/backend/utils/adt/ruleutils.c (REL7_2_STABLE): Back-patch 7.3
fix to fully parenthesize UNION/EXCEPT/INTERSECT queries in
ruleutils output. The p
On Fri, 2005-14-10 at 09:43 -0400, John D. Burger wrote:
> I believe these queries are exactly equivalent, but I presume the
> planner doesn't know that.
> explain select gazPlaceID from gazPlaces
> where gazPlaceID not in (select gazPlaceID from gazContainers);
> explain select gazPlaceI
Andrew Sullivan wrote:
On Fri, Oct 14, 2005 at 10:20:41AM -0500, Scott Marlowe wrote:
USers accessing machines behind the scenes is a VERY bad idea. It's not
a pgpool bug, is a user bug. :)
The problem with this glib answer is that we are talking about
systems where such a "user bug
Greg Stark wrote:
Tom Lane <[EMAIL PROTECTED]> writes:
If you write, say,
select max(relpages) from pg_class;
and the lexer thinks that it should fold unquoted identifiers to upper
case, then the catalog entries defining these names had better read
PG_CLASS, RELPAGES, and MAX, not
You can use a signed type with a CHECK constraint to restrict thecolumn's value to positive integers.
The sign doesn't concern me. I am storing a value that is unsigned and
16 bits wide natively. I'll have to just use an int4 and waste twice
the space I actually need.
Hi!
I'm having some difficulties using postgresql version 8.0.x with heimdal
installed from /usr/src (i.e. the base system). This is on FreeBSD-5.x.
When using the port of heimdal, from /usr/ports/security/heimdal, it works.
The port install into /usr/local, whereas the base system is in /usr
On Fri, Oct 14, 2005 at 01:24:05PM -0700, Joshua D. Drake wrote:
>
> > MySQL has a nice set of reference customers (MySQL AB's claims
> > include Google, US Census Bureau, Yahoo, Sabre, CERN, NASA, Associated
> > Press, Macys, Cox, Cable&Wireless, Nokia, Cisco, Sony, etc) - along
> > with a proven
pg_dump handles table ordering properly.
On Fri, Oct 14, 2005 at 10:24:55AM -0500, Dan Armbrust wrote:
> Jim C. Nasby wrote:
> >Since no one else has mentioned it, there has been discussion this week
> >on one of the lists (probably -general or -hackers) about expanding the
> >capabilities of pg_d
Title: Question/problem with create view and restore a backup with such a view
Hello,
i have following situation:
Postgres 7.2.1 (Debian woody)
I created a view (look into the attached file, the file was converted with nedit from unix to windows )
and if I paste it into psql it works.
Tom Lane wrote:
> Although ... it's true that there seem to be very few apps relying on
> case sensitivity per se, ie, expecting "Foo" and "foo" to be
> different. The complaints that I can remember were about programs
> that expected "FOO" and FOO (not quoted) to be the same. So
> always-smash-to
On Sat, 2005-15-10 at 16:42 -0400, jeff sacksteder wrote:
> It occurs to me that I don't know how to define unsigned integer
> datatypes. I'm making a schema to describe network packets and I need
> columns to contain values from 0-255, etc.
>
> I can't seem to find any documentation on this. What
On Oct 16, 2005, at 5:42 , jeff sacksteder wrote:
It occurs to me that I don't know how to define unsigned integer
datatypes. I'm making a schema to describe network packets and I
need columns to contain values from 0-255, etc.
I can't seem to find any documentation on this. What's the bes
It occurs to me that I don't know how to define unsigned integer
datatypes. I'm making a schema to describe network packets and I need
columns to contain values from 0-255, etc.
I can't seem to find any documentation on this. What's the best prectice for this situation?
This thread should continue under the proper title
since it's been hi-jacked .
I didn't read your entire post. If you know how to
join a pk and fk it's not difficult to build an
effective diagram on paper and reuse the same schema
for other applications.
> > I think there really is a need for a
On Oct 13, 2005, at 12:00 PM, Alex Turner wrote:
>
>Instance Manager: Uniquely MySQL. It allows things like starting
and
>stopping the database remotely.
>
>
I cannot think of a reason ever to need this when we have OpenSSH
I'm just curious, but how does this work for a windows bo
Martijn van Oosterhout writes:
> The main problem I see is that the most people who are complaining are
> people who create their tables as "MixedCaseQuoted" and then refer to
> them as Unquoted. Even following the SQL standard precisely will not
> fix this, given that behaviour is non-standard al
This is what Lubet, former Oracle sales mistress, has
to say about that: "I'm pretty sure, as an ex-Oracle
employee, that the sentence in the release about
'We'll certainly be happy to renew the contract,' that
it was written by Larry and that he was laughing out
loud as he [dictated it]."
Ma
Andrew Sullivan wrote:
On Fri, Oct 14, 2005 at 01:02:00PM -0700, Ron Mayer wrote:
I'd suspect that any single postgresql-support company that had a
similar customer list would get offers from Oracle as well
PostgreSQL support companies don't have the leverage that Oracle and
MySQL do to get t
> Hi all,
> I am trying to create an installable for my metalscan java
> application. Here are the specs:- I have created the
> installable using GKsetup(Gkware.com) a third party tool. I
> am using Postgresql 8.0.2 as my database for my Java
> application(metalscan). When the setup executable
On Fri, Oct 14, 2005 at 09:43:57AM -0400, John D. Burger wrote:
> (By the way, gazPlaces.gazPlaceID below is a primary key, so should be
> unique - I think that's required for these to be equivalent. I tested
> the two queries on small data sets, and they do indeed return the same
> results.
> This error is shown after choose the language in the
> installation of Postgresql 8.0.3 in windows 2000:
>
> "The installer has detected an incompatible version of
> OpenSSL installed in your system PATH. PostgreSQL requires
> OpenSSL 0.9.7 or later. If you remove your OpenSSL files
> (LIBEA
On 10/15/2005 6:22 AM, Thomas Beutin wrote:
Maybe they lost the development of the know how for the only transaction
safe table type of the current mysql releases, but they still "own" the
former Adabas/MaxDB/SAP-DB code with transaction safe tables. Probably
they force the "union" of mysql an
Johan Wehtje wrote:
I doubt you read the rest of the post otherwise I don't think you
would make that comment.
Personlly I think you were right. Access is a good front end, at least
in the sense that it is a hell of a lot better
than anything the OSS community has bothered to come up with. I
On Fri, Oct 14, 2005 at 10:34:53AM -0400, Jan Wieck wrote:
> On 10/13/2005 2:40 PM, Tom Lane wrote:
> >Since the end reward for all this work would be having to read CATALOGS
> >WRITTEN IN ALL UPPER CASE, none of the key developers seem very
> >interested ...
>
> Just an idea ...
>
> if the relea
I doubt you read the rest of the post otherwise I don't think you would
make that comment.
I think there really is a need for a rich DB client that allows Rapid
development and is easy to link to an office Suite. To be useful to a
business a database needs the applications built on top of it,
Hi all,
suppose that I want to allow one user local access to
template1 under the database account postgres (which is the
superuser for my PostgreSQL). pg_hba.conf contains this:
local all postgresident sameuser
I would then set up pg_ident.conf like this:
postgre
CSN wrote:
There are some articles on eweek about this:
Oracle Finds the Flaw in MySQL's Business Plan
http://www.eweek.com/article2/0,1895,1869989,00.asp
"This is what Oracle says in its release: "InnoDB's
contractual relationship with MySQL comes up for
renewal next year. Oracle fully expects
Someone trying to stick microsoft yet another place
they don't belong.
--- Johan Wehtje <[EMAIL PROTECTED]> wrote:
> Very much a description of the Business I am in.
>
> For all the criticism leveled at it, I still think
> that as a rich
> Database Client that permits really rapid
> developme
Very much a description of the Business I am in.
For all the criticism leveled at it, I still think that as a rich
Database Client that permits really rapid development of Database driven
applications Access is unbeatable. Pair it with a good Database server
and it is the perfect combination.
31 matches
Mail list logo