+list
First off you are going to get considerably better response from the JDBC
list or our github project.
Looking at the code; in order to ensure the backend has received the
acknowledgement you need to call forceUpdateStatus
Otherwise it may not receive the ack
Dave Cramer
da
I see.
Thanks Jeff,
On Mon, Sep 11, 2017 at 2:38 PM, Jeff Janes wrote:
> On Mon, Sep 11, 2017 at 7:02 AM, Dave Florek
> wrote:
>
>> Hi,
>>
>> I'm trying to setup streaming replication on a cluster of postgresql
>> databases and I followed the
Hi,
I'm trying to setup streaming replication on a cluster of postgresql
databases and I followed the instructions outlined here (
https://wiki.postgresql.org/wiki/Streaming_Replication) but I'm stuck on
the archive and restore commands. In reading the comments from the archive
command, WAL archiv
(product_id IS NOT
NULL)
-> Hash (cost=6.87..6.87 rows=387
width=4) (actual time=0.195..0.195 rows=387 loops=1)
Buckets: 1024 Batches: 1
Memory Usage: 14kB
-> Seq Scan on
kbdata_skill_aspects (cost=0
Hi, I am trying to analyze a performance regression from 9.2.21 to 9.6.3.
The query and execution plans are below with 9.6.3 first. If the query
looks a bit odd, it was generated by an ORM and the names have been
modified. The slight difference in row counts is because they are from
snapshots taken
Well we won't be fixing any bugs in anything but the latest version if that
makes a difference to you.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 25 August 2017 at 21:34, Rob Sargent wrote:
>
>
> On Aug 25, 2017, at 5:55 PM, Dave Cramer wrote:
>
> There ar
There are newer versions out there!
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 25 August 2017 at 19:53, Rob Sargent wrote:
>
>
> On 08/25/2017 05:34 PM, Dave Cramer wrote:
>
> The JDBC driver release is divorced from the server release.
>
> Thanks
&
The JDBC driver release is divorced from the server release.
Thanks
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 23 August 2017 at 19:33, Rob Sargent wrote:
> I see no mention of a new jdbc driver on the release notes for Beta 1.
> Does that mean there isn
the ORDER BY+LIMIT is not so easy (plus, with
different user input, it might need B or C in the ORDER BY).
- Dave
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
() and the last reset date can be retrieved from
pg_stat_database, but I’d prefer not to reset ALL stats when the focus is
on a particular table/index.
Are individual table/index reset timestamps stored? If so, can they be
retrieved?
Thanks,
Dave
mailing lists for comments or suggested
changes. If you have comments, please email them to
coc-comme...@postgresql.org no later than 2017-03-05, 11:59PM GMT for
the committee to review.
Regards, Dave.
--
Dave Page
PostgreSQL Core Team
http://www.postgresql.org/
--
Sent via pgsql-general mailing
Unfortunately JSONB is output in text. So this is the way it is done.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 27 August 2016 at 06:39, Alexander Farber
wrote:
> Hello,
>
> what do you use to retrieve a jsonb column using JDBC?
>
> I have tried
>
>
rs. I have no idea if this will work
5) pg_dump everything and reload it into a new db.
Let me know how it goes.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 6 June 2016 at 16:57, Adrian Klaver wrote:
> On 06/04/2016 01:20 PM, lifetronics wrote:
>
>> This morning I a
In cases like this I normally restart the progresql under strace/truss
etc and then wade through the output, it will normally tell me which
process was invoked.
On 23/08/15 18:49, Tom Lane wrote:
> Igor Sosa Mayor writes:
>> Adrian Klaver writes:
>>> Or more to the point how where they built?
>>
On Sat, Jun 27, 2015 at 11:00 AM, Francisco Olarte
wrote:
> Hi Dave:
>
> On Fri, Jun 26, 2015 at 2:59 AM, Dave Johansen
> wrote:
>
> > It appears that calling "SELECT insert_test_no_dup('2015-01-01', 1, 1)"
> > cause the XID to increment? I'm
On Tue, Jun 9, 2015 at 8:38 AM, Dave Johansen
wrote:
> On Mon, Jun 8, 2015 at 10:15 AM, Dave Johansen
> For the sake of documentation, here's the function that I used to
> accomplish this:
> CREATE FUNCTION insert_test_no_dup(tutc_ TIMESTAMP WITHOUT TIME ZONE, id_
> INT
24, 2015 12:50 PM
To: Gauthier, Dave
Cc: Postgres General
Subject: Re: [GENERAL] DB access speeds, App(linux)<->PG(linux) vs App(linux)
<->MSSql(Windows)
Hi Dave:
On Wed, Jun 24, 2015 at 3:44 PM, Gauthier, Dave wrote:
> Hi: I'm trying to get a 10,000 ft understanding of the
o:a...@squeakycode.net]
Sent: Wednesday, June 24, 2015 10:10 AM
To: Gauthier, Dave; Postgres General
Subject: Re: [GENERAL] DB access speeds, App(linux)<->PG(linux) vs App(linux)
<->MSSql(Windows)
On 6/24/2015 8:44 AM, Gauthier, Dave wrote:
> Hi: I'm trying to get a 10,000 f
Hi: I'm trying to get a 10,000 ft understanding of the difference in DB access
speeds for two different scenarios...
Scenario 1: Apps are on linux. PG DB is on linux (different server than
apps)
Scenario 2: Apps are on linux. MSSql DB is on Windows (obviously a
different server)
The
On Mon, Jun 8, 2015 at 10:15 AM, Dave Johansen
wrote:
> I'm using Postgres 8.4 on RHEL 6 and I need to support inserting data into
> a table from multiple processes with there occasionally being duplicates
> from the different processes. Here's a simple example table:
> C
updating and was
hoping to not have to use a custom function. So is there some way to catch
the unique_violation exception without creating a function? Or some other
solution to this?
Thanks,
Dave
to automate the creation of a complete set of test data... using psql to
load a dump, or possibly CREATE DATABASE testdbcopy WITH TEMPLATE testdb.
Integration tests can be costly to maintain with little ROI, tread
carefully...
-Dave
So we can consider this matter closed ? CallableStatements are necessary
because postgres has to use select to call a function.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 4 May 2015 at 18:06, Nanker Phelge wrote:
> The database function does not use out parameters
The logs from the server would be useful
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 4 May 2015 at 07:05, Thomas Kellerer wrote:
> Hannes Erven schrieb am 04.05.2015 um 12:31:
> > Hi,
> >
> >
> >> String sql = "
ROMs (I would have to generate all the WHEREs for Jim's
option D anyway, the data I am after is only tiny fraction of the original
db...)
- restore the filtered constraints/triggers
Dave Owens
541-359-2602
TU Corporate Website
<http://t.signauxun
.
Of course, I would love to hear about options D) - Z) as well! Thanks in
advance for your input.
Dave Owens
541-359-2602
TU Corporate Website
<http://t.signauxun.com/link?url=http%3A%2F%2Fwww.teamunify.com%2F__corp__%2F&ukey=agxzfnNpZ25hbHNjcnhyGAsSC1VzZXJQcm9maWxlGICAgOCP-IMLDA&
unfortunately not.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 6 March 2015 at 11:27, Philippe EMERIAUD wrote:
> Hi all,
> We have an application based on DB2 database, We are testing this same
> application on PostgreSQL database. By default we are in auto
George,
One solution for you might be to write a C function which gets the OS
timezone and then you can execute set timezone=server_timezone();
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 24 February 2015 at 09:25, George Woodring
wrote:
> -- In your origi
On 23 February 2015 at 16:31, Tom Lane wrote:
> Dave Cramer writes:
> > Everytime you get a connection the driver will issue set timezone ...
> > It does not change the default time zone for the server (AFAICS)
>
> Hmm ... depending on exactly how you issue it, it might bec
George,
Everytime you get a connection the driver will issue set timezone ...
It does not change the default time zone for the server (AFAICS)
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 23 February 2015 at 15:29, Adrian Klaver
wrote:
> On 02/23/2015 12:15
For posterity please be aware this will very likely break any timestamps
transfer using JDBC and binary transfer.
This is not recommended for general consumption
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 23 February 2015 at 10:49, Tom Lane wrote:
> George Woodr
control
which timezone both the server and the client are operating in.
I'm open to suggestions ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 23 February 2015 at 10:42, George Woodring
wrote:
> Yes, that is where we think we are heading, the issue is that
Well you could always just put it back to whatever you want when you open
the connection ie "set timezone "
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 23 February 2015 at 08:40, George Woodring
wrote:
> Anyone have a suggestion for setting the tim
I have written a test program using postgres that creates a string with a
surrogate pair. I then insert that string into a varchar property in a
table.
I then execute a select statement to pull the string out. But when I
evaluate the string the lead char of the pair is correct, but the following
I am new to Postgresql. I have a postgres server running on a windows
platform. The DBs will not have any remote access, only users logged onto
the localhost will have access. SSPI seems like a great authentication
protocol to use in this case.
I believe I have followed all the instructions on
On 25/11/14 22:24, David G Johnston wrote:
Thanks List, I think this is the right way to go.
Adrian Klaver-4 wrote
If I am only interested in get 2 entries per result set, I would expect
to see
Actually <=2.
How do you determine which rows to keep, by id or something else?
1 xx,yy
2 xx,yy
On 25/11/14 21:36, Adrian Klaver wrote:
On 11/25/2014 01:27 PM, Dave Potts wrote:
I have a psql function that make a general sql query, returns a set of
results
Q. Is there anyway that I can limit the size of the result sets ?
Put a LIMIT on the query.
If that is not what you want then we
I have a psql function that make a general sql query, returns a set of
results
Q. Is there anyway that I can limit the size of the result sets ?
Dave.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
Well the JDBC4 bits that are not implemented may or may not be relevant.
You can try the 9.1 driver or even the 9.3 driver. I still don't see enough
information in the stacktrace to tell what the issue really is?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 3
Can you elaborate as to your problems. That driver should work fine
depending on what you are doing. Also it would be better to use the jdbc
list.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 3 July 2014 06:25, Orestis Tsakiridis wrote:
> Hello,
>
> I&#x
forget we
support platforms other than Windows).
On Thu, Jul 3, 2014 at 10:35 AM, Sandeep Thakkar <
sandeep.thak...@enterprisedb.com> wrote:
> Okay. For psqlODBC, the dependencies only include gettext and OpenSSL.
>
>
> On Thu, Jul 3, 2014 at 2:08 PM, Dave Page wrote:
>
>&g
gt; script. Do we want to add all the OpenSSL header files? That must be around
> 75..
>
>
> On Thu, Jul 3, 2014 at 1:24 PM, Dave Page wrote:
>
>> Sandeep, how much effort is it to do this?
>>
>> On Thu, Jul 3, 2014 at 6:26 AM, Craig Ringer
>> wrote:
&
to use
> OpenSSL, gettext, etc its self.
>
> Thoughts?
>
> --
> Craig Ringer http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: ht
hanks very much!
--
--Dave Peticolas
Ya, they probably don't like that we use server side prepared statements
Might be possible to just mess with classpath's to get it done.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 11 April 2014 17:39, Rob Sargent wrote:
> On 04/11/2014 03:31 PM, Tecn
In theory, you could write a script that opens both DBs, then systematically
inserts or updates records in the destination DB table based on what's in the
source DB table. Brute force, but automatable.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Beh
What about a regexp match ?
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Tom Lane
Sent: Thursday, February 06, 2014 10:32 AM
To: alexandros_e
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Postgresql GROUP BY
You said they upgraded the driver but the versions you stated are the same
???
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Wed, Feb 5, 2014 at 12:23 PM, CS DBA wrote:
> Hi All;
>
> We have a client running Pentaho to migrate data.
>
> They recently u
Yes, please check the server logs. There should be no reason whatsoever
that JDBC would effect the results if the query is the same
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Fri, Jan 3, 2014 at 3:42 PM, Igor Neyman wrote:
> > -Original Message-
&g
Hi:
Longshot, but here goes
Someone is asking me for a way to architect a model which will store basic
table data (columns with names and rows), but the number and name of the
columns are both variables. I'll call these "data-tables" here.
Example, Store this "data-table"
'col1'
Ok, I found the offending line. It was not the pgadmin line. There was a
line with a large binary insert.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Mon, Sep 23, 2013 at 6:31 PM, Adrian Klaver wrote:
> On 09/23/2013 12:46 PM, Dave Cramer wrote:
>
>> OK,
I tried copying 500 lines above it and it still works :(
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Mon, Sep 23, 2013 at 4:15 PM, Alvaro Herrera wrote:
> Dave Cramer escribió:
> > OK,
> >
> > I have a little more information.
> >
> &g
OK,
I have a little more information.
Yes, in isolation I can import these lines, however something happens after
69000 lines. These lines cause an error.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Fri, Sep 20, 2013 at 9:59 AM, Adrian Klaver wrote:
> On 09
text,
PRIMARY KEY (session_id, session_line_num)
);
2) The exact error message is ERROR: extra data after last expected column
considering ~39000 lines go in before this line I am fairly certain it
is the line.
Dave
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On
id = i.page_id
WHERE
r.timestamp >= '2012-09-01' AND r.timestamp <= '2013-08-31'
GROUP BY
""Month Name"",
""Target""",367,,"pgAdmin III - Query Tool"
Dave Cramer
dave.cramer(at)credativ(dot)ca
htt
pgadmin uses multi line queries and copy from 'cvslogs' cannot read them.
Does anyone have a work around or other solution ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
.
If I used different schemas, it resolves data protection issues, but
doing a backup might become a nightmare
In general which is the fast access method?
regards
Dave.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
I have a DB that relies heavily on recursive stored procedures that tap
reflexive tables that store hierarchical data. These procedures are called
from queries and return record streams. Temp tables are used to store
collected data as the procedure runs up/down the hierarchy. And many other
I find stored procedures to be a God-send. The alternative, external code, is
the risky, difficult and often poorer performing approach to the problems sp's
solve. What better way to interact programatically with your database than
WITH your database?
The only people that I see frown upon th
Hi:
v9.0.1 on linux
Is there a way to query on synonyms of a value transparent to the user?
For example, a column called "animal" can have any text value, including
'horse' and 'cow' and 'pig'. But I want the user to find all the animal='pig'
records if they specify 'hog' instead.
So..
On 30 May 2013 14:48, Chris Angelico wrote:
> On Thu, May 30, 2013 at 6:02 AM, Corbett, James
> wrote:
>> For those twenty years as a developer I should say that I have been
>> completely blind, relying upon a screen review application known as JAWS and
>> a Braille display.
>>
>> I’m looking for
v9.0.1 on linux
thedb=# select
||bicolumn||,
coalesce(permitted_values,'is_null'),
case permitted_values when NULL then 'null' else ||permitted_values||
end
from bi_constraints limit 2;
?column?| coalesce| case
+---+
Hi:
v9.0.1 on linux.
I have a table with a column that is a csv. Users will select records based
upon the existence of an element of the csv. There is an index on that column
but I'm thinking that it won't be of much use in this situation. Is there a
way to facilitate these queries?
Exampl
As far as I remember this is an artifact of using rules to update a table.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Mon, Feb 25, 2013 at 2:52 PM, Russell Keane wrote:
> Hi,
>
> ** **
>
> We have a table which is inserted to and update via a vi
Many, many (many) years ago, while working at DIGITAL EQUIPMENT (before it
bellied up), I worked with a relational DB they created called "RDB". Someone
at DEC wrote an sql development gui in Xwindows called "InstantSQL". It was
really great. All the tables of the DB were icons, you could dra
Is there anything like this soln for v8.3.4 ?
I know, I know, just upgrade. But its out of my hands.
-Original Message-
From: Pavel Stehule [mailto:pavel.steh...@gmail.com]
Sent: Wednesday, February 13, 2013 9:24 AM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re
Trying ( and failing) to get this to run...
select regexp_replace(pg_get_functiondef(proname::regproc),E'[ ]+\\+\n','\n')
from pg_proc where proname = 'maketime';
Goal is to remove the space padding and the "+" at the end of each line in the
dump of pg_get_functiondef, something that could actu
]
Sent: Wednesday, February 13, 2013 9:26 AM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to get stored procedure args list from metadata
tables ?
On 02/13/2013 06:13 AM, Gauthier, Dave wrote:
> Hi:
>
> Looking for a table or view which contains the list of
Excellent !
Thank You very much !
-Original Message-
From: Albe Laurenz [mailto:laurenz.a...@wien.gv.at]
Sent: Wednesday, February 13, 2013 9:30 AM
To: Gauthier, Dave; pgsql-general@postgresql.org
Subject: RE: How to get stored procedure args list from metadata tables ?
Dave Gauthier
Hi:
Looking for a table or view which contains the list of arguments that are
passed to a stored procedure. Doesn't seem to be in pg_proc.prosrc or other
pg_proc columns.
Thanks in Advance for any help.
OK, with the help of this feedback, they caved and will keep it local storage.
Thanks !
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Can PG V9.1* support a DB that's on an NFS disk?
I googled around, but nothing popped out.
Also, would you happen to know the answer to this for MySQL v5.5*?
Thanks in Advance.
Bob,
Ok, have a look at PreparedStatement
Essentially the same
PreparedStatement pstmt= db.prepareStatement("insert into hello values ?")
pstmt.setInt(1,intVar)
pstmt.execute()
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Mon, Jan 28, 2013 at 1:50 PM, Bo
Bob,
Can you provide a snippet of code so I can understand what you mean by
declare ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Mon, Jan 28, 2013 at 7:11 AM, Bob Futrelle wrote:
> Do the declare statements and insert all have to be done in one statement
> e
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Steve Clark
Sent: Thursday, January 24, 2013 12:46 PM
To: Jeff Janes
Cc: Chris Angelico; pgsql-general@postgresql.org
Subject: Re: [GENERAL] noobie question
On 01/24/2013
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Steve Clark
Sent: Thursday, January 24, 2013 11:47 AM
To: pgsql
Subject: [GENERAL] noobie question
Hi list,
This may be really simple - I usually do it using a procedura
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Shridhar Daithankar
Sent: Wednesday, January 23, 2013 10:32 PM
To: pgsql-general@postgresql.org
Cc: Gauthier, Dave; Rob Sargent
Subject: Re: [GENERAL] DB alias ?
On Wednesday, January 23, 2013 09
ginal Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Steve Crawford
Sent: Wednesday, January 23, 2013 4:38 PM
To: Rob Sargent
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] DB alias ?
On 01/23/2013 01:16 PM, Rob Sargent wrote:
> O
On Behalf Of Rob Sargent
Sent: Wednesday, January 23, 2013 4:16 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] DB alias ?
On 01/23/2013 02:10 PM, Gauthier, Dave wrote:
> Nope. Think of it this way, a new DB is created on day 1 of every month. So
> there's a DB called
h. In the meantime, I want those
who try to connect to FEB to connect to JAN (for example).
-Original Message-
From: Joshua D. Drake [mailto:j...@commandprompt.com]
Sent: Wednesday, January 23, 2013 4:04 PM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] DB alias ?
Problem: Some users (scripts actually) try to connect to a DB who's name is
derived from environmental variables. The DB doesn't exist (yet), and I want
them to connect to a different DB for the time being. Is there a way to define
an alias for the existing DB that = the db name that doesn't
One thing I've done in the past is to create a temporary table and insert
"raise notice" debug statements to it, incrementing a sequence as it went
along. Then just select the message with order by the seq. Useful in the
recursive calls I was testing at the time. But it did require that I sti
The fix had to do with connecting as the "insert" user, then setting the
default privs. My mistake was to run the "alter default privileges..." as the
superuser.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Gauthier,
v9.1 on linux
Connect to postgres DB, then...
create user "select" password 'select';
create user "insert" password 'insert';
alter default privileges for user "insert" grant select on tables to "select";
alter default privileges for user "insert" grant select on sequences to
"select";
alter def
What's wrong with this picture. Trying (failing) to create a user called
"select" with default select privs and nothing else. Demo below. Comments in
red...
fcadsql7> psql sde
psql (9.1.5)
Type "help" for help.
sde=# \du
List of roles
Role name |
If you're from the US and are planning to come to FOSDEM in February,
can you ping me please?
Thanks.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-general mailing list (
psql (9.1.5)
Type "help" for help.
sde=> select * from foo;
ERROR: permission denied for relation foo
sde=>
.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Gauthier, Dave
Sent: Wednesday, December 05, 2012 8:00 AM
To: Chri
ubject: Re: [GENERAL] how do I grant select to one user for all tables in a DB?
On Wed, Dec 5, 2012 at 2:12 PM, Gauthier, Dave
mailto:dave.gauth...@intel.com>> wrote:
> V9.1.5 on linux
> User "select" created (yup, that's right, they want the user name to
> be "s
V9.1.5 on linux
User "select" created (yup, that's right, they want the user name to be
"select". Guess what ptivs it is to have! Don't kill the messanger :-) )
postgres=# grant select on all tables in schema sde to "select";
ERROR: schema "sde" does not exist
postgres=# \l
Also for PGAdmin and database drivers?
No, there are no plans to do so.
> Aparantly there are major issues with sideloading in windows 8.
We've seen no problems in our testing, and I haven't seen anything on
the -bugs list. If you see any specific issues, please report th
ctually works before running the
> initdb script, and if it doesn't, check %COMSPEC% to see if it really
> points to cmd.exe .
Interesting - thanks for the info Craig. Sandeep; can you please look
into adding such a check to the installer. We already test the
VBscript interpreter, so th
Thanks for the answers. But I also have a predicate...
select col1,col2 from foo where col4='c4' and col5 <> 'xxx';
How is that done?
From: Richard Broersma [mailto:richard.broer...@gmail.com]
Sent: Tuesday, October 23, 2012 3:24 PM
To: ch...@chriscurvey.com
Cc: Gau
Here's the deal...
Instead of architecting and loading a table like...
create teble foo (col1 text, col2 text, col3 text, col4 text, col5 text);
insert into foo (col1,col2,col3,col4,col5) values ('c1',null,'c3','c4',null);
They did this instead...
create table foo (property text, value text);
in
One thing I sometimes forget to do after loading up an empty DB with data is to
run "analyze". I usually "remember" once I see poor query performance, run the
analyze, and its fixed.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org]
If its not too much work, swap them around and retest to see if its really the
DB/version or the machine.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Scott Marlowe
Sent: Friday, September 21, 2012 3:01 PM
To: salah
Is there a way to determine when a DB was created (create database...)?
Thanks in advance.
I googled around and found that adding/dropping columns from views is not
available. (if not true, I'm all ears).
Given that, what's the best way to do this? I was thinking along the lines of
a stored procedure that reads the view's definition, modifies it, drops the
view, recreates the view.
Yup, works like a charm.
Thanks Salah and Tom for the advise !
-dave
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Wednesday, August 29, 2012 11:18 AM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] using vars in ddl in procedure call
Hi:
v9.0.1 on linux.
Trying (failing) a test to see if I can run ddl in a procedure where elements
of the ddl are vars. Consider...
create or replace function newcol (text) returns integer as $$
declare
newcol alias for $1;
begin
alter table target add column newcol text;
return(0);
end
Hi:
I want to create a string from the first 3 elements of a csv (for example).
The csv is longer than 3 elements. Example...
aaa,bbb,ccc,ddd,eee,fff,ggg
I want the string "aaa,bbb,ccc".
Tried splitting this to an array (precursor to appending elements 1,2,3), but
failed to be able to ref
1 - 100 of 1238 matches
Mail list logo
