"Dr. Evil" wrote:
>
> I just want to say, that PG is an awesome thing. I'm finding new uses
> for constraints of various kinds to ensure data integrity in my DB.
> Constraints will really make the whole application more solid, because
> programming errors elsewhere still won't allow corrupt da
Nicolas Kowalski wrote:
>
> Hello.
>
> We use PostgreSQL 7.1.2 on Debian GNU/Linux as our Intranet database. I
> am currently working on a small mailing-lists management application. I
> would like to enforce table access permissions depending on the current
> username :
>
> - if the current
Raymond Chui wrote:
>
> The Subject says its all.
>
Yes 'exists' works (though I never understood the advantage to the 'in' operator).
Nils
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send
KÈmeri Lajos wrote:
> And I call it: select * from LOGIN ('username', 'password');
> Result: 1, 'Lewis'
>
In PostgreSQL you can define only functions, they go a long way, but are
not really stored procedures. A stored procedure can return a tuple just
like you show. A function can only return
Carlos Moreno wrote:
>
> No, it's not spam! :-)
>
> I'm just wondering if there is a data type like Money, but with
> a (much much much) higher range -- checking the documentation,
> it would look like PG uses an int (32bits) to store the amount
> of cents -- but -21 million to +21 million is
Al Frick wrote:
> I may try FreeBSD as the server. But I am a little confused. My
> clients want Windows on the work stations. Can this be done?
>
The PostgreSQL ODBC driver for win32 works fine. With packages like
MS-Access, Delphi, VB etc. you can write a client application and
connect t
Trygve Falch wrote:
>
> In article <[EMAIL PROTECTED]>, "Nils Zonneveld" <[EMAIL PROTECTED]>
> wrote:
>
> >> Actually I think I found 'Allow queries across multiple databases' in
> >> the TODO-list under something they call &#
Mike Mascari wrote:
>
> Can you access other data sources via MS-Query, such as local Access
> databases, or possibly remote MSSQL server databases? I can't think
> of any reason why MS-Query should be crashing...
>
I use PostgreSQL data in Word and Excel via linked tables in MS Access.
Maybe
Jeff Meeks wrote:
>
> Hi,
> I am trying to join 3 tables
> with this query
> select a.id, a.name, sum(b.qty), sum(c.qty)
> from a, b, c
> where a.id=xxx and b.id=a.id and c.id=a.id
>
> what the sums that get returned look as if they are a cross products of
> the
Bill Barnes wrote:
>
> Does anyone know of a package for 7.0.3 or 7.1 that
> will install in SuSE's latest release.
>
> How about the Red Hat 7.1 RPMS?
>
I work with Suse 6.4, but installed PostgreSQL 7.0.3 and later 7.1 quite
easily from source. So if waiting for a RPM is holding you, I'd s
H
LD_LIBRARY_PATH=/usr/local/pgsql/lib
export LD_LIBRARY_PATH
PGLIB=/usr/local/pgsql/lib
export PGLIB
PGDATA=/var/lib/pgsql
export PGDATA
(depending on your own path settings of course)
If /etc/profile.local is not used, add the lines to /etc/profile.
HTH,
Nils Zonneveld
--
datactrl wrote:
>
> When will pgSQL v7.1 officially release?
>
It is released a week ago, take a look on the website
http://www.postgresql.org. Its definitly worth an upgrade, I like 7.1 a
lot (even the dump files look more readable).
Regards,
Nils
---(end of broadca
e source install, personally I found it easier and more convenient
to install from the source tar.gz file in stead of RPM (My Suse system
supports RPM, but Im not a big fan of RPM). BTW do you have a new
install or an upgrade?
Regards,
Nils Zonneveld
---(
Hi all,
Currently I connect from my mac via JDBC. But are there also PostgreSQL
ODBC drivers available for the Mac?
TIA,
Nils
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
in the Win32 ODBC
interface solved? It wasn't possible to update tables in PostgreSQL from
a MS Access client.
Greets and chapeaux for the PostgreSQL developers,
Nils Zonneveld
---(end of broadcast)---
TIP 2: you can get off all lists at
user process like postmaster could bring the whole server down.
If anyone has had a simulair experience and found a solution I would
like to know about it.
Thanks in advance,
Nils Zonneveld
--
"Misschien is niets geheel waar, en zelfs dat niet"
Multatuli (Eduard Douwes Dekker) - Idee 1
source (*.tar.gz files) much easier then with rpm. I use
Suse Linux which suports rpm as well, but my experiences are that
installing from source was easier then I expected and caused less
problems then using rpm.
Regards,
Nils Zonneveld
--
"Misschien is niets geheel waar, en zelfs dat niet"
Multatuli (Eduard Douwes Dekker) - Idee 1
mpTable;
count
---
2
(1 row)
Success and kind regards,
Nils Zonneveld
--
"Misschien is niets geheel waar, en zelfs dat niet"
Multatuli (Eduard Douwes Dekker) - Idee 1
18 matches
Mail list logo
