[GENERAL] .mdb to Postgres ?

2001-03-27 Thread Jean-Arthur Silve
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 Flix Eboue 75583 Paris Cedex 12 Tel : 01 44 67 05 05 Fax :

Re: [GENERAL] Making references

2001-03-27 Thread Stephan Szabo
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

Re: [GENERAL] .mdb to Postgres ?

2001-03-27 Thread Poul L. Christiansen
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 me

Re: [GENERAL] Supertypes?

2001-03-27 Thread will trillich
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 changes in one

Re: [GENERAL] Re: Patch (tiny): \cd (change dir) for psql.

2001-03-27 Thread will trillich
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 am surprised psql

Re: [GENERAL] Re: Patch (tiny): \cd (change dir) for psql.

2001-03-27 Thread Peter Eisentraut
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 to an

Re: [GENERAL] download PostgreSQL

2001-03-27 Thread Vince Vielhaber
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.

[GENERAL] RE: Supertypes?

2001-03-27 Thread Christian Marschalek
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've

[GENERAL] Two tables for the price of one?

2001-03-27 Thread Patrick Aland
I am seeing something kinda weird when I am creating tables (or viewing existing ones): BEGIN SESSION 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 \?

[GENERAL] C functions, arguments, and ssh oh my!

2001-03-27 Thread Joel Dudley
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

Re: [GENERAL] Two tables for the price of one?

2001-03-27 Thread Peter Eisentraut
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 mytable | table |

Re: [GENERAL] C functions, arguments, and ssh oh my!

2001-03-27 Thread Alfred Perlstein
* 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 -

Re: [GENERAL] C functions, arguments, and ssh oh my!

2001-03-27 Thread Peter Eisentraut
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, 255);

Re: [GENERAL] C functions, arguments, and ssh oh my!

2001-03-27 Thread Tom Lane
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

[GENERAL] how to load a sql-file????

2001-03-27 Thread markus jais
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

Re: [GENERAL] how to load a sql-file????

2001-03-27 Thread Zachary Beane
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

Re: [GENERAL] Supertypes?

2001-03-27 Thread Jason Earl
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 translation is

[GENERAL] Re: Logging Queries

2001-03-27 Thread Alex Howansky
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

[GENERAL] Alternate data locations

2001-03-27 Thread Rich Shepard
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

[GENERAL] fmgr, C , and character arguments

2001-03-27 Thread Joel Dudley
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 string.h #include stdlib.h #include "postgres.h" #include "fmgr.h" PG_FUNCTION_INFO_V1(ssh_exec); Datum ssh_exec(PG_FUNCTION_ARGS) {

Re: [GENERAL] fmgr, C , and character arguments

2001-03-27 Thread Marko Kreen
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 string.h #include stdlib.h #include "postgres.h" #include "fmgr.h"

[GENERAL] Out of date security docs

2001-03-27 Thread Adam Haberlach
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

Re: [GENERAL] Out of date security docs

2001-03-27 Thread Tom Lane
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?

Re: [GENERAL] Out of date security docs

2001-03-27 Thread Einar Karttunen
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?