[GENERAL] where find recent binary PostgreSQL

Hi, is there a packet source for recent PostgreSQL binaries? I just finished installing OpenSUSE 10.2 and like to add PostgreSQL 8.2.4 instead of the provided 8.1.5. I'd rather go with something that is at least vaguely official. PostgreSQL.org has only binaries for fedora+redhat and I found only

[GENERAL] Need a wee bit more info on PostgreSQL's SSL security options

y that got lost or is owned by a person who shouldn't be allowed to access the dbms anymore. How is this CRL file set up? Is there a documentation, that covers those matters more deeply than chapter 16.8 and 20.1 of PG's main documentation? Especially the whole client-side topic is rat

[GENERAL] odbc with encrypted ssl key?

Hi, is there a way to have MS-Access use ODBC and still use a passphrase encrypted private-key? Right now ODBC works with unencrypted key. For security reasons I'd rather have my private key stored encrypted. I suppose to do this Access had to tell the odbc driver the passphrase so that it can

[GENERAL] can I define own variables?

Hi, can I define connection-global variables within a ODBC connection ? Like that: connect to the DB set my_user_id = 42 Later a trigger would set a timestamp and the user-id when a record gets updated. obviously different connections would need differnt variable-values. the variable should

Re: [GENERAL] can I define own variables?

d access this client-local environment-variable for updates? How can the server-located function see client-local Env-Vars ? Regards Andreas Martin Gainty schrieb: http://www.postgresql.org/docs/8.3/static/libpq-envars.html use environment variables PGHOST is the host for Postgres PGHOSTADDR

Re: [GENERAL] Version 8.3

Alexander Staubo schrieb: On 10/27/07, Bob Pawley <[EMAIL PROTECTED]> wrote: I would like to try PostgreSQL 8.3 without uninstalling version 8.1. Is this possible?? Sure. If you're on Unix, download the source and install it somewhere in, say, your home directory. This requires a certa

[GENERAL] Need magic to clean strings from unconvertible UTF8

d the problematic rows. How could I delete every char in a string that can't be converted to WIN1252? Regards Andreas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Need magic to clean strings from unconvertible UTF8

Am 07.11.2010 06:54, schrieb John R Pierce: On 11/06/10 9:35 PM, Andreas wrote: somehow there have unconvertible characters sneaked into my DB. Very probaply they came in via Imports from MS-Access. Access doesn't complain but when I try to export stuff with pgAdmin to csv I get an error

Re: [GENERAL] What is Dialect

Am 22.11.2010 08:32, schrieb Adarsh Sharma: I am reading about Dialects of different databases. Yet I can't understand what is the need of dialect in Postgres or any other like Hibernate uses Dialect of all Databases for ORM. What is it & As far as I know, the term dialect is used to express

[GENERAL] How to get PG 9.3 for a RaspberryPI (Debian Wheezy)?

use of the missing net socket when it tries to initialize the cluster. I then even tried to remove the local repository and install PG 9.1. That doesn't work either now. Same problem with the socket. Is there a way to get a working PG9.3 on a Rasberry? regards Andreas PS: Yeah, I

Re: [GENERAL] How to get PG 9.3 for a RaspberryPI (Debian Wheezy)?

Am 05.08.2014 um 06:32 schrieb Michael Paquier: On Tue, Aug 5, 2014 at 12:32 PM, Andreas wrote: Is there a way to get a working PG9.3 on a Rasberry? This seems like a problem inherent to your OS or your RPMs as two buildfarm machines are Raspberry PIs and are able to run Postgres: hamster

Re: [GENERAL] How to get PG 9.3 for a RaspberryPI (Debian Wheezy)?

you can get it going it would be utterly great if you wrote an howto in your blog. :) Regards Andreas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] How to get PG 9.3 for a RaspberryPI (Debian Wheezy)?

