[HACKERS] Access 97 PostgreSQL ODBC Driver Problems
ch has not been totally successful, not sure about the first but will experiment with that. Does anyone have opinions on ways of resolving these issues? === Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/ Peter replied, Repent and be baptized, every one of you, in the name of Jesus Christ for the forgiveness of your sins. And you will receive the gift of the Holy Spirit. The promise is for you and your children and for all who are far offfor all whom the Lord our God will call. -- Acts 2:38 http://www.heartlight.org/cgi-shl/todaysverse.cgi?day=20010304 === Created by Mail2Sig - http://pdunford.godzone.net.nz/software/mail2sig/ ---(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
[HACKERS] Getting unique ID through SQL
People will have seen my post on problems with PostgreSQL ODBC driver and MS Access 97. Access 97 has some problems when a record is added that contains a primary key field of type SERIAL. This has something to do with the fact that the value of the primary key is not actually generated until the record is sent to the server. It seems it is easiest for me to get the unique ID from the server myself and insert it into the record when Access creates it. In the realm of file based databases on a local machine it is easy to do this: store the unique variable into a special table, read it out, increment it and store it back. Very quick and there may only ever be one user. Things become different on an SQL server because there may be multiple users simultaneously accessing the database. Two SQL operations are required to retrieve the variable's value and update it: a SELECT and UPDATE. Depending on how fast your connection is, between the SELECT and UPDATE, someone else could have run the same SELECT and got the same value back. Then when both records are sent to the server with duplicate values in the same primary key, one will fail. What I need is some foolproof way of getting and updating the variable in one operation. Is it going to be an Int4 stored in a special table, or can it be a serial? Do I use a stored procedure or what? How do I get its value from Access? Whatever you think of Access, the alternative seems to be clunky PHP forms with lots of code behind them for data entry and editing. === Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/ Peter replied, Repent and be baptized, every one of you, in the name of Jesus Christ for the forgiveness of your sins. And you will receive the gift of the Holy Spirit. The promise is for you and your children and for all who are far offfor all whom the Lord our God will call. -- Acts 2:38 http://www.heartlight.org/cgi-shl/todaysverse.cgi?day=20010304 === Created by Mail2Sig - http://pdunford.godzone.net.nz/software/mail2sig/ ---(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
[HACKERS] ODBC driver issue in MS Access
I installed the ODBC driver for Postgre, and linked in a table which has a Serial field for the primary key. In MS Access, the type is shown as just "Number (long integer)". When I try to add new records to my database in Access, I don't put anything into the key field because the server is supposed to generate it automatically. But when my record is sent back to the server, it rejects it and Access displays "#Deleted" in all of the fields. Is this because Postgre can't fill in the key field and so rejects it as an integrity constraint violation? I don't get any errors from Access. Should my database create its own key values and store them itself? ======= Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/ In this way, love is made complete among us so that we will have confidence on the day of judgment, because in this world we are like him. -- 1 John 4:17 http://www.heartlight.org/cgi-shl/todaysverse.cgi?day=20010210 === Created by Mail2Sig - http://pdunford.godzone.net.nz/software/mail2sig/
[HACKERS] RE: ODBC driver issue in MS Access
But then a funny thing happened. When I refreshed the view, the records changed from "#Deleted" to all the data I put in, and the serial field was filled in with the correct value. How do I stop that from happening? -Original Message----- From: Patrick Dunford [mailto:[EMAIL PROTECTED]] Sent: Sunday, 11 February 2001 14:59 To: PostgreSQL List Subject: ODBC driver issue in MS Access I installed the ODBC driver for Postgre, and linked in a table which has a Serial field for the primary key. In MS Access, the type is shown as just "Number (long integer)". When I try to add new records to my database in Access, I don't put anything into the key field because the server is supposed to generate it automatically. But when my record is sent back to the server, it rejects it and Access displays "#Deleted" in all of the fields. Is this because Postgre can't fill in the key field and so rejects it as an integrity constraint violation? I don't get any errors from Access. Should my database create its own key values and store them itself? =========== Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/ In this way, love is made complete among us so that we will have confidence on the day of judgment, because in this world we are like him. -- 1 John 4:17 http://www.heartlight.org/cgi-shl/todaysverse.cgi?day=20010210 === Created by Mail2Sig - http://pdunford.godzone.net.nz/software/mail2sig/
[HACKERS] FW: User management
-Original Message- From: Patrick Dunford [mailto:[EMAIL PROTECTED]] Sent: Friday, 19 January 2001 15:19 To: [EMAIL PROTECTED] Subject: User management What commands in SQL enable administrators to view user / group information? Are there special SQL commands? Or are there special system tables? === Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/ Not only so, but we also rejoice in our sufferings, because we know that suffering produces perseverance; perseverance, character; and character, hope. -- Romans 5:3-4 http://www.heartlight.org/cgi-shl/todaysverse.cgi?day=20010118 === Created by Mail2Sig - http://pdunford.godzone.net.nz/software/mail2sig/
[HACKERS] Ignored PostgreSQL SET command
I have a line in a PHP script that looks like this: $set=pg_exec($dbconn, "SET DATESTYLE TO 'European'"); //Set date format Since my ISP updated their server, this appears to be ignored as pgsql always returns dates in ISO format. 1. What is the default format of dates returned that I can ALWAYS rely on? 2. Why is the command ignored? ======= Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/ There is no wisdom, no insight, no plan that can succeed against the LORD. -- Proverbs 21:30 http://www.heartlight.org/cgi-shl/todaysverse.cgi?day=20010101 === Created by Mail2Sig - http://pdunford.godzone.net.nz/software/mail2sig/
[HACKERS] Connecting across internet
If I want to connect to a Postgresql server on the internet, how do I do it? What protocol do I use? How do I send commands? etc. === Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/ Therefore, since we are receiving a kingdom that cannot be shaken, let us be thankful, and so worship God acceptably with reverence and awe, for our "God is a consuming fire." -- Hebrews 12:28-29 http://www.heartlight.org/cgi-shl/todaysverse.cgi?day=20001228 === Created by Mail2Sig - http://pdunford.godzone.net.nz/software/mail2sig/
[HACKERS] Digest subscription
How do I change to digest? The instructions on the website are wrong. === Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/ Rejoice with those who rejoice; mourn with those who mourn. -- Romans 12:15 http://www.heartlight.org/cgi-shl/todaysverse.cgi?day=20001215 === Created by Mail2Sig - http://pdunford.godzone.net.nz/software/mail2sig/
