On Mon, Jun 20, 2005 at 11:11:23AM +0800, mohammad izwan ibrahim wrote:
>
> I need help on accessing few database without having a persistent connection.
Accessing a database how? What client application, programming
language, etc., are you using? What are you trying to do?
> So far accessing
2005/6/12, Steph Frias <[EMAIL PROTECTED]>:
>
>
> Inicie la instalacion del PostgreSQL 7.3.10 como dice
> el install:
>
> ./configure
> gmake
> su
> gmake install
> adduser postgres
> mkdir /usr/local/pgsql/data
> chown postgres /usr/local/pgsql/data
> su - postgres
> /usr/local/pgsql/bin/initdb
Hi there,
I need help on accessing few database without having a persistent connection.
So far accessing via dblink still require persistent database connecttion.
Is it possible to be done by postgress..and how to acheive that
tq
---(end of broadcast)
"Erik Aronesty" <[EMAIL PROTECTED]> writes:
> Should I start looking to figure out why the optimizer didn't figure out
> that it should be doing this sort of thing?
It looks to me that the problem is that convert_IN_to_join() is not
being smart about where to attach the IN's subselect to the join
On Sun, Jun 19, 2005 at 09:58:11AM -0600, Michael Fuhr wrote:
>
> If possible, it would be best to commit transactions that insert
> or update foreign keys as soon as possible.
I probably shouldn't have said "best" here, implying that this
solution is better than all other possibilities. As Tom
On Tue, Jun 14, 2005 at 01:12:13PM +0200, Vilinski Vladimir wrote:
>
> During the execution of transaction Nr:10295 (PID:18430) one new transaction
> with
> Nr:10339 (PID:18431) starts, that writes one record into the table. But this
> new
> transaction never stops, because it tries to set one S
Vilinski Vladimir <[EMAIL PROTECTED]> writes:
> During the execution of transaction Nr:10295 (PID:18430) one new transaction
> with
> Nr:10339 (PID:18431) starts, that writes one record into the table. But this
> new
> transaction never stops, because it tries to set one ShareLock to its
> parren
On Sat, Jun 11, 2005 at 10:23:11PM -0600, Larry Meadors wrote:
>
> I am looking at the features for pgsql 8.1 (based on what I read in
> http://gborg.postgresql.org/project/pljava/projdisplay.php), and am
> wondering if anyone reading this has a simple example of some
> procedures that use OUT and
Within a PL/pgSQL function this would be easy, but I need to store the
complete initialization script in a text file and execute it as a whole.
In your scritp, put a CREATE FUNCTION and then call it and drop it ;)
---(end of broadcast)--
Look contrib/intarray
On Tue, 14 Jun 2005, Sophie Yang wrote:
Say I have a table tbl1 with two columns:
tbl1(a integer, b integer, c integer)
I want to select the rows in which a and b are members
of a list of integer pairs. The SQL in my mind is
something like:
select * from tbl1 where (a,
10 matches
Mail list logo