Am 08.08.2014 um 01:20 schrieb Tom Lane: Andreas writes: When I checked the logfile of the local PG-9.3 server I found an error on startup that complained it couldn't bind a IPv4 socket for 5432. Another error says autovauum is not running. It would help if you provided the exac

[GENERAL] How to run a second instance on the same server?

Hi, I've got 2 hardware servers running PG 9.3.5 from the postgres.org-repository. It's a Ubuntu server 12.x. Box 2 replictes box 1. That works. I'd like to use Box 2 as a Test- and Training installation as it is probaply bored to death just mirroring Box 1. AFAIK I can't just create an addi

[GENERAL] Can I habe multi table indices?

. How can I do this? regard Andreas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Can't increase shared_buffers for PostgreSQL on openSUSE 12.3

something higher, PG won't start anymore. I had the same issue back with openSUSE 12.1 and it was solved when I switched from systemd back to sysvinit. How can I get more memory for PG on openSUSE 12.3 ? Regards Andreas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.or

Re: [GENERAL] Can't increase shared_buffers for PostgreSQL on openSUSE 12.3

Am 14.06.2013 20:55, schrieb Peter Geoghegan: On Fri, Jun 14, 2013 at 11:55 AM, Andreas wrote: How can I get more memory for PG on openSUSE 12.3 ? http://www.postgresql.org/docs/9.2/static/kernel-resources.html OK I think that did it :) I'm just wondering what point it could be t

[GENERAL] PG 8.3.x doesn't get build

Hi, on my old SUSE 9.3 box the build won't run through for PG 8.3.0 and 8.3.1. I earlier tried 8.3.0 and gave up. Now 8.3.1 doesn't work either. I'm in directory postgresql-8.3.1 and run ./configure --enable-nls='de' --enable-thread-safety the makefile gets created Then I run make The process d

Re: [GENERAL] PG 8.3.x doesn't get build

Alvaro Herrera schrieb: Tom Lane wrote: Andreas writes: make[3]: *** No rule exists for Target �utf8_and_euc_jis_2004.o�, needed to create �libutf8_and_euc_jis_2004.so.0.0�. END. There are two or three reports like this in the archives. It appears to be related to using an

[GENERAL] how drop a role that owns stuff ?

Hi, for some cleaning up I'd like to drop a certain role. Now DROP ROLE yields an error and complains about 271 objects being owned by this role. Is there an easy way to switch ownership of those objects to another role? At least, is there a way to store those dependencies as a file? The conte

[GENERAL] Design question: Should "postgres" own all the db objects?

Hi, who should own the db objects? I once read one should not let postgres or any other superuser own the tables and what not. Instead one should better create a separate user role with little privileges to be the owner. I'm not quite sure why this was abvised. Maybe like not using root for ev

[GENERAL] How move a referenced table between schemas?

Hi, how can I move a table from one schema to another even though it is referenced by foreign keys? Cloning the table and the manually recreating every reference shouldn't be the only way, or is it? :( How can I dump/export every reference on a table? Until now I call DROP TABLE and look in the

Re: [GENERAL] Postgres 8.4 literal escaping

Hi, I've got a similar issue with a function that uses regular-expression-magic. I got it from the sql list and it works but I'm just about 75% aware of how. Still PG complains about those \\ everywhere. Replacing every \ by || E'\\' || would make it ... cough ... not looking cuter as it all

[GENERAL] Flexibility of views and functions?

Hi, I need to do some reporting for projects that have some columns that stay the same for every project and then every project brings along some project specific stuff. Now I've got a big view for everyone of those about 100 projects (and growing) that is about 80% the same as every other view

[GENERAL] COPY command on windows???

Hi, I'd like to read a csv file into PG 8.4. COPY relations FROM E'd:\\relations.csv' CSV HEADER; It throws (translated): ERROR: can't open file >>d:\relations.csv<< for reading file or directory not found The PG doc doesn't describe the path-syntax for windows. With google I only find referenc

