PostgreSQL Database Forum

Hi all, I am working on a project to convert the data from dozens of ..dbf files to PostgreSQL Database. I wrote some perl script to employ dbfdump to extract data from .dbf files which sit on other remote server to a source text file. (Actually I just simply mount the directory to local server.) Then I modified the data in the source text...

Hi, I get the following error when I run make on Mac OS X v 10.1.5 Any ideas ? ---------------------------------------------------------- ar: illegal option -- s usage: ar -d archive file ... ar -m archive file ... ar -m position archive file ... ar -p archive ar -q archive file ... ar -r archive file ...

Has someone read this: http://www.wiscorp.com/sql/Sql99_p2.zip Are this guys at Whitemarsh Information Systems Corporation important in the SQL99 writing? -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; ----------------------------------------------------------------- Martín Marqués | mmarques@unl.edu.ar...

I am running OSDL-dbt1 - an e-commerce workload (http://www.osdl.org/lab_activities/kernel_testing/osdl_database_test_suite/osdl_dbt-1/) against PostgreSQL: 7.3.3. During the test, I saw a lot of messages in the database log file: NOTICE: _sc_id=0, _add_flag=0, _itemcount=0, _i_id=597, _pp_i_id=159, c_id=32760 ERROR: deadlock detected...

Is there a version of PostgreSQL that runs on a Windows machine?

Hi list, what happens with sequences if i dump a database and i want to reload it? Do i have to initialize the sequences like SELECT setval('sequence', max(id)) FROM table; ? Best regards,

Dear All, I have a simple table CREATE TABLE table1{ user name, si numeric }; Also I have function: CREATE FUNCTION check1(numeric) RETURN text AS'

I'm dealing with a project that requires me to query a MS SQL Server. Not a PostgreSQL issue I know but I want to ask if the LIMIT modifier is SQL standard? MS SQL Server uses a TOP modifier. select top 1 * from xxx; Whereas all the SQL RDBMS' I've used before used select * from xxx limit 1;

Howdy: Silly questions - Is it possible (or, has anyone got brave enough) to run PostgreSQL on Windows Server 2003? If so, what does it entail and how do I start? Thanks.

To whom it may concern: I installed postgres 7.3.4 on my laptop and have successfully been able to add the language pgsql. I haven't been able to get tcl to install properly even though I have installed the tcl rpm that came with the server rpms. I have searched my drive for the pgtcl file and found none. Does anyone know what's goin' on. ...

Hello, Can PostgreSQL resolve object dependencies automatic If we delete any object then Postgresql automatic resolve status (valid or invalid objects) regards ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster

Hi I have the data base "test" and two users "test1" "test2". I added the following record to pg_hba.conf local test password passwords I then created the "passwords" file in $PGDATA using pg_pasword and added entries for the two users "test1" and "test2". But when i tried to connect "test" using

Hi, all. Re: 7.2.2 I modified the postgresql.conf file to enable some debugging. I then did pg_ctl reload -D "blah". That got the debugging started. But when I tried to turn it off, it does not seem to want to stop debugging. I tried just commenting the lines out, then I tried explicitly changing them from true to false. Neither...

hi, Is there binary version of PostgreSQL available for Windows? Thanks, Mike _________________________________________________________________ Add photos to your messages with MSN 8. Get 2 months FREE*.

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Guys, since there isn't too much documentation/samples and stuff out for stored procedures etc, I decided to put up a quickhack on the web for code snippets like functions etc. I added some functions from the mailinglist I found interesting. I'd like to

Hi, I have a database, which just happens to be the main database on a RAQ4..(cobalt) that even when recreated it still dies, even before readding any tables.. Welcome to psql, the PostgreSQL interactive terminal. Type: \copyright for distribution terms

I'd like to run a clean up command on my tables to eliminate rows that I'm no longer using in the database. I want to do something like this: DELETE FROM tablename WHERE IS_REFERENCED_BY_FOREIGN_KEY IS FALSE; Does anyone know how something like this could be done in PostgreSQL? I know I can search all the tables that

I'm new to this list, so I'm not sure if this is the right place to post this. If not, please direct me to where it would be better to post it. Anyway, I'm creating a report generation tool of sorts in PHP for a database. As part of this report generation tool, I'd like to allow the user to reorder these results arbitrarily. In other words:...

Hi, I have an invoicing system using postgresql. Each time a customer makes a purchase, a new record is inserted into the "cart" table. The "cart" table, among other things, contains a customer_id field and a total for the amount purchased on the particular invoice. Now what I'd like to do is to calculate the total invoices for each customer in...

Hello list, A friend of mine just asked me this, why is postgres an ORDBMS and what does it mean and how to apply it on real development. Any comments about it Thanks --

Hi, all. I read that the "--with-perl" option "Build the PL/Perl server-side language". Does that mean the the switch is necessary to connect to the PostgreSQL database if you are using a perl program? It seems to me that it is only for allowing the use of perl *inside* of postgres and if one is just using perl programs to access the...

Dear All, I'm trying to create a table where the username and email can only be inserted into the table if the username is already in pg_user. The method I'm trying is: CREATE user( usename name, email text, FOREIGN KEY usename REFERENCES (pg_user)

I am curious if tablespaces are going to be seriously targeted for the next version. It really opens up new levels of scalability and is a killer feature from an administration perspective. Thanks, Brian

Hi, Had a problem with PsotgreSQL v7.3.4. I had a table that, after a while, decided to give me a fit: db=> insert into blocklist values ('2', 'km4n7s28ehiFizeYupm93Q', '1','2','3'); ERROR: Index idx_blk_id_addr is not a btree When I deleted and recreated the table, it worked fine. Any ideas?

hello, I need to change date format from mm.dd.yyyy to dd.mm.yyyy But only for one database. In other databases I need mm.dd.yyyy is it possible set this format permanently??? thanx... miso