Re: [SQL] locking problem

> > hi, > > can anyone help me out on the following scenario: > why this is happening, if i'm doing any thing wrong or its the feature of p= > ostgres... I'd say it's a feature - see below. > > regards > cheetor > == > == > ==

Re: [SQL] Sometimes referential integrity seems not to work

scott.marlowe wrote: On Mon, 2 Feb 2004, Jan Wieck wrote: Stephan Szabo wrote: > On Sat, 31 Jan 2004, Tom Lane wrote: > >> Stephan Szabo <[EMAIL PROTECTED]> writes: >> > On Mon, 26 Jan 2004, Enio Schutt Junior wrote: >> >> In a database I am working, I sometimes have to delete all the records i

[SQL] date function problem

Hi All I have an expiration_date column in my table with data type as timestamp. I need to set that as one year after the current time. how do i do that. I am getting a casting problem whenever i try something. something like now()+ 1 year. Please let me know --mohan --

Re: [SQL] date function problem

--On Tuesday, February 03, 2004 10:51:45 -0500 [EMAIL PROTECTED] wrote: Hi All I have an expiration_date column in my table with data type as timestamp. I need to set that as one year after the current time. how do i do that. I am getting a casting problem whenever i try something. something lik

Re: [SQL] Sometimes referential integrity seems not to work

On Tue, 3 Feb 2004, Jan Wieck wrote: > scott.marlowe wrote: > > > On Mon, 2 Feb 2004, Jan Wieck wrote: > > > >> Stephan Szabo wrote: > >> > >> > On Sat, 31 Jan 2004, Tom Lane wrote: > >> > > >> >> Stephan Szabo <[EMAIL PROTECTED]> writes: > >> >> > On Mon, 26 Jan 2004, Enio Schutt Junior wrote

Re: [SQL] Sometimes referential integrity seems not to work

On Tue, 3 Feb 2004, Jan Wieck wrote: > scott.marlowe wrote: > > > On Mon, 2 Feb 2004, Jan Wieck wrote: > > > >> Stephan Szabo wrote: > >> > >> > On Sat, 31 Jan 2004, Tom Lane wrote: > >> > > >> >> Stephan Szabo <[EMAIL PROTECTED]> writes: > >> >> > On Mon, 26 Jan 2004, Enio Schutt Junior wrote

Re: [SQL] date function problem

Dnia 2004-02-03 16:51, Użytkownik [EMAIL PROTECTED] napisał: Hi All I have an expiration_date column in my table with data type as timestamp. I need to set that as one year after the current time. how do i do that. I am getting a casting problem whenever i try something. something like now()+ 1 yea

[SQL] request to plsql tutorial

please send me all the tutorials related to plsql i am in urgent need of it it would be very helpful for me if u send it as soon as possible thank you __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -

[SQL]

Hi I have a postgresql in my red hat linux machine which will be our webserver. previously we had mysql in suse linux in another machine. so we are having a new webserver now with postgresql. I want to transfer my tables in mysql to postgresql so that I continue with my stuff in the new server. I

Re: [SQL] Executing dynamic queries (EXECUTE)

Hello Tomasz, I´m going to study the FOR-IN-EXECUTE statement and to try again. Thanks, Carla Mello - Original Message - From: "Tomasz Myrta" <[EMAIL PROTECTED]> To: "Carla Mello" <[EMAIL PROTECTED]> Cc: "Lista dyskusyjna pgsql-sql" <[EMAIL PROTECTED]> Sent: Sunday, February 01, 2004 5:4

[SQL] SQL query

Hello, I would like to retrieve all the records from table A which have given lang_id and its modification date is later then modification date of the same id record with lang_id='pl'. Example: table A - data example == id | modification_date | lang_id +---

Re: [SQL]

On Tue, 3 Feb 2004, Prashanthi Muthyala wrote: > Hi > > I have a postgresql in my red hat linux machine which will be our webserver. > previously we had mysql in suse linux in another machine. so we are having > a new webserver now with postgresql. I want to transfer my tables in mysql > to postg

Re: [SQL]

On Tuesday 03 February 2004 17:46, Prashanthi Muthyala wrote: > > I tried to search for the transfer of tables from mysql to postgresql > located on different machines, but could not figure out exactly how to > start and proceed. There is a section on converting from MySQL at the url below. http

Re: [SQL] request to plsql tutorial

On Tuesday 03 February 2004 13:06, arun raj wrote: > please send me all the tutorials related > to plsql > i am in urgent need of it > it would be very helpful for > me if u send it as soon as possible Sorry - I'm not sure what plsql is. Do you mean plpgsql? Anyway, assuming you've read the manua

Re: [SQL]

Look at http://techdocs.postgresql.org/#convertfrom There are several documents discussing converting from MySQL to PostgreSQL. Jan Prashanthi Muthyala wrote: Hi I have a postgresql in my red hat linux machine which will be our webserver. previously we had mysql in suse linux in another ma