[GENERAL] PG 9.3 complains about specified more than once ??? Those views worked in PG 9.1 + 9.2

Hi, *I ran into a major problem when I tried to import a backup from 9.1. into a 9.3 PG.* I just installed PG 9.3 on a new linux box. Then I wanted to import a plaintext dump of a DB that was created by pg_dump of PG 9.1 There are a lot of views that have joins to a subquery in the from-cla

Re: [GENERAL] Re: PG 9.3 complains about specified more than once ??? Those views worked in PG 9.1 + 9.2

Am 11.09.2013 21:02, schrieb David Johnston: Andreas-3-2 wrote Hi, *I ran into a major problem when I tried to import a backup from 9.1. into a 9.3 PG.* I just installed PG 9.3 on a new linux box. Then I wanted to import a plaintext dump of a DB that was created by pg_dump of PG 9.1 There

Re: [GENERAL] Re: PG 9.3 complains about specified more than once ??? Those views worked in PG 9.1 + 9.2

Hi David, your 3 examples work as you expected. That is 1+2 work and 3 throws an error. I tried to figure out an example and found something peculiar. The issue arises when there is another join in the subquery after the one with the reused table alias. There is no error without this followin

Re: [GENERAL] Re: PG 9.3 complains about specified more than once ??? Those views worked in PG 9.1 + 9.2

mbled dynamically in my application. Those won't get executed in the initial import of the db-dump but will come up anytime later when the query gets used the first time. This is a no go:( regards Andreas Am 12.09.2013 00:33, schrieb Andreas: Hi David, your 3 examples work as you expected.

Re: [GENERAL] Re: PG 9.3 complains about specified more than once ??? Those views worked in PG 9.1 + 9.2

n tblA.a_id = x.c_id; Am 12.09.2013 00:52, schrieb David Johnston: Andreas-3-2 wrote I never placed a bug-report. :} Could you give a hand? Sure. PostgreSQL homepage (postgresql.org) "Report a Bug" link on right-hand side of page. Fill in the form. SEND THIS>>>&g

[GENERAL] Howto import regularly some CSV files with variing names?

Hi, I need to import some log-files of an application running on a different host. This app can't talk to the db but only creates daily a dump in a remote directory that is mountable via samba by a Linux host that runs the db-server. The import would be easy if the files had a constant name

Re: [GENERAL] Howto import regularly some CSV files with variing names?

Am 24.09.2013 02:25, schrieb Adrian Klaver: On 09/23/2013 05:19 PM, Andreas wrote: I need to import some log-files of an application [...] The import would be easy if the files had a constant name but the app creates csv files with names like "ExportMMDD". So how would

[GENERAL] Is there something like a limited superuser to give to a db-assistant?

Hi, how can I give adb-assistant the rights to create and drop schemas, tables, views ... BUT keep him out of certain existing schemas and tables? This position of an restricted db assistant is new for us and it wasn't considered in our access rights until now. Our DB got a wee bit komplex

[GENERAL] Need help how to manage a couple of daily DB copies.

Hi, I'd like to set up a DB-Server that keeps copies of our productive db for an external db-assistant. He should prepare chores on the test-server and mail the sql scripts to me. I'll look over those scripts and run them against the productive db myself. So I'd like to have a daily cron job d

Re: [GENERAL] Need help how to manage a couple of daily DB copies.

Am 25.10.2013 04:15, schrieb Shridhar Daithankar: On Friday, October 25, 2013 03:53:14 AM Andreas wrote: Hi, I'd like to set up a DB-Server that keeps copies of our productive db for an external db-assistant. He should prepare chores on the test-server and mail the sql scripts to me. I&#x

Re: [GENERAL] maximum size limit for a query string?

Zitat von AI Rumman : Is there any maximum size limit for a query string in Postgresql 9.0.1? If yes, what is it ?. Not sure, but maybe 16 MByte, see http://www.phpbuilder.com/board/archive/index.php/t-10250064.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To m

