On Tue, 27 Mar 2001, Adam Haberlach wrote:
>
> This seems pretty out-of-date, since we seem to have had a 'CREATE GROUP' command
> for as long as I can remember -- are there any more accurate docs out there?
> How would I go about updating them?
>
> http://www.postgresql.org/users-lounge/docs/7.0
Adam Haberlach <[EMAIL PROTECTED]> writes:
> This seems pretty out-of-date, since we seem to have had a 'CREATE GROUP' command
> for as long as I can remember -- are there any more accurate docs out there?
> How would I go about updating them?
> http://www.postgresql.org/users-lounge/docs/7.0/pos
This seems pretty out-of-date, since we seem to have had a 'CREATE GROUP' command
for as long as I can remember -- are there any more accurate docs out there?
How would I go about updating them?
http://www.postgresql.org/users-lounge/docs/7.0/postgres/security17760.htm
/***/
Currently, there is
On Tue, Mar 27, 2001 at 03:45:17PM -0700, Joel Dudley wrote:
> Hello all,
>I am having a bit of trouble getting my arguments formatted into a
> command string for system(). Here is what I have so far for code.
>
> #include
> #include
> #include "postgres.h"
> #include "fmgr.h"
>
>
> PG
Hello all,
I am having a bit of trouble getting my arguments formatted into a
command string for system(). Here is what I have so far for code.
#include
#include
#include "postgres.h"
#include "fmgr.h"
PG_FUNCTION_INFO_V1(ssh_exec);
Datum
ssh_exec(PG_FUNCTION_ARGS)
{
char*
Back in the old days of 6.x, the use of alternate database locations (for
example, by defining $PGDATA2 wherever I wanted it to be located) didn't
work. This was scheduled to be fixed in 7.x. Has it?
I want to use postgres as the attribute-storing dbms for my GRASS (GIS)
projects. What I'd li
> Is there any way to have the server log the queries that are coming in so I
> can see what's actually getting processed?
Start the postmaster with "-d 2" on the command line.
--
Alex Howansky
Wankwood Associates
http://www.wankwood.com/
---(end of broadcast)-
On Tue, Mar 27, 2001 at 09:42:39PM +, markus jais wrote:
> hi,
> maybe this is somewhere in the docs but I couldn't find
> it.
> I am a beginner to postgresql and do not know much till now.
> I have bought a book on SQL and now I want to
> import the sample databases into postgresql
> they are
I believe that what you are looking for is
inheritance.
http://postgresql.readysetnet.com/devel-corner/docs/user/inherit.html
I hope this is helpful,
Jason Earl
--- Christian Marschalek <[EMAIL PROTECTED]> wrote:
> In school we've learned about supertypes. I don't
> know if the raw
> translatio
hi,
maybe this is somewhere in the docs but I couldn't find
it.
I am a beginner to postgresql and do not know much till now.
I have bought a book on SQL and now I want to
import the sample databases into postgresql
they are provided as *.sql.
in MySQL I can type something like in Bash on my linux
Joel Dudley <[EMAIL PROTECTED]> writes:
> what it does with those is builds a command string for an external app that
> is called with system() and exits 0. I know this is strange and ugly but I
> need to trigger this external app when an insert is made into a user table.
This seems an extremely
Joel Dudley writes:
> PG_FUNCTION_INFO_V1(ssh_exec);
>
> Datum
> ssh_exec(PG_FUNCTION_ARGS)
> {
> char sshcmd[255];
>
> strncpy(sshcmd, "/usr/local/bin/plsshexec ", 255);
> strncat(sshcmd, *uname, 255);
> strncat(sshcmd, " ", 255);
> strncat(sshcmd, *uid, 2
* Joel Dudley <[EMAIL PROTECTED]> [010327 11:29] wrote:
> Hello All,
> I am writing my first C function for postgres and failing miserably. my C
> function needs to get passed a username (char) , uid(int), and gid(int) and
right, wrong and wrong.
char *, uid_t, gid_t.
--
-Alfred Perlstein
Patrick Aland writes:
> test=# \dt
> No relations found.
> test=# CREATE TABLE mytable (
> test(# id INT,
> test(# stuff VARCHAR(10)
> test(# );
> CREATE
> test=# \dt
> List of relations
> Name | Type | Owner
> -+---+--
> mytable | table | gmguest
> mytab
Hello All,
I am writing my first C function for postgres and failing miserably. my C
function needs to get passed a username (char) , uid(int), and gid(int) and
what it does with those is builds a command string for an external app that
is called with system() and exits 0. I know this is strange
I am seeing something kinda weird when I am creating tables (or viewing
existing ones):
bash$ createdb test
CREATE DATABASE
bash$ psql test
Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on i
Oh yeah we've learned about the normal forms too :) It's all flying back
into my mind right now ;o)
Thx!
> -Original Message-
> From: Gregory Wood [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 27, 2001 5:04 PM
> To: Christian Marschalek
> Subject: Re: Supertypes?
>
>
> > Well we'
On Tue, 27 Mar 2001 [EMAIL PROTECTED] wrote:
> Hi
>
> Could someone tell me where I can download PostgreSQL for Windows and
> MacOS from HTTP site other than ftp site, since the proxy server won't
> allow me go to the ftp site?
>
> Looking forward to your reply!
Yeah, I put a link up for this.
will trillich writes:
> and with it i'd imagine we'll also need
>
> # return to previous directory, for the lazy
> \cd -
> # show current working directory
> \cwd
> \pwd
You can do this with
\!pwd
(Of course \!cd won't do what you want. This situation is similar
On Tue, Mar 27, 2001 at 09:52:05AM -0500, Bruce Momjian wrote:
> > On Mon, 26 Mar 2001 15:07:37 + (UTC), Mark Hamby
> > <[EMAIL PROTECTED]> wrote:
> > >
> > >
> > >Here's a patch for a \cd (change dir) command in psql program.
> > >It's very small and only adds a few lines.
> > >Personally, I
On Tue, Mar 27, 2001 at 03:58:39PM +0200, Christian Marschalek wrote:
> > Pg DOES support it!
> Oh... My fault :o)
>
> > However, it doesn't really have anything
> > to do with data redundancy. Data redundancy means storing
> > the same DATA in more than one table meaning that if it
> > change
You can use some conversion tools that can be found on www.greatbridge.org
I've used PgAdmin (windows only) to convert MS Access files to PostgreSQL.
Poul L. Christiansen
On Tue, 27 Mar 2001, Jean-Arthur Silve wrote:
> Hi !
>
> One of our customers has an MS Access DB (I think..)
>
> He sent
On Mon, 26 Mar 2001, bswiatek wrote:
Assuming you're doing these in this order, this can't
succeed. LECZENIE referenes WIZYTY which isn't
created yet as do some other tables, which causes
those tables not to exist later when you reference
them. If you want to make circular trees of references
Hi !
One of our customers has an MS Access DB (I think..)
He sent me a .mdb file.
Does anyone knows a way to convert this to postgreSQL db ?
thank you !
EuroVox
4, place Félix Eboue
75583 Paris Cedex 12
Tel : 01 44 67 05 05
Fax :
24 matches
Mail list logo
