> Hi;
> I've got PostgreSQL 7.2 and I would like to use MSAccess2k as a
> front end; in a LAN, because some of my colleagues just use Windows.
> Where could I find a ODBC driver for Postgresql to be use under windows2000?
>
> thanks and regards
What about http://odbc.postgresql.org ?
Isn't it e
On Sat, Nov 16, 2002 at 02:11:58PM -0500, Hugh Esco wrote:
> Hey folks:
>
> I've copied the shell dialogue below.
> Everything in: /usr/lib/postgresql/bin is owned by root:root.
It's default instalation in Debian Woody and it works fine
> >postgres@biko:/home/hesco$ psql
> >env: /usr/lib/postgres
> You seem to have a very bizarre setup there --- there is no such thing
> as "readpgenv" in the standard Postgres distribution, and
> /usr/lib/postgresql/bin/ isn't the standard place to put the executable
> files either. Perhaps the above is normal for the Debian package of
> Postgres, but I'm a
> Here are the results from reversing the arguments.
>
> >hesco@biko:~$ su postgres
> >Password:
> >postgres@biko:/home/hesco$ cd
> >postgres@biko:~$ cd /usr/bin
> >postgres@biko:/usr/bin$ psql tempate1 -U postgres
> >Could not execv /usr/lib/postgresql/bin/psql
> >postgres@biko:/usr/bin$ psql tem
On Tue, Jan 14, 2003 at 04:27:22PM +0200, Tambet Matiisen wrote:
>
> First I would like to say, that I'm quite amazed. You even guessed table names
>right! :) I did not expect such an in-depth analysis in such a short time. Thanks,
>Tomasz!
It wasn't difficult - these names where in foreign keys
On Thu, Jan 23, 2003 at 08:53:53AM -0800, Stephan Szabo wrote:
> On Wed, 22 Jan 2003, Tom Lane wrote:
>
> I haven't looked at code yet but tried examples like Tomasz's and some
> simple ones and have gotten reasonable seeming output for the estimates
> given accurate statistics (joining two estima
Did you look at
http://techdocs.postgresql.org/guides/SetReturningFunctions
? You need Postgresql 7.3 to do this.
Regards,
Tomasz Myrta
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail com
On Thu, Mar 06, 2003 at 06:25:29PM -0500, Mark Mitchell wrote:
> I have a Perl program that executes PostgreSQL queries through DBI.
> Is there any way to cancel a query once its started. If I could at least
> somehow get the PID of the child process postmaster starts I could kill
> that.
>
> This
On Thu, Mar 06, 2003 at 08:31:56AM -0600, Mark Mitchell wrote:
> These are select queries that may have been keyed incorrectly that I
> need to cancel. So a transaction won't help in this case.
What about setting maximum query execution time in postgresql
configuration? There are some options help
On Tue, Mar 18, 2003 at 03:47:55PM +0100, alexj wrote:
> Hi,
>
> I'm looking how can I do to insert multiple values from a
> complexe query.
>
> What I want to do is something like that :
>
> INSERT INTO est_planifie_jour (id,ref_activite,ref_ressource,ref_jour)
> (SELECT nextval('est_p_id_p')
On Sat, 29 Nov 2003 08:49:24 -0800 (PST), ow wrote
> explain select b, c, a
> from test
> group by b, c, a
> having count(*) > 1
I'm not sure about 7.4 aggregate improvements, but <=7.3 didn't work good
with aggregates at all. Maybe it's not directly an answer to your question,
but try theses qu
11 matches
Mail list logo