Re: [GENERAL] init script or procedure

No, that's not possible. Zitat von "Gauthier, Dave" : Does PG support the use of an init script or procedure? I'm looking for something that'll run unconditionally every time someone makes a DB connection. This script will create a temp table and stuff some data in it for general use wit

[GENERAL] how just install psql on windows?

Hi, can I just install psql on windows? Just the client without the server. There ist the server release as zip-file that includes psql so I at least hadn't had to actually install a service with a db cluster but having to keep all the server binary around is a wee bit overkill when I just nee

[GENERAL] Windows: where to put pgpass.conf for user "system"

Hi, I need to let a process running under user "system" call psql to store some event data into a database. The process calls a cmd-batchfile with parameters that constructs an insert-query and fires it off with psql. So far that works just for real user accounts but not for system. Where sh

[GENERAL] how to install 9.1 on non-graphical server?

Hi, is there a way to install the EnterpriseDB V9.1 release on a server without X-Windows? I've got an OpenSuse 11.4 and the have only V9.0.4 in their repository so I'd need the binary of EnterpriseDB. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to yo

[GENERAL] Log-Info Replication

Hello. I tried to use replication with version 9.1. But i get always the Error FATAL: falsche Pr?fsumme in Kontrolldatei I think, it would be good get a hint on a server with 'hot_standby = on' "if you try to replicate: it is not possible to replicate between 32 and 64bit&qu

[GENERAL] Can I integrate PostgreSQL into MS Visual Studio EXPRESS ?

Hi, can I integrate PostgreSQL into MS Visual Studio EXPRESS ? AFAIK odbc or similar ways to access non-ms-dbms are no standard options of the Express version, is it? Mind you, I dont want to build PG with MSVS. I'd be interested to use PG instead of ms-sql. -- Sent via pgsql-general mailing l

[GENERAL] pg_log is 2 hours ahead ???

Hi, I'm running a PG 9.1.3 on OpenSuse 12.1. I found that pg_log is 2 hours ahead though date on the console shows the right date and time. I have the ntp daemon watching the system's time every 60 minutes so this shouldn't be an issue. The time in PG's logfiles filenames as well as the t

[GENERAL] PG vs MSSQL language comparison ?

Hi, I'm not into comparing which DBMS is better as we all know ... kind of ... well ... I'd like to find ressources to look up how one can do X in MSSQL when one knows how it is done in PG's SQL and the other way around. regards Andreas -- Sent via pgsql-general mail

[GENERAL] DROP CASCADE

Hi I encountered something that puzzled me a bit. Is it expected that DROP table CASCADE drops this table and just the foreign key constraints but not the refering tables? PG 9.2.1 on WinXP -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscript

[GENERAL] Need help for import of text file

e import step and replace the 2 blanks with 1 blank. I use an OpenSuse server so some linux tool would do. regards Andreas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Need help for import of text file

Am 15.12.2012 22:22, schrieb Peter Bex: On Sat, Dec 15, 2012 at 10:16:55PM +0100, Peter Bex wrote: A simple sed(1) expression should do the trick: sed -E 's/ +/ /g' old-file > new-file I just remembered where I could check, and the GNU sed equivalent is: sed -r 's/ +/ /g' old-file > new-file

[GENERAL] Need magic that checks if a collumn contains values that CAN NOT be converted to Latin1

x27; complains that this weren't a valid UTF8 code at all. So how was it accepted and stored in the first place? When I know which record has faulty content I can correct it. regards Andreas :) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your sub

[GENERAL] weird sortorder issue

Hi, I've got a produktive pg-server V8.4 on SuSE and my dev-server on winxp localhost. The 2 servers produce different results in text sorting. The local server sorts as expected but the productive db produces unexpected orders. They have identical data. That the testbox has daily backups of t

[GENERAL] Need magic for identifieing double adresses

