Search results for query: *

You guessed it right. I am running postgreSQL on windows/cygwin. As for the path name is concerned Postgres assumes the folder in which I have installed cygwin as the root directory and I can successfully copy data into any file (so far I have tried .txt and .xls extensions) stored under the...

Thank u, but 7.3 version calls it 'trigger' but also accepts opaque from the old version as u have rightly pointed out. After searching various documentation finally I came across one which said its not possible to write trigger functions in SQL and should use rule instead. SO I am trying to use...

oh I figured out my problem. May be this will help someone else who have been struggling with such simple problems. Type one more single quote ' and then it will give u a prompt like mydb-#. Then type a ";" and it will come out giving an error message. Simple isn't it? but took some...

Hello there, I am trying to create a trigger which executes an SQL function. For creating a trigger, it insists that the return type of the function being triggered has to be 'trigger' type. So I tried creating a SQL function with return type 'trigger' as: create function display() returns...

Ya I am very new to PostgreSQl... examples would be great for me. I will greatly appreciate your help thank u. thanks again,

Hello, I am a new user of PostgreSQL. I recently installed it on windows 2000 using cygwin. I have been trying out simple things. However I am facing a problem. If I type a command wrong i.e while inserting a char type if I omit opening or closing quote('), then the screen gets stuck with...