Re: [ADMIN] database quotes - oops I'm talking rubbish
Sorry to reply to myself Ignore me sorry I'm talking rubbish. I was forgetting all processes would be owned by the postgres user and not the database user. (The oid2name stuff is still correct) - Stuart > -Original Message- > From: Hernan Nuñez [mailto:[EMAIL PROTECTED]] > Sent: 18 March 2002 11:37 > To: Yuri A. Kabaenkov; [EMAIL PROTECTED] > Subject: Re: database quotes > > > > Hi, > >I'm running postgresql-7.2 on FreeBSD 4.5 and I resolve > this using a > quota on the FileSystem applied to the gid. My problem is > that i could not > determine the relation between DataBase Name and the > Directory for that > DataBase. > > This works fine ... > > Regards > > Hernan Nuñez | VIA NET.WORKS Argentina > NICAR-P37184 | > [EMAIL PROTECTED] | local touch global reach > System Administrator | > Tecnología y Operaciones | http://www.vianetworks.com.ar > + ICQ: 36528552 | DDI +54 11 4323 > > > > > > - Original Message - > From: "Yuri A. Kabaenkov" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Sunday, March 17, 2002 5:54 PM > Subject: [ADMIN] database quotes > > > > Hello, > > Is there any way to setup quota per postgresql database? > > I need to limit db space for users. > > > > > > > > > > -- > > Best regards, > > Yuri mailto:[EMAIL PROTECTED] > > > > > > ---(end of > broadcast)--- > > TIP 1: subscribe and unsubscribe commands go to > [EMAIL PROTECTED] > > > > ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] database quotes
The name is the oid of the database. The oid2name in contrib can help here. However this doesn't solve the problem of new information going into the WAL files before being written into the actual tables. I am unsure what would happen if the database where unable to write to table files information what was already committed in the WAL. - Stuart > -Original Message- > From: Hernan Nuñez [mailto:[EMAIL PROTECTED]] > Sent: 18 March 2002 11:37 > To: Yuri A. Kabaenkov; [EMAIL PROTECTED] > Subject: Re: database quotes > > > > Hi, > >I'm running postgresql-7.2 on FreeBSD 4.5 and I resolve > this using a > quota on the FileSystem applied to the gid. My problem is > that i could not > determine the relation between DataBase Name and the > Directory for that > DataBase. > > This works fine ... > > Regards > > Hernan Nuñez | VIA NET.WORKS Argentina > NICAR-P37184 | > [EMAIL PROTECTED] | local touch global reach > System Administrator | > Tecnología y Operaciones | http://www.vianetworks.com.ar > + ICQ: 36528552 | DDI +54 11 4323 > > > > > > - Original Message - > From: "Yuri A. Kabaenkov" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Sunday, March 17, 2002 5:54 PM > Subject: [ADMIN] database quotes > > > > Hello, > > Is there any way to setup quota per postgresql database? > > I need to limit db space for users. > > > > > > > > > > -- > > Best regards, > > Yuri mailto:[EMAIL PROTECTED] > > > > > > ---(end of > broadcast)--- > > TIP 1: subscribe and unsubscribe commands go to > [EMAIL PROTECTED] > > > > ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [ADMIN] [CYGWIN] scheduling tasks under cygwin
I use at on NT to run .bat files Example for vacuum analyse: I first use at to run va.bat va.bat: c:\cygwin\bin\bash --login -i /va.sh va.sh: vacuumdb -a -z >/dev/null 2>&1 -Original Message- > From: Jean-Christophe FABRE > [mailto:[EMAIL PROTECTED]] > Sent: 15 March 2002 13:11 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: [CYGWIN] scheduling tasks under cygwin > > > Hi, > > to a larger way, > what is the best way to schedule tasks such as dump, vacuum, > analyze under > cygwin? > as I notice before, under Linux (and generic UNIX systems), > you can use > cron to do that, but under cygwin? > > JC > > > _ > Jean-Christophe FABRE > INRA - UMR Sol & Environnement tel: +33 (0)4 99 61 23 51 > 2, place Viala fax: +33 (0)4 67 63 26 14 > 34060 MONTPELLIER cedex 1 > FRANCE > > > ---(end of > broadcast)--- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] client connection
You need to use psql to connect eg: psql -h 10.240.22.203 -p -U postgres -d template1 This is assumeing you used initdb as the postgres user. If you haven't used initdb the command is: initdb -D /usr/local/pgsql/data Replace this with wherever you want to place it I suspect the as port 5432 is locked you either have another postmaster already running, or some left over lock files (in /tmp). There's a postgresql tutorial in the docs. - Stuart > -Original Message- > From: Gill, Jeffrey L [mailto:[EMAIL PROTECTED]] > Sent: 13 March 2002 01:34 > To: Pgsql Admin (E-mail) > Subject: client connection > > > I am trying to make my first connection from a client machine > to a postresql > server machine. What is the correct client command syntax > to connect to > the server? I do not want to attempt encryption yet so I am > not using SSH > or stunnel - I trying the easiest configuration i.e. telnet?. > > Specs: Client RedHat 7.1 2.4.2-2 kernal everything build > Server RedHat 7.1 2.4.2-2 kernal everything build with > Interchange 4.8 > > Both of these hosts are on the same subnet and can ping each other. > > I am learning Linux and Postgresql from scratch. > > I have started the postmaster with '-i' option to allow > TCP/IP connections. > > I used the following command to do this and am using port > to avoid lock > with port 5432. > Not sure if I have to do this but I show a message saying > 5432 was locked. > > pg_ctl -D /home/jeff/test -o '-i -p ' restart > > I edited the pg_hba.conf to allow any host from this subnet > to connect i.e. > host all 10.240.22.0 255.255.255.0 trust > > The way I tried to connect as the client to the server was > telnet 10.240.22.203 > > The response I get is > Connected 10.240.22.203 > Escape character is '^]'. > > When I hit the return key I get > Invalid packet length Connection closed by foreign host. > > What am I doing wrong or what else do I need to do? > > Thanks, > Jeff > > ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [ADMIN] Postgresql 7.1 "No database files found"
In 7.1 the directory names changed to be the oids. It appears to be you're start up script that is at fault. Hope this helps, - Stuart > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: 05 March 2002 07:03 > > > Hi, > > We recently installed pgsql 7.1 on Mandrake 8.1, and did a pg_dumpall > to import our old pgsql 7.0.2 databases. > > This morning, we tried to restart postgresql after a system crash, and > we find that we suddenly have an error starting postgresql with the > following message: > > [root@ocean home]# /etc/init.d/postgresql start > Checking postgresql installation: no database files found. >[ OK ] > Starting postgresql service: [FAILED] > > The strange thing is, is that the database and postgresql/postmaster > etc has been running for a month with no problems. > > By looking at the startup script, we noted that it needs a "template1" > directory, which we don't seem to have. We restored an old backup of > the pgsql directory, and it doesn't seem to exist there either. So > basically, we are not sure whether we have lost files in a system > crash, or something really weird is going on with postgresql. > > After doing an initdb, we noticed that template1 directory was > actually renamed to /var/lib/pgsql/data/1. Do this simply mean that > the startup script is incorrect? > > Does anyone have any suggestions? > > TIA, > > Meaghan > ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [ADMIN] can i use it on windows
Yes. You need to install cygwin (www.cygwin.com ). The development versions are available under the GPL. Currently there is a pre-built PostgreSQL include, but you need to seperatly download cygipc (can't remember the link of hand). There is a Postgresql README when you install. The PostgreSQL on cygwin mailing list is pgsql-cygwin. - Stuart > -Original Message- > From: Jayaram Bhat [mailto:[EMAIL PROTECTED]] > Sent: 12 March 2002 04:24 > To: [EMAIL PROTECTED] > Subject: can i use it on windows > > > Hi > > can i use post sql on windows. How can i purchase it and it > rate for a > company purpose > > > jayaram > > > > _ > MSN Photos is the easiest way to share and print your photos: > http://photos.msn.com/support/worldwide.aspx > > ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] Problem in installing PostgreSQL7.1.2 on Windows2000
Try the pgsql-cygwin mailing list. If you installed in the default location you put the cygipc-1.09-2.tar.gz file in c:\cygwin as this is the root, else put it where ever you installed cygwin. Then do tar -zxvf cygipc-1.09-2.tar.gz Note there is a PostgreSQL README if you install the PostgreSQL cygwin binary. Unfortunatly cygwin 1.3.9 doesn't work with PostgreSQL, so you'll also need to download the latest cygwin1.DLL snapshot from http://cygwin.com/snapshots You put cygwin1.DLL in /bin (c:\cygwin\bin for default install location) Hope this helps, - Stuart > -Original Message- > From: sreedhar [mailto:[EMAIL PROTECTED]] > Sent: 22 February 2002 13:28 > To: PostgreSQL; [EMAIL PROTECTED] > Subject: Problem in installing PostgreSQL7.1.2 on Windows2000 > > > Hi Jason, > > I installed "CygWin" on my windows 2000 system. If i click > cygwin prompt > just it is refershing. > > Downloaded cygipc-1.09-2.tar.gz and i could not get where I > have to put that > file.I your document you gave it as "/" directory. > > where can i run all unix like commands on my windows system. > > thanks in advance, hope i will get proper information. > > regards, > sreedhar > > ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] Where can I get Users and Roles information in PostgreSQL
Have a look at the system views pg_user and pg_group - Stuart > -Original Message- > From: Andy Ruhl [mailto:[EMAIL PROTECTED]] > Sent: 04 February 2002 13:33 > To: sreedhar > Cc: PostgreSQL > Subject: Re: Where can I get Users and Roles information in PostgreSQL > > > On Mon, 4 Feb 2002, sreedhar wrote: > > > Hi all, > > > > I am new bee to PostgreSQL. Where can I get Users and Roles > information in > > PostgreSQL. > > > > eg : In SQL-SERVER we can get users information using > 'sysusers' table. > > > > advance thanks for helping, > > I'm new too, so this may not be the best answer, but it's > useful anyway. > > If you are a superuser (ie: you can create other users), try this: > > select * from pg_shadow; > > Warning: Passwords will be shown in plain text. If you don't > want anyone > to see, make sure nobody is standing behind you! > > Andy > > -- > [EMAIL PROTECTED] > SDF Public Access UNIX System - http://sdf.lonestar.org > > ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [ADMIN] postgresql under Windows is slow
Try using NT. I use 98 for development but it just drops the ball to much for me to consider it for production (I've never had the regression tests complete on 98, mind you I havn't tried particularly hard either). If there is anyplace I would expect performance difference it would be in connection times due to windows forking (or lack there of). Cheers, - Stuart > -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED]] > Sent: 30 January 2002 17:58 > To: Oleg Bartunov > Cc: [EMAIL PROTECTED]; Pgsql Hackers > Subject: Re: postgresql under Windows is slow > > > Oleg Bartunov <[EMAIL PROTECTED]> writes: > > anybody has an experience how is stable postgresql under > Windows system ? > > I tried postgresq 7.1 under Cygwin, Windows 98 and was dissapointed > > by very bad performance. Are there something I could tune ? > > I got 250 sel/sec on simple select from table with 500 rows ! > > Under Linux I have 2500 sel/sec. > > Never tried it myself, but I distinctly recall someone reporting that > they got comparable performance on Cygwin as on Linux. You might try > asking on pgsql-cygwin. > > regards, tom lane > ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [ADMIN] system tables
pgadmin tables are not system tables; they're just used by the pgadmin tool. I believe there is an option to clean them out somewhere in pgadmin. System tables & views start with pg_ - Stuart > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, October 16, 2001 9:20 PM > To: [EMAIL PROTECTED] > Subject: system tables > > Hi > when I give \d command at psql prompt, it is displaying all the tables > including > pgadmin_tables etc in development database. But when I give the same > command in production datbase , it is just showing the table that have > been created, not any system tables( pgadmin tables or views). > why it is happening like this. > The development result set is: > DEPG=# \d > List of relations > Name| Type | Owner > +---+- > announce | table | develop > announce_index | table | develop > announce_manager | table | develop > contact_groups | table | develop > contacts_two | table | develop > cust_realms| table | pldev > events_calendar_two| table | develop > extranet_bug | table | develop > extranet_bug_notes | table | develop > extranet_bug_number| table | develop > extranet_bug_tasks | table | develop > extranet_docs | table | develop > extranet_groupfolderperms | table | develop > extranet_ids | table | develop > extranet_personfolderperms | table | develop > extranet_section | table | develop > extranet_section1 | table | pgsql > nprivate_label | table | pldev > personal_info | table | pldev > pgadmin_checks | view | pgsql > pgadmin_databases | view | pgsql > pgadmin_desc | table | pgsql > pgadmin_functions | view | pgsql > pgadmin_groups | view | pgsql > pgadmin_indexes| view | pgsql > pgadmin_languages | view | pgsql > pgadmin_param | table | pgsql > pgadmin_rev_log| table | pgsql > pgadmin_seq_cache | table | pgsql > pgadmin_sequences | view | pgsql > pgadmin_table_cache| table | pgsql > pgadmin_tables | view | pgsql > pgadmin_triggers | view | pgsql > pgadmin_users | view | pgsql > pgadmin_views | view | pgsql > private_label | table | pldev > ref_contact_type | table | pldev > ref_sla| table | pldev > ref_srv_type | table | pldev > survey_answers | table | develop > (40 rows) > > The production result is : > pgprod=# \d >List of relations > Name| Type | Owner > +---+--- > cust_realms| table | plprod > extranet_docs | table | extraprod > extranet_groupfolderperms | table | extraprod > extranet_ids | table | extraprod > extranet_personfolderperms | table | extraprod > extranet_section | table | extraprod > private_label | table | plprod > ref_sla| table | plprod > ref_srv_type | table | plprod > (9 rows) > > Thanks for any help in advance. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [ADMIN] Changing column modifiers?
ALTER TABLE authors ADD CHECK (NOT authorfirstname = NULL); Should that be: ALTER TABLE authors ADD CHECK (NOT authorfirstname IS NULL); ? Anyway, how about something like the following: UPDATE pg_attribute SET attnotnull='t' WHERE attname='field_name' AND attrelid in (SELECT pg_class.oid FROM pg_class WHERE relkind='r' AND relname='table_name'); Where field_name is the field name and table_name is the table name. Hope this helps, - Stuart > -Original Message- > From: Arne Weiner [SMTP:[EMAIL PROTECTED]] > Sent: Monday, September 10, 2001 10:06 AM > To: [EMAIL PROTECTED] > Subject: Re: Changing column modifiers? > > > It seems that it is not possible to alter column constraints and > table constraints do not include NOT NUL. > But you can use CHECK as workaround: > > ALTER TABLE authors ADD CHECK (NOT authorfirstname = NULL); > > Arne. > > Tim Boring wrote: > > > > Can you change a column modifier after you've created the table? For > > example, I have a table called "authors" with the following columns: > > authorid, authorfirstname, authorlastname, authormi, statecode, country, > > born, deceased. > > > > When I created the table, I forgot to make the "authorfirstname" and > > "authorlastname" columns NOT NULL. I've looked at ALTER TABLE but I > > don't see a way to use it to add NOT NULL...maybe I'm just missing the > > obvious? > > > > Any help/suggestions are appreciated. > > > > Thanks, > > Tim > > > > ---(end of broadcast)--- > > TIP 5: Have you checked our extensive FAQ? > > > > http://www.postgresql.org/users-lounge/docs/faq.html ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [ADMIN] FINAL: Multi-User PostgreSQL usage SECURITY
If you want them with the ability to alter the schema within there own database you could create them with createdb enable, create their db and then remove that privilidge, or create the db and change the db owner. I'm not sure how you'd grant them rights to create users. Maybe with an external C function that would check that who was doing what was allowed then update stuff appropriatly (maybe connecting to a special db storing any extra user info you need, probably which owner controls which user/group, although you might be able to do this by having a group for each db with all users a member and a special user for a db which all groups have as a member). - Stuart > -Original Message- > From: Mike Rogers [SMTP:[EMAIL PROTECTED]] > Sent: Friday, September 07, 2001 11:08 PM > To: [EMAIL PROTECTED] > Subject: FINAL: Multi-User PostgreSQL usage SECURITY > > Greets all; > So this issue was raised quite some time ago by many many people and > seems to contantly be asked by new PostgreSQL users. I never seem to find > any real answers for it. > > I am running a multi-user system and wish to have 10 user accounts > with > 10 different corresponding databases. I do not want user 'a' to be able > to > access user 'b's database- Only their own 'a' database. It really > shouldn't be this difficult. I realize that I can revoke access to all > users on the 'a' tables, but then user B can still create tables within > user > A's database. > There has to be an easy solution. As a hosting solutions provider for > a > small number of clients, I have always steered in the direction of MySQL > for > this feature, but I am seeing some demand for PostgreSQL. I do not have > the > resources to run each user with their own copy of PostgreSQL. > > I have tried chaning pg_hba.conf to add the database field to the > user, > but that doesn't seem to help at all. > > Any thoughts? If it makes a difference, i can make the databases the same > name as the username if I must. > > Please let me know if anyone knows of a way to do this. > > Thanks in advance; > -- > Mike ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [ADMIN] pg_dump & windows (what a mess...!)
What is the postgres database running on? Can't you just go to that machine and pg_dump? If not then you could try installing cygwin (www.cygwin.com). This will give you a unix like api and bash shell in windows. The default install also has a binary version of postgresql including tools such as pg_dump. If you are wanting the server running on the Windows box you will also need to download & install cygipc (see the FAQ-MSWIN on the postgresql site. There's also stuff on techdocs.postgresql.org), when you have ipc-daemon running you could then initdb. There is also a pgsql-cygwin list. - Stuart > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Friday, September 07, 2001 12:12 AM > To: [EMAIL PROTECTED] > Subject: pg_dump & windows (what a mess...!) > > Hi, > > I think I'm closer than yesterday to solving my troubles, but still need > some help (remember I couldn't start pg_dump from DOS' command line? well, > I still can't). > > As I couldn't what I was trying to, I tried to connect to Postgres via > psql > (from the command line) and I got the message: > > connectDB() -- connect() failed: No such file or directory > Is the postmaster running at 'localhost' and accepting connections on Unix > socket '5432'? > > I figured that, although through Windows clients everything works fine, > maybe from the command line it's not recognizing where Postgres is. Maybe, > I missed some configuration parameter or something else (TCP/IP > perhaps > what's pg_hba.conf for? How can I change it?) > > Can anyone of you, please, give me some advice? I'm getting crazy! My boss > will eat my liver, if I don't have this thing fixed right away > > Thanks in advance, for your patience. > > > Regards from Brazil > > Paulo > > A last question: Is there anybody in this crazy world as innocent as > myself > using Postgres & Windows? > ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [ADMIN] automatical start of postmaster for Windows2000
If you upgrade to the latest version of cygwin, there is a program called cygrunsrv which allows you to setup cygwin programs as services. It is worth noting there is (was?) a problem with cygwin shutdown leaving the postmaster.pid file due to windows issueing SIGHUP. I think the latest cygwin snap shots might prevent this and the prebuilt binary may be patched to ignore SIGHUP. Have a look at the pgsql-cygwin list for more info. Hope this helps, - Stuart > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Friday, August 31, 2001 4:12 AM > To: [EMAIL PROTECTED] > Subject: automatical start of postmaster for Windows2000 > > Dear PostgreSQL Adminstrators, > > Now I operate manually to run postmaster. > If the postmaster is automatically run, it is easy for a guest to use. > > Please tell me how to run automatically postmaster program for > Windows2000. > > OS: Windows2000 > DB: PostgreSQL 7.1.2 > SH: Cygwin B20 > Now command : postmaster -i & > -- > Jouji Miwa (Iwate Univ., JAPAN) ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [ADMIN] Windows Version
There is now a pre-built binary that comes cygwin, available at www.cygwin.com. There is also pgsql-cygwin mailing list. - Stuart > -Original Message- > From: Arne Weiner [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, August 30, 2001 6:28 PM > To: [EMAIL PROTECTED] > Subject: Re: Windows Version > > Yogesh Shahir wrote: > > > > > Hello Sir, > > > >Is postgreSQL is available for windows ? If yes, from where I can > downlo= > > ad it ? > > PostgreSQL is a multiplatform DMBS. You can download the tarball from > ftp.postgresql.org and compile postgres for MS Windows. There are some > extra requirements for compiling postgres under Windows. For more > information > read the FAQ_MSWIN file in the doc directory of the postgres tarball. > > > Arne ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[ADMIN] RE: ERROR: Conditional NOTIFY is not implemented
Off the top of my head:
Could you wrap it in a function:
CREATE FUNCTION rs_nt() RETURNS int4 AS '
BEGIN
RAISE NOTICE ''hello world'';
RETURN 0;
END;
' LANGUAGE 'plpgsql';
Then select this in the rule ( ie: DO (SELECT rs_nt()) )
Or:
CREATE FUNCTION rs_trig() RETURNS OPAQUE AS '
BEGIN
RAISE NOTICE ''hello world'';
RETURN NEW;
END;
' LANGUAGE 'plpgsql';
And execute it as a trigger function on INSERT/UPDATE (You'd have to replace
NEW with OLD for DELETE, OR make it an after trigger and return NULL).
There might be a way to RAISE without function overhead but I'm afraid I'm
not aware of it.
Hope this helps,
- Stuart
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, August 21, 2001 10:14 PM
> To: PostgreSqlAdmin
> Subject: ERROR: Conditional NOTIFY is not implemented
>
>
> I have a set of rules that worked in 7.0.3 for async notification. Those
> same set of rules don't seem to be working under 7.1.2. The rules look
> like this.
>
> CREATE RULE CONFIG_CHNG AS ON INSERT TO gs_config DO (NOTIFY
> CONFIG_CHANGE);
> CREATE RULE CONFIG_CHNG AS ON UPDATE TO gs_config DO (NOTIFY
> CONFIG_CHANGE);
> CREATE RULE CONFIG_CHNG AS ON DELETE TO gs_config DO (NOTIFY
> CONFIG_CHANGE);
>
> Here is a look at what my session looks like.
>
> bash# psql config
> Welcome to psql, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
>\h for help with SQL commands
>\? for help on internal slash commands
>\g or terminate with semicolon to execute query
>\q to quit
>
> config=# insert into gs_config values ('Life','42');
> INSERT 18842 1
> config=# update gs_config set config_value='0' where config_name='Life';
> ERROR: Conditional NOTIFY is not implemented
> config=# delete from gs_config where config_name='Life';
> ERROR: Conditional NOTIFY is not implemented
> config=# \q
>
>
> Obviously, this isn't what I desired to have happen. :) Anyone have any
> ideas on either a way that I can get around this little feature? I really
> really need the async notification stuff.
>
> Thanks,
> Matthew M. Copeland
>
>
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
[ADMIN] RE: Can't I do that?
Try using a select query. (eg SELECT func_name(arg1,arg2) AS result) - Stuart > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Friday, August 03, 2001 4:30 PM > To: [EMAIL PROTECTED] > Subject: Can't I do that? > > Hi, all! > > I'm pretty novice in using PostgreSql and I have many dummy questions. > Please forgive me for that! > > I intend to use it with Delphi 6, and I was trying to call a function that > I have just created. > > So, I dropped an StoredProc to the DataModule's application, and changed > the DataBaseName property to the one who represents the ODBC connection to > Postgres. > > When I tried to set the StoredProcName propertie, Delphi IDE's told me : > "Capability not supported". > > Does this mean that I can't use stored procedures with Postgres? > > Does anyone of you know some source of information about using Delphi with > Postgres ? > > I'll be very grateful for any advice. > > Thanks in advance, > > Paulo > > ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[ADMIN] RE: putting odbc on university server
The ODBC driver is under the LGPL so I see no reason why not (standard IANAL, etc... though). The only things you might have to do is also have the source available for download as well as the binary and also distribute a copy of the license. (I believe the full install includes such a license in its install). (not sure wether such use counts as distribution, any one else know?). (FYI: Most of postgresql is under a BSD license). - Stuart > -Original Message- > From: speeves [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, July 17, 2001 10:25 PM > To: [EMAIL PROTECTED] > Subject: putting odbc on university server > > Hi! > > I am wondering if it is ok to put the odbc driver for windows on a central > > university server? This will make it available to everyone that has > access > through the university Netware network. > > Please let me know. > > Thank you! > -- > Shannon Peevey > UNT-Central Web Support > [EMAIL PROTECTED] > 940-369-7786 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[ADMIN] RE: HELP PLEASE!! Installation on NT Machine.
Hello, have a look at: http://www.ca.postgresql.org/docs/faq-mswin Note however that cygwin now comes with prebuilt postgresql binaries so all you should need to do is to install cygwin and cygipc. Then ipc-daemon & initdb -D postmaster -i -D & If you have more problems the pgsql-cygwin list would probably be the best place to ask (have a look at www.postgresql.org for more info). - Stuart > -Original Message- > From: Neletulla, Sharat [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, June 26, 2001 3:08 PM > To: Grant; [EMAIL PROTECTED] > Subject: HELP PLEASE!! Installation on NT Machine. > > I am trying to install Postgresql on NT machine Since yesterday. I could > not able to do that. PL. HELP me. > What r all the things i have to do. HELP ME PLEASE > > > thanks > Sharat > ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