like this with postgresql ? I fear this will need still a lot of manual sorting and searching even when potential peers get automatically identified. Regards Andreas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Need magic for identifieing double adresses

Am 16.09.2010 13:18, schrieb Sam Mason: On Thu, Sep 16, 2010 at 04:40:42AM +0200, Andreas wrote: I need to clean up a lot of contact data because of a merge of customer lists that used to be kept separate. What to do depends on how much data you have; a few thousand and you can do lots of

[GENERAL] How: constants in multi-column-foreign-keys ?

Hi, a lot of attributes get stored as numbers. Usually I built a small table with a numerical key-column and a text-column to use in joins. Is there a way to store them all in a new table that has a 3rd column for group-numbers instead of having a single table for every textattribute-group?

Re: [GENERAL] How to lock and unlock table in postgresql

Zitat von Siva Palanisamy : Hi Alban, Thanks for the reply. 1) I'm using PostgreSQL 8.1; So, I can't use RETURNING clause! You should Upgrade ASAP! 8.1 is 'out of lifetime'. Regards, Andreas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

[GENERAL] Philosophical question

Hi, I asked elsewhere about the best way to store db credentials within a user-session of a web-app. It appeared that it was for everybody but me evident that instead of heaving a db-role+passwd for every user of an application it was better to have just 1 set of db-credentials for the appli

Re: [GENERAL] Philosophical question

Am 14.12.2011 14:28, schrieb Craig Ringer: On 14/12/2011 8:32 PM, Andreas wrote: Hi, I asked elsewhere about the best way to store db credentials within a user-session of a web-app. Where? Link? Well, it was on the general list of php.net. I read your link and understood your not a

Re: [GENERAL] Philosophical question

Am 15.12.2011 05:47, schrieb Darren Duncan: Darren Duncan wrote: A practice I like that I've seen done for a federal-government scale database program is to have each person using the application to login to the database using their own temporary database user. How it works is that the databa

[GENERAL] How to split up phone numbers?

Hi, is there a way to split up phone numbers? I know that's a tricky topic and it depends on the national phone number format. I'm especially interested in a solution for Germany, Swizerland and Austria. I've got everything in a phone number column that makes hardly sense like: +49432156780 004

[GENERAL] Howto Replication for dummies?

Hi, I've got a PG 9.1.3 on an OpenSuse 12.1 runnig that lately crashed because of memory allocation errors probaply due to failing RAMs. In this case the server died thursday afternoon and at first didn't comlain when I restartet it. Later some queries produced "out of memory" errors which is

[GENERAL] Desperately need a magical PG monitoring tool

Hi, is there a tool for monitoring PG servers? Something that checks if a master and a hot-standby is still running flawlessly. I'd be nice if one could generously overlook some errors like wrong passwords. The standby should be watched if it keeps in sync with the master. I have a cron j

[GENERAL] Problems with Binary Replication

Hi, I configured a master and a hot-standby server as described here: http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#Starting_Replication_with_only_a_Quick_Master_Restart At first everything looked ok. Then some days later I find that at least some sequences on the hot-standby are h

Re: [GENERAL] Problems with Binary Replication

