Re: [GENERAL] unique constraint on 2 columns

2007-04-20 Thread Vladimir Zelinski
This looks like more table design problem than database limitation. The one column should accommodate values from both columns with unique index built on this column. Your requirements tell me that these values are the same nature and should be placed in the same column. To distinguish between

Re: [GENERAL] Migrate postgres DB to oracle

2007-04-05 Thread Vladimir Zelinski
You can try metalink (https://metalink.oracle.com/), but they want $$$ for forum like this one. --- [EMAIL PROTECTED] wrote: - Mensaje original - De: bcochofel [EMAIL PROTECTED] Fecha: Jueves, Abril 5, 2007 7:46 pm Asunto: [GENERAL] Migrate postgres DB to oracle I need some help

Re: [GENERAL] question: knopixx and postgresql on flash drive

2007-03-23 Thread Vladimir Zelinski
SQLite database is much better choice for flash drive from my point of view. --- James Neff [EMAIL PROTECTED] wrote: Mark wrote: I would like to use postgresql with knopixx, Sounds like a simple idea :-) and I would like to get full version of postgresql stored on flash drive. I

[GENERAL] values from now() in the same transaction

2007-02-16 Thread Vladimir Zelinski
I created a function with VOLATILE directive. it's body looks like shown bellow cut start begin insert into monitor(ts, c1) values(LOCALTIMESTAMP, 'Step 1000'); -- start time -- query below runs for 20min insert ito t1 select * from big_table -- this timestamp

Re: [GENERAL] values from now() in the same transaction

2007-02-16 Thread Vladimir Zelinski
Thank you very much. It works. Vladimir --- Alvaro Herrera [EMAIL PROTECTED] wrote: Vladimir Zelinski wrote: I don't believe that it's bug, probably it's a feature of the postgreSql database. Correct. Is any way to insert a timestamp within the same transaction that would have

[GENERAL] How to search, how to post?

2007-02-14 Thread Vladimir Zelinski
Hi, I just now subscribed the mailing list, but I can't understand what I should do next. I need: 1) search forums for specific keywords 2) be able to post my question. How can I do that? I read help but it didn't have any information for helping me. Thank you, Vladimir

[GENERAL] Stored Procedure examples

2007-02-14 Thread Vladimir Zelinski
Hello everyone, I'm a brand new person to postgreSql, but not for databases. I came from Oracle and Sybase areas. I'm struggling to create a stored procedure. I searched on Internet for several hours trying to find a simple example, but didn't find anything. I saw dozens of questions how to