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 real
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 -
Hi All
VACUUM ANALYZE;
return me the next error:
pqReadData() -- 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.
Any ideas ?
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]
Subj
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 CustomerI
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 ac
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 get
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 go
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
>
> VA
> 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 PR
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 IN
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 s
15 matches
Mail list logo