s suppose - and hope - at least the data tables stay in sync. But with this phenomena I can't trust the system, can I? and I can't use the hot-standy to pull the backups from there to lighten the load of the master. :( Am 31.03.2012 21:42, schrieb Andreas: Hi, I configured a

Re: [GENERAL] Problems with Binary Replication

Am 31.03.2012 23:38, schrieb Tom Lane: Andreas writes: Now I added 1 row on the master. Before both sequence start values were 403. After the insert the master shows 404 as expected but the "hot-standby" shows 436. What are you doing to get it to "show" a value --- not n

Re: [GENERAL] copy syntax

Am 04.04.2012 22:01, schrieb Andy Chambers: dcm_eob=> copy ar_data from '/tmp/ar-data.csv' with header true; ERROR: syntax error at or near "true" LINE 1: copy ar_data from '/tmp/ar-data.csv' with header true; I can't figure out what's wrong with the syntax above. Is something missing? cop

[GENERAL] how to group by similarity ?

Hi, I'm trying to get an idea about pg_trgrm. I created a GIST index on a text column in a table. Now I can filter the table with similarity(). How would I group the table so that it shows groups that have similarity () > x ? Lets say the table looks like this: id, txt 1, aa1 2, bb1 3,

[GENERAL] How restrict select on a view ?

Hi, I'd like to have a view only to be used by certain users. The tables are public. Can this only be done by restricting access to the tables? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-ge

Re: [GENERAL] How restrict select on a view ?

Merlin Moncure schrieb: what does this get you? Not as much as I first hoped. In hindsight it was a silly question. The point was that the view gets linked into an Access-Client. There are some Users who shouldn't bother to figure over the results as it does some performance statistics. T

Re: [GENERAL] Remote access

George Weaver schrieb: I have a client with a main office and a branch office about 90 miles away. [...] What would be the best solution for them to access a PostgreSQL database located at the main office from the branch office? I read the other messages and the advice about fixed IP or dynam

Re: [GENERAL] ODBC connection string-constants A,B,C ?

Zlatko Matic wrote: Hello. When building ODBC connection string for PostgreSQL there are constants beginning with A, B and C. Where can I find description of each of these ? There is a HowTo on the psqlODBC site that mentions those codes. Keep in mind that those are MS-Access specific abrevatio

Re: [GENERAL] Win32 users?

Joe schrieb: I guess I wasn't clear enough. Currently, I'm about to use the native Win32 port. I suspect pgsql-hackers-win32 subscribers won't appreciate newbie-type questions. Specifically, I installed 8.0.3 with the installer. Then I opened a command prompt window, typed 'createdb mydb'

Re: [GENERAL] Win32 users?

Joe schrieb: What I am surprised is that this is (apparently) not discussed in the manual or the FAQ. The only indirect reference I found is in section 14.6.2 where it states --in a Unix context-- that "you should add [the PostgreSQL bin directory] into your PATH". Well, perhaps because the

Re: [GENERAL] automating backup ?

Zlatko Matic schrieb: Thanks Fuhr. Anybody can tell me how to do it on Windows XP ? Thanks. That's again a pure Windows issue, but not commonly needed. I guess, it should be in the Windows PG-FAQ, too. I'll describe the way you go with Windows 2000. If you are lucky WinXP Pro does it the sam

[GENERAL] DANGER Windows version might hurt you

I want to warn you all that you might hurt yourself by banging your head against the wall or damage your karma by using foul language if you find your postmaster rejecting to work after a minor change in the postgresql.conf. (I changed the listenig address to an IP instead of *.) Windows can't s

Re: [GENERAL] DANGER Windows version might hurt you

Magnus Hagander schrieb: Did you check the eventlog? It's supposed to write it there.. Well, you are right. =8-} There is "FATAL: Syntaxfehler in Datei »[...]/PostgreSQL-8.0.3/postgresql.conf«, Zeile 322, bei »#«" That's the error message I got on the console. I'm by far no Windows guru

Re: [GENERAL] automating backup ?

Zlatko Matic schrieb: I can't find pgpass.conf file. It should be in Application Data subdirectory, but there is no PostgreSQL subdirectory in Application Data directory (!?). I couldn't find pgpass.conf even by searching the hard disk.. you have to create the sub-dir and the file yourself

Re: [GENERAL] automating backup ?

Zlatko Matic schrieb: Now I have pgpass.conf file in D:\Documents and Settings\Zlatko\Application Data\postgresql content of pgpass.conf is: localhost:*:MONITORINGZ:postgres:tralalala content of backup_script.bat is: cd D:\Program Files\PostgreSQL\8.0\bin pg_dumpall >D:\MONITORINGZ_DUMPALL -U

[GENERAL] PG 8.0.3 ignores parameter listen_addresses ?

Hi, I compiled a Postgres 8.0.3 on a SuSE 9.3 system. This sytem has several network-interfaces. One points to the wild internet. Now I'd like postgres only to listen for localhost, the LAN and probaply the socket. I wrote listen_addresses = 'localhost,192.168.100.1' in the postgresql.conf res

Re: [GENERAL] PG 8.0.3 ignores parameter listen_addresses ?

Tom Lane schrieb: Andreas <[EMAIL PROTECTED]> writes: It still showed tcp0 0 :::5432 :::*LISTEN unix 2 [ ACC ] STREAM LISTEN 65292 /tmp/.s.PGSQL.5432 I'll bet you have -i on the postmaster command

Re: [GENERAL] Bad locking with MS-Access

Ets ROLLAND schrieb: For all the data created BEFORE the transfert to PostgreSQL, all works fine. For the records created SINCE this transfert, it is impossible to modify or delete these records !? MS-Access say that "The record is acceded by an other user", even I am the only user. As Rich

Re: [GENERAL] Bad locking with MS-Access

Hi Zlatko, You mentioned: "Use serial or serial4 to create auto-values. Don't use any bigint-types like bigserial. Access doesn't like 8-byte-ints.". Could you please explain why you don't recommend bigserial for primary key ? I use bigserial primary keys in Postgres tables, and din't rea

Re: [GENERAL] Schemas shown in ODBC

Claus Scherschel wrote: I've just upgraded from Postgres 8.0.1 to 8.1. For testing purposes I'm using a MS Access Frontend connected by ODBC. This worked fine until I switched to the new ODBC-Driver (the Unicode-version). When I try to connect to some new tables, the ODBC-Driver shows tables fro

[GENERAL] PG on Debian 4.0.x ?

had an anonymous option "SQL server" and installed PostgreSQL 8.1.8 as default without further question. This is cool because I - being a known pessimistic - expected to find MySQL. ;-) Do you know where I find PG 8.2.4 and pgAdmin 1.6.3 binaries for Debian 4.0.x ? regard

