Search found 8 matches

by Shomer
06.06.2007, 18:52
Forum: Feature Requests
Topic: triggers
Replies: 8
Views: 2929

Since my first post, almost 1 year ago, I am here again to see the news... So, The new 6.6 version contains such feature as a component?
by Shomer
25.01.2007, 13:58
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Database exist?
Replies: 2
Views: 671

You will need the TZSQLProcessor. Also check it with a sql:

select datname from pg_database where datname = "mydatabase"
by Shomer
05.07.2006, 18:17
Forum: PostgreSQL
Topic: Allow my app to connect via internet
Replies: 2
Views: 3081

Allow my app to connect via internet

Hi all! Would like to allow my application to connect to the PostgreSQL, I am using Zeoslib and have tried to configure the firewall but no success. Also the pg_hba.conf. How should be the correct configuration to pg_hba.conf that could allow my client application to connect to my database?

Thank you
by Shomer
29.06.2006, 15:52
Forum: PostgreSQL
Topic: Application wont run...
Replies: 0
Views: 1318

Application wont run...

I have one application that is not running on the client machine and I dont know why. I have put that libpq65.dll, 73 and 72 but no success :( After pursuing I saw the application hangs on Datamodule open... please help!
by Shomer
29.06.2006, 15:45
Forum: Feature Requests
Topic: triggers
Replies: 8
Views: 2929

I have 2 applications.. the 1st one is working to update my table, and the 2nd will try to see if there is any new updating. Now a days I am using a TTimer with an opened query, so time to time I issue a refresh to the query. With Interbase I could create a trigger, so after any change (controlling ...
by Shomer
03.05.2006, 16:36
Forum: Feature Requests
Topic: triggers
Replies: 8
Views: 2929

triggers

I used to have triggers with Interbase and worked with TIBEvents, how to work with tiggers within PostgreSQL?

I am also having errors when creating EMS SQL the triggers. Sintaxe error...
by Shomer
03.05.2006, 16:30
Forum: PostgreSQL
Topic: Runtime database create
Replies: 3
Views: 2129

Solved! I use ZProcessor with something such:

Add('CREATE DATABASE "'+myDatabaseName+'" WITH ENCODING = ''latin1'' TABLESPACE = "pg_default"; ');

Works fine! :)
by Shomer
10.04.2006, 16:12
Forum: PostgreSQL
Topic: Runtime database create
Replies: 3
Views: 2129

Runtime database create

Hi there! I am new here and new to Zeos. I am trying to issue such statment but I even can imagine how: CREATE DATABASE "dd01" WITH OWNER = "postgres" ENCODING = 'latin1' TABLESPACE = "pg_default" LOCATION = 'c:\teste' TEMPLATE = "postgres"; On that example, d...