See dbeaver. http://dbeaver.jkiss.org
community and Enterprise editions are free and it's very good
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Sat, 2016-09-03 at 21:36 +1200, Tim Uckun wrote:
> Does anybody use an IDE for doing heavy duty stored proc development? PGadmin
> is decent but I am looking for something better.
>
> I have tried jetbrains with the db browser plugin and on the surface it seems
> like a good choice but it's
On Tue, 2015-10-06 at 09:04 -0500, John McKown wrote:
> I'm wanting to do some reporting on data which I have an a PostgreSQL table.
> For lack of anything better, I've decided to see if I can do it in GNU awk.
perhaps... note the 4th extension...
On Tue, 2015-08-11 at 14:32 -0400, an unknown sender wrote:
On Tue, 2015-08-11 at 07:20 -0500, John McKown wrote:
PostgreSQL comes with ecpg which is a pre-processor to handle embedded
EXEC
SQL startements in C (OK, you already know that). I am wondering if anyone
knows of any such
On Tue, 2015-08-11 at 07:20 -0500, John McKown wrote:
PostgreSQL comes with ecpg which is a pre-processor to handle embedded EXEC
SQL startements in C (OK, you already know that). I am wondering if anyone
knows of any such program for other compiled languages, in particular GNU
COBOL or ADA?
On Sun, 2014-11-30 at 12:51 -0700, Léa Massiot wrote:
Me again. Sorry.
This looks good too: Building libpq Programs:
http://www.postgresql.org/docs/9.1/static/libpq-build.html
But what do I need to install on B?
Best regards.
--
View this message in context:
On Tue, 2013-11-05 at 04:14 -0800, bsreejithin wrote:
Not able to post the attached details as a comment in the reply box, so
attaching it as an image file :
http://postgresql.1045698.n5.nabble.com/file/n5776987/Untitled.png
--
View this message in context:
On Tue, 2013-05-14 at 14:51 +, S H wrote:
I am doing some experiment to understand the behaviour of manual
vacuum.
I created small table and started doing insertion/deletion/updation on
2 rows in infinite loop. It started bloating around 844 times, but
after it stopped bloating.. what
On Tue, 2012-03-20 at 09:22 -0500, Sam Loy wrote:
I have now tried at least 7 different install methods to get pg up and
running on Lion. I fear that my system is now thoroughly inoculated and will
never be able to run postgres/postgis.
I started with the pg mac installer / stack builder.
Looking for some quidance or suggestions.
PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.5
20110214 (Red Hat 4.4.5-6), 64-bit
$ uname -a
Linux db1.hw.ateb.com 2.6.32-131.21.1.el6.x86_64 #1 SMP Tue Nov 22 19:48:09 GMT
2011 x86_64 x86_64 x86_64 GNU/Linux
datid|
On Wed, 2012-01-11 at 20:50 +0100, Kirill Müller wrote:
that would
allow tracing the queries and their runtime while they are executed \
http://www.postgresql.org/docs/8.4/static/auto-explain.html
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On Tue, 2011-11-22 at 15:55 +, Gregg Jaskiewicz wrote:
for the future it is better to just use text type, and: check
length(field) 35;
thanks to all for the respones.
The above seems a prudent way to go in my future.
My assumption is that converting varchar(n) to text would still force a
reporting=# select version();
version
--
PostgreSQL 8.3.7 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC)
4.1.2 20071124 (Red Hat
On Thu, 2011-09-29 at 12:08 -0500, dennis jenkins wrote:
ERROR: could not load library /db/pgsql_micr_parser_64.so: ld.so.1:
postgres: fatal: /db/pgsql_micr_parser_64.so: Permission denied
for a different shared object, but may provide clues...
Error: - adding iplike database function... snip
I believe that there should be no issue, but am asking to be sure.
Thanks,
reid
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tue, 2011-09-13 at 16:39 +0200, Hannes Erven wrote:
Reid,
where any one of these 3
11 2011-01-01
11 2011-01-01
13 2011-01-01
or any one of these 2
31 2011-01-05
32 2011-01-05
are suitable for val = 1, val = 3
On 9/12/2011 9:54 PM, Reid Thompson wrote:
Ack -- i flubbed the subject and sample.
The sample data should be
val val2date
11 2011-01-01
22 2011-01-02
33 2011-01-03
41 2011-01-04
52 2011-01-05
53 2011-01-01
41 2011-01-02
2011-01-08
where any one of these 3
11 2011-01-01
11 2011-01-01
13 2011-01-01
or any one of these 2
31 2011-01-05
32 2011-01-05
are suitable for val = 1, val = 3 respectively.
On 9/12/2011 8:54 PM, Reid Thompson wrote:
Could someone
Could someone point me in the right direction..
Thanks - reid
Given the example data,
how do I write a query that will give me the resultset:
12011-01-01
22011-01-06
32011-01-05
42011-01-09
52011-01-05
62011-01-08
I.E. for each distinct val, return the record with the
On Fri, 2011-07-22 at 10:11 -0700, Samuel Hwang wrote:
I ran the same tests in SQL Server 2008R2, Oracle10 and PostgreSQL
9.0.4 and found something interesting...
results
=
SQL Server 2008 R2 (with case insensitive data, the ordering follows
ASCII order)
Oracle 10 (data is
On Thu, 2011-06-30 at 10:46 -0400, gnuo...@rcn.com wrote:
I'll need the contrib source, and I don't find it anywhere. I must not be
looking in the right place.
Where might that be?
http://www.postgresql.org/ftp/source/
--
Sent via pgsql-general mailing list
My postgresql instance was last started on Apr21.
In my temp space directory, I have various files that I believe are orphaned.
Given the information below, can I safely rm the files in
/mnt/iscsi/psql_tmp/tmpdata/41099 that are older than Jun 22?
If yes, should these files have been cleaned up
On 06/23/2011 11:08 AM, Eduard-Cristian Stefan wrote:
D:\me\usr\PostgreSQL\bin/pg_ctl.exe runservice -N pgsql -D
d:/me/etc/PostgreSQL
not very familiar with the windows version, but I think -D is supposed to point to the data directory which in your later info is
listed as
data_directory
On Thu, 2011-06-23 at 13:26 -0700, Adrian Klaver wrote:
On 06/23/2011 01:07 PM, Steve Crawford wrote:
On 06/23/2011 12:30 PM, hernan gonzalez wrote:
On Thu, Jun 23, 2011 at 4:15 PM, Adrian Klaver
adrian.kla...@gmail.com mailto:adrian.kla...@gmail.com wrote:
On 06/23/2011 11:40
On 05/24/2011 10:49 AM, Scott Marlowe wrote:
Oh good. My first response from google, with safe search turned off,
was much more distressing...
in other news, google trends for cbt just jumped
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On 05/24/2011 01:02 PM, fork wrote:
A psql prompt and the excellent postgresql documentation?
if you're concerned about mucking something up, download a postgresql livecd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On 3/5/2011 4:08 PM, matty jones wrote:
I already have a domain name but I am looking for a hosting company that I can use PG with. The few I have
contacted have said that they support MySQL only and won't give me access to install what I need or they
want way to much. I don't need a
Given the below information, is it reasonable to assume that files in pgsql_tmp
dated prior to 10 days ago can be safely removed?
postgres@hw-prod-repdb1 uptime
15:01:35 up 10 days, 13:50, 3 users, load average: 1.23, 1.15, 0.63
postgres@hw-prod-repdb1 pwd
/mnt/iscsi/psql_tmp/tmpdata
On 02/25/2011 09:30 AM, akp geek wrote:
Hi all -
I have recently upgraded from 8.3 to 9.0.2.
when I run the following sql in 9.0.2 select to_timestamp('02/26/2011 14:50',
'MM/DD/ HH24MI') I am getting the following
error and the sql runs fine in older version
Is it my installation
What am I missing that causes this to resort to sorting on disk?
obc=# select version();
version
--
PostgreSQL 8.3.7 on
On 02/22/2011 12:06 PM, Tom Lane wrote:
Reid Thompson reid.thomp...@ateb.com writes:
What am I missing that causes this to resort to sorting on disk?
The in-memory space required to sort N tuples can be significantly
larger than the on-disk space, because the latter representation
On Thu, 2010-12-09 at 17:40 +, Paul Taylor wrote:
what
have I got to be careful of.
I think that was in reference to turning fsync off, not work_mem values.
On 12/09/2010 09:59 AM, Andy Colson wrote:
On 12/9/2010 8:50 AM, Andy Colson wrote:
On 12/9/2010 6:25 AM, Paul Taylor wrote:
You need to bump up your SHMMAX is your OS.
sorry: SHMMAX _in_ your OS.
its an OS setting not a PG one.
-Andy
scroll down to the section on OSX
On 12/09/2010 12:36 PM, Paul Taylor wrote:
On 09/12/2010 15:12, Reid Thompson wrote:
On 12/09/2010 09:59 AM, Andy Colson wrote:
On 12/9/2010 8:50 AM, Andy Colson wrote:
On 12/9/2010 6:25 AM, Paul Taylor wrote:
You need to bump up your SHMMAX is your OS.
sorry: SHMMAX _in_ your OS.
its
Reposting as I noticed that the original was in reply to a different subject.
Hey Folks – have a coded myself into a corner yet?
I have a situation with a select count / group by / order by query that I need to limit each group to 500
entries. Not seeing a way to do this in a single query, do
On Thu, 2010-10-28 at 12:08 -0700, sub3 wrote:
Hi,
I have a small web page set up to search within my domain based on keywords.
One of the queries is:
SELECT page.id ts_rank_cd('{1.0, 1.0, 1.0, 1.0}',contFTI,q) FROM page,
to_tsquery('steve') as q WHERE contFTI @@ q
My problem
On Thu, 2010-10-21 at 10:35 -0700, Rich Shepard wrote:
On Thu, 21 Oct 2010, Scott Marlowe wrote:
So, what do
telnet localhost 5432
Scott,
That port's clear:
[rshep...@salmo ~]$ telnet localhost 5432
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
On Thu, 2010-10-21 at 11:38 -0700, Rich Shepard wrote:
On Thu, 21 Oct 2010, Reid Thompson wrote:
what does
$ netstat -an |grep 5432
return?
something is running on tcp port 5432
Doesn't show that.
[rshep...@salmo ~]$ netstat -an |grep 5432
tcp0 0 127.0.0.1:5432
On Thu, 2010-10-21 at 11:45 -0700, Rich Shepard wrote:
On Thu, 21 Oct 2010, Scott Marlowe wrote:
So a postgres IS running on your machine. I put it to you it's not
running where you think it is.
When I run 'ps ax | grep post' I found a few postgres processes. I tried
On 10/20/2010 6:53 PM, Rich Shepard wrote:
For reasons I do not understand, the Slackware start-up file for postgres
(/etc/rc.d/rc.postgresql) fails to work properly after I reboot the system.
(Reboots normally occur only after a kernel upgrade or with a hardware
failure that crashes the
On 5/7/2010 1:48 PM, Alex Hunsaker wrote:
On Fri, May 7, 2010 at 11:18, Joao Ferreira gmail
joao.miguel.c.ferre...@gmail.com wrote:
Hello all,
I need to write an application in C to read the list of databases
currently in the server. very much like a psql -l...
The first example in the
On Tue, 2010-02-23 at 13:50 -0500, Shu Ho wrote:
All
do you clean up the server file by removing them
use
find $logfile -mtime +$NUMBER_DAYS_TO_KEEP -type f -print -exec rm -f
{} \;
in postgres ?
How to remove the archive log files in postgres ? is the same way as
remove
On Tue, 2010-02-23 at 13:49 -0500, Amy Smith wrote:
All
do you clean up the server file by removing them
use
google logrotate
man logrotate
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On 2/20/2010 4:42 PM, John Gage wrote:
I have had the same/similar problem on a Mac. Postgres creates a user
postgres and the only way that user can see files is for them to exist
outside of any other particular user's home directory. I placed the
files in the root directory!? I would like, I
On 2/20/2010 4:42 PM, John Gage wrote:
I have had the same/similar problem on a Mac. Postgres creates a user
postgres and the only way that user can see files is for them to exist
outside of any other particular user's home directory. I placed the
files in the root directory!? I would like, I
On Thu, 2010-02-18 at 09:33 -0600, Little, Douglas wrote:
psql p1gp1 QUIT $LOGFile 21
\set ON_ERROR_STOP
select da_test.QATestBuild(false)
QUIT
mod to your needs...
$ cat dummy.sql
#MYTESTID=`psql -t -c select da_test.QATestBuild(false) dbname`
MYTS=`psql -t -c select
On Wed, 2010-02-17 at 11:59 -0500, Dhimant Patel wrote:
I have created a database, which I plan to load with several tables. I
am trying to find the size of the databases and came
across pg_database_size(oid) function. Since it requires databse oid,
I thought there must be a view where you
Does this max_fsm_pages value seem OK for a 46GB database?
I've clustered all the tables that seemed to be exhibiting large amounts
of bloat.
reporting=# SELECT pg_size_pretty(pg_database_size('reporting'));
pg_size_pretty
46 GB
(1 row)
NOTICE: number of page slots
On Mon, Jan 18, 2010 at 02:43:11PM -0500, Vick Khera wrote:
On Mon, Jan 18, 2010 at 1:47 PM, Reid Thompson reid.thomp...@ateb.com wrote:
Does this max_fsm_pages value seem OK for a 46GB database?
I've clustered all the tables that seemed to be exhibiting large amounts
of bloat.
One
utsav wrote:
Dear All,
I am using postgres 7.3 version on RHEL 4.0.
You should upgrade to a newer/the latest stable release
The commanddata field consists of binary data of a txt file whose size
is between 1kb to 4kb and there is a high frequecy of updates on this
table (approx twice in
So we know have data in ~30 partitioned tables.
Our requirements now necessitate adding some columns to all these tables
( done ) which will get populated via batch sql for the older tables and
by normal processing as we move forward.
The batch update is going to result in dead tuples in the
In the case where a_text is null, I essentially want the same result as the
case when a_text = ''.
would this:
select a_int || coalesce(a_text,'') from test1 where a_int = 102;
be the proper way?
postgres=# \d test1
Table public.test1
Column |
On Tue, 2009-09-29 at 07:54 -0400, Merlin Moncure wrote:
you are missing some quotes in there. also, don't use 'values', use
select. see my example above:
execute 'insert into foo_something select (''' || new::text || '''::foo).*';
the actual query should look like:
insert into
We have a set of tables that we're partitioning by year and month -
e.g. payments_parent, partitioned into payments_200901, payments200902, ...
and inquiries_parent, partitioned into inquiries_200901, inquiries_200902, ...
Each table has a timestamp field import_ts that can be used to partition
On Mon, 2009-09-28 at 12:42 -0400, Merlin Moncure wrote:
the best way to do this is very version dependent. the basic trick is
to use text cast to pass a composite type into the query sting.
one way:
execute 'insert into foo_something select (' || new::text || '::foo).*';
you can try:
On Mon, 2009-09-28 at 11:05 -0400, Reid Thompson wrote:
We have a set of tables that we're partitioning by year and month -
We can't seem to quite get it right...
This is our quick stub test.
--
-- Tables:
--
CREATE TABLE payments (
id serial,
payment_name varchar
Assuming the examples on
http://www.postgresql.org/docs/8.3/static/ddl-partitioning.html
where measurement has children as noted
CREATE TABLE measurement (
city_id int not null,
logdate date not null,
peaktempint,
may be of interest --
http://blogs.sun.com/jkshah/entry/igen_with_postgresql_8_4
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, 2009-07-01 at 16:16 -0500, Anthony Caduto wrote:
I am looking for something similar to:
http://www.arcanadev.com/adtempus/ but without the MS SQL server
dependency.
Thanks,
Tony
http://www.opensymphony.com/quartz/ might fit the bill
--
Sent via pgsql-general mailing list
Keith D. Evans wrote:
We usually run postgresql on a private machine (gravity) but due to
space, we have moved the database to a different machine through afs (a
local network at the university). We do not want the private machine to
be accessible to outside users, so our web pages are on the
I've a DB and I want to migrate the users to a new empty DB. How do I
dump/reload just the users?
Thanks,
reid
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
James Dooley wrote:
Hi,
Since PostgreSQL is by default case sensitive, I would like to know if
it is possible to do a search or somehow set the column in a relation to
be case insensitive (on search at least).
I would however like to store it case sensitive so I can display it as
it was
On Tue, 2009-01-13 at 18:22 -0600, Jason Long wrote:
Never used Python or Perl. I use primarily Java. I was thinking of
doing something like
INSERT INTO pictures (filename,data) VALUES
('filename','/path/to/my/image/img0009.jpg');
But, this syntax doesn't seem to be supported.
Maybe I
Scott Marlowe wrote:
On Sun, Nov 30, 2008 at 1:18 PM, Andrus [EMAIL PROTECTED] wrote:
Sorry, I'm no gentoo expert. It's certainly not the first distro I'd
recommend to someone just starting out with linux / unix. Time to
break out the google. I also found quite a few example scripts for
lftp
Michelle Konzack wrote:
Am 2008-11-08 19:07:35, schrieb Scott Marlowe:
No, your histrionics aside, it's the way this list works by default,
and for good reason. If you need it to work differently, there's a
setting which has been pointed out to you at two times now. Please
take responsibility
Allan Kamau wrote:
Sam, I have been unable to understand your shell script well enough to
use it. Seems am slow this afternoon :-)
On this list I saw a message detailing using copy as illustrated below
(see code/)when I run this command I get the following output (see
output/)
output
COPY
Allan Kamau wrote:
Reid Thompson wrote:
Allan Kamau wrote:
Sam, I have been unable to understand your shell script well enough
to use it. Seems am slow this afternoon :-)
On this list I saw a message detailing using copy as illustrated
below (see code/)when I run this command I get
On Fri, 2008-09-05 at 11:44 +0200, Filip Rembiałkowski wrote:
is the server running (see process list, ps ax | grep postgres)
does the socket file exist? (see filesystem, ls -l /tmp/.s.PGSQL.5432)
Since you say things work for several days, then stop -- make sure
there's no braindead
On Fri, 2008-08-15 at 16:37 -0400, Tom Lane wrote:
Reid Thompson [EMAIL PROTECTED] writes:
Would plpgsql.so get built with..
./configure --prefix=/usr/local/pgsql833 --without-readline --disable-shared
Uh
I'm getting this failure on compilation. Could someone point me in the
direction of a fix?
Thanks,
reid
System: AIX 5.3
$ uname -a
AIX aix53-dev-1 3 5 000B357F4C00
Configuration params:
./configure --prefix=/usr/local/pgsql833 --without-readline --disable-shared
The Error:
...SNIP...
On Fri, 2008-08-15 at 11:03 -0400, Tom Lane wrote:
Reid Thompson Woulwrites:
I'm getting this failure on compilation. Could someone point me in the
direction of a fix?
You probably ought to inquire into the cause of these:
gmake[2]: stat:regress.so: There are too many levels
On Sat, 2008-08-09 at 04:59 -0400, Fouad Zaryouh wrote:
Hi Aravind,
Run the following query
SELECT relname, reltuples, relpages * 8 / 1024 AS MB FROM pg_class
ORDER BY relpages DESC;
relname = table name
relpages = size in MB
reltuples = number of rows.
Hope this help.
On Mon, 2008-03-10 at 06:55 +, Raymond O'Donnell wrote:
On 09/03/2008 22:33, Reid Thompson wrote:
On Sun, 2008-03-09 at 19:41 +, Raymond O'Donnell wrote:
On 09/03/2008 15:34, Reid Thompson wrote:
you'll also probably have to add the parameter -h 127.0.0.1
psql defaults
akshay bhat wrote:
HELLO
i have psql file which is to be used for loading a database
it was downloaded from this link http://conceptnet.media.mit.edu/
the description says
The ConceptNet 3 database, as a PostgreSQL input file. You will need to
be running a PostgreSQL server to install
On Sun, 2008-03-09 at 19:41 +, Raymond O'Donnell wrote:
On 09/03/2008 15:34, Reid Thompson wrote:
you'll also probably have to add the parameter -h 127.0.0.1
psql defaults to connecting to the local machine unless you tell it
otherwise, so this is redundant; though it certainly
On Mon, 2008-02-18 at 17:46 +, Raymond O'Donnell wrote:
On 18/02/2008 13:14, pgsql_user wrote:
so wouldnt I run out of ids one day, if there are lot of failed insert
statements, lets say for every successful insert there are 50
unsuccessful inserts, so ids would be 1, 50, 100, and once
On Wed, 2007-08-22 at 18:57 -0400, Geoffrey wrote:
We are looking for a reporting tool that will enable users to generate
their own reports. Something like Crystal Reports.
Anyone using something like this with Postgresql?
agata, datavision, jasper reports, birt, openRPT -- google shows
On Wed, 2007-08-01 at 13:29 +0200, [EMAIL PROTECTED] wrote:
Hello,
I bought a Dell server and I am going to use it for installing PostgrSQL
8.2.4. I always used Windows so far and I would like now to install a
Linux distribution on the new server. Any suggestion on which distribution
?
Andrej Ricnik-Bay wrote:
On 8/2/07, Reid Thompson [EMAIL PROTECTED] wrote:
If it's a dedicated production server, look at UBUNTU 6.10 server.
If you're planning to connect a monitor and run X-windows ( i.e. I
bought a server, but i'm going to use it as a learning platform for
LINUX
Chris Hoover wrote:
I need some help. I am trying to replicate a function from Sybase
ASA, and am having difficulty.
I need to be able to subtract 2 date (or timestamps) and return the
results expressed in days, weeks, month, quarters, or years. How do I
do this?
I believe Postgres is
Chris Hoover wrote:
I need some help. I am trying to replicate a function from Sybase
ASA, and am having difficulty.
I need to be able to subtract 2 date (or timestamps) and return the
results expressed in days, weeks, month, quarters, or years. How do I
do this?
I believe Postgres is
On Tue, 2007-07-10 at 14:32 +0200, Zlatko Matic wrote:
Hello.
Is there any free program/utility for batch imports from .csv files, that
can be easily scheduled for daily inserts of data to PostgreSQL tables?
Regards,
Zlatko
---(end of
Hello list,
We are using PostgreSQL 8.0.3. Some background, and a couple of
questions..
We have a database table called jobq on the database machine,
and 2 networked server machines.
One of the network server machines has around 20 server processes
connecting over the network using ODBC.
These
On Thu, 2007-04-19 at 10:05 -0500, Tony Caduto wrote:
David Potts wrote:
Can any body recommend a generic opensource data entry tool that can be
used to make some simple forms for entering data in to postgres?
---(end of broadcast)---
Marc wrote:
what version of PostgreSQL?
what version of the jdbc driver?
The bottom line question is can an applet served to a client machine
other than the one the postrgres db resides on read that db?
I can't see why not.
An applet I’ve written and tested on the same box as my
On 10:44 Sun 18 Mar , Jeff Ross wrote:
Hi,
Is there a simple way to determine with a shell script if PostgreSQL is
ready to accept connections?
PostgreSQL is started and controlled by daemontools. This shell script
is called by the /etc/netstart script as a part of bringing up the
On Mon, 2007-02-26 at 14:54 +0100, peter pilsl wrote:
I need to export several tables as csv. I use the \f-command to set the
seperator and pipe the output of my select directly to a file.
Unfortunately thats all the control I have over the created csv-file. I
cannot
set the
On Mon, 2007-02-26 at 13:20 -0500, Reid Thompson wrote:
On Mon, 2007-02-26 at 14:54 +0100, peter pilsl wrote:
I need to export several tables as csv. I use the \f-command to set the
seperator and pipe the output of my select directly to a file.
Unfortunately thats all the control I have
On Mon, 2007-02-12 at 15:16 -0500, HT NB wrote:
Hi,
How are you doing?
First, I am testing if this email address is valid. It is the first
time that I am using this account. I have a question about how to
start write embedded SQL in C programming code. What are the basic
requirements in
On Fri, 2007-01-26 at 12:16 -0800, [EMAIL PROTECTED] wrote:
I am looking for some sample code using the libpqxx (C++) API for
Postgresql. I have found some tutorials
(http://thaiopensource.org/devprojects/libpqxx/doc/2.6.8/html/Tutorial/
John McCawley wrote:
Here's a little tool I wrote:
http://www.hardgeus.com/projects/pgdesigner/
I have a Windows binary up there. The build process is currently a
mess, sorry.
It's a pretty decent little tool for quick-and-dirty visualization,
which is all I really use it for.
nyenyec
On Mon, 2006-10-16 at 14:56 -0400, Harpreet Dhaliwal wrote:
Hi,
I have a timestamp field in my table and want to set a default value
of current date/time for it.
What should i enter as its default value? is there any function like
now() in postgres?
Thanks,
~Harpreet
test=# select
Ziff Davis Media eSeminars: The Online Seminar Standard
Realizing the Value of Enterprise Open Source Databases:
How Sony Online Entertainment Replaced Oracle with EnterpriseDB
October 12, 2006 @ 12:00 p.m. Eastern/9:00 a.m. Pacific
Duration: 60 minutes
Register Attend Online
Using a legacy installation ( 7.2.3 ).
Occasionally the system will reach a state where attempted psql
connection attempts fail, with the following error in the postgresql
log:
postmaster: StreamConnection: accept: No such device or address
Will also occasionally get no connection to server
Larry Rosenman wrote:
Reid Thompson wrote:
Using a legacy installation ( 7.2.3 ).
Occasionally the system will reach a state where attempted psql
connection attempts fail, with the following error in the postgresql
log:
postmaster: StreamConnection: accept: No such device or address
Jasbinder Bali wrote:
Hi
Can anyone help me with the usage of ECPG??
Like how to go about it, what all header files to include in my C file
and other things that i need to give due considerations before using ECPG
~Jas
see headOfPgSourceTree/src/interfaces/ecpg ( test has several examples )
Reid Thompson wrote:
PG_VERSION 8.1 - windows XP - 1GB RAM -- Desktop workstation, PG used
for test/dev.
This installation has been working fine for quite a while. I've used
it minimally.
I rebooted yestderday- log file from reboot
2006-05-18 12:24:32 LOG: database system was shut down
Eliana Providel wrote:
Hola a todos
Estoy trabajando con postgresql y tengo el siguiente problema
cuando intento listar todas las bases de datos existentes con psql -l
me sale el siguiente error:
ERROR: no existe la relación pg_catalog.pg_user
Puedo crear bases de datos y acceder a ellas
PG_VERSION 8.1 - windows XP - 1GB RAM -- Desktop workstation, PG used
for test/dev.
This installation has been working fine for quite a while. I've used it
minimally.
I rebooted yestderday- log file from reboot
2006-05-18 12:24:32 LOG: database system was shut down at 2006-05-18
12:23:08
Steve Atkins wrote:
On May 8, 2006, at 11:05 PM, Guido Neitzer wrote:
On 09.05.2006, at 0:33 Uhr, Karen Hill wrote:
What is your favorite front end for end users to interact with your
postgresql db? Is it java, .net, web apache + php, MS-Access, ruby on
rails? Why is it your favorite? Which
1 - 100 of 137 matches
Mail list logo