[GENERAL] HowTo SSL probaply with ODBC ?

e the access besides PG's user/password. I couldn't even restrict the accessing IPs within PG because they will be dynamic. Regards Andreas ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] dns less connection

There is actually an ODBC list vor PG availlable ;) The drivers name is postgresql unicode orpostgresql ansidepending on your needs. Driver={PostgreSQL UNICODE};DATABASE=X1;SERVER=X2;PORT=X3;UID=X4;PWD=X5;X6; This is the connection string but you have to replace X1 with the name of

[GENERAL] Admin-Functions in Ubuntu's PG 8.2 missing?

Hi, I've got an Ubuntu 7.04 (Feisty Fawn) set up and it has Ubuntu's binary PG 8.2.4 running. If I connect with a pgAdmin3 1.6.3 from Windows Tools --> Server Status pgAdmin complains that "The server lacks instrumentation functions. pgAdmin III uses some support funtions ..." I though tho

Re: [GENERAL] Admin-Functions in Ubuntu's PG 8.2 missing?

Joshua D. Drake schrieb: Andreas wrote: I've got an Ubuntu 7.04 (Feisty Fawn) set up and it has Ubuntu's binary PG 8.2.4 running. If I connect with a pgAdmin3 1.6.3 from Windows Tools --> Server Status pgAdmin complains that "The server lacks instrumentation functions.

Re: [GENERAL] Is it possible to remove the public schema?

Henry Combrinck wrote: <>It sounds to me like the real problem is with non-schema-aware client software. They're using Office XP Developer (Access 2000). No hope of fixing that. No problem at all. It's easy to automate the table linking process. I have a table in access that holds - among other th

[GENERAL] invalid byte sequence ?

Hi, I've got pg 8.1.4 from the binary Windows installer. Windows 2000 / German Now I entered "\d" into psql on the text-console and got this: db_test=# \d ERROR: invalid byte sequence for encoding "UTF8": 0xfc6d6572220a What's up ? db_test was created UTF8 encoded -

Re: [GENERAL] invalid byte sequence ?

Bruce Momjian schrieb: Andreas wrote: I've got pg 8.1.4 from the binary Windows installer. Windows 2000 / German Now I entered "\d" into psql on the text-console and got this: db_test=# \d ERROR: invalid byte sequence for encoding "UTF8": 0xfc6d6572220a What&#

[GENERAL] what about uniqueness of inherited primary keys

Hello list, what about uniqueness of inherited primary keys ? eg you have : create table objects ( id int4, date_created timestamp(0), primary key (id) ); create table persons ( firstname varchar(100), lastname varchar(100) ) inherits (objects); now ... insert into objects (id) values

Re: [GENERAL] what about uniqueness of inherited primary keys

27;t be that bad, if the table contents weren't merged in SELECTs. Probaply one could do some trigger-magic to check the inserted id against an id-pool in another table. If one knew anything about triggers that is ... well ... miles to go before I sleep ... Thanks Andreas ---

Re: [GENERAL] simple auto-updating timestamp ?

r update your table. And you could never set the value to anything other than NOW() because your trigger would catch it and set it back to NOW() again. That is what I had in mind. I'd like to see when there was the last update to a record. ... Andreas ---(end of broa

[GENERAL] Is there something like an dynamic view ?

ECT c_id FROM cp_relation WHERE p_id = 1; view2 : SELECT c_id FROM cp_relation WHERE p_id = 2; view3 : SELECT c_id FROM cp_relation WHERE p_id = 3; ... That screams for a parameter. Is this possible ? Thanks for reading so far Andreas ---(end of broadcast)-

[GENERAL] Postmaster won't run as service on Cygwin

start postmaster" run as uster postgres gives System-Error 5 access denied What now ? Andreas ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] Postmaster won't run as service on Cygwin

missions aren't OK, then how can postmaster work when it is started by hand ? Where is the difference between user postgres starting postmaster as service and doing it on the cygwin-console in regards of using a data path that starts with /cygdrive/... Help ? Andreas --

Re: [GENERAL] Postmaster won't run as service on Cygwin

tory. Right now I have both services installed, but not started. "postmaster5" can be started but "postmaster" throws error 1067 go figure ... Andreas ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an

[GENERAL] will I need nested transactions ?

is Access 2000 via ODBC talking to an PostgreSQL 7.4.2 on Linux. Regards Andreas ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [GENERAL] win32 port

Hallo Hans, [EMAIL PROTECTED] wrote: ...i have little experience in linux and i work on windows. I don't know the current state of the Windows port (PG 7.5) but as I understood it currently won't run as service at all. For getting a service you need to go with cygwin ... I didn't test it, but a

[GENERAL] Is there an opposite to pg_get_userbyid() ?

Hi, I'd like to store who changed records on some tables. I'd prefer not to store the username but rather his/her ID. Will I allways have to run select usesysid from pg_user where usename=session_user; or is there a complement to pg_get_userbyid() ? Can I have this as a default-value for a create

Re: [GENERAL] Is there an opposite to pg_get_userbyid() ?

Michael Fuhr wrote: On Thu, Oct 14, 2004 at 07:42:22PM +0200, Andreas wrote: or is there a complement to pg_get_userbyid() ? If there is then I've overlooked it in the documentation. It's easy enough to write: Thanks :) I though it was consequent to expect such a function, s

Re: [GENERAL] 9.4+ partial log-shipping possible?

available. Read more: http://michael.otacoo.com/postgresql-2/postgres-9-4-feature-highlight-basics-logical-decoding/ i think, this (logical replication) are still under construction... Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect.

  1   2   3   4   5   6   7   8   9   10   >