RE: [GENERAL] PostgreSQL & the BSD License
At 08:24 10/07/00 -0400, Robert D. Nelson wrote: > >Stupid question time: BSD allows forking of the code base, perhaps to >proprietary. If going proprietary, I would imagine you could change the >license. So why can't we have a "license fork"? > I'll ask, but I think he'll say that the license applies to the source; if a commercial fork was made, then they are free to hide the source. But if they ever release the source, then it has to go under the BSD again. Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.C.N. 008 659 498) | /(@) __---_ Tel: (+61) 0500 83 82 81 | _ \ Fax: (+61) 0500 83 82 82 | ___ | Http://www.rhyme.com.au |/ \| |---- PGP key available upon request, | / and from pgp5.ai.mit.edu:11371 |/
RE: [GENERAL] PostgreSQL & the BSD License
On Mon, 10 Jul 2000, Philip Warner wrote: > At 08:24 10/07/00 -0400, Robert D. Nelson wrote: > > > >Stupid question time: BSD allows forking of the code base, perhaps to > >proprietary. If going proprietary, I would imagine you could change the > >license. So why can't we have a "license fork"? > > > > I'll ask, but I think he'll say that the license applies to the source; if > a commercial fork was made, then they are free to hide the source. But if > they ever release the source, then it has to go under the BSD again. Actually, my understanding is that even if a commercial fork was made, the original license has to be visible *somewhere*, even if its just the COPYRIGHT file itself ...
[GENERAL] [NOVICE] newbie problem on creating table
> >I am trying to get a start with Postgres 6.4 on Suse Linux 6.4. > I did that just 2 weeks ago. and it works? > >I created a superuser who is allowed to create databases.I created a > >user and a database, but I didn't manage so far to create a table. > like : $ psql -c "create table test ( a int, b int )" yes, I tried exactly this statement, but still the same error > > It just returns "Error cannot create . > Did you install the pg_datab and pg_ifa packages, too ? yes, I installed both packages > >In the configuration file for the authentication, I used the settings coming > >with the installation: > > > >local alltrust > >hosts all 127.0.0.1 255.255.255.255 trust > > > >The logfile also just shows the messages: > >Error: Cannot create > >AbortCurrentTx > > > > > >I am really stuck and have no glue where to look or to start. Any help is > >highly welcome > Well, glue won't help you to become unstuck :-) I take whatever it needs to get this fixed :-) > >thomas > > > >PS: posted to pgsql-novice and pgsql-general > > > > > -- > Bernd Tegge mailto:[EMAIL PROTECTED] > Tel: ++49-511-87449-12 repas AEG Automation GmbH > Fax: ++49-511-87449-20 GS Hannover, Germany > > >
[GENERAL] newbie problem on creating table
> > > > I am trying to get a start with Postgres 6.4 on Suse Linux 6.4. I created a > > superuser who is allowed to create databases. I created a user and a > > database, but I didn't manage so far to create a table. It just returns > > "Error cannot create . > > The owner of your database might the postgres superuser. You will have > to set the permissions or the owner accordingly. The latter can be > done in 7.0.x as superuser with: > > UPDATE pg_database > SET datdba= > WHERE datname= > ; I checked pg_database: The datadba for the database is root and I am accessing the database as root. any other ideas? > HTH > Holger Klawitter > -- > Holger Klawitter+49 (0)251 484 0637 > [EMAIL PROTECTED]http://www.klawitter.de/ > >
Re: [GENERAL] [NOVICE] newbie problem on creating table
Does the database you created have the same name as the user executing the query you mentioned? I believe that, as given, psql will try to connect to a database having the same name as the login name of the user executing the statement. Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer On Mon, 10 Jul 2000, Thomas Krebs wrote: > > >I am trying to get a start with Postgres 6.4 on Suse Linux 6.4. > > I did that just 2 weeks ago. > > and it works? > > > >I created a superuser who is allowed to create databases.I created a > > >user and a database, but I didn't manage so far to create a table. > > like : $ psql -c "create table test ( a int, b int )" > > yes, I tried exactly this statement, but still the same error >
Re: [GENERAL] Problems installing pltcl
Peter Eisentraut wrote: > > I tried to install PostgreSQL 7.0.2. Everything looked fine but the file > > 'pltcl.so' was not installed. But this is needed for creating functions > > in TCL! What did I make wrong? > > We need more information than that, in particular the make output. OK, here are more detailed informations: im running PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66 configure: ./configure --prefix=/opt/local/DWH --with-tcl --with-tkconfig=/opt/local/DWH/lib --exec_prefix=/opt/local/DWH --with-tclconfig=/opt/local/DWH/lib the output of the configure is: ... checking setting USE_TCL... enabled ... creating interfaces/libpgtcl/Makefile ... creating pl/plpgsql/src/Makefile creating pl/plpgsql/src/mklang.sql creating pl/tcl/mkMakefile.tcldefs.sh and finaly the output of the makefile: ... make -C pl all make[1]: Entering directory `/DWH/PRG/postgresql-7.0.2/src/pl' make -C plpgsql all make[2]: Entering directory `/DWH/PRG/postgresql-7.0.2/src/pl/plpgsql' make -C src all make[3]: Entering directory `/DWH/PRG/postgresql-7.0.2/src/pl/plpgsql/src' ... make[3]: Leaving directory `/DWH/PRG/postgresql-7.0.2/src/pl/plpgsql/src' make[2]: Leaving directory `/DWH/PRG/postgresql-7.0.2/src/pl/plpgsql' make[1]: Leaving directory `/DWH/PRG/postgresql-7.0.2/src/pl' All of PostgreSQL is successfully made. Ready to install. Do you need some more informations? Thanks, Peter -- Bezirksfinanzdirektion Muenchen Vermessungsabteilung . Peter Keller : Tel: (+49) 089-2190-2594 Vermessungsrat z.A.: Fax: (+49) 089-2190-2459 Alexandrastr. 3: mailto:[EMAIL PROTECTED] 80538 Muenchen : web: http://www.bayern.de/vermessung
Re: [GENERAL] Slashdot discussion
> P.S. My tolerance is negligible for anything that goes "beep" the way > mysql insists on doing when giving error messages. Like anyone needs > that when they're trying to figure out SQL syntax! Having to figure > out SQL syntax is pennance enough, surely ... MySQL beeps at you on an error. Ewe. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026
[GENERAL] Backends don't die
Hi there, I'm running postgres 6.5 under Linux RedHat 6.2. I've got a NT logging via ODBC on my Pg database and it seems that backends connections dont die... I have set MAX_BACKENDS up to 1000 ! but after a while, i got an error message indicating "Maximum number of connections exeeded". Is that possible to tell Postmaster to Kill Backends when it Idle ? Regards, Remy DufourIT ProgrammerWebNet Inc - ISPremy.tech@webnet.qc.ca
RE: [GENERAL] PostgreSQL & the BSD License
On Mon, 10 Jul 2000, Robert D. Nelson wrote: > >I'll ask, but I think he'll say that the license applies to the source; if > >a commercial fork was made, then they are free to hide the source. But if > >they ever release the source, then it has to go under the BSD again. > > What I was asking was, if someone forks the code base, aren't they allowed > to change their license? It would only make sense that they distinguish > themselves as the developers of the new code fork, right? no they can't ... they can add to the current license, but they can't remove it ...
RE: [GENERAL] PostgreSQL & the BSD License
>I'll ask, but I think he'll say that the license applies to the source; if >a commercial fork was made, then they are free to hide the source. But if >they ever release the source, then it has to go under the BSD again. What I was asking was, if someone forks the code base, aren't they allowed to change their license? It would only make sense that they distinguish themselves as the developers of the new code fork, right? So, can't the code be forked in such a way that no code changes, and only the license? Rob Nelson [EMAIL PROTECTED]
RE: [GENERAL] PostgreSQL & the BSD License
At 10:36 10/07/00 -0400, Robert D. Nelson wrote: >>I'll ask, but I think he'll say that the license applies to the source; if >>a commercial fork was made, then they are free to hide the source. But if >>they ever release the source, then it has to go under the BSD again. > >What I was asking was, if someone forks the code base, aren't they allowed >to change their license? It would only make sense that they distinguish >themselves as the developers of the new code fork, right? > >So, can't the code be forked in such a way that no code changes, and only >the license? I think the answer is no, not without permission from all parties to the current license agreement, which would, arguably, include UoC + anyone who had ever used or worked on the code. This is not as bad as it sounds; it merely ensures that a BSD license can not be dumped. The BSD license itself does not require source to be distributed, and it does not place any requirements on how the source is used, except in so far is it requires the copyright and license terms to be displayed etc. I asked also if I could create a new license that includes the following text at the start: "The floowing paragraphs are only relevant in Botswana for the year 1967" since that seems (naievely) to be legal. I am told that this would also, probably, be in breach of the license terms...at least in Australia (which is based on UK law). Sadly I am still waiting for complete answers to most of my questions. Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.C.N. 008 659 498) | /(@) __---_ Tel: (+61) 0500 83 82 81 | _ \ Fax: (+61) 0500 83 82 82 | ___ | Http://www.rhyme.com.au |/ \| |---- PGP key available upon request, | / and from pgp5.ai.mit.edu:11371 |/
Re: [GENERAL] [NOVICE] newbie problem on creating table
"Thomas Krebs" <[EMAIL PROTECTED]> writes: It just returns "Error cannot create . I believe this error indicates that the kernel rejected Postgres' attempt to create a file for the new table. Unfortunately we can't see the exact kernel error message (that's fixed for 7.1, but it won't help you for 7.0 unless you're prepared to alter and recompile sources...). I will make a wild guess that the problem is incorrect permissions on the database directory. Take a look in $PGDATA/base/ and make sure the database subdirectory is owned and writable by whatever user you are running the postmaster as. (Which had better NOT be root!) regards, tom lane
[GENERAL] moving from mySQL to pgsql, need a bit of help (perl)
Hello, I'm trying to move from mySQL to PostgreSQL, and I've got to port a
web app over that's written in perl. It uses the DBD/DBI stuff, and works
great so far with mySQL. I've got a very specific question relating to
pulling data out of a database, I hope this is the correct forum for it.
Here goes:
I have a database set up with a table that has 3 fields in it:
userid
username
userdata
In my current code (perl/mySQL), I execute the following query: "SELECT *
from table_name" - then use the following code to put it in a hash:
$j = 0;
while (@row = $sth->fetchrow_array)
{
for ($i = 0; $i < $fields; $i++)
{
$taghash[$j]{$$fieldnames[$i]} = $row[$i];
}
$j++;
}
What I end up with is an array of hashes containing all the table data.
Each element in the array is a hash called $taghash[$i], and the fields can
be accessed via $taghash[$i]{'userid'}, $taghash[$i]{'username'}, and
$taghash[$i]{'userdata'}. $fields and $fieldnames are variables created by a
subroutine I wrote which is called after the query is executed. $fields is
simply the number of fields in the table, and $fieldnames is an array
containing the names of the columns in the table, in order, produced by
"$fieldnames = $sth->{NAME};" HERE is the problem. The PostgreSQL DBI/DBD
doesn't seem to support this. I'm looking for something that returns the
names of the columns in the table, so I can duplicate my code without
changing too much. Is there anything available to do this? I've yet to find
it in the documentation, though I may have simply missed it, as I'm new to
PostgreSQL... Any help is appreciated...
Thanks,
Matt ([EMAIL PROTECTED])
Re: [GENERAL] moving from mySQL to pgsql, need a bit of help (perl)
Matt Housh wrote:
>
> In my current code (perl/mySQL), I execute the following query: "SELECT *
> from table_name" - then use the following code to put it in a hash:
>
> $j = 0;
> while (@row = $sth->fetchrow_array)
> {
>for ($i = 0; $i < $fields; $i++)
>{
> $taghash[$j]{$$fieldnames[$i]} = $row[$i];
>}
>$j++;
> }
>
> What I end up with is an array of hashes containing all the table data.
> Each element in the array is a hash called $taghash[$i], and the fields can
> be accessed via $taghash[$i]{'userid'}, $taghash[$i]{'username'}, and
> $taghash[$i]{'userdata'}. $fields and $fieldnames are variables created by a
> subroutine I wrote which is called after the query is executed. $fields is
> simply the number of fields in the table, and $fieldnames is an array
> containing the names of the columns in the table, in order, produced by
> "$fieldnames = $sth->{NAME};" HERE is the problem. The PostgreSQL DBI/DBD
> doesn't seem to support this. I'm looking for something that returns the
> names of the columns in the table, so I can duplicate my code without
> changing too much. Is there anything available to do this? I've yet to find
> it in the documentation, though I may have simply missed it, as I'm new to
> PostgreSQL... Any help is appreciated...
I believe DBI/DBD does this for you:
while ($row_href = $sth->fetchrow_hashref)
{
push( @taghash, $row_href);
}
Regards,
Ed Loehr
RE: [GENERAL] PostgreSQL & the BSD License
>no they can't ... they can add to the current license, but they can't >remove it ... Okay, well that is what's wanted, correct? Or am I reading the mail wrong? Rob Nelson [EMAIL PROTECTED]
[GENERAL] Re: Slashdot discussion
In article <[EMAIL PROTECTED]>, Chris Bitmead <[EMAIL PROTECTED]> wrote: >Graeme Merrall wrote: >> Without wanting to starta thread war I think postgres is >> great, but for many people the learning curve is too great and thus >> MySQL is a good introduction. > >In what way is mysql easier to learn? I think MySQL is easier to learn since there are a lot of DB features (transactions, views, sub-queries, etc) that are missing... so there's a lot less to learn... I'm not entirely sure that's a good thing though since people end up "hacking" there way around that sort of thing -- I know I did... There are a lot more third-party tools (someone mentioned that web admin tool) etc... which a lot of people like. I tend to stick to the command line and for the most part they are both the "same" in how easy/hard it is to learn them. I personally find postgres' docs to be much better if only because it is broken up into reasonable chunks... and I like the very explicit statements indicating whether this is a postgres extension etc... (yes, i know there is a section in mysql, but i don't think it's mentioned with the defination of a particular statement). -philip
RE: [GENERAL] PostgreSQL & the BSD License
On Mon, 10 Jul 2000, Robert D. Nelson wrote: > >no they can't ... they can add to the current license, but they can't > >remove it ... > > Okay, well that is what's wanted, correct? Or am I reading the mail wrong? I've contacted the University of California "licensing director" about upgrading our current BSD COPYRIGHT (which is ~4years old) to the more recent version ... baring that, adding an amendment will have to be the next option ...
Re: [GENERAL] ODBC drivers for linux
Trond Eivind Glomsrød wrote: > > Kevin Heflin <[EMAIL PROTECTED]> writes: > > > I've used postgresql for a few years, running on Linux.. using PHP with > > apache to connect to postgresql.. after finding an ODBC drivers for use on > > windowsNT, I also use PHP and tango with IIS to connect to postgresql > > running on linux. > > > > I'm currently looking for something like an ODBC driver for Linux, that > > can connect to postgresql running on linux. > > http://www.unixODBC.com/ > > -- > Trond Eivind Glomsrød > Red Hat, Inc. Or http://www.iodbc.org. Also I've found that Postgres v7 is better with odbc than the 6.x series. /Matt. -- Matt Goodall, Software Engineer | Isotek Electronics Ltd mailto:[EMAIL PROTECTED] | Claro House, Servia Road http://www.isotek.co.uk | Leeds, LS7 1NL Tel: +44 113 234320 | England
[GENERAL] Re: PostgreSQL and Windows NT
Should work under NT. Check out postgresql.org for instructions. For NT, the server-side port of Postgres uses RedHat/Cygnus Cygwin toolset. For Windows 9x, only a client odbc connection can be made. Never done odbc calls to an NT postgres server, but I have made odbc request to a Linux Box w/ postgres server from an NT & 95 Workstation - works great. Hope that helps... Ruediger Maehl <[EMAIL PROTECTED]> wrote in message news:newscache$vgxuwf$dgg$1@www... > Hi, > > has anyone made any experiences with PostgreSQL on Windows NT? > > Does PostgreSQL even work under Windows NT? > > How about ODBC calls from other clients to the > PostgreSQL on Windows NT? Does that work? > > Any information is highly appreciated. > > Rudy > >
[GENERAL] [Help] INSTALLing 7.02
Hi, If anyone out there would be so kind as to point out what may be the problem I would appreciate it immensely. (PS - I tried without the --with-CC and got the same error at the same place) ./configure --with-CC=/usr/opt/SUNWmd/sbin/cc loading cache ./config.cache checking host system type... sparc-sun-solaris2.7 checking echo setting... checking setting template to... solaris_sparc_gcc checking whether to support locale... disabled checking whether to support cyrillic recode... disabled checking whether to support multibyte... disabled checking setting DEF_PGPORT... 5432 checking setting DEF_MAXBACKENDS... 32 checking setting USE_TCL... disabled checking setting USE_PERL... disabled checking setting USE_ODBC... disabled checking setproctitle... disabled checking setting ASSERT CHECKING... disabled checking for gcc... /usr/opt/SUNWmd/sbin/cc checking whether the C compiler (/usr/opt/SUNWmd/sbin/cc ) works... no configure: error: installation or configuration problem: C compiler cannot create executables.
[GENERAL] images
Is it possible to save images in postgreSQL ?? If yes, and in the case of a web site using both postgrSQL and mod_perl, is it preferable (faster) to save images in the database, or to simply save a reference to the images in the database, but load the image from the filesystem ??? Yves. Yves Dorfsman[EMAIL PROTECTED] http://www.cuug.ab.ca/~dorfsmay
[GENERAL] raw devices
Is there any way to use raw devices within postgreSQL, or does it support file system only ?? Is there any reason for not supporting raw device, or is it just a question of not having the time to write a driver ? Yves. Yves Dorfsman[EMAIL PROTECTED] http://www.cuug.ab.ca/~dorfsmay
[GENERAL] Another mySQL to PostgreSQL move question
Does PostgreSQL support something like mySQL's auto_increment tag? For example, my entering "create table test (userid int default 0 not null auto_increment);" in mySQL creates a table with one field that automatically increments its value if none is specified. I have not been able to duplicate this in PostgreSQL yet (still new...) - any help is appreciated... Matt
Re: [GENERAL] Another mySQL to PostgreSQL move question
Matt Housh wrote: > > Does PostgreSQL support something like mySQL's auto_increment tag? See question 4.16.1 of http://www.postgresql.org/docs/faq-english.html Regards, Ed Loehr
Re: [GENERAL] Another mySQL to PostgreSQL move question
> See question 4.16.1 of > > http://www.postgresql.org/docs/faq-english.html > > Regards, > Ed Loehr Once again, thanks Ed :) That's exactly what I needed. :) Matt
[GENERAL] Log files
Hi there, Is there any way to open pg_log file ? Thanks! Remy DufourIT ProgrammerWebNet Inc - ISPremy.tech@webnet.qc.ca
Re: [GENERAL] raw devices
This seems to be coming up so often perhaps somebody should put it in the FAQ. The reason it doesn't support raw devices, according to a moderately long discussion not too long ago, is that with modern operating systems it is better to let the OS handle the low level stuff. Yves Dorfsman wrote: > > Is there any way to use raw devices within postgreSQL, or does it support > file system only ?? > > Is there any reason for not supporting raw device, or is it just a > question of not having the time to write a driver ? > > Yves. > > Yves Dorfsman[EMAIL PROTECTED] > http://www.cuug.ab.ca/~dorfsmay
[GENERAL] Hints about how to debug pg_dump problem?
Hi, I'm trying to move a database from a development machine onto a production machine. I seem to get good output from my pg_dump command, but when I read the resulting files, I can't get them to import everything. (FWIW, I'm moving from a Debian potato/woody combo onto a fresh Debian potato install with just PostgreSQL updated to the 7.0.2 deb package.) What I don't understand is the order in which a dump file is processed. I thought it should be processed pretty much in the order it appears, right? After all, if you do $ psql -e my_database < my_dumpfile you should just get a straight-ahead reading of the dumpfile, no? Watching the output, however, things are not getting created even though there are no complaints from psql (about that data). For instance, if I have data from table1 which appears in the dump file before data from table2, and I'm getting a parse error on table2, shouldn't the data from table1 show up (assuming that nothing in it depends on the data from table2 being there) after the error? The read eventually dies with a parse error. I'm sure there must be something wrong in my source database that I'm getting this, but I don't even know where to begin tracking down the problem. I've dumped and re-read this database before, but I've added the data that is causing the problem since then. Obviously, that's what the problem is; I just can't see how the file is getting read. Any hints as to where to start would be much appreciated. A -- Andrew Sullivan Computer Services <[EMAIL PROTECTED]>Burlington Public Library +1 905 639 3611 x158 2331 New Street Burlington, Ontario, Canada L7R 1J4
[GENERAL] Using the JDBC Driver in version 7.02
Hello. I am using Postgres 7.02 on my redhat linux box. I have installed
the JDK and a JSP engine.
I have also copied the JDBC level 4 Drivers that came with postgresql 7.02
onto my hard drive.
When I try to interface with it in java, even after loading the driver with
the line:
Class.forName("org.postgresql.Driver");
I get an error that the DriverManager cannot find a suitable driver.
The code I use to connect goes as follows:
Connection chamber = DriverManager.getConnection("localhost:5432");
I also tried it as:
Connection chamber =
DriverManager.getConnection("localhost:5432","username","password");
and still no luck.
Can anyone help with this problem?
I have two suspicions: First, that I am not pointing to the right class in
the jar file. Driver.class might be the wrong file to start with. Second,
maybe my server is not taking requests properly, so Java says "hey, this
driver is not working." when it's not the drivers fault, but the servers
fault.
Just so you know, I set up my server to trust all localhost connections.
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
[GENERAL] dump files
Ok, so I really am even stupider than I look. I had a third look at the output from my attempted read, and finally noticed the permissions error early on which made everything fail. Sorry to be a bother. A -- Andrew Sullivan Computer Services <[EMAIL PROTECTED]>Burlington Public Library +1 905 639 3611 x158 2331 New Street Burlington, Ontario, Canada L7R 1J4
Re: [GENERAL] Using the JDBC Driver in version 7.02
You have to format your url properly so the java runtime can figure out
what driver to use for the connection.
Justin Jaynes wrote:
>
> Hello. I am using Postgres 7.02 on my redhat linux box. I have installed
> the JDK and a JSP engine.
>
> I have also copied the JDBC level 4 Drivers that came with postgresql 7.02
> onto my hard drive.
>
> When I try to interface with it in java, even after loading the driver with
> the line:
>
> Class.forName("org.postgresql.Driver");
>
> I get an error that the DriverManager cannot find a suitable driver.
>
> The code I use to connect goes as follows:
>
> Connection chamber = DriverManager.getConnection("localhost:5432");
>
> I also tried it as:
>
> Connection chamber =
> DriverManager.getConnection("localhost:5432","username","password");
>
> and still no luck.
>
> Can anyone help with this problem?
>
> I have two suspicions: First, that I am not pointing to the right class in
> the jar file. Driver.class might be the wrong file to start with. Second,
> maybe my server is not taking requests properly, so Java says "hey, this
> driver is not working." when it's not the drivers fault, but the servers
> fault.
>
> Just so you know, I set up my server to trust all localhost connections.
>
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
Re: [GENERAL] Slashdot discussion
Bruce Momjian writes:
> OK, thanks to the www.phpbuilder.com PostgreSQL/MySQL comparison, there
> is another PostgreSQL/MySQL thread on shashdot.org. Looks interesting,
> and of course, we are looking good too.
Is anyone else noticing this: Everytime this sort of thing comes up a
number of people invariably tell that they are using MySQL because it's
easier to install, and that PostgreSQL is difficult ("a pain") to install.
I've studied the MySQL installation instructions, and they don't strike me
as inherently simpler. Is it only perception, or what can we do better?
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/Sweden
