[ADMIN] Creating a table in a different database

Hi,   The CREATE TABLE command creates a table in the current database. What I want to achieve is a SQL script that will create a database and a user and then create some tables and functions in the new database.   Is it possible to do this in a single SQL file, and if so, how do I chan

Re: [ADMIN] Creating a table in a different database

I just create .sql files with all the commands I want to run and then run them in psql with the "\i myscript.sql".If you want to switch databases in psql, use the \c[onnect] [DBNAME|- [USER]] .  For example "\c my_database my_user". I recommend going into psql and typing in "\?" for a list of commo

[ADMIN] logfile

I assume I do not understand the manual right (or my kind of english).   In PGSQL 7.4 I only want error situations in the logfile, and if an error occurs as much as possible information like e.g. the sql statement.   I entered in postgresql.conf:   client_min_messages = error log_min_messag

Re: [ADMIN] postgres dying

"Guido Barosio" <[EMAIL PROTECTED]> wrote: Hi Callis, It would be great to understand how it is dying. Note that you've just said that it keeps dying, but you haven't explained us "how is it dying". Therefore, are you able to explain us how / when is it dying? This the error me

Re: [ADMIN] postgres dying

Callis wrote: > Jun 6 06:12:45 Billing postgres[2296]: [1-4] You can > either reduce the request size or reconfigure the kernel > with larger SHMMAX So did you try to increase the kernel's SHMMAX? -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL

[ADMIN] remove

remove _ Because e-mail on your cell phone should be easy: Try Windows Live Mail for Mobile beta http://www2.imagine-msn.com/minisites/mail/Default.aspx?locale=en-us ---(end of broadcast)--

[ADMIN] delete

delete _ Because e-mail on your cell phone should be easy: Try Windows Live Mail for Mobile beta http://www2.imagine-msn.com/minisites/mail/Default.aspx?locale=en-us ---(end of broadcast)--

[ADMIN] oralink documentation

I pulled down the oralink contrib module from the pg foundry but it has no docs. Anyone know of ant docs/help/etc for this contrib module? ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an

[ADMIN] How to connect to an oracle table from Postgres?

Hi List; I want to be able to read an oracle tabe from within Postgres. The Oracle db is on a different server within the same network. Is there a good way to pull this off? Thanks. -joe ---(end of broadcast)--- TIP 2: Don't 'kill -9' the p

Re: [ADMIN] How to connect to an oracle table from Postgres?

On 6/6/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: I want to be able to read an oracle tabe from within Postgres. The Oracle db is on a different server within the same network. Is there a good way to pull this off? Your only option with native PostgreSQL is to use dbi-link. Not to expl

Re: [ADMIN] oralink documentation

On 6/6/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: I pulled down the oralink contrib module from the pg foundry but it has no docs. Anyone know of ant docs/help/etc ... ? Nope... is it even maintained? -- Jonah H. Harris, Software Architect | phone: 732.331.1300 EnterpriseDB Corporation

[ADMIN] postgres & ECCN

All, I am wondering if you can help. I need to find the ECCN coding for the DB in order to be able to export of our products with the dB included. Re Roy ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [ADMIN] postgres & ECCN

[EMAIL PROTECTED] ("Rosario Colica \(XX/MCI\)") wrote: > All, > > I am wondering if you can help. > > I need to find the ECCN coding for the DB in order to be able to export of > our products with the dB included. People have asked this about Mozilla, with the following answer: http://www.heck

Re: [ADMIN] oralink documentation

Unsubscribe ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [ADMIN]

On Wed, May 31, 2006 at 04:53:04PM +0530, Neelagal shantaraj wrote: > scenario is > > There is one Head office and there are around 300 branches all over > india.My question is how to transfer data of each branch to the head > office. Slony or dblink. -- Jim C. Nasby, Sr. Engineering Consultant

Re: [ADMIN] logfile

On Tue, Jun 06, 2006 at 02:37:11PM +0200, H.J. Sanders wrote: > I assume I do not understand the manual right (or my kind of english). > > In PGSQL 7.4 I only want error situations in the logfile, and if an error > occurs as much as possible information like e.g. the sql statement. > > I entered

Re: [ADMIN] delete

On Tue, Jun 06, 2006 at 08:56:55AM -0500, Thomas LeBlanc wrote: > delete List-Unsubscribe: -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.comwork: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf

Re: [ADMIN] How to connect to an oracle table from Postgres?

On Tue, Jun 06, 2006 at 11:13:48AM -0400, [EMAIL PROTECTED] wrote: > > Hi List; > > I want to be able to read an oracle tabe from within Postgres. The Oracle db > is on a different server within the same network. Is there a good way to pull > this off? Only way to do it from within PostgreSQL

Re: [ADMIN] oralink documentation

On Tue, Jun 06, 2006 at 12:09:09PM -0400, Jonah H. Harris wrote: > On 6/6/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > >I pulled down the oralink contrib module from the pg foundry > >but it has no docs. Anyone know of ant docs/help/etc ... ? > > Nope... is it even maintained? And in case y

[ADMIN] pg_dumpall 8.1.4 large objects error

I'm curious why this would happen: pg_dump: dumpBlobs(): could not open large object: ERROR: inv_open: large object 145391 not found The db being dumped is 7.3.2 and the pg_dumpall is from a source compiled 8.1.4. The OS in question is Redhat 8 (soon to be upgraded). When I used the 7.3.2

Re: [ADMIN] pg_dumpall 8.1.4 large objects error

Jeff Frost <[EMAIL PROTECTED]> writes: > I'm curious why this would happen: > pg_dump: dumpBlobs(): could not open large object: ERROR: inv_open: large > object 145391 not found Some cursory trawling in the REL7_3 sources says that this means that "SELECT DISTINCT loid FROM pg_largeobject" foun