Hi,
i asked some question about this topic few weeks ago, but i am still
thinking about good application design with postgresql.
good apps have three components:
- frontend (like html, gui, psql etc.)
- middleware (Objectorientated modules)
- backend (postgresql)
But then i thought: Do i
On Mon, Jul 02, 2001 at 11:52:47PM -0700, Pieter Vissenberg wrote:
The postmaster seems to be running smoothly (psql session works
fine). However when I try to connect to the database via Apache
with PHP, I get an errormessage in the style of 'pconnect()
failed. Is the postmaster (with -i)
Tom... you are totally right. We had version 7.03 installed - which
didn't support OUTER hence we couldn't figure this thing out!
Many thanks to all!
Jeff
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: 11 July 2001 00:32
To: Jeff Rhys-Jones
Cc: [EMAIL PROTECTED]
Yup! This is what I ended up using, (couldn't retract my email fast
enough...);
% rs = st.executeQuery(SELECT DISTINCT CustomerID, Username, Password,
Email FROM Customer WHERE NOT EXISTS (SELECT Registration.CustomerID WHERE
(Registration.CustomerID = Customer.CustomerID)) ORDER BY
On Tue, Jul 10, 2001 at 09:40:31AM +0100, Mark Muffett wrote:
Is there a Postgresql equivalent to the Oracle NVL( ) function,
which allows a SELECT statement to fill in default values if a
column is NULL?
Yes.
Use the DEFAULT keyword while creating the table.
That is:
CREATE TABLE
Matt,
Thank you for the feedback!
I, too, am not a guru. Indeed, I'm so far from guru-hood that I'm not
even clear on why it is that you need anything more complicated than a
SELECT.
Well, this may be exactly what we need, since a view is basically just a
SELECT statement. It's just
This is because of the way Access works, and the way it tries to be extra
friendly. When you go to change the text box source, it wants to contact the
back end so that it can get a list of valid choices for you to choose from, and
to validate your choice so you don't type something in that's
Did you change the names or structures of your tables?
If you've left your structures the same, you should be
able to replace the Access tables with ODBC links with
the same names without changing forms, queries,
reports, etc. This assumes, of course, that you
didn't create Visual Basic code in
What version are you using, and what does your postgres
log show? There's probably more information there.
- Original Message -
From: Ben-Nes Michael [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 17, 2001 5:02 AM
Subject: [GENERAL] VACUUM ANALYZE
Hi All
VACUUM
How can you get a listing of foreign keys to a table?
We haven't figure out a good way yet. The pg_depend discussion on
hackers may lead to a solution if we evern implement it.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610)
will trillich writes:
in the old days (7.0.3) i could list databases via
psql -l
but these days (7.1) i must
psql -l [-d] nameOfADatabaseFromPreordainedKnowledge
probably because of some fuxnored setting. but which?
Evidence please?
--
Peter Eisentraut [EMAIL PROTECTED]
On Wed, Jul 04, 2001 at 02:56:06PM +0100, Richard Huxton wrote:
From: Johan Björk [EMAIL PROTECTED]
Have a little problem with bit operaitions that I cannot find the answer
to on the Internet. Have been searching through the archives but no result.
In MySQL you can have a INT column and
Hello PG's,
I want to extract the weekday of a given 'date' type field in my table
when selecting. How can I do this?
For example in a table bschft_days filled with values with type 'date'
I want to select all the days within the month 'march' and output the respective
weekday. I tryed this:
On Tue, Jul 17, 2001 at 09:26:02PM +0200, Peter Eisentraut wrote:
will trillich writes:
in the old days (7.0.3) i could list databases via
psql -l
but these days (7.1) i must
psql -l [-d] nameOfADatabaseFromPreordainedKnowledge
probably because of some fuxnored
14 matches
Mail list logo