Hey all – my inaugural post,
I have a Java web application on Tomcat 5 using
pg73jdbc3.jar to connect to PostgreSQL 7.3.4 running on the same server (Red
Hat Linux [8.0, I think]).
I have a Perl script that drops the database and rebuilds it
with all of our table/function/etc. scrip
PostgreSQL 7.4.2 ... The tables in question have been vacuumed.
...stepping gingerly into the woods of foreign keys... I need some advice:
Given a foriegn key structure:
table1.p1 uniqueidentifier
table2.p1 uniqueidentifier
table3.p1 uniqueidentifier
table4.p1 uniqueidentifier
table4.q1 uniqueid
We have a number of tables in a CRM that is written in MS access that I need
to be able to provide a web interface to. I can export the tables just fine
using pgadmin II, but I cant' think of a clean way to import them from
postgresql back to access. Synchronizing only needs to happen once a day
On Fri, Apr 30, 2004 at 01:01:25 -0400,
Tom Lane <[EMAIL PROTECTED]> wrote:
>
> Bruno Wolff III <[EMAIL PROTECTED]> writes:
> > No. You can do effectively this by joining a select nextval to whatever
> > you main select is. Something like:
> > insert into ...
> >select a.n as a, a.n as b
On 2004.04.29 22:21 Tom Lane wrote:
> "Parameters to a function can be composite types (complete table
> rows). In that case, the corresponding identifier $n will be a row
> variable, and fields can be selected from it, for example
$1.user_id."
That says that a parameter passed *into* a plpgsql f
El Vie 30 Abr 2004 11:16, Thomas LeBlanc escribió:
> What are the SQL commands to find who is logged on a server, what database
> he/she has open, etc?
>
> Where is this information in the help file or documentation?
select * from pg_stat_activity;
--
11:47:01 up 1 day, 17:09, 3 users, load a
What are the SQL commands to find who is logged on a server, what database
he/she has open, etc?
Where is this information in the help file or documentation?
Thanks,
Thomas
_
FREE pop-up blocking with the new MSN Toolbar get it now
Does postgresql takes advantage of hugetlb feature of
linux kernel 2.6 ?
http://otn.oracle.com/pub/notes/technote_rhel3.html
regds
mallah.
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-no
Tom Lane <[EMAIL PROTECTED]> writes:
> > Unfortunately there's no easy way to fix this, because the statistics
> > information does not have information about the physical position of
> > tuples with certain vaules.
>
> Yeah, I think the real problem is that the desired rows are not
> uniformly d
Sounds like an excellent suggestion ... we'll get a copy of this release.
Do you know of any incompatabilities with postgres 7.4 ?
We can upgrade a server to 7.5 and the JDBC, put running some servers on 7.4/7.4 JDBC
might be, uhm, difficult for me to sell operations (and we have only seen thi
Hi all.
In _PostgreSQL 7.3.5_, I have to check if a value is in an array.
I've got an array of dates (date[]) in a table and I would like to
perform queries like:
SELECT * FROM table WHERE date IN dates_array;
I've tried using array_contains_date (contrib/array_iterator.sql)
function unsuccess
11 matches
Mail list logo
