If that's true, then termcap-devel should probably be added to the SRPM
dependencies. Isn't the RPM maintainer on this list? (wink wink)
Wes
Mike Mascari <[EMAIL PROTECTED]>@postgresql.org on 06/24/2003 03:32:22 PM
Sent by:[EMAIL PROTECTED]
To:Paul Ramsey <[EMAIL PROTECTED]>
cc:
You need a left outer join:
select name, count(sales.client_id) from clients left outer join sales on
sales.client_id = clients.id group by name;
Outer joins were not supported prior to 7.1, so if you're using an earlier
version, you'll want to either upgrade or read the docs for your version;
What was wrong with JDBC::ODBC? I don't use Java, but I thought this solution
was out there for a while already? Just not db-specific enough for them?
tony <[EMAIL PROTECTED]> on 09/26/2001 04:09:32 AM
To: postgres list <[EMAIL PROTECTED]>
cc:(bcc: Wesley Sheldahl/Lex/Lexmark)
Subje
One of the things on the TODO list at jobs.perl.org is to make it "themable,"
with jobs.apache.org given as an example. Perhaps a jobs.postgresql.org could
be set up in conjunction with them?
Wes
"Roderick A. Anderson" <[EMAIL PROTECTED]> on 09/07/2001
10:42:42 AM
To: [EMAIL PROTECTED]
For one specific label:
select TableB.label from TableA, TableB where TableA.idA=TableB.idA and
TableA.name='test2';
To get a list of name-label pairs:
select TableA.name, TableB.label from TableA, TableB where TableA.idA=TableB.idA
order by TableA.name, TableB.label;
"G.L. Grobe" <[EMAIL
Thanks; that's just what I needed. I'm glad you mentioned needing to
double-quote the trigger names!
Just in case anyone else needs to do this before they get DROP CONSTRAINT
support, I got the trigger names with:
select tgname, tgconstrname from pg_trigger where
tgconstrname='name_of_my_fore
Does it help if you drop and recreate the indexes, in addition to the vacuuming
you're doing now? I think this was suggested not long ago on this list.
Erwin Lansing <[EMAIL PROTECTED]> on 08/14/2001 04:38:59 AM
To: [EMAIL PROTECTED]
cc:(bcc: Wesley Sheldahl/Lex/Lexmark)
Subject: Re
I think someone pointed out not long ago that that naming convention isn't
always 100% reliable. How about creating the sequence dynamically (using that
naming convention even), then create the table dynamically and have it
explicitly use the sequence you just created. That way you *know* the
Why do you need to change the value of the id field?? The id field shouldn't
have any meaning attached to it beyond the fact that it uniquely identifies a
row in the table, and of course its usage as a foreign key when it serves that
role. If you just want to change what numbers get assigned,
For that matter, you could write a perl function using perl's built-in crypt()
function. I'm not sure if it's exactly identical to what mysql does, though I
strongly suspect that it is.
Philip Hallstrom <[EMAIL PROTECTED]> on 07/23/2001
02:13:27 PM
To: Jason DiCioccio <[EMAIL PROTECTED]>
Drop the semicolon at the end of the string. In this context, it's not needed
to tell where the end of the statement is.
You might want to use a parameterized stored procedure that does multiple
updates inside a transaction. You would invoke the stored procedure via
mdb.Execute, as per your e
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
I think there should be a Postgres Features section. It might be nice to have a
concise comparison chart comparing its features with, for instance, MySQL, SQL
Server 2000, Oracle, and any others that come up often in questions. The
comparison chart should be frank while still unabashedly highl
It looks like they aren't quite ready for a full release yet, and may not even
be ready to save changes made to the table schema, based on what I read at
http://dbdesigner.sourceforge.net/. It does look promising though.
Bruce Momjian <[EMAIL PROTECTED]> on 07/12/2001
05:39:29 PM
To: Morg
The list looks fantastic. I'm now looking forward to this release. Sounds like
it's planned for just 6-9 months after the 7.1 release, or thereabouts? Good
agressive schedule.
I would like to request one more feature of course: support for ALTER TABLE
tablename MODIFY columnname [create cla
So does this impact Postgresql's performance on Windows as well? I think Apache
had to rewrite their Windows port to use threads instead of processes before
they got decent performance on that platform. Any chance of Postgresql doing
that sort of thing? Not that I'm asking for the change; I'd
I agree. How is a person supposed to count the number of users if the database
is being used to support a public dynamic web site? Is the company supposed to
buy a separate license for every unique IP address that ever hits a dynamic web
page on the site? I can see licensing per server, or ev
Hi,
Has there been any substantial change in the way large objects are handled with
the coming of 7.1 and the expanded row size limit? Some old online articles
suggested that would change things, but the current docs seem say I still need
to use functions like lo_import.
Assuming things haven
That limit can also be raised by changing a constant and recompiling Apache;
8190 is just the default. Check the online docs for LimitRequestLine at
httpd.apache.org.
"Bryan White" <[EMAIL PROTECTED]> on 06/25/2001 02:59:30
PM
To: "Frank Hilliard" <[EMAIL PROTECTED]>,
"psql-general
19 matches
Mail list logo
