Re: [GENERAL] selecting a random record

Can this be done in the framework of plpgsql? I know I can do it in the front end (java) but it would be nice to aviod having to grab the rowcount first. I haven't seen a random function in the documentation. I could install another language but boy am I lazy :) --- Mark Lane <[EMAIL PROTECTE

Re: [GENERAL] new type proposal

At 03:43 PM 2/6/2001 -0500, Joseph Shraibman wrote: >I've been thinking on some new pesudo-types like SERIAL. > >1) LAST_MODIFIED is the timestamp of that last time this row was >modified. Easy enough to do currently with triggers. >2) TIME_CREATED is the timestamp of when this row was first crea

[GENERAL] Re: clean rebuild process?

At 15:02 06.02.2001 -0500, chris markiewicz wrote: >the limit of my imaginatin is this - some sort of command/utility that >queries a table and generates the insert statements from the results. then >i wouldn't have to worry about updating my default data scripts everytime >data changes. pg_dump

[GENERAL] new type proposal

I've been thinking on some new pesudo-types like SERIAL. 1) LAST_MODIFIED is the timestamp of that last time this row was modified. Easy enough to do currently with triggers. 2) TIME_CREATED is the timestamp of when this row was first created with an INSERT. I'm not sure how to do this because

Re: [GENERAL] selecting a random record

Greetings. I have a smallish sized database that's getting alot of update transactions to it. It's been running fine over the past several weeks, but suddenly I'm starting to see : NOTICE: Deadlock detected -- See the lock(l) manual page for a possible cause. NOTICE: current transaction is a

Re: [GENERAL] Re: PostreSQL SQL for MySQL SQL

: I think it's still a good idea to provided the "if exists" clause in a : future PostgreSQL version for these reasons: : 1. it's convenient : 2. it doesn't interfere with existing functionality or performance : 3. it makes porting from MySQL to PostgreSQL easier I seco

[GENERAL] Re: full text searching

"Mitch Vincent" <[EMAIL PROTECTED]> writes: > Well, the search engine isn't the database, IMHO. The search "engine" is > your application... The database will go get anything you tell it to, you > just have to know how to tell it and make sure that your application tells > it in the correct way.

[GENERAL] selecting a random record

Any suggestions on how to select a random record from any given table? Culley __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/

[GENERAL] clean rebuild process?

