Re: [GENERAL] Support for idempotent schema changes?
David Lowe wrote: > So how can I make statements of the form: > * alter table only customers add constraint > a_previously_missed_constraint unique (a, b, c); > > * add column points int4 not null default 0; > idempotent? You just ignore the error if the object already exists. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] PG Dump 8.2
>> To my knowledge there are no 8.2 binaries for Ubuntu LTS. The best you >> could probably get is 8.1 which is a perfectly acceptable and stable >> release. >> >> Sincerely, >> >> Joshua D. Drake > > Well, there are 8.2 binaries for Ubuntu 6.10 [1], but for LTS (6.04) 8.1 > is the latest version available. Right, that makes sense because LTS doesn't rev versions of software. They will only stick with the current major version they shipped with, just like RedHat ES. Joshua D. Drake > > Regards > > MP > > > [1] https://launchpad.net/ubuntu/+source/postgresql-8.2 > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] PG Dump 8.2
Joshua D. Drake wrote: Mikko Partio wrote: Laurent ROCHE wrote: Hi, Does anyone know if Ubuntu 6.10 (LTS) has packages for PostgreSQL 8.2, from a recommandable place ? I can not recommend my clients to use 8.2 if there's nobody supporting the packages (so just compiling from the source code is not an option). To my knowledge there are no 8.2 binaries for Ubuntu LTS. The best you could probably get is 8.1 which is a perfectly acceptable and stable release. Sincerely, Joshua D. Drake Well, there are 8.2 binaries for Ubuntu 6.10 [1], but for LTS (6.04) 8.1 is the latest version available. Regards MP [1] https://launchpad.net/ubuntu/+source/postgresql-8.2 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] Configure can't find com_err on OpenBSD for --with-krb5
Jim Rosenberg <[EMAIL PROTECTED]> writes: > --On Saturday, March 3, 2007 11:24 PM -0500 Tom Lane <[EMAIL PROTECTED]> > wrote: >> Perhaps you need a --with-libs switch too? > Hmm. libkrb5 is in /usr/lib -- with all the rest of the libs -- not > somewhere special. OK, then the next likely answer is that there's something odd about the library dependencies for libkrb5. You need to look at the config.log output to see exactly what configure tried to do and what error it got. The "can't find" message really means that it couldn't link a program that tries to call com_err, and there are any number of possible reasons for that. regards, tom lane ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] Configure can't find com_err on OpenBSD for --with-krb5
--On Saturday, March 3, 2007 11:24 PM -0500 Tom Lane <[EMAIL PROTECTED]> wrote: I am trying to build PostgreSQL 8.2.3 on OpenBSD 4.0. When I give the command ./configure -v --with-openssl --with-krb5 --with-includes=/usr/include/kerberosV I get: checking for library containing com_err... no configure: error: could not find function 'com_err' required for Kerberos 5 Perhaps you need a --with-libs switch too? Usually, if the package didn't put its include files right in /usr/include, it likely didn't put the libraries right in /usr/lib either. Hmm. libkrb5 is in /usr/lib -- with all the rest of the libs -- not somewhere special. I also have /usr/lib/libcom_err.a too, and it seems to have com_err.o also. Putting in an explicit ./configure --with-openssl --with-krb5 --with-includes=/usr/include/kerberosV --with-libs=/usr/lib (sorry for the word wrap) doesn't help. The "standard" PostgreSQL port that OpenBSD wants to make is (alas) 8.1.8. -Thanks, Jim ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] Configure can't find com_err on OpenBSD for --with-krb5
Jim Rosenberg <[EMAIL PROTECTED]> writes: > I am trying to build PostgreSQL 8.2.3 on OpenBSD 4.0. When I give the > command > ./configure -v --with-openssl --with-krb5 > --with-includes=/usr/include/kerberosV > I get: > checking for library containing com_err... no > configure: error: could not find function 'com_err' required for Kerberos 5 Perhaps you need a --with-libs switch too? Usually, if the package didn't put its include files right in /usr/include, it likely didn't put the libraries right in /usr/lib either. regards, tom lane ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[GENERAL] Configure can't find com_err on OpenBSD for --with-krb5
I am trying to build PostgreSQL 8.2.3 on OpenBSD 4.0. When I give the command ./configure -v --with-openssl --with-krb5 --with-includes=/usr/include/kerberosV I get: checking for library containing com_err... no configure: error: could not find function 'com_err' required for Kerberos 5 This is puzzling, because com_err.o is clearly listed in libkrb5.a. Any thoughts on how to get this to build would be appreciated. -Thanks, Jim ---(end of broadcast)--- TIP 1: 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: [GENERAL] Can I getting a unique ID from a select
On Thu, Mar 01, 2007 at 06:16:02 -0800, Timasmith <[EMAIL PROTECTED]> wrote: > I am using hibernate, using a view like a read only table and I need a > primary key each time a select is issued. > > create view myview as > select rownum, t1.field, t2.field > from tableOne t1, tableTwo t2 > where t1.key = t2.fkey > > select * from myview > > But what I really need is > > select makemeauniquekey, t1.field, t2.field > ... Is there some reason you can't use the join key? ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
Re: [GENERAL] How Can I set a non standard date format?
[EMAIL PROTECTED] wrote: Hi All Esteemed Developers, I have a requirement to have dates like ddmmmyyy. ie: 03MAR07 I want to be able to have dates returned from a query in this format so that I can use passthrough queries from Access. I know I can use to_char to format the date anyway I want, but this causes the column to appear as a text datatype instead of a date datatype. I am exporting the data to Excel, and the columns that have dates formatted as text do not sort properly. That is why I want the column to remain a date type. Have you tried formatting the dates as mmdd? It will allow excel to sort the dates properly even if it sees them as numbers or text. My guess is that you may find it easier to send dates out as a standard dd/mm/ and have excel format them to display any way you want. Select the excel column with the dates and goto format cells if you select custom you can set the display format to ddmmmyyy or any other display you may think of. In Oracle I could use NLS_TIMESTAMP_FORMAT to accomplish this. But I cannot find a way to use PGDATESTYLE or anything else to to the same thing. Any ideas? best regards, billc ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/ -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 1: 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: [GENERAL] Partition Table
Good Stuff! Thanks Josh! M-- --- This e-mail message (including attachments, if any) is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, proprietary , confidential and exempt from disclosure. If you are not the intended recipient, you are notified that any dissemination, distribution or copying of this communication is strictly prohibited. --- Le présent message électronique (y compris les pièces qui y sont annexées, le cas échéant) s'adresse au destinataire indiqué et peut contenir des renseignements de caractère privé ou confidentiel. Si vous n'êtes pas le destinataire de ce document, nous vous signalons qu'il est strictement interdit de le diffuser, de le distribuer ou de le reproduire. - Original Message - From: "Joshua D. Drake" <[EMAIL PROTECTED]> To: "Martin Gainty" <[EMAIL PROTECTED]> Cc: Sent: Saturday, March 03, 2007 3:26 PM Subject: Re: [GENERAL] Partition Table > Martin Gainty wrote: >> Good Afternoon All- >> I come from the other DBMS from California where extremely large datasets >> could be partitioned into separate and distinct partition tables >> Lets say for example I have Property Table which contains a tera worth of >> data and to gain performnce in the indexing I *could* partition this table >> so that >> All Cities which are A-M are in Partition1PropertyTable >> All Cities which are N-Z are in Parition2PropertyTable >> Can I achieve this in Postgres DB? > > http://www.postgresql.org/docs/8.2/static/ddl-partitioning.html > > Joshua D. Drake > > >> Thanks, >> Martin -- >> --- >> This e-mail message (including attachments, if any) is intended for the use >> of the individual or entity to which it is addressed and may contain >> information that is privileged, proprietary , confidential and exempt from >> disclosure. If you are not the intended recipient, you are notified that any >> dissemination, distribution or copying of this communication is strictly >> prohibited. >> --- >> Le présent message électronique (y compris les pièces qui y sont annexées, >> le cas échéant) s'adresse au destinataire indiqué et peut contenir des >> renseignements de caractère privé ou confidentiel. Si vous n'êtes pas le >> destinataire de ce document, nous vous signalons qu'il est strictement >> interdit de le diffuser, de le distribuer ou de le reproduire. >> >> ---(end of broadcast)--- >> TIP 6: explain analyze is your friend >> > > > -- > > === The PostgreSQL Company: Command Prompt, Inc. === > Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 > Providing the most comprehensive PostgreSQL solutions since 1997 > http://www.commandprompt.com/ > > Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate > PostgreSQL Replication: http://www.commandprompt.com/products/ > > > ---(end of broadcast)--- > TIP 6: explain analyze is your friend > ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] Partition Table
Martin Gainty wrote: > Good Afternoon All- > I come from the other DBMS from California where extremely large datasets > could be partitioned into separate and distinct partition tables > Lets say for example I have Property Table which contains a tera worth of > data and to gain performnce in the indexing I *could* partition this table so > that > All Cities which are A-M are in Partition1PropertyTable > All Cities which are N-Z are in Parition2PropertyTable > Can I achieve this in Postgres DB? http://www.postgresql.org/docs/8.2/static/ddl-partitioning.html Joshua D. Drake > Thanks, > Martin -- > --- > This e-mail message (including attachments, if any) is intended for the use > of the individual or entity to which it is addressed and may contain > information that is privileged, proprietary , confidential and exempt from > disclosure. If you are not the intended recipient, you are notified that any > dissemination, distribution or copying of this communication is strictly > prohibited. > --- > Le présent message électronique (y compris les pièces qui y sont annexées, le > cas échéant) s'adresse au destinataire indiqué et peut contenir des > renseignements de caractère privé ou confidentiel. Si vous n'êtes pas le > destinataire de ce document, nous vous signalons qu'il est strictement > interdit de le diffuser, de le distribuer ou de le reproduire. > > ---(end of broadcast)--- > TIP 6: explain analyze is your friend > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ ---(end of broadcast)--- TIP 6: explain analyze is your friend
[GENERAL] Partition Table
Good Afternoon All- I come from the other DBMS from California where extremely large datasets could be partitioned into separate and distinct partition tables Lets say for example I have Property Table which contains a tera worth of data and to gain performnce in the indexing I *could* partition this table so that All Cities which are A-M are in Partition1PropertyTable All Cities which are N-Z are in Parition2PropertyTable Can I achieve this in Postgres DB? Thanks, Martin -- --- This e-mail message (including attachments, if any) is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, proprietary , confidential and exempt from disclosure. If you are not the intended recipient, you are notified that any dissemination, distribution or copying of this communication is strictly prohibited. --- Le présent message électronique (y compris les pièces qui y sont annexées, le cas échéant) s'adresse au destinataire indiqué et peut contenir des renseignements de caractère privé ou confidentiel. Si vous n'êtes pas le destinataire de ce document, nous vous signalons qu'il est strictement interdit de le diffuser, de le distribuer ou de le reproduire. ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] COPY FROM and multiple null strings
Angva wrote: > Hi, > > I've run into a little snag in my data loads, and I come seeking > advice before I resort to an ugly workaround... > > I have a function which runs COPY FROM several times. My problem is > that my data provider uses symbols to represent nulls - there is a > different symbol for each different data type. For instance a null > date would be '1900-01-01' and a null string would be '#'. Is there > any way to define multiple null strings in the COPY FROM command? > > As always, any suggestions would be much appreciated. Man... that sounds like eating elementary school spinach... you remember the kind that slithered down your throat? There are two immediate ways I can think of to handle this. 1. Write a parser in > Thanks, > Mark > > > ---(end of broadcast)--- > TIP 4: Have you searched our list archives? > >http://archives.postgresql.org/ > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] How Can I set a non standard date format?
[EMAIL PROTECTED] wrote: > Hi All Esteemed Developers, > > I have a requirement to have dates like ddmmmyyy. ie: 03MAR07 > > I want to be able to have dates returned from a query in this format > so that I can use passthrough queries from Access. I know I can use > to_char to format the date anyway I want, but this causes the column > to appear as a text datatype instead of a date datatype. Well, 03MAR07 is not a valid date. This is the formats we understand: http://www.postgresql.org/docs/8.2/static/datatype-datetime.html Joshua D. Drake > Any ideas? > > best regards, > billc > > > ---(end of broadcast)--- > TIP 4: Have you searched our list archives? > >http://archives.postgresql.org/ > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
[GENERAL] Support for idempotent schema changes?
At our development shop we use many different PostgreSQL databases simultaneously, each corresponding to a specific version of our software. For example, a developer might be working on v1.0 and v1.1 at the same time, while QA is busily testing/verifying version 1.0.3. All application code and SQL is managed in SVN, and we use scripts to automatically update our sandboxes from one version to another. Each database schema maintains its version history and current version, and the update scripts can move a schema from one version to the next (all in the context of a transaction of course). In general this works well when updates are applied in order and corresponding to a specific development branch. It doesn't work as well when updates need to be applied out of order corresponding to a different code branch. As I see it the key to making the update process work smoothly is to make the updates themselves idempotent. For data oriented operations this is usually accomplished via 'where not exists' clauses. However, most of the updates are not data operations, but schema operations, for example, adding a missed unique constraint, or a column. So how can I make statements of the form: * alter table only customers add constraint a_previously_missed_constraint unique (a, b, c); * add column points int4 not null default 0; idempotent? I can always fallback on scripting to accomplish this - I can write functions to check for the 'thing' (column, constraint, whatever) before attempting to create it (via php, python pgdb, or via stored procedures, etc.). But am I missing something in PostgreSQL which would allow me to accomplish the same in a more direct manner?
[GENERAL] COPY FROM and multiple null strings
Hi, I've run into a little snag in my data loads, and I come seeking advice before I resort to an ugly workaround... I have a function which runs COPY FROM several times. My problem is that my data provider uses symbols to represent nulls - there is a different symbol for each different data type. For instance a null date would be '1900-01-01' and a null string would be '#'. Is there any way to define multiple null strings in the COPY FROM command? As always, any suggestions would be much appreciated. Thanks, Mark ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
Re: [GENERAL] strange behaviour with sub-select and pl/pgSQL
On Tue, Feb 27, 2007 at 12:15:03PM +0100, Robert Partyka wrote: > Hi, > > I found PostgreSQL have strange behaviour with sub-select and pl/pgSQL, > see the case study at: > http://www.bobson.pl/pgsql/pgsql_sb1.html The PostgreSQL optimiser is pretty smart and will pull up simple sub-selects like yours. If you put your subselect into a view, you'd also want the optimiser to find the optimal plan, right? If you want to stop it pulling up the subquery, you can add an OFFSET 0 or ORDER BY or anything that makes it a not-simple subquery. That tells the planner to leave it alone. Hope this helps, -- Martijn van Oosterhout http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate. signature.asc Description: Digital signature
Re: [GENERAL] supporting 2000 simultaneous connections.
Hi, Thanks for your reply and help. The web application I am talking about is a Learning Management System. By simultaneous users I mean that all 2000 users should be able to access the application and for example say take a test. We are using JNDI connection pooling. I think we have to now think about upgrading the hardware as well. thanks for your time. regards Shiva --- Bill Moran <[EMAIL PROTECTED]> wrote: > In response to "Joshua D. Drake" > <[EMAIL PROTECTED]>: > > > Bill Moran wrote: > > > In response to Shiva Sarna > <[EMAIL PROTECTED]>: > > > > > >> Hi, > > >> > > >> I am working on a web application where the > front end is struts framework > > >> and back end is PgSQL 7.4. > > > > *cough*, you are going to greatly decrease your > ability to scale if you > > are running anything less than 8.1. > > > > > > Performance _will_ degrade if all of those > connections are busy at once, but > > > that's going to happen with any shared system. > The disk can only read from > > > one area at a time, and other system resources > will be contended for as well. > > > > 7.4 doesn't scale to what he wants, even on big > hardware. > > Oops ... didn't notice that. > > -- > Bill Moran > Collaborative Fusion Inc. > __ Yahoo! India Answers: Share what you know. Learn something new http://in.answers.yahoo.com/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] US Highschool database in postgres
http://en.wikipedia.org/wiki/Category:Lists_of_schools_in_the_United_States Has one parsed the list of high schools in the USA and stored in postgres or is there an open list of backup files that people can share so they can share their useful backups of useful dbs like list of high schools list of cities list of zipcodes etc thanks mArk On 3/1/07, Ron Johnson <[EMAIL PROTECTED]> wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hmmm. Have you Googled? "list of high schools in california" brought up some very useful sites. I would not be surprised if there were such sites for all the other states. You'll need some skill with Perl or Python to efficiently grab all the data, though. On 03/01/07 13:39, [EMAIL PROTECTED] wrote: > List of highschools by city state and county > Mark > > On 3/1/07, Ron Johnson <[EMAIL PROTECTED]> wrote: >> > On 02/27/07 01:04, mobil wrote: >> Is there a downlaodable high school database in postgresql > > What exactly do you mean by "high school database"? > > >> -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFF5zXpS9HxQb37XmcRAsUEAKDpswN/4IHBF4QFDDwCmn2kd6/K7gCfZlH2 PtSrXdRordiqRPkYSgzgSrQ= =zczG -END PGP SIGNATURE-
Re: [GENERAL] PG Dump 8.2
Mikko Partio wrote: > Laurent ROCHE wrote: >> Hi, >> >> Does anyone know if Ubuntu 6.10 (LTS) has packages for PostgreSQL 8.2, >> from a recommandable place ? >> >> I can not recommend my clients to use 8.2 if there's nobody supporting >> the packages (so just compiling from the source code is not an option). >> To my knowledge there are no 8.2 binaries for Ubuntu LTS. The best you could probably get is 8.1 which is a perfectly acceptable and stable release. Sincerely, Joshua D. Drake -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[GENERAL] pg temp tables
Hi, I have been going around telling everyone that there is no point using physical tables in postgres for temporary storage within a procedure. Why bother bothering the system with something which is only used in one procedure I said to myself... I have just learnt that with MS Sql Server, this is not the case, and that there are locks on some system table and temp tables eat up memory and lots of other unfortunate things. Can someone give me a 101 on temp table considerations? Or rather give me "the good link"? Cheers Anton ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] I'd love to know what the rest of this error messagei s.
> --- Original Message --- > From: Magnus Hagander <[EMAIL PROTECTED]> > To: Hannes Dorbath <[EMAIL PROTECTED]> > Sent: 03/03/07, 12:09:18 > Subject: Re: [GENERAL] I'd love to know what the rest of this error messageis. > > Hannes Dorbath wrote: > > Bill Moran wrote: > >> It's a shame -- I get the impression that the rest of that error message > >> would help you fix the issue, but I don't remember what you can do about > >> it. Probably something to do with group policy, or some other setting > >> in the security realm. > > > > > > Try CTRL + C while focus on the error dialog, then paste to notepad. > > That usually works. > > > > FWIW, the complete message comes out of this line: > snwprintf(errmsg,errsize,__("Your local '%s' > group contains > '%S'.\n\nThis is a common configuration error that causes security > issues. For this reason, PostgreSQL will not run until this error has > been corrected."), > groupname, > lookforsids[j].friendlyname); > > (sorry about the linebreaks) > > First of all, we should enlarge that buffer :) > > But second, I think we can remove the check altogether, now that we in > 8.2 will actually start from such an account. We did remove the check > for the actual account being in there... Dave, do you agree? Yes, please fix :-P /D ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] ftell mismatch with expected position
Bruce Momjian wrote: > Jan Muszynski wrote: >> I found this thread (I'm posting here because I'm not subscribed to >> Hackers) >> http://www.mail-archive.com/pgsql-hackers@postgresql.org/msg85241.html >> >> which seems to be talking about this issue. I'm just wondering what the >> current status on this is. Someone I know is getting this error -(I'm not >> 100% sure what version he's running other than it's an 8.2 series, >> although I am finding out. And yes it's definitely on Windows). >> >> Does he have to wait until 8.3? Will it be fixed in 8.3? Or is it fixed in >> the latest release? > > It will be fixed in 8.3. It is too risky to backpatch to 8.2.X. The > fix is in current CVS, but again that is 8.3. Uh, it was backpatched to 8.2... It's not in a release yet, but it should be in the next one. //Magnus ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
Re: [GENERAL] I'd love to know what the rest of this error message is.
Hannes Dorbath wrote: > Bill Moran wrote: >> It's a shame -- I get the impression that the rest of that error message >> would help you fix the issue, but I don't remember what you can do about >> it. Probably something to do with group policy, or some other setting >> in the security realm. > > > Try CTRL + C while focus on the error dialog, then paste to notepad. > That usually works. > FWIW, the complete message comes out of this line: snwprintf(errmsg,errsize,__("Your local '%s' group contains '%S'.\n\nThis is a common configuration error that causes security issues. For this reason, PostgreSQL will not run until this error has been corrected."), groupname, lookforsids[j].friendlyname); (sorry about the linebreaks) First of all, we should enlarge that buffer :) But second, I think we can remove the check altogether, now that we in 8.2 will actually start from such an account. We did remove the check for the actual account being in there... Dave, do you agree? //Magnus ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] I'd love to know what the rest of this error message is.
Bill Moran wrote: It's a shame -- I get the impression that the rest of that error message would help you fix the issue, but I don't remember what you can do about it. Probably something to do with group policy, or some other setting in the security realm. Try CTRL + C while focus on the error dialog, then paste to notepad. That usually works. -- Best regards, Hannes Dorbath ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] Interface to posgresql
makhan wrote: Hi I am trying to connect to the postgresql and make quries usuing my application in c language using the libpq library.can you please tell me how to setup the enviromnet and where to place files so that I can run examples given on the libpq site.( if I use gcc compiler on linux or borland turbo c) Regards The standard placing for the files is /usr/lib for libpq and /usr/include for the header files. These paths should be standard search paths for gcc I believe the linux installs have these files as part of the devel install - the postgresql-devel-xxx rpm - you will need to install that. If you have done a manual setup and build from source then /usr would be replaced with the prefix path used (./configure --prefix=...) eg. /usr/local/pgsql/lib is a common one. For gcc HEADER_SEARCH_PATHS is used for headers and LIBRARY_SEARCH_PATHS for libs. Or -I can be used as an option to gcc and -L with ld when linking. eg gcc -I /usr/local/pgsql/include myprog.c -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
[GENERAL] Interface to posgresql
Hi I am trying to connect to the postgresql and make quries usuing my application in c language using the libpq library.can you please tell me how to setup the enviromnet and where to place files so that I can run examples given on the libpq site.( if I use gcc compiler on linux or borland turbo c) Regards -- View this message in context: http://www.nabble.com/-GENERAL--libpq%2B%2B-installation-error-tf771167.html#a9283255 Sent from the PostgreSQL - general mailing list archive at Nabble.com. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq