[SQL] postmaster -i & establishes three connections why?
Hi, I've just upgraded my cygwin to 1.3.20-1 and postgresql to 7.3.2 And I found that when run postmaster -i & There are three connections being established and why is that? Administrator@DemoServer ~ $ LOG: database system was shut down at 2003-02-13 17:33:26 EST LOG: checkpoint record is at 0/841330 LOG: redo record is at 0/841330; undo record is at 0/0; shutdown TRUE LOG: next transaction id: 484; next oid: 16976 LOG: database system is ready $ ps -l PIDPPIDPGID WINPID TTY UIDSTIME COMMAND 2292 12292 2292 con 500 17:43:20 /usr/bin/bash 232022922292 2324 con 500 17:43:22 /usr/local/bin/ipc-daemo n 209222922292 2404 con 500 17:43:22 /c/progra~1/apache~1/apa che/cgi-bin/printspool 231222922292 2452 con 500 17:43:24 /usr/bin/postgres 204823122292 2048 con 500 17:43:28 /usr/bin/postgres 188420482292 1884 con 500 17:43:28 /usr/bin/postgres 250422922504 1960 con 500 17:43:36 /usr/bin ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[SQL] Fwd: How to encrypt a column
Hi,
I'm interested in encrypting an column in table. Are there any example using "C" to create the encrypted column, inserting and retreiving data to/from it?
the table is:
CREATE TABLE mytable ( id SERIAL PRIMARY KEY, crypted_content BYTEA );
I'm getting (null) in the field with the following sql statement:
strcpy(data, "data to be encrypted");
sprintf(query_buff, "insert into mytable values('%s', '%s')", key, encrypt(data, 'foo', 'bar'));
PQexec(conn, query_string);
Another question is can the encrypted column be of type "text" ?
Thank you
Start your day with Yahoo! - make it your home page
Re: [SQL] Fwd: How to encrypt a column
I do get a couple of warnings at compile time:
intrasend.c:496:37: warning: multi-character character constantintrasend.c:496:44: warning: multi-character character constantintrasend.c:517:84: warning: character constant too long for its type
Here's what is in the variable "data" = "0018`0018`64045`08112005`64045`1Discount=0.00;``2``~"
printf("%s", encrypt(data, "foo", "bar"))
prints out (null)
Thank youOwen Jacobson <[EMAIL PROTECTED]> wrote:
Jeff Lu wrote:> Hi,>> I'm interested in encrypting an column in table. Are there any> example using "C" to create the encrypted column, inserting and> retreiving data to/from it?>> the table is:> CREATE TABLE mytable (> id SERIAL PRIMARY KEY,> crypted_content BYTEA> );>> I'm getting (null) in the field with the following sql statement:>> strcpy(data, "data to be encrypted");> sprintf(query_buff, "insert into mytable values('%s', '%s')", key,Try printing out the contents of 'query_buff' here. You shouldn't begetting NULLs in the table, but you may well be getting '' (the emptystring) if encrypt(data, 'foo', 'bar') returns "" or (char *) (0).> encrypt(data, 'foo', 'bar'));> PQexec(conn, query_string);Even better, don't do i
t this
way. This is potentially open to SQLinjection attacks and definitely open to problems with "interesting" valuesof key.Look up PQprepare/PQexecParams for separating the query string from thevalues. I use ODBC indirectly, so I can't help you directly, but the docsatIN>should help.> Another question is can the encrypted column be of type "text" ?Can't see any reason why not, so long as the encrypted data is representedas text.---(end of broadcast)---TIP 5: don't forget to increase your free space map settings
Start your day with Yahoo! - make it your home page
[SQL] How to encrypt a column
Hi, I'm interested in encrypting column in table. Are there any example using "C" to create the encrypted column, inserting and retreiving data to/from it? Thank you __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Re: [SQL] hi any one can help me
You will need to manually remove the postgresql folder under Program files because uninstalling does not remove that folder for you. - Original Message From: Penchalaiah P. <[EMAIL PROTECTED]> To: [email protected] Sent: Sunday, December 3, 2006 5:33:41 AM Subject: [SQL] hi any one can help me Hi … I installed postgresql 8.1 .. then I uninstalled postgresql.. Now again I am re installing the same postgresql 8.1 .. but its not installing .its giving error like already user exists its showing… I removed those files from registry also.. but I am getting same error… Any one can help to reinstall my postgresql in my machine… Thanks & Regards Penchal reddy | Software Engineer Infinite Computer Solutions | Exciting Times…Infinite Possibilities... SEI-CMMI level 5 | ISO 9001:2000 IT SERVICES | BPO Telecom | Finance | Healthcare | Manufacturing | Energy & Utilities | Retail & Distribution | Government Tel +91-80-5193-(Ext:503)| Fax +91-80-51930009 | Cell No +91-9980012376|www.infics.com Information transmitted by this e-mail is proprietary to Infinite Computer Solutions and/ or its Customers and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at [EMAIL PROTECTED] and delete this mail from your records. Information transmitted by this e-mail is proprietary to Infinite Computer Solutions and / or its Customers and is intended for use only by the individual or the entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at [EMAIL PROTECTED] and delete this email from your records. Cheap talk? Check out Yahoo! Messenger's low PC-to-Phone call rates. http://voice.yahoo.com