hello. i am trying to develop a relatively clean process for creating/populating a new database. i have all of the table creation scripts and am about to start writing scripts to populate the db with the necessary default data (an admin user, a guest user, default application info, default prefe

Re: [GENERAL] ON DELETE CASCADE and TRIGGER

On Wed, 31 Jan 2001, Raymond Chui wrote: > I have three tables: > > CREATE TABLE table1 ( > idchar(8) NOT NULL, > > PRIMARY KEY (id) > ); > > CREATE TABLE table2 ( > idchar(8) NOT NULL, > > PRIMARY KEY (id), > FOREIGN KEY (id) REFERENCES table1 (id) ON DELETE CASCADE > ); >

Re: [GENERAL] permissions on databases

On Tue, 6 Feb 2001, Tressens Lionel wrote: > I am the super user of my DBMS and if create a database for a simple user, > I do : > > => create database formyuser; > > But If this user connects to the database and tries to create a table, he > has no rights. I must (the super user) create the tabl

[GENERAL] permissions on databases

Hi all, I am the super user of my DBMS and if create a database for a simple user, I do : => create database formyuser; But If this user connects to the database and tries to create a table, he has no rights. I must (the super user) create the table for him and then give him all the permissions

[GENERAL] Re: PostreSQL SQL for MySQL SQL

> I'm fairly new to PostreSQL, coming from MySQL. My Python application > generates these MySQL commands: > > drop database if exists Foo; > create database Foo; > use Foo; > Using the PostgreSQL online docs, my closest translation is: > > drop database Foo; > create database Foo; You supply the

[GENERAL] PostreSQL SQL for MySQL SQL

Hi, I'm fairly new to PostreSQL, coming from MySQL. My Python application generates these MySQL commands: drop database if exists Foo; create database Foo; use Foo; Using the PostgreSQL online docs, my closest translation is: drop database Foo; create d

Re: [GENERAL] Number of open files

"Mark Alliban" <[EMAIL PROTECTED]> writes: > I am having problems with the number of open files on Redhat 6.1. The value > of /proc/sys/fs/file-max is 4096 (the default), but this value is reached > with about 50 ODBC connections. Increasing the file-max value would only > temporarily improve matt

Re: [GENERAL] GUI Clients for PostgreSQL

Two other widely used GUI interfaces are hosted at GreatBridge.org: PgAdmin is a Windows-based GUI: http://www.greatbridge.org/project/pgadmin/projdisplay.php phpPgAdmin is a cross-platform Web-based GUI: http://www.greatbridge.org/project/phppgadmin/projdisplay.php They're both excelle

Re: [GENERAL] Re: sintax???

Alfonso Peniche <[EMAIL PROTECTED]> writes: > NOTICE: plpgsql: ERROR during compile of registrarconexion near line 1 > "RROR: parse error at or near " The overwriting of the initial "E" suggests that the thing is trying to complain about a carriage return (\r). Probably you saved your script f

[GENERAL] Re: startup Postgres on NT

On Thu, Feb 01, 2001 at 11:23:53AM +0700, [EMAIL PROTECTED] wrote: > 2. How to startup postgres with NT startup? The (klugey) procedure I used to setup up PostgreSQL as an NT service is documented in I've since patched a version of ipc-daemon so t

[GENERAL] Re: full text searching

> Well you wouldn't want to start building these kind of rules in your > application - better to have them in the search engine. The fulltextindex > in the contrib package does of course not offer anything like this, it > would be nice to see a third party addon provide fulltext capabilities for

Re: [GENERAL] 7.1 release date?

As soon as its ready? :) Seriously, we did a beta4 just before Linuxworld, and should be doing a beta5 relatively shortly as things have starrted to quiet down ... Thomas has his "two weeks grace" for docs, which will most likely start on the 15th of Feb, so we're looking at March 1st for a rele

[GENERAL] is grouping over many columns avoidable?

Hi there, I would like to do a query in order to retrieve a complete row of a table maching a number of requirements being stored in another table. The best I could think of was: select x.id, x.1, x.2, ..., x.30 from x, y where x.id = y.id and x.name like 'bla%' (y.attr=v

[GENERAL] Re: Problems with Relationships in SQL7

> I am trying to design a database in SQL Server ver7, using > Can anyone PLEASE HELP?? Possibly, but you'd be more likely to find an answer on an SQL Server mailing list. This list is for the PostgreSQL database. Greg

[GENERAL] Re: [ANNOUNCE] Request for speakers at O'Reilly conference

This is a good opportunity to promote PostgreSQL and I think we should utilize it. I'm not sure I'll have a chance to take part in the conference, but I'd like somebody describe GiST extension and presents tutorial how to use it. We could prepare some materials and examples from real life. I think

Re: [GENERAL] Debian packages of 7.1beta4 available

Oliver Elphick wrote: > > At long last I have got the Debian packages of 7.1beta4 done. Great ! > See http://www.debian.org/~elphick/postgresql/ I tried to install it "fresh" (i. e. on a Sid system with no previous PostgreSQL installation). The main Postgres packages tries to start ./etc/postm

[GENERAL] 4GL on Postgresql ?

Hi! You know, does Psql support for 4GL anyway?

[GENERAL] 7.1 release date?

Is there any idea of when is PostgreSQL 7.1 going to be released? Thanks in advance, Roberto "Wolfox" Amorim

[GENERAL] [JDBC][INTERFACES][NOVICE] Postgresql inteface to Star Office using JDBC

Has anyone had any luck interfacing StarOffice to PostgreSQL using JDBC? Here is what I have tried: 1. Created a pgsql database called test2 on our linux machine (rh 6.2/postgresql 7.0.3). 2. Placed the jdbc7.0-1.2.jar file in the class path on my windows machine and renamed it to postgresql.jar.

Re: [GENERAL] 7.1beta4-2 Debian packages... help!

DaVinci wrote: > I have tried to install experimental Debian packages of Postgresql > 7.1beta4, but get a dependency error with libssl09. > > My system is Debian inestable. I have a installed package of name > libssl096, but dependency is broken. > > What is the problem?. Thanks. l

[GENERAL] Re: [HACKERS] Re: Re: grant privileges to a database [URGENT]

Hello A few weeks ago I was interested in this question. My results were: - Yes, this is a sorrowful but true fact that if you enable access to someone to a database, she is automatically enabled to create objects in it. - Yes, the developers know it, and they said: there is a patch existing

Re: [GENERAL] 7.1beta4 initdb problem

Tim Barnard: > The program '/usr/local/pgsql/bin/postgres' needed by initdb does not belong to PostgreSQL version 7.1beta4. Check your installation. > Any ideas? Yes, happened to me, too. You need not to be root, but an unprivileged user (i.e. postgres). That's the strangest error message in

[GENERAL] Problems with Relationships in SQL7

Dear, I am trying to design a database in SQL Server ver7, using relationships between tables so that when I enter data in a particular field in one table, it will update a related field in another table. Also apply to deleting & inserting fields. I have set up the tables & their relationships bu

Re: [GENERAL] GUI Clients for PostgreSQL

The best one I like is pgaccess, but it does not support Copy/Paste. Hopefully it will later on! Check out: http://flex.flex.ro/pgaccess/ Art Taylor wrote in message <[EMAIL PROTECTED]>... > >Can anyone tell me what open source GUI clients are available for PostgreSQL >and where they can be dow

[GENERAL] RE: Solaris 8 compilation errors _OUTPUT

Hi John, It can't find one of the header files it needs to compile that file. I looked around and cannot find the header containing the definition of va_args anywhere -- these developers will know. Did you download gcc for Solaris 8 as a binary or package? If so, Bad idea -- and here's why: I

[GENERAL] Re: 7.1beta4-2 Debian packages... help!

On Tuesday 6 February 2001, at 10 h 50, the keyboard of DaVinci <[EMAIL PROTECTED]> wrote: > I have tried to install experimental Debian packages of Postgresql > 7.1beta4, but get a dependency error with libssl09. > My system is Debian inestable. You mean 'unstable' :-) The PostgreSQL versi

[GENERAL] Re: MS Access data to PostgrSQL data

>> hi, >> >> can anyone help me ? i need to convert a ms access .mdb file into >> somthing readable so i can insert it into my postgreSQL db... >> >> does anyone have any experiance? (preferably using PHP) >> >> Robert Korteweg >> The Netherlands export the .mdb file in comma seperated format and

[GENERAL] extracting parts from date values

Hi, How can I extract parts (e.g. month or day) from date values? -- Hubert Palme [EMAIL PROTECTED]

[GENERAL] Problem when calling setObject on Timestamp column with JDBC driver

I'm having a problem doing a select on an Order with a where clause below, getting a preparedStatemtnt and calling preparedStatement.setObject(timeStamp); Its return nothing and I know there is a row with that orderDate. SQL: select OrderID,CustomerID,EmployeeID,OrderDate,RequiredDate,ShippedDat

[GENERAL] RE: [NOVICE] RE: Sizing of LARGE databases.

On Fri, 2 Feb 2001, Michael Miyabara-McCaskey wrote: > Francisco, > > Excellent idea. > > Thanks for the info. Is this what you are doing now? And if so, since the > current version does not appear to have replication, have you found a > workaround? > -Michael I am new to PostgreSQL so I haven

[GENERAL] max cocurrent connection

When stress test Postgres, It can only hold about 200 cocurrent connection while keep calling DriverManager.getConnection() Is this number configurable? Or it is the limitation of postgres? Any suggestion? Thanks Feng

Re: [GENERAL] 7.1beta4-2 Debian packages... help!

On Tue, Feb 06, 2001 at 10:26:12AM +, Oliver Elphick wrote: > DaVinci wrote: > > I have tried to install experimental Debian packages of Postgresql > > 7.1beta4, but get a dependency error with libssl09. > libssl09 is a separate package, from unstable (non-US) I only see libssl096 in

[GENERAL] Packages to Install

What packages do I need for PostgreSQL 7.xx? I went to rpmfind.net and there were too many files. I am running a Pentium. Can someone please tell me what packages I need to install POstgreSQL 7.xx. P.S I am going to have a fresh install Thanks